I decided to start from the beginning and work through the tutorial
using MSSQL as the database and adodbapi as the DB-API layer. I didn't
get very far...
I tried this program:
from sqlalchemy import *
db = create_engine('mssql://xx:[EMAIL PROTECTED]/SQLAlchemyTest')
metadata = BoundMetaData(db)
metadata.engine.echo = True
users_table = Table('users', metadata,
Column('user_id', Integer, primary_key=True),
Column('user_name', String(40)),
Column('password', String(10))
)
users_table.create()
It runs and completes without error; here is the output:
[2006-09-09 16:14:16,905] [engine]:
CREATE TABLE users (
user_id INTEGER NOT NULL IDENTITY(1,1),
user_name VARCHAR(40),
password VARCHAR(10),
PRIMARY KEY (user_id)
)
[2006-09-09 16:14:16,905] [engine]: None
[2006-09-09 16:14:16,921] [engine]: COMMIT
But if I now go in to Query Analyzer and look at the SQLAlchemyTest
database, there is no users table; it seems like the table is created
but not persisted somehow. Is there some kind of commit I need to do?
A couple more experiments; if I add these lines to the end of the program:
i = users_table.insert()
i.execute(user_name='Mary', password='secure')
I get the error "Invalid object name 'users'."
On the other hand if I go to Query Analyzer and create the table (using
the same login and SQL as the program), then run the original program, I
get the error "There is already an object named 'users' in the
database." So my program is definitely talking to the database, but
somehow the CREATE doesn't commit.
Help!
Thanks,
Kent
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
