Re: [SQLObject] SQLObject

2009-09-29 Thread Oleg Broytman
(sqlobject.SQLObject): class sqlmeta: table = 'Table1' idName = 'Table1ID' _connection = conn BOB = StringCol(dbName='strbob') Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] SQLObject

2009-09-30 Thread Oleg Broytman
() _connection = conn or class Table1(sqlobject.SQLObject): class sqlmeta: table = 'Table1' idName = 'Table1ID' _connection = conn BOB = StringCol(dbName='BOB') Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB

Re: [SQLObject] SQLObject

2009-09-30 Thread Oleg Broytman
print Cruise.sqlmeta.testList Why do you do this? Why not just print Cruise.sqlmeta.columns ? Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] SQLObject

2009-09-30 Thread Oleg Broytman
On Wed, Sep 30, 2009 at 11:28:28AM +0100, Chris Wood wrote: Excellent, that works! Thanks. Good. 2009/9/30 Oleg Broytman p...@phd.pp.ru (Answering to the list...) On Wed, Sep 30, 2009 at 10:33:18AM +0100, Chris Wood wrote: class Cruise(sqlobject.SQLObject): connection = conn

Re: [SQLObject] porting to python 3

2009-09-30 Thread Oleg Broytman
is not supported' ) fix will be good enough. I made the first one RuntimeError and the second one TypeError. I'll report on any further progress I make on porting sqlobject to python 3. Any progress? Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru

Re: [SQLObject] SQLObject

2009-10-07 Thread Oleg Broytman
a SelectResults instance which you can iterate over. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- Come build with us

Re: [SQLObject] Memory Leak in sqlobject/cache.py

2009-10-08 Thread Oleg Broytman
On Thu, Oct 08, 2009 at 11:30:51AM -0700, Jason Culverhouse wrote: I do 2 things in the cull method 1 - cull dead weak references out of the expiredCache. 2 - avoid placing dead weak references into the expiredCache Looks good. I will try it and apply it. Oleg. -- Oleg Broytman

Re: [SQLObject] Memory Leak in sqlobject/cache.py

2009-10-09 Thread Oleg Broytman
0.10, 0.11 and the trunk). Thank you very much! Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- Come build with us

Re: [SQLObject] show/log query

2009-10-13 Thread Oleg Broytman
On Tue, Oct 13, 2009 at 10:11:13AM +0200, Lutz Steinborn wrote: On Tue, 13 Oct 2009 11:45:36 +0400 Oleg Broytman p...@phd.pp.ru wrote: On Tue, Oct 13, 2009 at 08:52:48AM +0200, Lutz Steinborn wrote: is there a way to log the query that SQLObject generates ? Sure. You can turn

Re: [SQLObject] show/log query

2009-10-13 Thread Oleg Broytman
, actually) emits a number of logging messages, see method printDebug at http://svn.colorstudy.com/SQLObject/trunk/sqlobject/dbconnection.py Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

[SQLObject] SQLObject 0.12.0b2

2009-10-16 Thread Oleg Broytman
--- * Fixed a bug in calling column.from_python in sqlbuilder. For a more complete list, please see the news: http://sqlobject.org/News.html Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without

Re: [SQLObject] porting to python 3

2009-10-18 Thread Oleg Broytman
, but this in itself is already promising. Thank you for the report! Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- Come build

[SQLObject] SQLObject 0.12.0

2009-10-20 Thread Oleg Broytman
remained string exceptions. For a more complete list, please see the news: http://sqlobject.org/News.html Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] SQLObject 0.12.0

2009-10-20 Thread Oleg Broytman
On Tue, Oct 20, 2009 at 06:02:47PM +0400, Oleg Broytman wrote: version 0.12.0, the first stable release of branch 0.12 of SQLObject. With this release branch 0.10 is retired. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die

Re: [SQLObject] SQLObject 0.12.0

2009-10-20 Thread Oleg Broytman
On Tue, Oct 20, 2009 at 04:17:34PM +0200, Daniel Fetchinson wrote: I'm pleased to announce version 0.12.0, the first stable release of branch 0.12 of SQLObject. Great, my app works with the new release without a problem. Thank you for the report! Oleg. -- Oleg Broytman

[SQLObject] SQL pie chart

