Help newbie add tables - tg-admin sql create, TG1.1b3, sqlalchemy

0 views
Skip to first unread message

Adam Yee

unread,
May 29, 2009, 12:40:12 AM5/29/09
to TurboGears
Using SQLAlchemy, I've written some models using declarative_base (see
link)

(Go to line 191 beginning with # MY STUFF)
http://dpaste.com/hold/48879/

Below shows the user identity tables for what TG already created.
After running tg-admin sql create, the database is still the same...

(tg1.1env)adam@adam-laptop:~/tg1.1env/Mini-Blog-test1$ sqlite3
devdata.sqlite
SQLite version 3.6.10
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
group_permission tg_group user_group visit_identity
permission tg_user visit
sqlite> .exit
(tg1.1env)adam@adam-laptop:~/tg1.1env/Mini-Blog-test1$ tg-admin sql
create
Creating tables at sqlite:////home/adam/tg1.1env/Mini-Blog-test1/devdata.sqlite
(tg1.1env)adam@adam-laptop:~/tg1.1env/Mini-Blog-test1$ sqlite3
devdata.sqlite
SQLite version 3.6.10
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
group_permission tg_group user_group visit_identity
permission tg_user visit
sqlite> .exit

I don't know why it won't add the tables. What am I missing?

Thank you!
Adam
Reply all
Reply to author
Forward
0 new messages