[sqlalchemy] transactions

2007-01-20 Thread jose
Hi all, I have a question about transactions I need to insert data into two tables (anag and user), sice I need to insert the generated primary key of anag into user. I have to flush anag to have the id to insert into user table. What happens if there's an interruption in the middle of

[sqlalchemy] Re: count(*) function

2007-01-20 Thread milena
It worked. Thanks! On Jan 15, 11:37 am, Marco Mariani [EMAIL PROTECTED] wrote: milenawrote: I have tried select([func.count(*)], from_obj=[table_name]).execute() but it didn't workI suppore you're not using mappers, so this is the fastest method: number_of_rows =

[sqlalchemy] Re: Problem with array fields in postgres

2007-01-20 Thread exhuma.twn
Sean Davis wrote: On 1/2/07, Mando [EMAIL PROTECTED] wrote: Sorry, but I don't understand how create, insert or select data with the array field in postgres. I don't think array fields are supported yet. There is a post from this week that discusses the issue. Sean Good to

[sqlalchemy] Re: Problem with array fields in postgres

2007-01-20 Thread Antonio
* sabato 20 gennaio 2007, alle 02:57, exhuma.twn wrote : Sorry, but I don't understand how create, insert or select data with the array field in postgres. I use a composite type in PostgreSQL fatture=# \d datirim Composite type public.datirim Column | Type

[sqlalchemy] Re: ORM ramblings 2 - and announcing some o2r wrapper

2007-01-20 Thread Michael Bayer
changeset 2221 addresses the pattern youre doing in test_case3. it required SA is more strict about matching foreignkey columns in a relatoinship into the primary join condition, luckily all the unit tests still pass. this is because youre doing self-referential relationships on

[sqlalchemy] Re: transactions

2007-01-20 Thread Jonathan Ellis
yes, you should, and your commented-out code looks fine On 1/20/07, jose [EMAIL PROTECTED] wrote: Hi all, I have a question about transactions I need to insert data into two tables (anag and user), sice I need to insert the generated primary key of anag into user. I have to flush anag

[sqlalchemy] Re: transactions

2007-01-20 Thread jose
Jonathan Ellis wrote: yes, you should, and your commented-out code looks fine thank you, Jonathan. On 1/20/07, jose [EMAIL PROTECTED] wrote: Hi all, I have a question about transactions I need to insert data into two tables (anag and user), sice I need to insert the generated

[sqlalchemy] PickleType too small

2007-01-20 Thread milena
Hi, I am having trouble with PickleType used as column type (Column('data',MyPickle)). I want to store a dictionary data type into a database (mySQL), but the dictionary is to big. Can anyone tell me how to enlarge PickleType so that it can hold up all my data. Thanks in advance!

[sqlalchemy] new docs new docs new docs

2007-01-20 Thread Michael Bayer
hey list - trying to wrap up as much as i can for the next release, just wanted to highlight some new doc sections and improvements, since i know everyone just loves my docs and their various typos, careless flubs, and great endorsement of the insurance industry: SQLAlchemy is Two Libraries in