[sqlalchemy] Re: MySQL - Index String Prefix

2009-10-30 Thread Michael Bayer
On Oct 30, 2009, at 8:45 PM, Ted Dziuba wrote: > Hi, > > I am trying to create an index on a fixed-width prefix of a VARCHAR > column in MySQL. In my Alchemy model, I have the following: > > url = Column(String(4096)) > > And I know that there an index = True parameter I can pass to the > Col

[sqlalchemy] Re: proxy_factory tests or examples? [was Many to Many[...]]

2009-10-30 Thread Michael Bayer
On Oct 30, 2009, at 10:15 PM, Jared Nuzzolillo wrote: > Thanks again Mike! > > Please accept my apologies for the double post, I had tried to send > it before registering. > > Are there any examples of using proxy_factory and proxy_bulk_set? I > couldn't find any (nor tests?), and have had tr

[sqlalchemy] MySQL - Index String Prefix

2009-10-30 Thread Ted Dziuba
Hi, I am trying to create an index on a fixed-width prefix of a VARCHAR column in MySQL. In my Alchemy model, I have the following: url = Column(String(4096)) And I know that there an index = True parameter I can pass to the Column constructor, but that will attempt to index the entire field. My

[sqlalchemy] Re: Directly saving a dictionary of column values to SA...

2009-10-30 Thread cd34
On Oct 31, 12:00 am, cd34 wrote: > On Oct 30, 4:44 am, Shane wrote: > > > I am using SA within TurboGears.  When saving data from form fields, I > > often have a dict of key/value pairs (where values is always a string > > and must by correctly typed) where each key is set up to correspond to >

[sqlalchemy] Re: Directly saving a dictionary of column values to SA...

2009-10-30 Thread cd34
On Oct 30, 4:44 am, Shane wrote: > I am using SA within TurboGears.  When saving data from form fields, I > often have a dict of key/value pairs (where values is always a string > and must by correctly typed) where each key is set up to correspond to > a column within the SA Table: > (Data from f

[sqlalchemy] proxy_factory tests or examples? [was Many to Many[...]]

2009-10-30 Thread Jared Nuzzolillo
Thanks again Mike! Please accept my apologies for the double post, I had tried to send it before registering. Are there any examples of using proxy_factory and proxy_bulk_set? I couldn't find any (nor tests?), and have had trouble getting everything wired up, at least without resorting to what fe

[sqlalchemy] Re: Directly saving a dictionary of column values to SA...

2009-10-30 Thread Shane
Hi Tomasz, Thanks, but I think that your suggestion gives me the attributes within the class, and this is not what I need. The problem is that if I have a None value where there could also be an Integer (nullable FK for instance), then take the type from a mapper prop I am going to end up with N

[sqlalchemy] Locking tables

2009-10-30 Thread Nathan Harmston
Hi, I have a script which will process a large amount of data and save some of those results to the database. This takes a large amount of time and so what I would do in something like java is to lock the tables before processing, do the work, and then lock them after processing..concurre

[sqlalchemy] Re: Directly saving a dictionary of column values to SA...

2009-10-30 Thread Tefnet Developers - Tomasz Jezierski
Dnia 2009-10-30, Pt o godzinie 01:44 -0700, Shane pisze: > Hi All, > > I am using SA within TurboGears. When saving data from form fields, I > often have a dict of key/value pairs (where values is always a string > and must by correctly typed) where each key is set up to correspond to > a column

[sqlalchemy] Directly saving a dictionary of column values to SA...

2009-10-30 Thread Shane
Hi All, I am using SA within TurboGears. When saving data from form fields, I often have a dict of key/value pairs (where values is always a string and must by correctly typed) where each key is set up to correspond to a column within the SA Table: (Data from fields for a ProductLineItem Type) k

[sqlalchemy] Re: merge without merging related objects

2009-10-30 Thread Tvrtko
> you want the cascade setting on "history" > > backref=backref("history", cascade='save-update') That did the trick! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send em