sqlobject-discuss

[SQLObject] IntCol not working - desparately need help

[Mike M. <mm...@wo...>]

Hi,

I have the following test code:

from SQLObject import *
import MySQLdb

conn = MySQLdb.connect()
conn.cursor().execute('create database mike')
conn.close()

compcode = 'mike'
conn = MySQLConnection(user = '', db = 'mike')

class Person(SQLObject):
    _connection = conn
    firstName = StringCol(length = 20, default = None)
    lastName = StringCol(length = 20, default = None)
    index = IntCol()
    
    
Person.createTable(ifNotExists = True)

p = Person.new(firstName = 'Mike', lastName = 'Moum')
p = Person.new(firstName = 'Dean', lastName = 'Paque')


< end code >

When I try to run it, I get:

[root@localhost test]# python sqlobjtest.py
Traceback (most recent call last):
  File "sqlobjtest.py", line 18, in ?
    Person.createTable(ifNotExists = True)
  File "/usr/local/lib/python2.3/site-packages/SQLObject/SQLObject.py", line 
965, in createTable
    cls._connection.createTable(cls)
  File "/usr/local/lib/python2.3/site-packages/SQLObject/DBConnection.py", 
line 271, in createTable
    self.query('CREATE TABLE %s (\n%s\n)' % \
  File "/usr/local/lib/python2.3/site-packages/SQLObject/DBConnection.py", 
line 123, in query
    return self._runWithConnection(self._query, s)
  File "/usr/local/lib/python2.3/site-packages/SQLObject/DBConnection.py", 
line 72, in _runWithConnection
    val = meth(conn, *args)
  File "/usr/local/lib/python2.3/site-packages/SQLObject/DBConnection.py", 
line 120, in _query
    conn.cursor().execute(s)
  File "/usr/local/lib/python2.3/site-packages/MySQLdb/cursors.py", line 95, 
in execute
    return self._execute(query, args)
  File "/usr/local/lib/python2.3/site-packages/MySQLdb/cursors.py", line 114, 
in _execute
    self.errorhandler(self, exc, value)
  File "/usr/local/lib/python2.3/site-packages/MySQLdb/connections.py", line 
33, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL 
syntax.  Check the manual that corresponds to your MySQL server version for 
the right syntax to use near 'INT\n)' at line 5")
[root@localhost test]#


When I comment out the IntCol field in the Person class, all is well.
Please help!  Am working on a program.

Thanks,
Mike
-- 
the Moum's (Mike, Dede, Suzanne, Jeff, Kristen)
Tipp City, Ohio, USA
Visit the Baha'i World web site at www.bahai.org
Visit the U.S. Baha'i web site at www.us.bahai.org

Re: [SQLObject] IntCol not working - desparately need help

[Randall R. <ra...@ra...>]

On Friday, November 14, 2003, at 02:04 AM, Mike Moum wrote:

> Hi,
>
> I have the following test code:
>
> from SQLObject import *
> import MySQLdb
>
> conn = MySQLdb.connect()
> conn.cursor().execute('create database mike')
> conn.close()
>
> compcode = 'mike'
> conn = MySQLConnection(user = '', db = 'mike')
>
> class Person(SQLObject):
>     _connection = conn
>     firstName = StringCol(length = 20, default = None)
>     lastName = StringCol(length = 20, default = None)
>     index = IntCol()

The word "index" is reserved in MySQL.

You should use
myIndex = IntCol()
if you have to have a separate index.

However, probably you could use the SQLObject 'id'
column for this, which is created automatically
for you:

class Person(SQLObject):
   _connection = conn
   firstName = StringCol(length=20, default=None)
   lastName = StringCol(length=20, defaultNone)

 >>> p = Person.new()
 >>> print p.id
1

--
Randall Randall
ra...@ra...

Re: [SQLObject] IntCol not working - desparately need help

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

On Nov 14, 2003, at 2:10 AM, Randall Randall wrote:
> On Friday, November 14, 2003, at 02:04 AM, Mike Moum wrote:
>
>> Hi,
>>
>> I have the following test code:
>>
>> from SQLObject import *
>> import MySQLdb
>>
>> conn = MySQLdb.connect()
>> conn.cursor().execute('create database mike')
>> conn.close()
>>
>> compcode = 'mike'
>> conn = MySQLConnection(user = '', db = 'mike')
>>
>> class Person(SQLObject):
>>     _connection = conn
>>     firstName = StringCol(length = 20, default = None)
>>     lastName = StringCol(length = 20, default = None)
>>     index = IntCol()
>
> The word "index" is reserved in MySQL.
>
> You should use
> myIndex = IntCol()
> if you have to have a separate index.

Good catch.  You can also do
     index = IntCol(colName="person_index")

--
Ian Bicking | ia...@co... | http://blog.ianbicking.org

Re: [SQLObject] IntCol not working - desparately need help

[Mike M. <mm...@wo...>]

On Friday 14 November 2003 11:31 am, Ian Bicking wrote:

Thank you both for prompt and accurate replies.  Approximately 1-3/4 seconds 
after waking up this morning, it occured to me that "index" is indeed a 
reserved word in SQL, which goes to confirm one more time that continuing to 
beat one's head against the wall late at night is futile and painful.  
Unfortunately, that doesn't stop me from doing it, though.

Also, thanks for not rubbing my nose in it.

Mike
> On Nov 14, 2003, at 2:10 AM, Randall Randall wrote:
> > The word "index" is reserved in MySQL.
> >
> > You should use
> > myIndex = IntCol()
> > if you have to have a separate index.
>
> Good catch.  You can also do
>      index = IntCol(colName="person_index")
>
> --
> Ian Bicking | ia...@co... | http://blog.ianbicking.org

-- 
the Moum's (Mike, Dede, Suzanne, Jeff, Kristen)
Tipp City, Ohio, USA
Visit the Baha'i World web site at www.bahai.org
Visit the U.S. Baha'i web site at www.us.bahai.org