Hi list, I'm new to sqlalchemy and I want to say... WOW fantastic library!
I'm studying this library because I want to move my worker program to
use sqlalchemy in place of tough sql, so before start, just some questions:
- Are there, inside the library the "alter" (drop, etc.) sql function?
I haven't found it.
- Where are defined "create_session" function? I haven't found it :)
- create_session return a session, but how many session can I have into
my programs? How long does it live? Can I create one and use for all
my program life (also hours +):
def my_class(object):
def __init__(self):
#create all the sql obj
self._mysession = create_session()
def after_some_hours(self):
self._mysession.query
- If in a db, I have already "cascade rules", row example:
creation_user integer NOT NULL
REFERENCES _sys_users (id) ON DELETE CASCADE
how I have to wrote the sqlalchemy definitions? Does sqlalchemy see if
there are already that db rules and work in consequence? Or it will
raise errors? (the I'll delete record, of course)
- If a db don't have real "cascade rules" (sqlite), sqlalchemy do the
work for it?
End for now :)
Thanks a lot,
Michele
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
