gmane.comp.python.sqlobject

SQLObject 0.10.3

Oleg Broytmann — 2008-12-01T13:49:13

Hello! I'm pleased to announce version 0.10.3, a minor bugfix release of 0.10 branch of SQLObject. What is SQLObject ================= SQLObject is an object-relational mapper. Your database tables are described as classes, and rows are instances of those classes. SQLObject is meant to be easy to use and quick to get started with. SQLObject supports a number of backends: MySQL, PostgreSQL, SQLite, Firebird, Sybase, MSSQL and MaxDB (also known as SAPDB). Where is SQLObject ================== Site: http://sqlobject.org Development: http://sqlobject.org/devel/ Mailing list: https://lists.sourceforge.net/mailman/listinfo/sqlobject-discuss Archives: http://news.gmane.org/gmane.comp.python.sqlobject Download: http://cheeseshop.python.org/pypi/SQLObject/0.10.3 News and changes: http://sqlobject.org/News.html What's New ========== News since 0.10.2 ----------------- * Changed interpretation of strings in the DB URI for boolean parameters: '0', 'no', 'off' and 'false' are now interpreted as False

SQLObject 0.9.8

Oleg Broytmann — 2008-12-01T13:47:34

Hello! I'm pleased to announce version 0.9.8, a minor bug fix release of SQLObject. What is SQLObject ================= SQLObject is an object-relational mapper. Your database tables are described as classes, and rows are instances of those classes. SQLObject is meant to be easy to use and quick to get started with. SQLObject supports a number of backends: MySQL, PostgreSQL, SQLite, Firebird, Sybase, MSSQL and MaxDB (also known as SAPDB). Where is SQLObject ================== Site: http://sqlobject.org Development: http://sqlobject.org/devel/ Mailing list: https://lists.sourceforge.net/mailman/listinfo/sqlobject-discuss Archives: http://news.gmane.org/gmane.comp.python.sqlobject Download: http://cheeseshop.python.org/pypi/SQLObject/0.9.8 News and changes: http://sqlobject.org/News.html What's New ========== News since 0.9.7 ---------------- * Changed interpretation of strings in the DB URI for boolean parameters: '0', 'no', 'off' and 'false' are now interpreted as False. * Fixed a bug w

Precedence of manually installed pysqlite

Markus Gritsch — 2008-11-27T15:35:43

Hi, currently the sqlite3 module is, if present, preferred over a manually installed pysqlite2 module. Therefore it is not possible to use a newer version of pysqlite than the one that ships with Python 2.5 and 2.6. Is this really the desired behavior? The attached patch reverses the order in which the importing of the respective SQLite modules is performed. Kind regards, Markus ------------------------------------------------------------------------- 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

How to get data from two tables in a single query?

Matthew Wilson — 2008-11-20T19:34:32

I have a table of employees and a table of shifts and I want to write a single query like this: select emp.name, shifts.start_time from employees emp, shifts where emp.department_id = 99 and emp.id = shifts.employee_id I can't figure out how to do this with SQLObject. When I do this: x = Shift.select(AND( Employee.q.departmentID==99, Shift.q.employeeID==Employee.q.id)) I get the right shifts, but when I try to display information from the employee table, then for each row, SQLObject does a single query. In other words, when I do: [(sh.employee.name, sh.start_time) for sh in x] Then for every shift in the query results, I see SQLObject go back to the database again to get that employee's name. Is there a better way? 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

Triggers?

Darren Govoni — 2008-11-17T01:08:11

Hi, I googled around a bit, but couldn't see if SQLObject (or any Python DB API) supports triggers. I want to call some python code when a particular database action has occurred such as an insert on a particular table. Is this currently possible? thank you, Darren ------------------------------------------------------------------------- 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=/

SingleJoin help

Darren Govoni — 2008-11-14T14:08:05

Hi, I read the documentation and it briefly mentions SingleJoin, but gives no example. I tried to use ForeignKey in the referenced class and SingleJoin in the primary class, but I get this error when retrieving. AttributeError: DataRow instance has no attribute 'processRowID' My classes are simple. class DataRow(SQLObject): type = StringCol() data = BLOBCol(length=2**24) text = UnicodeCol() row = ForeignKey('ProcessRow') class ProcessRow(SQLObject): path = StringCol() status = StringCol() data = SingleJoin('DataRow') r = ProcessRow(path='here',status='loading') datar=DataRow(data=d,type='binary',text='',row=r) I'm not sure how to set the 'data' attribute for a ProcessRow since both classes refer to each other. The DataRow SQL entry has a correct row_id column set, but when I try to read it back like this, gives error. r = ProcessRow.get(1) print "STATUS:"+r.status print "DATA:"+r.data.type <<<<< generates error thank you. Darren --------------

