Thread: [SQL-CVS] [ sqlobject-Bugs-1421647 ] sqlobject-manager sql (show create-table commands) semicolon
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: SourceForge.net <no...@so...> - 2006-02-01 16:59:14
|
Bugs item #1421647, was opened at 2006-02-01 11:59 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1421647&group_id=74338 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: General Group: SQLObject from repository Status: Open Resolution: None Priority: 5 Submitted By: Daniel Holth (joeforker) Assigned to: Nobody/Anonymous (nobody) Summary: sqlobject-manager sql (show create-table commands) semicolon Initial Comment: Hi, I'm playing with turboblog (http://svn.turboblog.python-hosting.com/turboblog) with postgresql as the database. sqlobject-manager will print my database CREATE TABLE () but it's severely lacking in ; . This would be okay except for some reason it does not create the tables correctly in the normal way. So I must print the CREATE TABLE commands, add the necessary semicolons, and run it through psql. Notice the linkage tables are created with the same function call as the main table. Then the 'sql' command of sqlobject-admin (sqlobject/manager/command.py line 495) adds one semicolon for the group. CREATE TABLE tg_group ( id SERIAL PRIMARY KEY, child_name VARCHAR(255), group_id VARCHAR(16) NOT NULL UNIQUE, display_name VARCHAR(255), created TIMESTAMP ) CREATE TABLE tg_user_group ( group_id INT NOT NULL, user_id INT NOT NULL ) CREATE TABLE tg_group_permission ( group_id INT NOT NULL, permission_id INT NOT NULL ); ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1421647&group_id=74338 |
From: SourceForge.net <no...@so...> - 2006-05-02 14:18:50
|
Bugs item #1421647, was opened at 2006-02-01 08:59 Message generated for change (Comment added) made by nobody You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1421647&group_id=74338 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: General Group: SQLObject from repository Status: Open Resolution: None Priority: 5 Submitted By: Daniel Holth (joeforker) Assigned to: Nobody/Anonymous (nobody) Summary: sqlobject-manager sql (show create-table commands) semicolon Initial Comment: Hi, I'm playing with turboblog (http://svn.turboblog.python-hosting.com/turboblog) with postgresql as the database. sqlobject-manager will print my database CREATE TABLE () but it's severely lacking in ; . This would be okay except for some reason it does not create the tables correctly in the normal way. So I must print the CREATE TABLE commands, add the necessary semicolons, and run it through psql. Notice the linkage tables are created with the same function call as the main table. Then the 'sql' command of sqlobject-admin (sqlobject/manager/command.py line 495) adds one semicolon for the group. CREATE TABLE tg_group ( id SERIAL PRIMARY KEY, child_name VARCHAR(255), group_id VARCHAR(16) NOT NULL UNIQUE, display_name VARCHAR(255), created TIMESTAMP ) CREATE TABLE tg_user_group ( group_id INT NOT NULL, user_id INT NOT NULL ) CREATE TABLE tg_group_permission ( group_id INT NOT NULL, permission_id INT NOT NULL ); ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2006-05-02 07:18 Message: Logged In: NO Please also see: http://trac.turbogears.org/turbogears/ticket/738 Cheers Roger ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1421647&group_id=74338 |
From: SourceForge.net <no...@so...> - 2006-05-18 16:52:10
|
Bugs item #1421647, was opened at 2006-02-01 19:59 Message generated for change (Comment added) made by phd You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1421647&group_id=74338 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: General Group: SQLObject from repository >Status: Closed >Resolution: Fixed Priority: 5 Submitted By: Daniel Holth (joeforker) >Assigned to: Oleg Broytmann (phd) Summary: sqlobject-manager sql (show create-table commands) semicolon Initial Comment: Hi, I'm playing with turboblog (http://svn.turboblog.python-hosting.com/turboblog) with postgresql as the database. sqlobject-manager will print my database CREATE TABLE () but it's severely lacking in ; . This would be okay except for some reason it does not create the tables correctly in the normal way. So I must print the CREATE TABLE commands, add the necessary semicolons, and run it through psql. Notice the linkage tables are created with the same function call as the main table. Then the 'sql' command of sqlobject-admin (sqlobject/manager/command.py line 495) adds one semicolon for the group. CREATE TABLE tg_group ( id SERIAL PRIMARY KEY, child_name VARCHAR(255), group_id VARCHAR(16) NOT NULL UNIQUE, display_name VARCHAR(255), created TIMESTAMP ) CREATE TABLE tg_user_group ( group_id INT NOT NULL, user_id INT NOT NULL ) CREATE TABLE tg_group_permission ( group_id INT NOT NULL, permission_id INT NOT NULL ); ---------------------------------------------------------------------- >Comment By: Oleg Broytmann (phd) Date: 2006-05-18 20:52 Message: Logged In: YES user_id=4799 Applied the fix from http://trac.turbogears.org/turbogears/ticket/738 . Commiedt in the revision 1774. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2006-05-02 18:18 Message: Logged In: NO Please also see: http://trac.turbogears.org/turbogears/ticket/738 Cheers Roger ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1421647&group_id=74338 |