2009-11-19 Thread Oleg Broytman
Absolute crazy SQL, both the idea and the code: http://code.openark.org/blog/mysql/sql-pie-chart Not related to SQLObject or even Python, but it's so crazy I cannot resist. (-: Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die

Re: [SQLObject] InheritableSQLObject: Data corruption when child record create fails

2009-12-07 Thread Oleg Broytman
it. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- Join us December 9, 2009 for the Red Hat Virtual Experience

Re: [SQLObject] Changing validator messages

2009-12-10 Thread Oleg Broytman
('empty', state), value, state) formencode.api.Invalid: The name may not be empty. for me. I suspect you are using old buggy version of FormEncode. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] Changing validator messages

2009-12-11 Thread Oleg Broytman
to upgrade to testing now). Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- Return on Information: Google Enterprise

Re: [SQLObject] bug report: limit(num) method for Firebird

2009-12-20 Thread Oleg Broytman
@@ import kinterbasdb self.module = kinterbasdb -self.limit_re = re.compile('^\s*(select )(.*)', re.IGNORECASE) - self.host = host self.db = db self.user = user Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru

Re: [SQLObject] problem setting charset for a postgresql db (psycopg2)

2010-01-03 Thread Oleg Broytman
On Sun, Jan 03, 2010 at 02:32:06PM +0100, Davide Alberani wrote: conn.query(SET client_encoding TO %s % dbEncoding) AttributeError: 'psycopg2._psycopg.connection' object has no attribute 'query' The bug has already been reported in the SF tracker. I will fix it RSN. Oleg. -- Oleg

Re: [SQLObject] problem setting charset for a postgresql db (psycopg2)

2010-01-06 Thread Oleg Broytman
: 'psycopg2._psycopg.connection' object has no attribute 'query' Fixed in the revisions 4067, 4068 (branch 0.12 and the trunk.) Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

[SQLObject] SQLObject 0.11.3

2010-01-08 Thread Oleg Broytman
. For a more complete list, please see the news: http://sqlobject.org/News.html Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

[SQLObject] SQLObject 0.12.1

2010-01-08 Thread Oleg Broytman
. * Fixed a bug in FirebirdConnection. For a more complete list, please see the news: http://sqlobject.org/News.html Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] SQLObject 0.12.1

2010-01-08 Thread Oleg Broytman
to include the change in the announcement. And I forgot to put the date in today releases. I need to write down the checklist. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] PATCH: adds support for an interval timedelta column

2010-01-15 Thread Oleg Broytman
of the database. See StringLikeConverter for an example. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- Throughout

Re: [SQLObject] FW: longId=True handling...

2010-01-22 Thread Oleg Broytman
tests and sets it too) to the list of unshared attributes but make sqlmeta.__classinit__ to recognize inherited attributes and do not reset them. I will think of it... Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just

Re: [SQLObject] FW: longId=True handling...

2010-01-25 Thread Oleg Broytman
On Fri, Jan 22, 2010 at 09:57:13PM +0300, Oleg Broytman wrote: In essence, the problem is in class sqlmeta, method setClass: if cls.idName is None: cls.idName = cls.style.idForTable(cls.table) The method poisons the class so in any class inherited from sqlmeta

Re: [SQLObject] This transaction has already gone through ROLLBACK

2010-01-25 Thread Oleg Broytman
is neccessary to redirect attribute access on self._dbConnection back to the transaction instance. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] This transaction has already gone through ROLLBACK

2010-01-26 Thread Oleg Broytman
class because without it .close gets redirected to DBConnection.close but that's wrong for a transaction. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] I wish bool evaluation of selectResults objects ran .count()

2010-01-27 Thread Oleg Broytman
bug if self.count() returns 0. Currently people are accustomed that SelectResults instances are always evaluated to True in a boolean context. I don't know, though, how often people write code like that. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru

Re: [SQLObject] I wish bool evaluation of selectResults objects ran .count()

2010-01-27 Thread Oleg Broytman
On Wed, Jan 27, 2010 at 04:27:03PM +, Matthew Wilson wrote: Here's another solution -- instead of defining nonzero, what about defining __len__, so I could use this approach on both lists AND selectResults objects: http://sqlobject.org/FAQ.html#why-there-is-no-len Oleg. -- Oleg

Re: [SQLObject] Problem with InheritableSQLObject and ForeignKeys/MultipleJoin

