[SQL-CVS] [ sqlobject-Bugs-1421647 ] sqlobject-manager sql (show create-table commands) semicolon

[SourceForge.net <no...@so...>]

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