[sqlalchemy] Re: MySQL error

2009-03-23 Thread morecowbell
it should. how/where are you setting up the tables? can you post the essential parts of your code? On Mar 22, 9:11 pm, pete.do...@gmail.com wrote: I am having trouble connecting to mysql database. I keep getting Programming error 1146 after trying to do a metadata.create_all(). I created the

[sqlalchemy] Re: MySQL error

2009-03-23 Thread morecowbell
= True  ),     Column('real_name'  ,String, nullable = True    ),     Column('email_addr' ,String, nullable = True, unique = True  ),     Column('address'    ,String, nullable = True    ), ) try:     metadata.create_all(db) except Exception,err:     print err     exit(1) morecowbell

[sqlalchemy] Re: Can't connect to local MySQL server

2008-10-10 Thread morecowbell
make sure your mysqld.sock is in the location mysql expects it to be. default is /tmp/mysql.sock; if you are using darwinports, depending on mysql version it's /opt/local/var/run/mysqld/mysqld.sock (append mysql version to mysqld). otherwise, head over to forums.mysql.com ; i'm pretty sure

[sqlalchemy] cloning tables from object model

2008-07-22 Thread morecowbell
greetings, in my app i'm processing rows in a mysql table and i've trying to use SA in ORM-like manner and got stuck at something presumably totally simple. i have a class Orders and mapped the oder_table to Order and now i'm processing each row in order_table. one column in the table is