Discussion of Python object-relational mapper SQLObject

MySQL backend removes backslashes

Hi,

when running the self contained test script below using the SQLite
backend, the output correctly reads

C:\some\path

When using the MySQL backend is reads

C:somepath

Is this a bug?  What is the behavior of other backends.  Shouldn't
SQLObject escape the backslashes for the MySQL backend?

Kind regards,
Markus

from sqlobject import *

# SQLite works fine
#sqlhub.processConnection = connectionForURI('sqlite:/:memory:')

# MySQL removes backslashes
sqlhub.processConnection = connectionForURI('mysql://markus <at> localhost/test')

class Test(SQLObject):
    name = StringCol()

Test.dropTable(ifExists = True)
Test.createTable(ifNotExists = True)

(Continue reading)

headers

Oleg Broytmann | 5 Sep 12:25

Re: Bind / Prepare Success (20% to 40% faster), Sample Code

Hello.

On Thu, Aug 30, 2007 at 10:52:38PM -0500, Kevin J. Rice wrote:
>     if not selectResults and self.sqlmeta._perConnection and prepName:
>         statement = "execute %s (%s)" % (prepName, self.id)
>         selectResults = self._connection.queryOne(statement)
> 
> class Org(SQLObject):
>     class sqlmeta:
>         idName = 'OrgID'
>         table  = 'Org'
>         getByIDPrepName = table + '_getByID'
> 
> def getTransaction(tableList = []):
>     dsn = "host=127.0.0.1 dbname=dbrel203 user=krice password=chicken4lunch"
> 
>     con = PostgresConnection(dsn, debug=0)
>     for t in tableList:
>         prepName = None
>         try:
>             prepName = t.sqlmeta.getByIDPrepName
>         except AttributeError:
>             print "No getByIDPrepName defined."
>         assert prepName, "Must define a sqlmeta getByIDPrepName for each
> table object passed into getTransaction."    
>         dbNames = [col.dbName for col in t.sqlmeta.columnList]
>         prep = "prepare %s (int) as select %s from %s where (%s.%s) = $1;" %
> \
>             (t.sqlmeta.table + '_getByID', 
>              ', '.join([x for x in dbNames]),

(Continue reading)

headers

Oleg Broytmann | 5 Sep 12:33

Re: MySQL backend removes backslashes

On Tue, Sep 04, 2007 at 08:35:09PM +0200, Markus Gritsch wrote:
> Test(name=r'C:\some\path')
> print Test.get(1).name # C:somepath when using MySQL

   SQLite:

 4/QueryIns:  INSERT INTO test (name) VALUES ('C:\some\path')
C:\some\path

   Postgres:

 1/QueryIns:  INSERT INTO test (id, name) VALUES (1, 'C:\\some\\path')
C:\some\path

   Please add "?debug=1" to your DB URI and show the output. What version
of SQLObject are you using?

Oleg.
--

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

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

headers

luis cota | 5 Sep 13:18

IronPython & SQLObject

Has anyone been able to build SQLObject for IronPython successfully? I attempted to run the standard python version but IronPython has no ZipImport module...

Any help is much appreciated...

Thanks!

- Luis

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

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

headers

Oleg Broytmann | 5 Sep 13:31

Re: IronPython & SQLObject

On Wed, Sep 05, 2007 at 07:18:15AM -0400, luis cota wrote:
> Has anyone been able to build SQLObject for IronPython successfully?  I
> attempted to run the standard python version but IronPython has no ZipImport
> module...

   Why do you need ZipImport for SQLObject? To use an egg?

Oleg.
--

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

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

headers

luis cota | 5 Sep 13:46

Re: IronPython & SQLObject

I suppose I don't *need* SQLObject, that was just how I had it installed. I am attempting to run the build.py script using the ipy.exe executable but the script failes with:

error: package directory 'sqlobject' does not exist

- Luis

On 9/5/07, Oleg Broytmann <phd <at> phd.pp.ru> wrote:

On Wed, Sep 05, 2007 at 07:18:15AM -0400, luis cota wrote:
> Has anyone been able to build SQLObject for IronPython successfully?  I
> attempted to run the standard python version but IronPython has no ZipImport
> module...

  Why do you need ZipImport for SQLObject? To use an egg?

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

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>   http://get.splunk.com/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

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

headers

Oleg Broytmann | 5 Sep 13:51

Re: IronPython & SQLObject

On Wed, Sep 05, 2007 at 07:46:59AM -0400, luis cota wrote:
> error: package directory 'sqlobject' does not exist

   Instead of using the egg try unzipping the directory sqlobject out of
the egg. Or extract it from the source tarball.

Oleg.
--

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

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

headers

luis cota | 5 Sep 13:59

Re: IronPython & SQLObject

I extracted the sqlobject folder from the egg directory in my site-packages. When attempting an import, this is the error returned in IronPython. Perhaps you can help me with building the library?

>>> import sqlobject
Traceback (most recent call last):
File , line 0, in <stdin>##93
File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\sqlobject\__init__.py, line 1, in Initial
ize
File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\sqlobject\main.py, line 40, in Initialize

File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\sqlobject\dbconnection.py, line 19, in In
itialize
File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\sqlobject\col.py, line 30, in Initialize
File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\formencode-0.7.1-py2.5.egg\formencode\__i
nit__.py, line 1, in Initialize
File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\formencode- 0.7.1-py2.5.egg\formencode\api
.py, line 9, in Initialize
File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\setuptools-0.7a1dev_r53614-py2.5.egg\pkg_
resources.py, line 16, in Initialize
File , line 0, in __import__##4
ImportError: No module named zipimport

On 9/5/07, Oleg Broytmann <phd <at> phd.pp.ru> wrote:

On Wed, Sep 05, 2007 at 07:46:59AM -0400, luis cota wrote:
> error: package directory 'sqlobject' does not exist

  Instead of using the egg try unzipping the directory sqlobject out of
the egg. Or extract it from the source tarball.

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

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>   http://get.splunk.com/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

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

headers

luis cota | 5 Sep 14:03

Re: IronPython & SQLObject

After clearing out my site-packages directory and leaving only sqlobjects, this is what is returned:

>>> import sqlobject
Traceback (most recent call last):
File , line 0, in <stdin>##83
File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\sqlobject\__init__.py, line 1, in Initial
ize
File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\sqlobject\main.py, line 40, in Initialize

File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\sqlobject\dbconnection.py, line 19, in In
itialize
File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\sqlobject\col.py, line 30, in Initialize
File , line 0, in __import__##4
ImportError: No module named formencode

On 9/5/07, luis cota <lo.maximo73 <at> gmail.com> wrote:

I extracted the sqlobject folder from the egg directory in my site-packages. When attempting an import, this is the error returned in IronPython. Perhaps you can help me with building the library?

>>> import sqlobject
Traceback (most recent call last):
File , line 0, in <stdin>##93
File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\sqlobject\__init__.py, line 1, in Initial
ize
File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\sqlobject\main.py, line 40, in Initialize

File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\sqlobject\dbconnection.py, line 19, in In
itialize
File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\sqlobject\col.py, line 30, in Initialize
File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\formencode-0.7.1-py2.5.egg\formencode\__i
nit__.py, line 1, in Initialize
File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\formencode- 0.7.1-py2.5.egg\formencode\api
.py, line 9, in Initialize
File , line 0, in __import__##4
File C:\IronPython\lib\site-packages\setuptools-0.7a1dev_r53614-py2.5.egg\pkg_
resources.py, line 16, in Initialize
File , line 0, in __import__##4
ImportError: No module named zipimport

On 9/5/07, Oleg Broytmann <phd <at> phd.pp.ru > wrote:

On Wed, Sep 05, 2007 at 07:46:59AM -0400, luis cota wrote:
> error: package directory 'sqlobject' does not exist

  Instead of using the egg try unzipping the directory sqlobject out of
the egg. Or extract it from the source tarball.

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

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>   http://get.splunk.com/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

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

headers

Oleg Broytmann | 5 Sep 14:22

Re: IronPython & SQLObject

On Wed, Sep 05, 2007 at 08:03:57AM -0400, luis cota wrote:
> ImportError: No module named formencode

   SQLObject requires FormEncode.

Oleg.
--

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

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

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