Declaring column type or large BLOB?

Darren Govoni — 2008-11-13T14:06:06

Hi, I need to use a Large BLOB (the 'L' in blob), but SQLObject creates only a 'tinyblob' for BLOBCol in MySQL. Is there a way to tell SQLObject to make it a large blob? thanks, Darren ------------------------------------------------------------------------- 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=/

Cascade, MySQL, InnoDB

Brian Long — 2008-11-07T20:04:03

I'll admit I'm a newbie to SQLObject. I understand MySQL only supports cascade on delete using the InnoDB engine. When I define a class foreign key and specify "cascade=True", MySQL does not store this because the default engine is MyISAM. Since the sqlmeta createSQL code gets run after table creation, specifying "ALTER TABLE foo ENGINE InnoDB" runs after the foreign key constraint was created. This means I have to re-construct / re-add the constraint inside createSQL. Are there any better ways to accomplish this? The SQLObject docs state: "MySQL only supports transactions when using the InnoDB backend, and SQLObject currently does not have support for explicitly defining the backend when using createTable." Are there any plans to change this in an upcoming release? If I could specify InnoDB for all created tables, the "cascade=True" attribute would not get discarded by MySQL. Thanks. /Brian/ ------------------------------------------------------------------------- This SF.Net email is sponsored b

unicode fix

Dan Pascu — 2008-11-03T12:07:51

I just committed a fix in handling unicode values. The StringCol had an asymmetric behavior. When it read values from the database, it would use the database encoding to get a string if the db drivers returned an unicode value. However when an unicode value was given from python it would use a hardcoded ascii codec to get the value to write in the database. This asymmetry was weird and I have no idea why it was like this in the first place. It makes sense to use the database encoding for a value that will be written to the database in a column with that encoding. As a side note, the UnicodeCol uses the defined dbEncoding for both in and out of database operations. I believe that this was the reason why so many people reported problems when using StringCol and they had unicode values on input with non-ascii content. The suggestion was to use UnicodeCol instead, but that is no longer necessary with this fix applied, as a StringCol will work just fine with unicode input as long as it can be encod

Run SQLObject with a mock database connection?

Matthew Wilson — 2008-11-01T23:25:07

I've got a lot of complex logic in some of my SQLObject methods, and I'd like to verify that they work in unit tests, and I don't want to have any kind of database connection, not even a SQLite in-memory database. For example, I've got a parent-child relationship inside of one table, where rows have an optional "parent row" field. I want to set the status on the parent row based on the status of all the different children. For example: When all the children have a status AAA, I'll set the parent status to AAA. When all the children have a status BBB, I'll set the parent status to BBB. When the children have different status, I'll set the parent status to 'Mixed'. Of course, this is a simplification of something much uglier. I want to make sure I execute the correct logic by feeding in lots of possible scenarios through my function. The test will run much faster if I can fake the connection to a database. Is this possible? Any advice on mocking or stubbing a database connection is welcome. Matt

sqlrepr question

Matt Richardson — 2008-10-29T15:07:14

If I want to quote an sql statement to escape any injection badness, is this the proper way to do it? alert_param = "check_in_record.%s + interval 3 day < now() " % "somecolumn" quoted_param = CheckInRecord.sqlrepr(alert_param) results = CheckInRecord.select(quoted_param) I saw the mention of it in the documentation on the website, but wasn't clear on proper use. thanks,

How to disconnect from one database and connect todifferent database?

Matthew Wilson — 2008-10-28T18:33:01

I have a special case where I need to disconnect from one database, then connect to another database. After I connect to the second database, I want to import a different set of SQLObject classes that represent that database. Finally, I want to close that connection to database #2, and then go back to database #1, and reload all the classes for that one. Is this possible? 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=/

Catching an integrity error....

Sam's Lists — 2008-10-20T07:54:22

------------------------------------------------------------------------- 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

Unicode problem with MySQL-python < 1.2.2

Toshio Kuratomi — 2008-10-17T19:57:03

Firebird linux client => windows SQL server problem

Petr Jakeš — 2008-10-06T08:25:01

Query using ends with

Leandro Sales — 2008-09-30T22:19:23

