Ed Leafe wrote:
> On Oct 17, 2007, at 5:28 PM, Kenneth Kixmoeller/fh wrote:
>
>
>>> But then again, in Python I miss being able to type out a raw SELECT
>>> statement and get a cursor of results.
>>>
>> I *really* miss that, too. So much so that I sometimes keep VFP open
>> so i can pass the same SQL through it so I can see the data for
>> testing.
>>
>
> I have a quick little script that returns a MySQL cursor object for
> the database I pass to it, and then do something like this in the
> Dabo Command Window:
>
> import getcursor
> crs = getcursor.connect("somedatabase")
> x = crs.execute
> f = crs.fetchall
> browse = dabo.ui.browse
>
> ... and from then on I can just run:
>
> x("select fld1, fld2 ...")
> browse(f())
>
> x("select fld4, fld5 ...")
> browse(f())
>
>
> -- Ed Leafe
> -- http://leafe.com
> -- http://dabodev.com
>
Hi Ed, I was following your little tutorial and I run into this :
PyCrust 0.9.5 - The Flakiest Python Shell
Python 2.5.4 (r254:67916, Dec 23 2008, 15:10:54) [MSC v.1310 32 bit
(Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import dabo
>>> conint = dabo.db.dConnectInfo(DbType='MySQL')
>>> conint.Host = "dabodev.com"
>>> conint.Database = 'daboconsult'
>>> conint.User = 'dabotutorial'
>>> conint.Password = 'PEDW3EH09S84P45DF9QE9SDA'
>>> conn = dabo.db.dConnection(conint).getConnection()
>>> cur = conn.cursor()
>>> cur.execute('select * from clients')
3L
>>> dabo.ui.browse(cur.fetchall())
Traceback (most recent call last):
File "<input>", line 1, in <module>
File "C:\Python25\lib\site-packages\dabo\ui\uiwx\__init__.py", line
1360, in browse
parent = dabo.ui.dForm(None, Caption=cap)
File "C:\Python25\lib\site-packages\dabo\ui\uiwx\dForm.py", line 914,
in __init__
BaseForm.__init__(self, preClass, parent, properties, attProperties,
*args, **kwargs)
File "C:\Python25\lib\site-packages\dabo\ui\uiwx\dForm.py", line 44,
in __init__
fm.dFormMixin.__init__(self, preClass, parent, properties,
attProperties, *args, **kwargs)
File "C:\Python25\lib\site-packages\dabo\ui\uiwx\dFormMixin.py", line
77, in __init__
attProperties, *args, **kwargs)
File "C:\Python25\lib\site-packages\dabo\ui\uiwx\dPemMixin.py", line
184, in __init__
self._afterInit()
File "C:\Python25\lib\site-packages\dabo\ui\uiwx\dForm.py", line 70,
in _afterInit
super(BaseForm, self)._afterInit()
File "C:\Python25\lib\site-packages\dabo\ui\uiwx\dFormMixin.py", line
92, in _afterInit
mbc = self.MenuBarClass
File "C:\Python25\lib\site-packages\dabo\ui\uiwx\dFormMixin.py", line
788, in _getMenuBarClass
mb = self._menuBarClass = self.Application.DefaultMenuBarClass
AttributeError: 'NoneType' object has no attribute 'DefaultMenuBarClass'
>>> dabo.ui.browse(cur.fetchall(), None)
Traceback (most recent call last):
File "<input>", line 1, in <module>
File "C:\Python25\lib\site-packages\dabo\ui\uiwx\__init__.py", line
1360, in browse
parent = dabo.ui.dForm(None, Caption=cap)
File "C:\Python25\lib\site-packages\dabo\ui\uiwx\dForm.py", line 914,
in __init__
BaseForm.__init__(self, preClass, parent, properties, attProperties,
*args, **kwargs)
File "C:\Python25\lib\site-packages\dabo\ui\uiwx\dForm.py", line 44,
in __init__
fm.dFormMixin.__init__(self, preClass, parent, properties,
attProperties, *args, **kwargs)
File "C:\Python25\lib\site-packages\dabo\ui\uiwx\dFormMixin.py", line
77, in __init__
attProperties, *args, **kwargs)
File "C:\Python25\lib\site-packages\dabo\ui\uiwx\dPemMixin.py", line
184, in __init__
self._afterInit()
File "C:\Python25\lib\site-packages\dabo\ui\uiwx\dForm.py", line 70,
in _afterInit
super(BaseForm, self)._afterInit()
File "C:\Python25\lib\site-packages\dabo\ui\uiwx\dFormMixin.py", line
92, in _afterInit
mbc = self.MenuBarClass
File "C:\Python25\lib\site-packages\dabo\ui\uiwx\dFormMixin.py", line
788, in _getMenuBarClass
mb = self._menuBarClass = self.Application.DefaultMenuBarClass
AttributeError: 'NoneType' object has no attribute 'DefaultMenuBarClass'
>>>
What am I doing wrong?
TIA
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: [email protected]
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/[email protected]
