Discussion of Python object-relational mapper SQLObject

tyson | 2 Feb 20:17

schema name ?

Hi,
   I have a question regarding the schema naming process.  When I create 
a class "Person" with SQLObject it automatically adds a person table to 
the "public" schema in my postgres database.   If I want it to add this 
table into a different schema, lets say "hr", then I am unsure of the 
correct way to implement this.  I know if I set the tag 
"_tableName=hr.person" in the class itself, it works and the table is 
added where I want it.   On the other hand, after doing this I created 
an Address class with a foreign key to Person.  When I add a join to 
these two tables everything works correctly, but then when I query the 
person table to look for resulting address's I run into an error.

For example when I run this line of code I get an inner-join error:

"Person.get(1).addresses"

the sql generated is incorrect.  It doesn't add the tablename person to 
the corresponding field.  Here is the result:

SELECT address_id FROM hr.address WHERE hr.person_id = (1)

It should say "WHERE hr.Person.person_id = (1)".  Does anyone know how to fix this problem?

--

-- 
Tyson Wenger
Computer Programmer
V&L Tool,Inc.

2021 MacArthur Rd.
Waukesha, WI 53188

(Continue reading)

headers

Oleg Broytmann | 2 Feb 20:30

Re: schema name ?

On Fri, Feb 02, 2007 at 01:17:56PM -0600, tyson wrote:
> Does anyone know how to fix this problem?

   We have some bug reports about it, and there is an incomplete patch...

http://sqlobject.gcu.info/trac/ticket/159
http://sqlobject.gcu.info/trac/ticket/289

Oleg.
--

-- 
     Oleg Broytmann            http://phd.pp.ru/            phd <at> phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

headers

Dan Pascu | 3 Feb 07:04

Patch to improve ids for mysql databases


Currently the mysql backend for sqlobject uses an int for the table id 
when generating the schema. The attached patch modifies it to use an 
unsigned int. This will result in doubling the range of available ids and 
also makes more sense considering that the table id is never negative.

--

-- 
Dan

Attachment (sqlobject-mysql-id-unsigned.diff): text/x-diff, 619 bytes

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

headers

Oleg Broytmann | 3 Feb 11:45

Re: Patch to improve ids for mysql databases

On Sat, Feb 03, 2007 at 08:04:23AM +0200, Dan Pascu wrote:
> +        return '%s INT UNSIGNED PRIMARY KEY AUTO_INCREMENT' % soClass.sqlmeta.idName

   Ok, thank you.

Oleg.
--

-- 
     Oleg Broytmann            http://phd.pp.ru/            phd <at> phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

headers

Jim Steil | 5 Feb 22:56

How would I do this?

I have a legacy table that I’m trying to update. It has an integer primary key that works fine for most of what I’m doing. But, in some situations I need to update a record based on values in 2 other fields. Below is a snippet of the def:

class OrderItem(SQLObject):

class sqlmeta:

style = Style(longID=True)

idName = 'orderItemId'

orderItemId = IntCol()

orderNumber = IntCol()

lineNumber = IntCol()

What I need to do is find out if the orderNumber/lineNumber combination exists and if so, do an update of the attributes instead of adding a new record.

I suppose I could do a select and return an object and then do a get based on the orderItemId, but that seems cumbersome. Is there something I can do so that I can perform a get against 2 columns, orderNumber and lineNumber in this case, something similar to:

X = OderItem.get(orderNumber=1234, lineNumber=1)

-Jim

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

headers

sophana | 6 Feb 09:43

Re: How would I do this?

Jim Steil a écrit :

I have a legacy table that I’m trying to update. It has an integer primary key that works fine for most of what I’m doing. But, in some situations I need to update a record based on values in 2 other fields. Below is a snippet of the def:

class OrderItem(SQLObject):

    class sqlmeta:

        style = Style(longID=True)

        idName = 'orderItemId'



    orderItemId = IntCol()

    orderNumber = IntCol()

    lineNumber = IntCol()

What I need to do is find out if the orderNumber/lineNumber combination exists and if so, do an update of the attributes instead of adding a new record.

I suppose I could do a select and return an object and then do a get based on the orderItemId, but that seems cumbersome. Is there something I can do so that I can perform a get against 2 columns, orderNumber and lineNumber in this case, something similar to:

X = OderItem.get(orderNumber=1234, lineNumber=1)

            -Jim

Why not a select?
X=OrderItem.selectBy(orderNumber=1234, lineNumber=1)

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

headers

Oleg Broytmann | 6 Feb 16:23

Re: [PATCH] Allow empty argument list to AND/OR

Hello!

On Tue, Jan 23, 2007 at 11:51:27AM -0200, Johan Dahlin wrote:
>  def AND(*ops):
> +    if not ops:
> +        return

   Committed in th trunk, doc bracnh and 0.8 branch in the revisions
2255-2257. Thank you!

Oleg.
--

-- 
     Oleg Broytmann            http://phd.pp.ru/            phd <at> phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

headers

Jim Steil | 6 Feb 16:31

decoding Unicode is not supported

Hi:

