[sqlalchemy] Re: How do I Instantiate a class with an Auto-assigned Key ID

2008-02-03 Thread jdcman
Ok, so can you please tell me how I can make a class that AutoIncrements the ID automatically whenever I need to make a new record let me explain... As I add records, I want the ID to Auto Increment. When you say "define a constructor for your class which does not require an ID", but I

[sqlalchemy] Re: how to subscribe with non-google email address?

2008-02-03 Thread Werner F. Bruhin
jason kirtland wrote: > send an email to [EMAIL PROTECTED] > > Michael Bayer wrote: > >> im clicking around and i have no clueim not seeing any option for >> this. we have lots of people subscribed with non google email addresses, >> many of whom have subscribed in just the past few weeks.

[sqlalchemy] Re: Handling of currency values

2008-02-03 Thread Werner F. Bruhin
Michael, Michael Bayer wrote: > ... > if i understand the Decimal class correctly the trailing zeroes should not > matter ...they indicate the stored precision but otherwise this is just a > string formatting issue. heres an example of a monetary formatter for > Decimal: > > http://docs.python.o

[sqlalchemy] Re: how to subscribe with non-google email address?

2008-02-03 Thread jason kirtland
send an email to [EMAIL PROTECTED] Michael Bayer wrote: > > im clicking around and i have no clueim not seeing any option for > this. we have lots of people subscribed with non google email addresses, > many of whom have subscribed in just the past few weeks. Does anyone have > an answer o

[sqlalchemy] Re: Handling of currency values

2008-02-03 Thread Michael Bayer
Werner F. Bruhin wrote: > > I am converting an existing Firebird DB over to use sqlalchemy (0.4.0) > and I can't figure out how to define the model for currency values. > > In the DB they are defined as numeric(18,2) default 0 and in the model I > do e.g. > > sa.Column(u'cbb_currentvalue', > sa.Nu

[sqlalchemy] Re: cherrypy, sqlachemy, mod_wsgi, and apache2

2008-02-03 Thread Michael Bayer
there seems to be more going on there, but perhaps are all side effects of the same thing: http://www.sqlalchemy.org/trac/wiki/FAQ#MySQLserverhasgoneawaypsycopg.InterfaceError:connectionalreadyclosed or otherwise your mysql client is not able to connect at all. braydon fuller wrote: > I need s

[sqlalchemy] Re: How do I Instantiate a class with an Auto-assigned Key ID

2008-02-03 Thread Michael Bayer
jdcman wrote: > > our members table has an ID as the primary key with an auto-assigned > key ID. > > When we create the class it is instantiated with the ID and also > returns an ID. > > obviously if we provide an ID it conflicts with the auto-generated ID. > and if we don't provide an ID it says

[sqlalchemy] Re: moving objects between sessions

2008-02-03 Thread Michael Bayer
Brett wrote: > > > Is it possible to move a pending object that is a child in a relation to > a new sessions without flushing the objects original session? yes but you'll have to either detach it from its parent first, or disable cascade rules using cascade="none". it would look like: del paren

[sqlalchemy] Re: expunge vs clear

2008-02-03 Thread Michael Bayer
Jonathon Anderson wrote: > > I'm using an orm configuration with a sessionmaker().mapper doing the > mapping between my classes and my metadata. > > The documentation says that doing a Session.clear() should do the > equivalent of a Session.expunge(inst) for all instances attached to > the session

[sqlalchemy] how to subscribe with non-google email address?

2008-02-03 Thread Michael Bayer
im clicking around and i have no clueim not seeing any option for this. we have lots of people subscribed with non google email addresses, many of whom have subscribed in just the past few weeks. Does anyone have an answer on this ? John Draper wrote: > I really don't want my list mail goi

[sqlalchemy] Can the moderator of this group please contact me?

2008-02-03 Thread jdcman
Will the moderator please contact me?I'm having a lot of problems re-directing my list mail to a non-gmail account. Please contact me at my gmail account, but I don't want any of the list postings to be sent there, I just want to read it on the web, as I checked the appropriate button. But

[sqlalchemy] Re: Handling of currency values

2008-02-03 Thread Werner F. Bruhin
[EMAIL PROTECTED] wrote: > according to sqlalchemy/types.py, the Decimal() is used straight away, > without any precision etc stuff. the numeric(precision/length) are only for > the db. i assume u have to use some precision-context around your db-related > stuff. > So, what is the correct wh