Edgewall Software
Modify

Opened 18 years ago

Closed 18 years ago

Last modified 15 years ago

#4562 closed enhancement (wontfix)

I want to contribute with DB Models (wiki?)

Reported by: jmt4b04d4v@… Owned by: Jonas Borgström
Priority: normal Milestone:
Component: wiki system Version:
Severity: normal Keywords: database model
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

I needed the DB model to prepare a new report query and I didn't knew the DB schema.
That's why I elaborated a DB schema for educational purposes only.
I built this model reversing the script from a PostgreSQL 8.1 database used by my trac installation, then I thought maybe someone needs this for the same purposes. That's why I'm contributing this model, maybe have defects, but it worth the effort (maybe it can be put in the development section of the wiki as attachments).
Fell free to do whatever you want with it.

Thanks again for trac.
I didn't found another place to contribute this, sorry.

Attachments (1)

trac-schema.pdm (138.3 KB ) - added by jmt4b04d4v@… 18 years ago.
Power Designer, Database Model

Download all attachments as: .zip

Change History (6)

by jmt4b04d4v@…, 18 years ago

Attachment: trac-schema.pdm added

Power Designer, Database Model

comment:1 by jmt4b04d4v@…, 18 years ago

I tried to attach images to the ticket, but got an error from trac.

comment:2 by jmt4b04d4v@…, 18 years ago

trac detected an internal error …

Python Traceback

Traceback (most recent call last):

File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 387, in dispatch_request

dispatcher.dispatch(req)

File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 237, in dispatch

resp = chosen_handler.process_request(req)

File "/usr/lib/python2.4/site-packages/trac/attachment.py", line 361, in process_request

self._do_save(req, attachment)

File "/usr/lib/python2.4/site-packages/trac/attachment.py", line 475, in _do_save

for field, message in manipulator.validate_attachment(req, attachment):

File "build/bdist.linux-x86_64/egg/tracspamfilter/adapters.py", line 130, in validate_attachment File "build/bdist.linux-x86_64/egg/tracspamfilter/api.py", line 131, in test File "build/bdist.linux-x86_64/egg/tracspamfilter/model.py", line 119, in insert File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 50, in execute

return self.cursor.execute(sql_escape_percent(sql), args)

File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 50, in execute

return self.cursor.execute(sql_escape_percent(sql), args)

ProgrammingError: current transaction is aborted, commands ignored until end of transaction block

comment:3 by jmt4b04d4v@…, 18 years ago

Contact me about uploading the image files (it was a zip file with JPG & PNG images, I also tried uploading the files individually, same error).
It was really hard to create this tickets, your Spam Software started in about 73% and decreasing until I posted this ticket''

comment:4 by Christian Boos, 18 years ago

Resolution: wontfix
Status: newclosed

Well, unless I'm mistaken, I never received the updated (translated) schemas.

No need to reopen the ticket if you want to complete this, just send us the schemas (encoding your pictures in a non binary format like base64 would make it possible to attach them here despite the #4087 issue).

in reply to:  4 comment:5 by anonymous, 18 years ago

Replying to cboos:

Well, unless I'm mistaken, I never received the updated (translated) schemas.

Strange, and yes Christian, you are mistaken. I've sent the images in January 26th directly to your mail, anyway, I've sent it again minutes ago ;-).

¿Maybe content was filtered by binary attachment?, it was a tarball compressed file.

No need to reopen the ticket if you want to complete this, just send us the schemas (encoding your pictures in a non binary format like base64 would make it possible to attach them here despite the #4087 issue).

Greetings, jmt4b04d4v.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Jonas Borgström.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from Jonas Borgström to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.