[dabo-users] sqlite3 error

Back to top

Author: Jim Byrnes

Posted: 2010-09-30 17:49:33 Link

I am handcoding a Dabo app. When I run it I get the following error:

Traceback (most recent call last):

File "dMask.py", line 66, in <module>

testBizobj = TestBizobj(conn)

File "/usr/local/lib/python2.6/dist-packages/dabo/biz/dBizobj.py",

line 51, in __init__

self.setConnection(conn)

File "/usr/local/lib/python2.6/dist-packages/dabo/biz/dBizobj.py",

line 129, in setConnection

self.dbapiCursorClass = self._cursorFactory.getDictCursorClass()

AttributeError: 'sqlite3.Connection' object has no attribute

'getDictCursorClass'

Version info: Platform: GTK

Python Version: 2.6.5 on linux2

Dabo Version: Version 0.9.2; Revision ~5924

UI Version: 2.8.11.0 on wxGTK (gtk2)

Sqlite3 was installed with Ubuntu Lucid so it should be version 3.6.22-1

Thanks, Jim

_______________________________________________

Post Messages to: Dabo-users@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Searchable Archives: http://leafe.com/archives/search/dabo-users

This message: http://leafe.com/archives/byMID/4CA505ED.904@comcast.net

New Search

Back to top

Re: [dabo-users] sqlite3 error

Author: Ed Leafe

Posted: 2010-09-30 17:58:42 Link

On Sep 30, 2010, at 5:49 PM, Jim Byrnes wrote:

> I am handcoding a Dabo app. When I run it I get the following error:

>

> Traceback (most recent call last):

> File "dMask.py", line 66, in <module>

> testBizobj = TestBizobj(conn)

> File "/usr/local/lib/python2.6/dist-packages/dabo/biz/dBizobj.py",

> line 51, in __init__

> self.setConnection(conn)

> File "/usr/local/lib/python2.6/dist-packages/dabo/biz/dBizobj.py",

> line 129, in setConnection

> self.dbapiCursorClass = self._cursorFactory.getDictCursorClass()

> AttributeError: 'sqlite3.Connection' object has no attribute

> 'getDictCursorClass'

>

> Version info: Platform: GTK

> Python Version: 2.6.5 on linux2

> Dabo Version: Version 0.9.2; Revision ~5924

> UI Version: 2.8.11.0 on wxGTK (gtk2)

>

> Sqlite3 was installed with Ubuntu Lucid so it should be version 3.6.22-1

The error has nothing to do with Sqlite; it's in the dConnection class (which is the bizobj's _cursorFactory). My guess is that you are using a plain connection to the database, and not a Dabo dConnection.

Can you show me the code where the 'conn' in the dMask.py code is defined?

-- Ed Leafe

_______________________________________________

Post Messages to: Dabo-users@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Searchable Archives: http://leafe.com/archives/search/dabo-users

This message: http://leafe.com/archives/byMID/7EA7F30A-5542-4FE9-B826-4D49AE1C0FAA@leafe.com

New Search

Back to top

Re: [dabo-users] sqlite3 error

Author: John Fabiani

Posted: 2010-09-30 17:59:46 Link

On Thursday, September 30, 2010 02:49:33 pm Jim Byrnes wrote:

> I am handcoding a Dabo app. When I run it I get the following error:

>

> Traceback (most recent call last):

> File "dMask.py", line 66, in <module>

> testBizobj = TestBizobj(conn)

> File "/usr/local/lib/python2.6/dist-packages/dabo/biz/dBizobj.py",

> line 51, in __init__

> self.setConnection(conn)

> File "/usr/local/lib/python2.6/dist-packages/dabo/biz/dBizobj.py",

> line 129, in setConnection

> self.dbapiCursorClass = self._cursorFactory.getDictCursorClass()

> AttributeError: 'sqlite3.Connection' object has no attribute

> 'getDictCursorClass'

>

> Version info: Platform: GTK

> Python Version: 2.6.5 on linux2

> Dabo Version: Version 0.9.2; Revision ~5924

> UI Version: 2.8.11.0 on wxGTK (gtk2)

>

> Sqlite3 was installed with Ubuntu Lucid so it should be version 3.6.22-1

