sqlobject-discuss

[SQLObject] Several problems with current CVS

[Frank B. <fb...@fo...>]

Hallo,

I'm still a bit struggling with getting SQLObject to work properly.
I'm trying both postgres and mysql. 

First people.py aborted with an NameError: MySQLConnection not defined

from DBConnection import *

fixes this, but it's probably not intended this way, or is it? 

Then the tests seem to run, but not correctly. The first error, using
either PG or MySQL is:

 >>> print p is p2
 0

This should yield True or 1, I guess. 

The next error follows soon:

 >>> p.addRole(r)
 Traceback (most recent call last):
   File "people.py", line 182, in ?
     runTest(test2)
   File "people.py", line 136, in runTest
     exec line[4:]
   File "<string>", line 1, in ?
 AttributeError: 'tuple' object has no attribute 'addRole'

Attached is the full debug output of a MySQL run. I'm running
python2.2 here on Debian, with these db-packages:
Source: python-mysqldb
Version: 0.9.2-0.2
Source: psycopg
Version: 1.0.13-1

MySQL is 3.22, PG is 7.2.3.

Any ideas? 

I'd like to get this working properly before I'm going to debug my
half functioning DBConnection.py with sqlite support ;)

ciao
-- 
 Frank Barknecht                               _ ______footils.org__

Re: [SQLObject] Several problems with current CVS

[Ian B. <ia...@co...>]

Oops, I forgot to do cvs commit.  Check out a new version and try
again...

On Sat, 2003-03-01 at 04:45, Frank Barknecht wrote:
> Hallo,
> 
> I'm still a bit struggling with getting SQLObject to work properly.
> I'm trying both postgres and mysql. 
> 
> First people.py aborted with an NameError: MySQLConnection not defined
> 
> from DBConnection import *
> 
> fixes this, but it's probably not intended this way, or is it? 
> 
> Then the tests seem to run, but not correctly. The first error, using
> either PG or MySQL is:
> 
>  >>> print p is p2
>  0
> 
> This should yield True or 1, I guess. 
> 
> The next error follows soon:
> 
>  >>> p.addRole(r)
>  Traceback (most recent call last):
>    File "people.py", line 182, in ?
>      runTest(test2)
>    File "people.py", line 136, in runTest
>      exec line[4:]
>    File "<string>", line 1, in ?
>  AttributeError: 'tuple' object has no attribute 'addRole'
> 
> Attached is the full debug output of a MySQL run. I'm running
> python2.2 here on Debian, with these db-packages:
> Source: python-mysqldb
> Version: 0.9.2-0.2
> Source: psycopg
> Version: 1.0.13-1
> 
> MySQL is 3.22, PG is 7.2.3.
> 
> Any ideas? 
> 
> I'd like to get this working properly before I'm going to debug my
> half functioning DBConnection.py with sqlite support ;)
> 
> ciao

Re: [SQLObject] Several problems with current CVS

[Frank B. <fb...@fo...>]

Hallo,
Ian Bicking hat gesagt: // Ian Bicking wrote:

> Oops, I forgot to do cvs commit.  Check out a new version and try
> again...

Thanks. I still need to import everything from DBConnection by hand.
Then I'm coming through now, but still I get 

  >>> p2 = Person(p.id)
  >>> print p2
  <Person 2 firstName='John' middleInitial='Q' lastName='Doe'>
  >>> print p is p2
  0

which irritates me quite a bit. 

Later, it fails at 

>>> peeps2 = Person.select(AND(PhoneNumber.q.personID == Person.q.id, PhoneNumber.q.phoneNumber.startswith('612')))
Traceback (most recent call last):
  File "examples/people.py", line 196, in ?
    runTest(test3)
  File "examples/people.py", line 139, in runTest
    exec line[4:]
  File "<string>", line 1, in ?
NameError: name 'AND' is not define

but this is fixed by adding
  from SQLBuilder import *
in people.py

I don't know, what the importing policy in SO should be. I'd like it,
if "from SQLObject import * " would be sufficient to use SO.

And my Shop.py script using the records db, I wrote you about before
this list was started is working fine now as well.

ciao
-- 
 Frank Barknecht                               _ ______footils.org__