[sqlalchemy] sqlalchemy and securtiy

2007-02-15 Thread dischdennis
Hi there, I am currently writing my thesis and using sqlalchemy as mapper. I did not find anything security related in the docu. Maybe can you give me some examples how sql alchemy supports security? For example I think it prevents SQLInjection. Dennis

[sqlalchemy] Re: PostGreSQL Referential Integrity with composed primary key

2007-02-15 Thread dischdennis
Sorry, I placed the testcase here: http://groups.google.de/group/sqlalchemy/web/testcase_dischdennis_Postgre.py I could not find a way to upload it with the message directly. Dennis --~--~-~--~~~---~--~~ You received this message because you are subscribed to

[sqlalchemy] construct flexible query via sqlalchemy

2007-02-03 Thread dischdennis
Hi, I would like to build a query dynamically: I have a list called process_ids that contains the process ids that should be included in the result set. so the or_ tuple has to be filled according to the number of items in list here an example with 2 items: where =

[sqlalchemy] sqlalchemy lost connection?

2007-02-03 Thread dischdennis
Hi I am using sqlalchemy with zope and when I have the server running a while ( 6 hours) without interaction, I cannot access any site, (OperationalError) (2013, 'Lost connection to MySQL server during query'), and have to restart the server.

[sqlalchemy] how to find out the last insert id ?

2007-01-12 Thread dischdennis
what is the easiest way to find out the last insert id? (MySQL 5) supplast = select([func.last_insert_id()],app_schema.SupplierTable.c.pr_supplier_ID 0).execute().fetchone()[0] does not work for some reason Dennis --~--~-~--~~~---~--~~ You received this

[sqlalchemy] Re: many to many on another many to many

2006-12-27 Thread dischdennis
the tables have all foreign key relationships, but the buggy software I use (db designer) forgot to print it out I will set up a complete testcase now that tries to do what I want to do. but do you see any problems in general to relate from one association object to another? Dennis

[sqlalchemy] sqlalchemy limiting

2006-12-05 Thread dischdennis
At startup of a zope application I am mapping the complete resultset for all users. Now I would like to restrict the resultset depending on the logged user before showing in table view because it takes a long time in table view when having 1 rows mapped. How is it possible to restrict on the

[sqlalchemy] mysql and sqlalchemy

2006-10-26 Thread dischdennis
Hi, I tried to make the tutorial according to the tutorial on the sqlalchemy site. I used the shipped mysql module in sqlalchemy 0.2.8.(mysql://[EMAIL PROTECTED]/alc) Everything worked fine except until I tried to make a join between two tables. I know that MySQL doesn't support the JOIN ON