2010-01-29 Thread Oleg Broytman
, joinColumn=root_id) This works by copying all parent columns to the child table. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] Problem with InheritableSQLObject and ForeignKeys/MultipleJoin

2010-01-30 Thread Oleg Broytman
On Fri, Jan 29, 2010 at 02:53:26PM +0300, Oleg Broytman wrote: class File(SQLObject): name = StringCol() root = ForeignKey(Directory, default=None) class Directory(File): dirs = MultipleJoin(Directory, joinColumn=root_id) files = MultipleJoin(File, joinColumn=root_id

Re: [SQLObject] memcache

2010-02-01 Thread Oleg Broytman
the corresponding __getstate__ and __setstate__ to SQLObject and test them a bit. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] ForeignKey and MultipleJoin on legacy (existing) database

2010-02-01 Thread Oleg Broytman
. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- The Planet: dedicated and managed hosting, cloud storage, colocation Stay

Re: [SQLObject] memcache

2010-02-01 Thread Oleg Broytman
connection? Also, in a totally random thought, you will probably hit the 1mb memcache limit when storing objects. What's the limit? Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] per-instance connection (was: setConnection)

2010-02-04 Thread Oleg Broytman
= sqlhub.processConnection.transaction() and now do xfer = XferTable.get(id, connection=trans) or XferTable.select(condition, connection=trans). Most SQLObject methods accept 'connection' parameter. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers

Re: [SQLObject] per-instance connection

2010-02-04 Thread Oleg Broytman
. This is especially important for transactions and rows locked using SELECT FOR UPDATE. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] how to set dbEncoding for the whole table/database

2010-02-04 Thread Oleg Broytman
UnicodeCol'umns at once? Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- The Planet: dedicated and managed hosting

[SQLObject] Mail

2010-02-05 Thread Oleg Broytman
Hello. My provider is upgrading its mail system. Because of this I don't receive your messages as quick as they used to be. I hope all messages will be delivered sooner or later, and no later than Monday. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru

Re: [SQLObject] how to set dbEncoding for the whole table/database

2010-02-05 Thread Oleg Broytman
TODO. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- The Planet: dedicated and managed hosting, cloud storage

Re: [SQLObject] how to set dbEncoding for the whole table/database

2010-02-05 Thread Oleg Broytman
UnicodeCol has a default dbEncoding=utf-8. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- The Planet: dedicated

Re: [SQLObject] Instance pickling (was: memcache)

2010-02-05 Thread Oleg Broytman
On Mon, Feb 01, 2010 at 11:43:09PM +0300, Oleg Broytman wrote: I am going to do it in steps. The first step - to make SQLObject instances pickleable. Committed to the trunk in the revision 4099. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru

Re: [SQLObject] how to get id (primary key) from database

2010-02-05 Thread Oleg Broytman
there, and fromDatabase machinery has problems finding the id column. Because of the column 'id_message' is used twice - once from id and once from the list of columns. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB

Re: [SQLObject] [SOLVED]: how to insert id (primary key) manually to the database?

2010-02-05 Thread Oleg Broytman
=myId, idEmployee=3, dateAdd=tStamp) Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- The Planet: dedicated and managed

Re: [SQLObject] how to get id (primary key) from database

2010-02-06 Thread Oleg Broytman
. Result attached. Thank you. The results look good. Method columnsFromSchema() should recognize the id column 'id_message'... but it doesn't. Strange. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without

Re: [SQLObject] how to force select method to retrieve just requested columns

2010-02-06 Thread Oleg Broytman
() (and sqlbuilder.Select) accept a boolean parameters lazyColumns that does what you want! With lazyColumns=True .select() only SELECTs IDs, and then attributes will be loaded one by one or all at once depending on the cacheValues. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru

Re: [SQLObject] how to set dbEncoding for the whole table/database

2010-02-07 Thread Oleg Broytman
= True). fromDatabase machinery for MySQL takes into account parameters from DB URI - 'use_unicode' and 'charset'. If use_unicode is set to True (1) columnsFromSchema() replaces all StringCol by UnicodeCol with charset as its dbEncoding. Oleg. -- Oleg Broytmanhttp://phd.pp.ru

Re: [SQLObject] manually created query

2010-02-07 Thread Oleg Broytman
will be a list of tuples. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- The Planet: dedicated and managed hosting, cloud

Re: [SQLObject] TimeValidator from_python method missing?

