Author: Bob K.
Posted: 2011-06-01 16:34:24 Link
In the classdesigner, I’ve added an sqlite data connection, and the test works. when selecting the connection and clicking the ‘next’ button, nothing is happening (no error, no new screen). I’m using windows 7.
bop k.
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
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/E8DEF90CE5C24DCEAFBEF8F5C71E33AA@BobPC
Author: Ed Leafe
Posted: 2011-06-01 16:53:02 Link
On Jun 1, 2011, at 4:34 PM, Bob K. wrote:
> In the classdesigner, I’ve added an sqlite data connection, and the test works. when selecting the connection and clicking the ‘next’ button, nothing is happening (no error, no new screen). I’m using windows 7.
This is almost certainly a pathing problem, since SQLite is a file-based connection. Can you open the .cnxml file and tell me what's in the <database> tag? Is it an accurate path from where you're running the Class Designer app?
-- 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/7803C74E-642F-44C9-AEFD-07B6A018ABB6@leafe.com
Author: Bob K.
Posted: 2011-06-02 08:00:16 Link
Hi Ed,
I've edited the database tag, and it's still not working. here's the
traceback info:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\dabo\ide>c:\python27\python classdesigner.py
C:\dabo\ide>c:\python27\python classdesigner.py
Traceback (most recent call last):
File "c:\python27\lib\site-packages\wx-2.8-msw-unicode\wx\_core.py", line
1464
0, in <lambda>
lambda event: event.callable(*event.args, **event.kw) )
File
"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\dDataControlM
ixinBase.py", line 365, in _delayedSetDataSource
self.update()
File
"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\dDataControlM
ixinBase.py", line 102, in update
self.__dataUpdate()
File
"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\dDataControlM
ixinBase.py", line 154, in __dataUpdate
self.Value = srcatt
File
"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\uiwx\dControl
ItemMixin.py", line 384, in _setValue
self.StringValue = value
File
"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\uiwx\dControl
ItemMixin.py", line 358, in _setStringValue
raise ValueError(_("String must be present in the choices."))
ValueError: String must be present in the choices.
Traceback (most recent call last):
File
"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\uiwx\dControl
Mixin.py", line 27, in _onWxHit
self.raiseEvent(dEvents.Hit, evt, *args, **kwargs)
File
"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\uiwx\dPemMixi
n.py", line 992, in raiseEvent
super(dPemMixin, self).raiseEvent(eventClass, nativeEvent, *args,
**kwargs)
File
"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\lib\eventMixin.p
y", line 92, in raiseEvent
bindingFunction(event)
File
"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\dialogs\Wizar
d.py", line 124, in onNext
self.CurrentPage += pg.nextPage()
File
"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\dialogs\Wizar
d.py", line 291, in _setCurrPage
ok = self._pages[self._currentPage].onLeavePage(direction)
File "C:\dabo\ide\wizards\QuickLayoutWizard.py", line 63, in onLeavePage
return self.Wizard.makeConnection()
File "C:\dabo\ide\wizards\QuickLayoutWizard.py", line 788, in
makeConnection
tbls = crs.getTables()
File
"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\db\dCursorMixin.
py", line 2041, in getTables
return self.BackendObject.getTables(self.AuxCursor, includeSystemTables)
File
"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\db\dbSQLite.py",
line 148, in getTables
cursor.execute("select * from sqlite_master")
File
"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\db\dCursorMixin.
py", line 355, in execute
raise dException.DBQueryException(errMsg)
dabo.dException.DBQueryException: file is encrypted or is not a database
-----Original Message-----
From: Ed Leafe
Sent: Wednesday, June 01, 2011 4:53 PM
To: Dabo Users list
Subject: Re: [dabo-users] classDesigner Data Connection not working
On Jun 1, 2011, at 4:34 PM, Bob K. wrote:
> In the classdesigner, I’ve added an sqlite data connection, and the test
> works. when selecting the connection and clicking the ‘next’ button,
> nothing is happening (no error, no new screen). I’m using windows 7.
This is almost certainly a pathing problem, since SQLite is a file-based
connection. Can you open the .cnxml file and tell me what's in the
<database> tag? Is it an accurate path from where you're running the Class
Designer app?
-- 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/7803C74E-642F-44C9-AEFD-07B6A018ABB6@leafe.com
_______________________________________________
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/42F30762088B4F6484A22A91F2698160@BobPC
Author: Ed Leafe
Posted: 2011-06-03 08:15:27 Link
On Jun 2, 2011, at 8:00 AM, Bob K. wrote:
> File "c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\db\dbSQLite.py",
> line 148, in getTables
> cursor.execute("select * from sqlite_master")
> File "c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\db\dCursorMixin.
> py", line 355, in execute
> raise dException.DBQueryException(errMsg)
> dabo.dException.DBQueryException: file is encrypted or is not a database
That error message means that the SQLite database was created with an older version of SQLite. Where did this database come from? Can you open it from Python?
-- 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/00B77DD1-3A64-4BD9-885B-9FB9444D2D95@leafe.com
Author: Bob K.
Posted: 2011-06-03 08:38:57 Link
The database was created with SQLiteManager. The database connection test
ran successfully, so I assumed it was good.
I'm very new to python. what is the quickest way for me to test the
database?
bob k.
-----Original Message-----
From: Ed Leafe
Sent: Friday, June 03, 2011 8:15 AM
To: Dabo Users list
Subject: Re: [dabo-users] classDesigner Data Connection not working
On Jun 2, 2011, at 8:00 AM, Bob K. wrote:
> File
> "c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\db\dbSQLite.py",
> line 148, in getTables
> cursor.execute("select * from sqlite_master")
> File
> "c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\db\dCursorMixin.
> py", line 355, in execute
> raise dException.DBQueryException(errMsg)
> dabo.dException.DBQueryException: file is encrypted or is not a database
That error message means that the SQLite database was created with an older
version of SQLite. Where did this database come from? Can you open it from
Python?
-- 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/00B77DD1-3A64-4BD9-885B-9FB9444D2D95@leafe.com
_______________________________________________
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/97313F2C998B4902A22739C2D81205F7@BobPC
Author: Ed Leafe
Posted: 2011-06-04 11:59:26 Link
On Jun 3, 2011, at 8:38 AM, Bob K. wrote:
> The database was created with SQLiteManager. The database connection test
> ran successfully, so I assumed it was good.
>
> I'm very new to python. what is the quickest way for me to test the
> database?
Here is an example of a Python session that should do the trick: http://dabo.codepad.org/5LIrndI2
It's doing the basics of what the code that caused the exception was doing. Let me know what error message, if any, you get when you run it.
-- 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/CFDD6374-E239-4696-A37E-CB49B53147A6@leafe.com
Author: bob k.
Posted: 2011-06-04 12:33:02 Link
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\Bob>cd\
C:\>cd photography
C:\Photography>cd software
C:\Photography\Software>cd dabo
C:\Photography\Software\dabo>c:\python27\python
Python 2.7.1 (r271:86832, Nov 27 2010, 18:30:46) [MSC v.1500 32 bit (Intel)]
on
win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> cn = sqlite3.connect("rakPhoto.sqlite")
>>> crs = cn.cursor()
>>> crs.execute("select * from sqlite_master")
<sqlite3.Cursor object at 0x01802420>
>>> crs.fetchall()
[]
>>>
-----Original Message-----
From: Ed Leafe
Sent: Saturday, June 04, 2011 11:59 AM
To: Dabo Users list
Subject: Re: [dabo-users] classDesigner Data Connection not working
On Jun 3, 2011, at 8:38 AM, Bob K. wrote:
> The database was created with SQLiteManager. The database connection test
> ran successfully, so I assumed it was good.
>
> I'm very new to python. what is the quickest way for me to test the
> database?
Here is an example of a Python session that should do the trick:
http://dabo.codepad.org/5LIrndI2
It's doing the basics of what the code that caused the exception was doing.
Let me know what error message, if any, you get when you run it.
-- 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/CFDD6374-E239-4696-A37E-CB49B53147A6@leafe.com
_______________________________________________
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/A656A615BC6F48FC8BCC9DC7BE89CFA1@BobHP
Author: Ed Leafe
Posted: 2011-06-04 12:39:39 Link
On Jun 4, 2011, at 12:33 PM, bob k. wrote:
> C:\Photography\Software\dabo>c:\python27\python
> Python 2.7.1 (r271:86832, Nov 27 2010, 18:30:46) [MSC v.1500 32 bit (Intel)]
> on
> win32
> Type "help", "copyright", "credits" or "license" for more information.
>>>> import sqlite3
>>>> cn = sqlite3.connect("rakPhoto.sqlite")
>>>> crs = cn.cursor()
>>>> crs.execute("select * from sqlite_master")
> <sqlite3.Cursor object at 0x01802420>
>>>> crs.fetchall()
> []
>>>>
So was the 'rakPhoto.sqlite' database file in the current directory? If not, SQLite will create the database, which would show up as empty, as your last line does.
-- 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/86A71697-52CF-4063-BA5D-D6C014486661@leafe.com
Author: bob k.
Posted: 2011-06-04 12:51:44 Link
my apologies Ed. Here's the correct text:
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\Bob>cd\
C:\>cd photography
C:\Photography>cd software
C:\Photography\Software>cd dabo
C:\Photography\Software\dabo>c:\python27\python
Python 2.7.1 (r271:86832, Nov 27 2010, 18:30:46) [MSC v.1500 32 bit (Intel)]
on
win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> cn = sqlite3.connect("rakData.sqlite")
>>> crs = cn.cursor()
>>> crs.execute("select * from sqlite_master")
<sqlite3.Cursor object at 0x017C2420>
>>> crs.fetchall()
[(u'table', u'Chemicals', u'Chemicals', 2, u'CREATE TABLE [Chemicals]
(Chemicals
ID integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,ChemicalsName text NOT
NULL
UNIQUE,Active boolean,Notes text)'), (u'index',
u'sqlite_autoindex_Chemicals_1'
, u'Chemicals', 3, None), (u'index', u'sqlite_autoindex_Chemicals_2',
u'Chemical
s', 4, None), (u'table', u'sqlite_sequence', u'sqlite_sequence', 5, u'CREATE
TAB
LE sqlite_sequence(name,seq)')]
>>>
-----Original Message-----
From: Ed Leafe
Sent: Saturday, June 04, 2011 12:39 PM
To: Dabo Users list
Subject: Re: [dabo-users] classDesigner Data Connection not working
On Jun 4, 2011, at 12:33 PM, bob k. wrote:
> C:\Photography\Software\dabo>c:\python27\python
> Python 2.7.1 (r271:86832, Nov 27 2010, 18:30:46) [MSC v.1500 32 bit
> (Intel)]
> on
> win32
> Type "help", "copyright", "credits" or "license" for more information.
>>>> import sqlite3
>>>> cn = sqlite3.connect("rakPhoto.sqlite")
>>>> crs = cn.cursor()
>>>> crs.execute("select * from sqlite_master")
> <sqlite3.Cursor object at 0x01802420>
>>>> crs.fetchall()
> []
>>>>
So was the 'rakPhoto.sqlite' database file in the current directory? If not,
SQLite will create the database, which would show up as empty, as your last
line does.
-- 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/86A71697-52CF-4063-BA5D-D6C014486661@leafe.com
_______________________________________________
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/B94C927063074114AB2241B35E37F73D@BobHP
Author: Ed Leafe
Posted: 2011-06-04 13:06:01 Link
On Jun 4, 2011, at 12:51 PM, bob k. wrote:
> my apologies Ed. Here's the correct text:
OK, so it looks like the database is OK. When you ran the wizard, did the name of the connection for that database appear in the list box on the first page, or did you have to manually add it?
-- 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/DB258F68-4E86-4528-A21E-83DB1A32B58C@leafe.com