[sqlalchemy] Re: how to do manualy incremented counter

2008-06-24 Thread Jorge Godoy
Bobby Impollonia wrote: In mysql you can declare a integer column to be auto_increment and it will handle for you giving each row a different number. Other databases have similar mechanisms. It sounds like the invoice number is the primary key for the invoice table? If you have a integer

[sqlalchemy] Re: SQLAlchemy 0.4.2b released

2008-01-09 Thread Jorge Godoy
Jon Rosebaugh wrote: What are we supposed to do with Unicode? As far as I can tell, the Unicode type passes its defined length directly to the underlying string, so that a Unicode(30) column is turned into a VARCHAR(30) or the dialect equivalent. I may be able to determine that a particular

[sqlalchemy] Re: Save the default function into the database

2007-11-11 Thread Jorge Godoy
Paul Johnston wrote: Hi, generate the default values (default = _some_python_function_). The problem is that such function is not saved in the database itsself. Ok, I wonder, why is this a problem for you? Usually people are happy with ORM-specific logic (such as this) just being stored

[sqlalchemy] Re: Save the default function into the database

2007-11-11 Thread Jorge Godoy
Michael Bayer wrote: im fairly certain triggers used to generate INSERT values are compatible with NOT NULL columns. although in this particular thread I dont think I understand the issue exactly, it seemed like it was just asking for some Python function to be executed external to the

[sqlalchemy] Re: SQLAlchemy 0.4 MERGED TO TRUNK

2007-07-31 Thread Jorge Godoy
Marco Mariani wrote: Michael Bayer ha scritto: can i have an example http://trac.turbogears.org/browser/branches/1.0/turbogears/database.py?rev=2320 281 [run_with_transaction.when(_use_sa())] 282 def sa_rwt(func, *args, **kw): 283 log.debug(New SA transaction)

[sqlalchemy] Re: SQLAlchemy 0.4 MERGED TO TRUNK

2007-07-30 Thread Jorge Godoy
Michael Bayer wrote: a lot. no decorators for now. Not even the way we did on TurboGears that mimics the PEAK decorators? This way, people can use @decorator(param) on Python 2.4+ and can use [decorator(param)] on Python 2.3. At the same place (before the method / function declaration).

[sqlalchemy] Re: Orphaned parents..

2007-05-04 Thread Jorge Godoy
NOT IN (SELECT parent_id FROM child_table GROUP BY parent_id); It runs periodically and cleans the database from stale records. -- Jorge Godoy [EMAIL PROTECTED] --~--~-~--~~~---~--~~ You received this message because you

[sqlalchemy] Re: Column to default to itself

2007-04-12 Thread Jorge Godoy
clashes and to be fair to all connections that are inserting data on your table. -- Jorge Godoy [EMAIL PROTECTED] --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send

[sqlalchemy] Re: Legacy DB Migration Strategy - How to question?

2007-03-26 Thread Jorge Godoy
project, things get easier for reverse engineering tools (including SQL Alchemy). Any links to relevant ref materials/tutorials/etc would be appreciated here. There are docs on the website. They help a lot! -- Jorge Godoy [EMAIL PROTECTED

[sqlalchemy] Re: How to deal with non-ASCII(such as Chinese)table name?

2007-03-25 Thread Jorge Godoy
, though, who would be crazy to create such names. -- Jorge Godoy [EMAIL PROTECTED] --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com

[sqlalchemy] Splitting the model into multiple files

2007-03-24 Thread Jorge Godoy
Hi! How's SQL Alchemy's support for splitting the model into multiple files? I've been having some difficulties with getters and SQL Object, so I'd like to know if a move to SQL Alchemy would help me with that or would let me with similar problems... TIA, -- Jorge Godoy [EMAIL

[sqlalchemy] Re: use_labels =30 vs MAX_LABEL_LENGTH

2007-03-17 Thread Jorge Godoy
jose [EMAIL PROTECTED] writes: * PostgreSQL = 64 - 1 This can be changed in compilation time. -- Jorge Godoy [EMAIL PROTECTED] --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

[sqlalchemy] Re: matz blogged us

2007-03-10 Thread Jorge Godoy
. -- Jorge Godoy [EMAIL PROTECTED] --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy

[sqlalchemy] Re: Support for incomplete dates

2007-03-04 Thread Jorge Godoy
a many-to-many relationship OR you could have more boolean fields... I'd think along these lines instead of using invalid dates. -- Jorge Godoy [EMAIL PROTECTED] --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups

[sqlalchemy] Re: sqlalchemy lost connection?

2007-02-04 Thread Jorge Godoy
(be it old or not). Anyway, I think that this is a problem at lower layers: mysql db adaptor or the mysql server itself. This timeout should be configurable and one of the options should be disabling this timeout. -- Jorge Godoy [EMAIL PROTECTED

[sqlalchemy] Re: Assign mapper many-to-many with extra columns

2007-02-04 Thread Jorge Godoy
', failed to locate a corresponding column from table 'article_61f0' A hint might be that the error message has no c in it. If you put it there, then the error might be generated somewhere else or be dependent on something that is not exactly where you're changing your code. -- Jorge Godoy