2010-02-08 Thread Oleg Broytman
On Mon, Feb 08, 2010 at 02:11:00PM +0200, Tom Coetser wrote: +from_python = to_python + Thank you. I will test it. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] SQLObject connection class for Rdbhost

2010-02-15 Thread Oleg Broytman
. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- SOLARIS 10 is the OS for Data Centers - provides features such as DTrace

Re: [SQLObject] Python 3 version

2010-02-19 Thread Oleg Broytman
send patches. If the patches are compatible with Python 2 I can just include them in the code. If they are not I will create a separate branch for Python3 (and install Python3 myself to run tests). Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru

Re: [SQLObject] Python 3 version

2010-02-20 Thread Oleg Broytman
On Sat, Feb 20, 2010 at 12:03:03PM +0200, Neil Muller wrote: On 19 February 2010 17:14, Oleg Broytman p...@phd.pp.ru wrote: I haven't started to move to Py3k myself. The biggest problem is that I don't see DB AP drivers for Py3k I have no idea about the status of MySQLdb, but psycopg did

Re: [SQLObject] SQLObject, _perConnection PicklingError

2010-02-26 Thread Oleg Broytman
') but I'm still getting the same PicklingError. I'll look into it. What can I be missing? I've seen a few recent posts about fixing this Fixing what? I cannot unpickle the exact per-instance connection, so I refuse to pickle it (and the SQLObject instance with it). Oleg. -- Oleg Broytman

Re: [SQLObject] SQLObject, _perConnection PicklingError

2010-02-26 Thread Oleg Broytman
On Fri, Feb 26, 2010 at 11:42:28PM +0300, Oleg Broytman wrote: but I'm still getting the same PicklingError. I'll look into it. Ok, found it. .select() always passes a connection to .get() thus setting _perConnection flag. I added a test if get() or _init() is passed the same

Re: [SQLObject] Circular dependencies

2010-03-01 Thread Oleg Broytman
still makes sense this way. Thank you, I'll add it. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- Download

Re: [SQLObject] TimeValidator from_python method missing?

2010-03-03 Thread Oleg Broytman
than other validators. So I decided to make an exception to allow date/time columns to accept strings and convert them to their proper date/time types. I committed your patch in the revision 4118. Thank you! Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru

Re: [SQLObject] migration how-to

2010-03-04 Thread Oleg Broytman
-sqlobject-db-migration-how-to/ I'll be happy to receive corrections, answer more questions, etc. Thank you! I'll add it to the SQLObject links. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

[SQLObject] SQLObject 0.11.4

2010-03-04 Thread Oleg Broytman
, please see the news: http://sqlobject.org/News.html Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- Download Intel

[SQLObject] SQLObject 0.12.2

2010-03-04 Thread Oleg Broytman
, please see the news: http://sqlobject.org/News.html Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- Download Intel#174

Re: [SQLObject] Method to validate data

2010-03-16 Thread Oleg Broytman
j...@qlf.com, please answer to the mailing list, not to me personally. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] SQLObject mass insertion (was: Speed comparison)

2010-03-23 Thread Oleg Broytman
- sqlrepr() does value conversion and quoting, e.g. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- Download Intel#174

Re: [SQLObject] Help with SQLBuilder NOTIN

2010-03-30 Thread Oleg Broytman
it from the item ContItem.q.dbStock. The second parameter to Select is WHERE clause; if you don't need it just omit it. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] Help with SQLBuilder NOTIN

2010-03-31 Thread Oleg Broytman
) works for me; the query is 3/QueryR : SELECT stock.id, stock.db_stock_code FROM stock WHERE ((stock.db_stock_code LIKE ('XXX%') ESCAPE '\') AND (stock.id NOT IN (SELECT cont_item.db_stock_id FROM cont_item))) Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p

Re: [SQLObject] SQLObject mass insertion

2010-04-01 Thread Oleg Broytman
. There are two debugging entries for every query (see CREATE TABLE for examples) but every query runs only once. Two debugging output are from different methods. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] SQLObject mass insertion

2010-04-01 Thread Oleg Broytman
(), ._executeRetry(), etc can be called from different methods in a different order so these extra debugging allows to trace the call stack. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

[SQLObject] PRAGMA (SQLite)

2010-04-01 Thread Oleg Broytman
. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself

Re: [SQLObject] AttributeError: No connection has been defined for this thread or process

2010-04-09 Thread Oleg Broytman
been defined for this thread or process This is a very fresh code, I added it in the last releases. Try a release before the very last - 0.11.3 or 0.12.1. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without

Re: [SQLObject] AttributeError: No connection has been defined for this thread or process

2010-04-09 Thread Oleg Broytman
that help? Yes, it helps to understand what is going on. The test suite is used a global connection so it cannot catch the bug in the code if there was no connection. I will look into it and fix the bug. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru

Re: [SQLObject] AttributeError: No connection has been defined for this thread or process

2010-04-09 Thread Oleg Broytman
). fromDatabase can only be used as a variable (actually, constant) of the inner sqlmeta because it only affects class creation. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] AttributeError: No connection has been defined for this thread or process

