On Mar 8, 2006, at 4:38 PM, Robert E. Anderson wrote:
On Wed March 8 2006 15:54, Michael Bayer wrote:
> python test/engines.py --db oracle
Thanks. With that hint I found "--dburi oracle://..." seems to get
me further though!
wow, i didnt even know that option was there, OK.
I'll have to look a little more at the results but I believe my I'm
failing some of these due to table name case?
Ive been chasing down other issues today...are you testing with the
oracle.py thats checked in or have you made some changes?
I wonder why there must be a "default" OR "sequence" defined for
table creation? Seems like it would make more sense to ensure that
a value is given on insertion. I would think the constaints should
determine if it's a violation of the constaints?
you dont have to have a default or a sequence on a particular
table. if you insert a row missing a primary key and theres no
default, sequence, or built-in ID generator (like sqlite has) you
will get a constraint error from the database, just like you
describe. however, SQLAlchemy tries to take the best advantage it
possibly can of the various methods of auto-creating primary key
values, and since the other three major databases supported
(postgres, mysql, sqlite) include such methods, it uses them when it
declares a primary key column. a non-NULL primary key value continues
to be useable as it overrides defaults/sequences/etc.
Oracle on the other hand doesnt have any "automatic primary key" type
of feature, so the user is encouraged to make sequences for tables,
but its definitely not needed (unless theres a bug im unaware of).
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
