Discussion of Python object-relational mapper SQLObject

Re: Short vacation

> Hi! I'm leaving the Net for a week. Will be back at 6th of November.

Have fun on your vacation Oleg!

Cheers,
Daniel

--

-- 
Psss, psss, put it down! - http://www.cafepress.com/putitdown

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference

headers

Wolfgang Morawetz | 8 Nov 21:45

Select does not work with some fieldname

Hi,
please help.
how do i this SQL
SELECT *
FROM `TAthlet`
WHERE TCountry_id = 'AUT'

The table "TAthlet" have this fields:
TUnion_id
id
short
name
TGender_id
TGoup_id
TCountry_id

This does not work:
from sqlobject import *
sqlhub.processConnection =
connectionForURI('mysql://archer:xxxxxx <at> localhost/adb')

class TAthlet(SQLObject):
    class sqlmeta:
        #if i dont do this i get a wrong tathlet table
        table = "TAthlet"
        fromDatabase = True

TAthlet._connection.debug = True
r = TAthlet.select(TAthlet.q.Tcountry_id=='AUT')

(Continue reading)

headers

Petr Jakeš | 8 Nov 22:01

Re: Select does not work with some fieldname

please help.
how do i this SQL
SELECT *
FROM `TAthlet`
WHERE TCountry_id = 'AUT'

The table "TAthlet" have this fields:
TUnion_id
id
short
name
TGender_id
TGoup_id
TCountry_id

This does not work:
from sqlobject import *
sqlhub.processConnection =
connectionForURI('mysql://archer:xxxxxx <at> localhost/adb')

class TAthlet(SQLObject):
class sqlmeta:
#if i dont do this i get a wrong tathlet table
table = "TAthlet"
fromDatabase = True

TAthlet._connection.debug = True
r = TAthlet.select(TAthlet.q.Tcountry_id=='AUT')

The Error:
AttributeError: TAthlet instance has no attribute 'Tcountry_id'

what about:
r = TAthlet.select(TAthlet.q.TcountryId=='AUT')

Petr

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july

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

headers

Petr Jakeš | 10 Nov 13:30

Re: Select does not work with some fieldname

2009/11/10 Wolfgang Morawetz <wolfgang.morawetz <at> gmx.at>

Petr Jakeš schrieb:

>
> Maybe you can printout the names SQLObject reads from the database
> and than use this names:
> for col in TCountry.sqlmeta.columnList:
> print col
>
> Or maybe:
>
> print col.origName, col.dbName
>
> Petr
>

Hmmm,
for TAthlet i get:
TUnionID TUnion_id
short short
name name
TGenderID TGender_id
TGroupID TGroup_id
TCountryID TCountry_id

and for TCountry:
name name

So SQLObject removes the underline ok, but i get no id fields?

BTW Thanks for helping Petr!

You can define (name) existing columns (names) explicitly. Even existing ID column. I am using existing database as well and I am connecting to it this way:

class Cenktgm01(SQLObject):
#    _connection = connection
    class sqlmeta:
        idType = str
        idName = 'OID$CENKTGM01'
    ktgi = StringCol(dbName="ktginterni")

BTW, you do not need to know about the id. SQLObject is treating id automatically beneath the scene.

Sometime wiki can help: http://wiki.sqlobject.org/
I am experimenting with the SQLite inMemory database a lot as well (as shown in following exampe).

from sqlobject import *
connectionInMemory = connectionForURI('sqlite:/:memory:')
class Person(SQLObject):
    _connection = connectionInMemory
    firstName = StringCol()
    middleInitial = StringCol(length=1, default=None)
    lastName = StringCol()

Regards

Petr

PS: please try to "reply to all", so other peeople in the mailing list can help/comment as well.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july

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

headers

Oleg Broytman | 19 Nov 15:02

SQL pie chart

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 Broytman            http://phd.pp.ru/            phd <at> phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july

headers

Daniel Fetchinson | 19 Nov 18:00

Re: SQL pie chart

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

Is it portable to all backends sqlobject supports? :)

Cheers,
Daniel

--

-- 
Psss, psss, put it down! - http://www.cafepress.com/putitdown

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july

headers

Oleg Broytman | 19 Nov 18:05

Re: SQL pie chart

On Thu, Nov 19, 2009 at 06:00:02PM +0100, Daniel Fetchinson wrote:
> > 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. 
> 
> Is it portable to all backends sqlobject supports? :)

   If I knew... Actually, I didn't recognize the SQL dialect used.
There is 'mysql' in the URL, but I doubt it is really MySQL.

Oleg.
--

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

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july

headers

Daniel Fetchinson | 20 Nov 00:25

Re: SQL pie chart

>> > 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. 
>>
>> Is it portable to all backends sqlobject supports? :)
>
>    If I knew... Actually, I didn't recognize the SQL dialect used.
> There is 'mysql' in the URL, but I doubt it is really MySQL.

>From the output it also seems to me that it is mysql, actually I am
pretty certain it is.

Would love to do this in sqlite :)

Cheers,
Daniel

--

-- 
Psss, psss, put it down! - http://www.cafepress.com/putitdown

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july

headers

inf200475 | 27 Nov 04:19

relation

Hi , first of all sorry for my english, I speak Spanish, but I am working with SQLObject and I am a newbie, and I dont know how to make a relation among 3 tables M:M
Thanks

Untitled Document

Participe en Universidad 2010,
del 8 al 12 de febrero del 2010
La Habana, Cuba
http://www.universidad2010.cu
http://www.universidad2010.com

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july

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

headers

Oleg Broytman | 27 Nov 11:28

Re: relation

On Thu, Nov 26, 2009 at 10:19:24PM -0500, inf200475 <at> ucf.edu.cu wrote:
> Hi , first of all sorry for my english, I speak Spanish, but I am working with SQLObject
> and I am a newbie,

   Welcome!

> and I dont know how to make a relation among 3 tables M:M

   Probably you need 3 separate relations - table1<->table2,
table2<->table3, table1<->table3.
   What SQL queries do you have in mind? I must say in advance that
high-level API in SQLObject doesn't allow any query to be expressed in
SQLObject's objects, but there is medium-level API that allows you to
execute any SQL query and get back the list of lists of results.

Oleg.
--

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

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july

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