2010-04-09 Thread Oleg Broytman
SVN - any branch will do, 0.11, 0.12 or the trunk. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- Download Intel#174

Re: [SQLObject] AttributeError: No connection has been defined for this thread or process

2010-04-09 Thread Oleg Broytman
? Thanks Oleg, you're a lifesaver :) You are welcome! Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- Download

[SQLObject] rdbhost

2010-04-09 Thread Oleg Broytman
import rdbhost ImportError: No module named rdbhost That's strange. I see the directory in SVN: http://svn.colorstudy.com/SQLObject/trunk/sqlobject/ and I can import it. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't

Re: [SQLObject] rdbhost

2010-04-09 Thread Oleg Broytman
On Sat, Apr 10, 2010 at 12:32:02AM +0400, Oleg Broytman wrote: import rdbhost ImportError: No module named rdbhost That's strange. I see the directory in SVN: http://svn.colorstudy.com/SQLObject/trunk/sqlobject/ and I can import it. Aha, I see - I have forgotten to add

Re: [SQLObject] rdbhost

2010-04-09 Thread Oleg Broytman
On Fri, Apr 09, 2010 at 05:51:46PM -0300, Juan Manuel Santos wrote: http://svn.colorstudy.com/SQLObject/trunk/sqlobject/ Aha, I see - I have forgotten to add it to setup.py. Will be fixed. No probs, just post when it's ready and I'll test Must be ready now. Oleg. -- Oleg

Re: [SQLObject] rdbhost

2010-04-09 Thread Oleg Broytman
On Fri, Apr 09, 2010 at 06:37:27PM -0300, Juan Manuel Santos wrote: On Fri, Apr 9, 2010 at 6:05 PM, Oleg Broytman p...@phd.pp.ru wrote: On Fri, Apr 09, 2010 at 05:51:46PM -0300, Juan Manuel Santos wrote: http://svn.colorstudy.com/SQLObject/trunk/sqlobject/ Aha, I see - I have

[SQLObject] SQLObject 0.11.5

2010-04-11 Thread Oleg Broytman
a bug in replacing _connection in a case when no previous _connection has been set. For a more complete list, please see the news: http://sqlobject.org/News.html Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB

[SQLObject] SQLObject 0.12.3

2010-04-11 Thread Oleg Broytman
a bug in replacing _connection in a case when no previous _connection has been set. For a more complete list, please see the news: http://sqlobject.org/News.html Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB

Re: [SQLObject] More connections for more tables

2010-04-14 Thread Oleg Broytman
(SQLObject's DBConnection, not a Python DB API connection). Every method has a connection parameter. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] Search for Full Name

2010-04-14 Thread Oleg Broytman
')) SQL query is SELECT id, name, surname FROM contact WHERE name) || (' ')) || (surname)) LIKE ('%Test1 One%')) Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] Search for Full Name

2010-04-14 Thread Oleg Broytman
, ' ', Contact.q.surname) == 'Test1 One') SELECT id, name, surname FROM contact WHERE ((CONCAT(name, ' ', surname)) = ('Test1 One')) I replaced CONTAINSSTRING with an equality test, just for example. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru

Re: [SQLObject] Reply to list (was: Search for Full Name)

2010-04-14 Thread Oleg Broytman
, reply to the list. Also mutt allows to ignore Reply-To from mailing lists, so I don't care too much. What do people think? If most people say they want Reply-To I can change the list options. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers

Re: [SQLObject] Reply to list

