gmane.comp.python.sqlobject

Re: How to use OVERLAPS keyword with SQLObject?

Oleg Broytmann — 2008-07-24T19:20:43

There is no. Oleg.

How to use OVERLAPS keyword with SQLObject?

Matthew Wilson — 2008-07-24T18:25:20

I just learned about the OVERLAPS keyword, used like this: matt=# select (TIMESTAMP '2008-07-24 03:00:00', TIMESTAMP '2008-07-24 09:00:00') overlaps (TIMESTAMP '2008-07-24 5:0:0', TIMESTAMP '2008-07-24 11:0:0') ; overlaps ---------- t (1 row) I'm testing if the time interval from 3 AM today through 9 AM today overlaps the time interval from 5 AM through 11 AM. How can I use this with SQLObject? I poked around a little with SQLOp. Before I write an ugly patch, is there already a way to do it? It is important to use the TIMESTAMP label to disambiguate types. Matt ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

Re: sqlobject 0.10 and picklecol protocol problem

Oleg Broytmann — 2008-07-24T15:29:13

It does. I clearly remember we discussed this a year or two ago but you lost interest because you stopped using PickleCol. Oh, MySQLdb... no, not again, please! :( Still there is no way to force MySQLdb into ascii-only? Does setting 'charset=...' in the DB URI help? Oleg.

sqlobject 0.10 and picklecol protocol problem

Sophana — 2008-07-24T15:17:06

Hi there seem to be a problem with picklecol and v0.10 It seem that v0.10 uses highest pickle protocol by default (2). When reading back there are problems related to protocol2 and unicode. pickle does not understand what it just pickled before... Can someone confirm this? My workaround is to force protocol 0. Thanks for all ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

Re: Nested Table/Foreign Key to same table

Oleg Broytmann — 2008-07-24T15:15:13

Welcome! Don't be too afraid. (-: [skip] MultipleJoin expects an "*_id" column in the other table (even if the other table is the same table itself). ForeignKey provides such key but you have to tip MultipleJoin what column to use. This works for me: class NestedTest(SQLObject): attr1 = StringCol() attr2 = StringCol() parent = ForeignKey('NestedTest', default=None) children = MultipleJoin('NestedTest', joinColumn='parent_id') NestedTest.createTable() n1=NestedTest(attr1='first', attr2='55408') n2=NestedTest(attr1='second', attr2='55409', parent=n1) n3=NestedTest(attr1='third', attr2='55410', parent=n1) print n1.children The output is: [, ] Seems ok for me. PS. Proper plural for for the word 'child' is 'children' :-) Oleg.

Re: How to provide default non-null values for foreignkeys?

Oleg Broytmann — 2008-07-24T15:03:47

Depends on the applications and the DB. If you know the row is in the DB already just point to it using "...FOREIGN KEY REFERENCES...." (I mean SQL CREATE TABLE). If you aren't sure the row is there, I doubt there is a magical service in an SQL backend. You just have to check regularly if the row has been inserted. SQLObject can help a bit - Luke Opperman reminded how you can pass a callable as a default value - but that's all. Oleg.

Re: How to provide default non-null values for foreignkeys?

Matthew Wilson — 2008-07-24T13:49:56

So, if I wanted to make sure that some rows are always in the Sales table, is there a recommended approach? Matt ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

Nested Table/Foreign Key to same table

dimi duj — 2008-07-24T07:56:01

------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/_______________________________________________ sqlobject-discuss mailing list sqlobject-discuss< at >lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Re: How to provide default non-null values for foreignkeys?

Luke Opperman — 2008-07-23T23:59:00

As Oleg notes, your default argument call to byName is evaluated at class creation time ie, before you've created the Sales Department record. In the same way, if you had: when = DateTimeCol(default=now()) the default would always be the value returned by now() at the time the class is imported. However, default can also be a callable. In the datetime example, changing it to: when = DateTimeCol(default=now) will cause SQLObject to call now() separately for each insert (that needs the default for this column). So as long as the Sales department is created before you actually insert any Employees, something like this should work to make that byName call lazy: def get_sales_dept(): return Department.byName('SALES') class Employee(SQLObject): user_name = UnicodeCol(alternateID=True) department = ForeignKey(default=get_sales_dept) - Luke ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build

Re: How to provide default non-null values for foreignkeys?

Oleg Broytmann — 2008-07-23T21:26:45

I don't see how you can misinterpret this. There is no 'Sales' department in the DB, so why do you expect SQLObject magically finds one?! .byName() is an "active" operation, it cannot be done lazily. You have to know in advance the id of the 'Sales' department. Oleg.

Re: How to provide default non-null values for foreignkeys?

Matthew Wilson — 2008-07-23T21:04:10

It fails in the instance where I'm importing a model with an empty database. So for example, my unit tests use a sqlite :memory: database, and this won't work. The byName lookup raises an SQLObjectNotFound exception. Sorry, I should have been more clear. Matt ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

Re: How to provide default non-null values for foreignkeys?

Oleg Broytmann — 2008-07-23T20:01:19

In what way? For .byName() to work Department.name must be an alternateID column (which implies uniqueness). This works for me: class Department(SQLObject): name = StringCol(default=None, alternateID=True) Department.createTable() Department(name='Directorat') Department(name='Sales') class Employee(SQLObject): name = StringCol(default=None) department = ForeignKey('Department', default=Department.byName('Sales')) Employee.createTable() Employee(name='slave') Oleg.

How to provide default non-null values for foreign keys?

Matthew Wilson — 2008-07-23T19:50:47

I have an employees table and a departments table, and every employee has a foreign key to the departments table. 99% of the time, new employees belong to one particular department, "SALES". How can I make the SALES department the default department for new employees? I tried this: class Department(SQLObject): name = UnicodeCol(alternateID=True) class Employee(SQLObject): user_name = UnicodeCol(alternateID=True) department = ForeignKey(default=Department.byName("SALES") And it failed. Any ideas? Thanks in advance. Matt ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

Re: assert id is not None

Ray Van Dolson — 2008-07-22T23:42:56

Thanks for the explanation. I've filed a bug and am following your suggestion of declaring my columns explicitly. All is well for now. :) Ray ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

Re: childName

Oleg Broytmann — 2008-07-22T19:01:02

class Test1(InheritableSQLObject): name1 = StringCol(default=None) class Test2(Test1): name2 = StringCol(default=None) Test1.createTable() Test2.createTable() t1 = Test1(name1='test1') t2 = Test2(name2='test2') print t2._parent.childName # prints 'Test2' Oleg.

childName

Luis Javier Peris — 2008-07-22T18:48:46

Re: SQLObject with a custom backend?

Oleg Broytmann — 2008-07-22T13:16:07

I am afraid you have to patch mysqlconnection backend pretty extensively. Start looking at sqlobject/dbconnection.py, then sqlobject/mysql/mysqlconnection.py. Oleg.

SQLObject with a custom backend?

inhahe — 2008-07-22T11:25:38

What if I want to modify the backend to SQLObject in some way? I want its requests to call my own custom function(s) that ultimately use the DBS. Basically I'm using stackless and I want my custom function to put the request in a queue that goes to a thread pool of database connections to MySQL and when a result is ready sends it back to the function on a channel so that the function can return the result. Can this be done? ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

Re: assert id is not None

Oleg Broytmann — 2008-07-22T10:34:26

And there is SystemsInfo.sqlmeta.delColumn() call. Oleg.

Re: assert id is not None

Oleg Broytmann — 2008-07-22T10:06:06

[skip] If idTYpe is not autoincrement (integer, actually) SQLObject expects 'id' in the list of passed columns: [skip] Oops, seems like a bug. I think what caused the bug is using fromDatabase and idName simultaneously - SQLObject drew SystemName from the DB and added it because of the idName. To work around the bug avoid using fromDatabase - declare your columns explicitly. SQLObject stores columns in dictionaries so the order (of keys) could be random. Do not rely on the order of columns in SO. Columns are in SystemsInfo.sqlmeta object (see main.py), in .columns, .columnList, .columnDefinitions. Oleg.

Re: assert id is not None

Ray Van Dolson — 2008-07-22T00:34:39

Hmm, I am guessing the note right above this: http://www.sqlobject.org/SQLObject.html#class-sqlmeta Is probably a big part of my issue. :) Since my primary key in this case is _not_ immutable. Am I on the right track? Any way to override this behavior (other than the try/except or python -O)? Ray ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/