Hello. Please consider the following: I have a sqlobject object named Domain that stores the list of available domains: class Domain(SQLObject): name = StringCol(alternateID=True, length=255, default=None) In the database I have domains like: ID name -------------------------- 1 domain1.com 2 domain2.com I'd like to query the domain into the database that contains in a given hostname, lets say "www.domain1.com". I now that I can do something like: domain = Domain.select(Domain.q.name.endswith("www.domain1.com")) but instead, I'd check which domain name is in the hostname. Somethink like: domain = Domain.select("www.domain1.com".endswith(Domain.q.name.endswith())) .. but sqlobject doesn't allow me to do this. Any clue? Thank you, Leandro. ------------------------------------------------------------------------- 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 tri

Query using sqlobject.sqlbuilder.AND

Leandro Sales — 2008-10-01T20:56:31

How can I add more than 2 ands in a query? Something like: MySQLObject.select(AND(X,Y,Z)) Thank you, Leandro. ------------------------------------------------------------------------- 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=/

Lazy query

Leandro Sales — 2008-10-01T19:16:53

Hi, I have an sqloject object (ObjectParent) that contains others sqlobject objects (OtherObject): class ObjectParent(SQLObject): name = StringCol(alternateID=True, length=255, default=None) objects = MultipleJoin("OtherObject", joinColumn="objectId") class OtherObject(SQLObject): name = StringCol(alternateID=True, length=255, default=None) object = ForeignKey('ObjectParent', dbName='objectId', cascade=True) Then if I do x = ObjectParent.select(some_query) ... aparrently sqlobject loads also x.objects, selecting all related objects. Is it possible to tell to sqlobject to query the records only when I read x.objects for the first time? Thank you, Leandro. ------------------------------------------------------------------------- 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/red

UnicodeEncodeError

Markus W. Barth — 2008-09-28T16:20:02

I have run into that before and can't remember how I got around it: UnicodeEncodeError: 'ascii' codec can't encode character u'\xf3' This is what I'm trying to do: solicitud = model.Solicitud(lugar_nacimiento = kw['lugar_nacimiento'].decode('utf-8')) I have also tried solicitud = model.Solicitud(lugar_nacimiento = kw['lugar_nacimiento']) where the problem is the word 'Gijón' passed to a input field and which prints out nicely as 'Gij\u00f3n' Any hints? (this one should be on the FAQ ;-) I am using SQLObject (this time) with turbogears on Ubuntu with mysql 5.0.51a-3ubuntu5.1 for debian-linux-gnu on x86_64 ------------------------------------------------------------------------- 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=/

Inheritance and signals

David Turner — 2008-09-27T17:51:45

Depending on how attributes are set on child classes, rowupdatesignal fires either just on the base class, or on both the base and the child. This is inconsistent. from sqlobject import * from sqlobject.inheritance import InheritableSQLObject class Base(InheritableSQLObject): name = StringCol() def _set_name(self, new_name): print "base", new_name self._SO_set_name(new_name) class Child(Base): def _set_name(self, new_name): print "child", new_name self._SO_set_name(new_name) sqlhub.processConnection = connectionForURI('sqlite:/:memory:') Base.createTable() Child.createTable() def rowUpdateb(instance, kwargs): print "base signal", instance, kwargs def rowUpdatec(instance, kwargs): print "child signal", instance, kwargs events.listen(rowUpdateb, Base, events.RowUpdateSignal) events.listen(rowUpdatec, Child, events.RowUpdateSignal) c = Child(name="zero") c.name = "one" #once c.set(name="two") #twice ----------- results: base zero base one base si

dburi argument handling fixes

Dan Pascu — 2008-09-10T12:02:54

I just commited some fixes regarding how the dburi parameters are handled. The first fix is for incorrect handling of calls like connectionForURI(dburi, cache=False) when dburi already contains some parameters encoded in the URI, like mysql://user:pass< at >host/db?debug=1 The second fix is for incorrectly interpretted boolean values passed via arguments to connectionForURI or via dburi parameters. Because internally connectionForURI encodes all arguments using urllib.encode, they end up like strings. Same for dburi parameters which are extracted as strings. As a result any such value will end up in DBConnection as a string instead of a boolean, being misinterpretted whenever a false value is intended. For example connectionForURI(dburi, cache=False) will result in DBConnection receiving a cache='False' argument, which evaluates to True as a boolean value since the string 'False' is not empty. Similarly, dburi='mysql://user:pass< at >host/db?debug=0' will end up as debug='0' in DBConnection, being inte