2010-04-15 Thread Oleg Broytman
to a list causing much embarassment. That's my experience, too. I have saw too many passwords and private conversations in mailing lists. IMHO, it should require a tiny bit of effort before sending a message to hundreds of recipients. Well said! Oleg. -- Oleg Broytmanhttp

Re: [SQLObject] SQLObject / Interbase, generated SQL defective

2010-04-15 Thread Oleg Broytman
' - Python already passed False and SQLObject happily converts it to 0. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] is there a way to (re)set generator?

2010-04-19 Thread Oleg Broytman
the query directly, right? *I just wonder if there is a way to (re)set generators to the initial value (1). In general, there is no way. The only way to reset a generator is to create a new generator. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru

Re: [SQLObject] bug in sqlobject-admin

2010-04-19 Thread Oleg Broytman
. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself

Re: [SQLObject] is there a way to (re)set generator?

2010-04-19 Thread Oleg Broytman
. I know nothing about FB so I cannot help. Look it up in the FB docs. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] is there a way to (re)set generator?

2010-04-19 Thread Oleg Broytman
and set them at will. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- Download Intel#174; Parallel Studio Eval Try

Re: [SQLObject] bug in sqlobject-admin

2010-04-20 Thread Oleg Broytman
there is a lot of code to collect information before schema changing and even more code that puts the collected information into the new columns. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] bug in sqlobject-admin

2010-04-20 Thread Oleg Broytman
of forced fromDatabase=True. And most connection classes don't recognize size/precision in DecimalCol'umns. In this particular case it would be enough, I think, to extend columnsFromScheme to pass None's as size/precision. I will do some experiments before committing the hack. Oleg. -- Oleg

Re: [SQLObject] bug in sqlobject-admin

2010-04-20 Thread Oleg Broytman
On Tue, Apr 20, 2010 at 08:23:39PM +0400, Oleg Broytman wrote: In this particular case it would be enough, I think, to extend columnsFromScheme to pass None's as size/precision. I will do some experiments before committing the hack. Fixed and committed in the revisions 4175-4177

Re: [SQLObject] bug in sqlobject-admin

2010-04-20 Thread Oleg Broytman
. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. -- ___ sqlobject-discuss mailing list

Re: [SQLObject] bug in sqlobject-admin

2010-04-20 Thread Oleg Broytman
On Tue, Apr 20, 2010 at 09:35:12PM +0300, Imri Goldberg wrote: On Tue, Apr 20, 2010 at 9:12 PM, Oleg Broytman p...@phd.pp.ru wrote: BTW, DecimalCol is only recognized by SQLiteConnection. That's strange, as I currently use mysql. I haven't given it much thought, but it seems to work well

Re: [SQLObject] bug in sqlobject-admin

2010-04-26 Thread Oleg Broytman
: fromDatabase = True if 'idPl' not in Plate.sqlmeta.columns: Plate.sqlmeta.addColumn(IntCol(IDpl, default=None, dbName=id_pl), changeSchema=True) (Wow, three different ways of naming 'id_pl' column, damn!) Oleg. -- Oleg Broytmanhttp://phd.pp.ru

[SQLObject] SQLObject 0.11.6

2010-05-05 Thread Oleg Broytman
the news: http://sqlobject.org/News.html Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

[SQLObject] SQLObject 0.12.4

2010-05-05 Thread Oleg Broytman
details. For a more complete list, please see the news: http://sqlobject.org/News.html Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] An idea regarding deleteMany

2010-05-06 Thread Oleg Broytman
On Thu, May 06, 2010 at 09:36:54PM +0300, Imri Goldberg wrote: Working on it now I'm running into some problems, I will write more once I have this worked out. Ok, we're waiting... Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers

Re: [SQLObject] left join with subquery and WHERE

2010-05-14 Thread Oleg Broytman
of a JOIN are table names, not a subselect. That could be fixed. Oleg. -- Oleg Broytmanhttp://phd.pp.ru/p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN

Re: [SQLObject] left join with subquery and WHERE

2010-05-14 Thread Oleg Broytman
On Fri, May 14, 2010 at 06:22:05PM +0400, Oleg Broytman wrote: On Fri, May 14, 2010 at 03:37:46PM +0200, Imre Horvath wrote: select * from pricegroups left join (select * from products_pricegroups where products_pricegroups.product_id=1) as a on (pricegroups.id=a.pricegroup_id) Does

  1   2   3   4   5   6   >