[sqlalchemy] Re: Updating a table with a trigger silently fails (SQL Server)

2009-10-12 Thread Nicol van der Merwe
On Sun, Oct 11, 2009 at 4:35 PM, Michael Bayer mike...@zzzcomputing.comwrote: On Oct 11, 2009, at 9:32 AM, Nicol van der Merwe wrote: Hi All I am using sqlsoup and pyodbc to update a couple of rows in the database. On a number of tables in the database I have triggers that basically

[sqlalchemy] Re: problem with like

2009-10-12 Thread Christian Démolis
Hi, The idea of creating another column is good but it will multiplicate the size of my table by 2 for nothing. Is it possible to use MYSQL regular expression search with sql alcmehy? If yes, what is the command? 2009/10/10 Andre Stechert stech...@gmail.com This is not really a sqlalchemy

[sqlalchemy] Documentation please

2009-10-12 Thread Christian Démolis
Hello, class sqlalchemy.sql.expression.ColumnOperators¶ Defines comparison and math operations. __init__()¶ x.__init__(...) initializes x; see x.__class__.__doc__ for signature asc()¶ between(cleft, cright)¶ collate(collation)¶ concat(other)¶ contains(other,

[sqlalchemy] Re: Documentation please

2009-10-12 Thread Julien Cigar
see http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/expressions.html On Mon, 2009-10-12 at 10:08 +0200, Christian Démolis wrote: Hello, class sqlalchemy.sql.expression.ColumnOperators¶ Defines comparison and math operations. __init__()¶ x.__init__(...) initializes

[sqlalchemy] Re: problems with pickle and RowProxy

2009-10-12 Thread Manlio Perillo
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael Bayer ha scritto: On Oct 11, 2009, at 12:59 PM, Manlio Perillo wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael Bayer ha scritto: [...] BufferedColumnRow is also not picklable. The reference to the parent ResultProxy

[sqlalchemy] Re: problem with like

2009-10-12 Thread Conor
Christian Démolis wrote: Hi, The idea of creating another column is good but it will multiplicate the size of my table by 2 for nothing. Is it possible to use MYSQL regular expression search with sql alcmehy? If yes, what is the command? MySQL supports RLIKE/REGEXP operators; you can see

[sqlalchemy] Defining custom types

2009-10-12 Thread thatsanicehatyouhave
Hello, I have a custom type defined in my postgresql database, and this is giving me the warning: /Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site- packages/sqlalchemy/engine/base.py:1265: SAWarning: Did not recognize type 'fibertype' of column 'fiber_type'

[sqlalchemy] Re: Very odd utf8 problem

2009-10-12 Thread Yo'av Moshe
Hey, Yes, I'm using a MySQL 5. I understand that the problem is probably happening because of some data I have in my DB, but it's seems odd to me since everything I have in this DB was created using SA. Can't it read the data it written? My mysql connection is specified with

[sqlalchemy] Re: Defining custom types

2009-10-12 Thread Michael Bayer
On Oct 12, 2009, at 4:26 PM, thatsanicehatyouh...@mac.com wrote: Hello, I have a custom type defined in my postgresql database, and this is giving me the warning: /Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site- packages/sqlalchemy/engine/base.py:1265: SAWarning:

[sqlalchemy] Re: Very odd utf8 problem

2009-10-12 Thread Michael Bayer
On Oct 12, 2009, at 7:22 PM, Yo'av Moshe wrote: Hey, Yes, I'm using a MySQL 5. I understand that the problem is probably happening because of some data I have in my DB, but it's seems odd to me since everything I have in this DB was created using SA. Can't it read the data it