>

> Thanks, Jim

for testing checkout what I did on the wiki

http://wiki.dabodev.com/CreateAOpenOfficeSpreadSheet

Johnf

_______________________________________________

Post Messages to: Dabo-users@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Searchable Archives: http://leafe.com/archives/search/dabo-users

This message: http://leafe.com/archives/byMID/201009301459.46165.johnf@jfcomputer.com

New Search

Back to top

Re: [dabo-users] sqlite3 error

Author: Jim Byrnes

Posted: 2010-09-30 20:24:06 Link

Ed Leafe wrote:

> On Sep 30, 2010, at 5:49 PM, Jim Byrnes wrote:

>

>> I am handcoding a Dabo app. When I run it I get the following

>> error:

>>

>> Traceback (most recent call last): File "dMask.py", line 66,

>> in<module> testBizobj = TestBizobj(conn) File

>> "/usr/local/lib/python2.6/dist-packages/dabo/biz/dBizobj.py", line

>> 51, in __init__ self.setConnection(conn) File

>> "/usr/local/lib/python2.6/dist-packages/dabo/biz/dBizobj.py", line

>> 129, in setConnection self.dbapiCursorClass =

>> self._cursorFactory.getDictCursorClass() AttributeError:

>> 'sqlite3.Connection' object has no attribute 'getDictCursorClass'

>>

>> Version info: Platform: GTK Python Version: 2.6.5 on linux2 Dabo

>> Version: Version 0.9.2; Revision ~5924 UI Version: 2.8.11.0 on

>> wxGTK (gtk2)

>>

>> Sqlite3 was installed with Ubuntu Lucid so it should be version

>> 3.6.22-1

>

> The error has nothing to do with Sqlite; it's in the dConnection

> class (which is the bizobj's _cursorFactory). My guess is that you

> are using a plain connection to the database, and not a Dabo

> dConnection.

>

> Can you show me the code where the 'conn' in the dMask.py code is

> defined?

>

> -- Ed Leafe

No need for the code, you are correct. I can connect using dConnection.

I was looking at and possibly misunderstanding an example I found that

was written in 2008.

Thanks, Jim

_______________________________________________

Post Messages to: Dabo-users@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Searchable Archives: http://leafe.com/archives/search/dabo-users

This message: http://leafe.com/archives/byMID/4CA52A26.4000307@comcast.net

New Search

Back to top

Re: [dabo-users] sqlite3 error

Author: Jim Byrnes

Posted: 2010-09-30 20:30:11 Link

John Fabiani wrote:

>

> for testing checkout what I did on the wiki

>

> http://wiki.dabodev.com/CreateAOpenOfficeSpreadSheet

>

> Johnf

Actually I was working off of an email you wrote back in 2008. It looks

quite different from the wiki, Things must have changed a lot in the

interim. Thanks for the example.

Regards, Jim

_______________________________________________

Post Messages to: Dabo-users@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Searchable Archives: http://leafe.com/archives/search/dabo-users

This message: http://leafe.com/archives/byMID/4CA52B93.4090205@comcast.net

New Search

Back to top

Re: [dabo-users] sqlite3 error

Author: John Fabiani

Posted: 2010-09-30 20:33:22 Link

On Thursday, September 30, 2010 05:30:11 pm Jim Byrnes wrote:

> John Fabiani wrote:

> > for testing checkout what I did on the wiki

> >

> > http://wiki.dabodev.com/CreateAOpenOfficeSpreadSheet

> >

> > Johnf

>

> Actually I was working off of an email you wrote back in 2008. It looks

> quite different from the wiki, Things must have changed a lot in the

> interim. Thanks for the example.

>

> Regards, Jim

To my knowledge the connection stuff hasn't change in years. But it's

possible get connections object many different ways. But it's best just to

use the standard way.

self.Application.addConnectFile("summit.cnxml")

self.apiconn = self.Application.getConnectionByName("summitConn")

Johnf

_______________________________________________

Post Messages to: Dabo-users@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Searchable Archives: http://leafe.com/archives/search/dabo-users

This message: http://leafe.com/archives/byMID/201009301733.22759.johnf@jfcomputer.com

New Search