I’m getting the following exception using SQLObject. I’ve done some searches to find out what to do about this, but can’t seem to find a definitive answer about what I need to do to make this go away. Is there an easy way to fix this without specifically encoding each and every string attribute before setting it on my object?

-Jim

Traceback (most recent call last):

File "C:\PyWork\Scripts\Synchronization\syncOrders2.py", line 164, in ?

arrivalNumber=arrivalNumber, hasBeenFaxed=hasBeenFaxed, fobCode=fobCode)

File "c:\python24\lib\site-packages\SQLObject-0.7.2-py2.4.egg\sqlobject\declarative.py", line 93, in _wrapper

return fn(self, *args, **kwargs)

File "c:\python24\lib\site-packages\SQLObject-0.7.2-py2.4.egg\sqlobject\main.py", line 1203, in __init__

self._create(id, **kw)

File "c:\python24\lib\site-packages\SQLObject-0.7.2-py2.4.egg\sqlobject\main.py", line 1230, in _create

self._SO_finishCreate(id)

File "c:\python24\lib\site-packages\SQLObject-0.7.2-py2.4.egg\sqlobject\main.py", line 1254, in _SO_finishCreate

id, names, values)

File "c:\python24\lib\site-packages\SQLObject-0.7.2-py2.4.egg\sqlobject\dbconnection.py", line 361, in queryInsertID

return self._runWithConnection(self._queryInsertID, soInstance, id, names, values)

File "c:\python24\lib\site-packages\SQLObject-0.7.2-py2.4.egg\sqlobject\dbconnection.py", line 221, in _runWithConnection

val = meth(conn, *args)

File "c:\python24\lib\site-packages\SQLObject-0.7.2-py2.4.egg\sqlobject\mysql\mysqlconnection.py", line 98, in _queryInsertID

self._executeRetry(conn, c, q)

File "c:\python24\lib\site-packages\SQLObject-0.7.2-py2.4.egg\sqlobject\mysql\mysqlconnection.py", line 77, in _executeRetry

myquery = unicode(query, self.encoding)

TypeError: decoding Unicode is not supported

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

headers

Oleg Broytmann | 6 Feb 16:39

Re: Patch to handle sets with the IN operator

On Wed, Jan 24, 2007 at 11:32:57PM +0200, Dan Pascu wrote:
> The attached patch allows one to use set/frozenset sets (available since 
> python 2.4) or Set/ImmutableSet sets (available since python 2.3) as 
> sequences passed to the IN operator (currently only lists and tuples can 
> be used). In fact it'll accept a set of values everywhere a list/tuple of 
> values is accepted.

   Committed in the trunk, docs and 0.8 branch in the revisions 2258-2260.
Thank you!

Oleg.
--

-- 
     Oleg Broytmann            http://phd.pp.ru/            phd <at> phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

headers

Oleg Broytmann | 6 Feb 17:12

Re: decoding Unicode is not supported

On Tue, Feb 06, 2007 at 09:31:52AM -0600, Jim Steil wrote:
>     myquery = unicode(query, self.encoding)
> 
> TypeError: decoding Unicode is not supported

   "query" must be string here. You have passed a unicode somewhere to
SQLObject where it is not allowed.

Oleg.
--

-- 
     Oleg Broytmann            http://phd.pp.ru/            phd <at> phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

5	February 2012
12	January 2012
16	December 2011
17	November 2011
12	August 2011
29	July 2011
9	June 2011
27	May 2011
26	April 2011
36	March 2011
44	February 2011
15	January 2011
30	December 2010
11	November 2010
26	October 2010
12	September 2010
23	August 2010
37	July 2010
13	June 2010
14	May 2010
71	April 2010
23	March 2010
63	February 2010
24	January 2010
11	December 2009
10	November 2009
20	October 2009
38	September 2009
57	August 2009
36	July 2009
30	June 2009
38	May 2009
19	April 2009
22	March 2009
46	February 2009
69	January 2009
65	December 2008
41	November 2008
37	October 2008
21	September 2008
30	August 2008
66	July 2008
31	June 2008
82	May 2008
69	April 2008
55	March 2008
139	February 2008
82	January 2008
54	December 2007
137	November 2007
101	October 2007
31	September 2007
81	August 2007
118	July 2007
82	June 2007
129	May 2007
120	April 2007
115	March 2007
102	February 2007
152	January 2007
135	December 2006
128	November 2006
330	October 2006
142	September 2006
161	August 2006
94	July 2006
160	June 2006
254	May 2006
218	April 2006
228	March 2006
157	February 2006
235	January 2006
235	December 2005
315	November 2005
466	October 2005
303	September 2005
336	August 2005
265	July 2005
166	June 2005
193	May 2005
152	April 2005
145	March 2005
258	February 2005
264	January 2005
177	December 2004
169	November 2004
60	October 2004
78	September 2004
65	August 2004
52	July 2004
67	June 2004
65	May 2004
88	April 2004
123	March 2004
92	February 2004
38	January 2004
61	December 2003
95	November 2003
85	October 2003
88	September 2003
64	August 2003
129	July 2003
107	June 2003
206	May 2003
204	April 2003
43	March 2003
2	February 2003

Mon	Tue	Wed	Thu	Fri	Sat	Sun

			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28