dShell error

[Nate Lowrie]

Ed,

I get this error when I try to launch a dShell using the menu...

Dabo Error Log: Mon Jul 21 09:30:41 2008: Cannot populate without data for alias
 dataset
Traceback (most recent call last):
  File "c:\Python25\lib\site-packages\dabo-full\trunk\dabo\ui\uiwx\dMenuItem.py"
, line 55, in __onWxHit
    self.raiseEvent(dEvents.Hit, evt)
  File "c:\Python25\lib\site-packages\dabo-full\trunk\dabo\ui\uiwx\dPemMixin.py"
, line 922, in raiseEvent
    super(dPemMixin, self).raiseEvent(eventClass, nativeEvent, *args, **kwargs)
  File "C:\Python25\lib\site-packages\dabo-full\trunk\dabo\lib\eventMixin.py", l
ine 92, in raiseEvent
    bindingFunction(event)
  File "C:\Python25\lib\site-packages\dabo-full\trunk\dabo\dApp.py", line 1019,
in onCmdWin
    self.uiApp.onCmdWin(evt)
  File "C:\Python25\lib\site-packages\dabo-full\trunk\dabo\ui\uiwx\uiApp.py", li
ne 345, in onCmdWin
    self.showCommandWindow()
  File "C:\Python25\lib\site-packages\dabo-full\trunk\dabo\ui\uiwx\uiApp.py", li
ne 352, in showCommandWindow
    dlg = dabo.ui.dShell.dShell(context)
  File "c:\Python25\lib\site-packages\dabo-full\trunk\dabo\ui\uiwx\dSplitForm.py
", line 14, in __init__
    super(dSplitForm, self).__init__(*args, **kwargs)
  File "C:\Python25\lib\site-packages\dabo-full\trunk\dabo\ui\uiwx\dForm.py", li
ne 972, in __init__
    BaseForm.__init__(self, preClass, parent, properties, attProperties, *args,
**kwargs)
  File "C:\Python25\lib\site-packages\dabo-full\trunk\dabo\ui\uiwx\dForm.py", li
ne 108, in __init__
    fm.dFormMixin.__init__(self, preClass, parent, properties, attProperties, *a
rgs, **kwargs)
  File "C:\Python25\lib\site-packages\dabo-full\trunk\dabo\ui\uiwx\dFormMixin.py
", line 71, in __init__
    attProperties, *args, **kwargs)
  File "c:\Python25\lib\site-packages\dabo-full\trunk\dabo\ui\uiwx\dPemMixin.py"
, line 183, in __init__
    self._afterInit()
  File "c:\Python25\lib\site-packages\dabo-full\trunk\dabo\ui\uiwx\dShell.py", l
ine 334, in _afterInit
    self.restoreHistory()
  File "c:\Python25\lib\site-packages\dabo-full\trunk\dabo\ui\uiwx\dShell.py", l
ine 422, in restoreHistory
    ds = self._loadHistory()
  File "c:\Python25\lib\site-packages\dabo-full\trunk\dabo\ui\uiwx\dShell.py", l
ine 395, in _loadHistory
    ds = dsu.sort("stamp", "desc")
  File "c:\Python25\lib\site-packages\dabo-full\trunk\dabo\db\dDataSet.py", line
 139, in sort
    ret = self.execute(stmnt)
  File "c:\Python25\lib\site-packages\dabo-full\trunk\dabo\db\dDataSet.py", line
 351, in execute
    self._cursor.execute(sqlExpr, params)
sqlite3.OperationalError: no such table: dataset


_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/4bef56240807210832qf7805f3h33b2d52c0aac6dde@...

[Ed Leafe]

On Jul 21, 2008, at 10:32 AM, Nate Lowrie wrote:

> I get this error when I try to launch a dShell using the menu...


        OK, I see the problem if there is no previous history. I've posted a  
fix. I am surprised that SQLite balked at creating a table with no data.

-- Ed Leafe





_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/DD91DA14-9851-4F93-AA53-F507E9D778F5@...

[Nate Lowrie]

On Mon, Jul 21, 2008 at 9:39 AM, Ed Leafe <ed@...> wrote:
>        OK, I see the problem if there is no previous history. I've posted a
> fix. I am surprised that SQLite balked at creating a table with no data.

Works for me.  I thought the issue was that there was no table?


_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/4bef56240807210842q50f64f98k12b9827c8256d04f@...

[Nate Lowrie]

On Mon, Jul 21, 2008 at 9:42 AM, Nate Lowrie <solodex2151@...> wrote:
> On Mon, Jul 21, 2008 at 9:39 AM, Ed Leafe <ed@...> wrote:
>>        OK, I see the problem if there is no previous history. I've posted a
>> fix. I am surprised that SQLite balked at creating a table with no data.
>
> Works for me.  I thought the issue was that there was no table?

On another note, what exactly did you add to dShell and how do I use it?


_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/4bef56240807210844y7eb406dwa822f79d2a609cdf@...

[Ed Leafe]

On Jul 21, 2008, at 10:42 AM, Nate Lowrie wrote:

>>       OK, I see the problem if there is no previous history. I've  
>> posted a
>> fix. I am surprised that SQLite balked at creating a table with no  
>> data.
>
> Works for me.  I thought the issue was that there was no table?

        It's the sorting algorithm used with dDataSet. It does a select/order  
to do the ordering, and SQLite was balking at  selecting from an empty  
table.

-- Ed Leafe





_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/F3802A53-DC75-4A23-AC69-65E70426A544@...

[Ed Leafe]

On Jul 21, 2008, at 10:44 AM, Nate Lowrie wrote:

> On another note, what exactly did you add to dShell and how do I use  
> it?

        If you use *nix terminals, you know that ctrl-R brings up the ability  
to search previous commands. I implemented this visually in dShell.  
Try pressing ctrl-R and then typing some part of a previous command to  
see it in action.

-- Ed Leafe





_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/65177E45-9116-478D-939D-8C139D475041@...

[Nate Lowrie]

On Mon, Jul 21, 2008 at 9:47 AM, Ed Leafe <ed@...> wrote:
> On Jul 21, 2008, at 10:44 AM, Nate Lowrie wrote:
>
>> On another note, what exactly did you add to dShell and how do I use
>> it?
>
>        If you use *nix terminals, you know that ctrl-R brings up the ability
> to search previous commands. I implemented this visually in dShell.
> Try pressing ctrl-R and then typing some part of a previous command to
> see it in action.

Nothing is happening when I hit Ctrl-R...No logs, tracebacks, nothing
visually, nothing when I start typing part of a previous command.


_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/4bef56240807210852s39eb3d7cw21ea36b36403ac23@...

[Ed Leafe]

On Jul 21, 2008, at 10:52 AM, Nate Lowrie wrote:

> Nothing is happening when I hit Ctrl-R...No logs, tracebacks, nothing
> visually, nothing when I start typing part of a previous command.


        Platform?

        I tested on Mac and it's working flawlessly. I added it for my own  
use, since I use dShell all the time.

-- Ed Leafe





_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/CEB52077-397F-49AE-A181-47D184B04E5E@...

[Nate Lowrie]

On Mon, Jul 21, 2008 at 9:56 AM, Ed Leafe <ed@...> wrote:

> On Jul 21, 2008, at 10:52 AM, Nate Lowrie wrote:
>
>> Nothing is happening when I hit Ctrl-R...No logs, tracebacks, nothing
>> visually, nothing when I start typing part of a previous command.
>
>
>        Platform?
>
>        I tested on Mac and it's working flawlessly. I added it for my own
> use, since I use dShell all the time.

XP


_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/4bef56240807210902h4cee2ce4v2e96d5d4d7849350@...

[Ed Leafe]

On Jul 21, 2008, at 11:02 AM, Nate Lowrie wrote:

>>       I tested on Mac and it's working flawlessly. I added it for  
>> my own
>> use, since I use dShell all the time.
>
> XP

        Is the latest dDateTextBox working for you on XP?

-- Ed Leafe





_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/37B5E2C2-712C-430B-BCFF-2341F95687A1@...

[Nate Lowrie]

On Mon, Jul 21, 2008 at 10:07 AM, Ed Leafe <ed@...> wrote:
> On Jul 21, 2008, at 11:02 AM, Nate Lowrie wrote:
>
>>>       I tested on Mac and it's working flawlessly. I added it for
>>> my own
>>> use, since I use dShell all the time.
>>
>> XP
>
>        Is the latest dDateTextBox working for you on XP?

Just checked.  I ran dDateTextBox.py and was able to double click on
the control and the calender floating panel popped up perfectly.


_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/4bef56240807210911l53bbd2a9vb74de42662f3ea22@...

[Ed Leafe]

On Jul 21, 2008, at 11:11 AM, Nate Lowrie wrote:

>>       Is the latest dDateTextBox working for you on XP?
>
> Just checked.  I ran dDateTextBox.py and was able to double click on
> the control and the calender floating panel popped up perfectly.


        Well, the shell history also uses the FloatingPanel, so it should be  
working if dDateTextBox is.

        If you want to try debugging, start in dShell.onShellKeyDown()

-- Ed Leafe





_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/9E800D4A-3948-4C79-AB49-32AF54F5A4BB@...

[Nate Lowrie]

On Mon, Jul 21, 2008 at 10:18 AM, Ed Leafe <ed@...> wrote:

> On Jul 21, 2008, at 11:11 AM, Nate Lowrie wrote:
>
>>>       Is the latest dDateTextBox working for you on XP?
>>
>> Just checked.  I ran dDateTextBox.py and was able to double click on
>> the control and the calender floating panel popped up perfectly.
>
>
>        Well, the shell history also uses the FloatingPanel, so it should be
> working if dDateTextBox is.
>
>        If you want to try debugging, start in dShell.onShellKeyDown()

I'll take a look at it.


_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/4bef56240807210922v3d252a8diec8ecc7f00675672@...

[Nate Lowrie]

On Mon, Jul 21, 2008 at 10:22 AM, Nate Lowrie <solodex2151@...> wrote:

> On Mon, Jul 21, 2008 at 10:18 AM, Ed Leafe <ed@...> wrote:
>> On Jul 21, 2008, at 11:11 AM, Nate Lowrie wrote:
>>
>>>>       Is the latest dDateTextBox working for you on XP?
>>>
>>> Just checked.  I ran dDateTextBox.py and was able to double click on
>>> the control and the calender floating panel popped up perfectly.
>>
>>
>>        Well, the shell history also uses the FloatingPanel, so it should be
>> working if dDateTextBox is.
>>
>>        If you want to try debugging, start in dShell.onShellKeyDown()
>
> I'll take a look at it.

Here is the issue.  evt.controlDown is registering and is set to true.
 However, it also registers as a key.  So, we get the ASCI value of 17
passed as the key that is down.  Then, if you press R or any other key
for that matter, wx doesn't register it.  It just records the Control
key press.  Not sure what to do about this.


_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/4bef56240807210947i35cd64bcx5b8a052f5027476b@...

[Ed Leafe]

On Jul 21, 2008, at 11:47 AM, Nate Lowrie wrote:

> Here is the issue.  evt.controlDown is registering and is set to true.
> However, it also registers as a key.  So, we get the ASCI value of 17
> passed as the key that is down.  Then, if you press R or any other key
> for that matter, wx doesn't register it.  It just records the Control
> key press.  Not sure what to do about this.


        That sounds very odd. How are you supposed to detect ctrl-R, or any  
other key combo, for that matter?

-- Ed Leafe





_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/9D0D6FD7-4B4A-4BCE-90D9-4D1233CFD1C3@...

[Nate Lowrie]

On Mon, Jul 21, 2008 at 10:48 AM, Ed Leafe <ed@...> wrote:

> On Jul 21, 2008, at 11:47 AM, Nate Lowrie wrote:
>
>> Here is the issue.  evt.controlDown is registering and is set to true.
>> However, it also registers as a key.  So, we get the ASCI value of 17
>> passed as the key that is down.  Then, if you press R or any other key
>> for that matter, wx doesn't register it.  It just records the Control
>> key press.  Not sure what to do about this.
>
>
>        That sounds very odd. How are you supposed to detect ctrl-R, or any
> other key combo, for that matter?

I am not sure, but that is what I am seeing.  This is what I have
onShellKeyDown as:

        def onShellKeyDown(self, evt):
                print evt.controlDown, ord(evt.keyChar)
                if evt.controlDown and evt.keyChar in ("r", "R"):
                        print "is proper key sequence"
                        if not (evt.commandDown or evt.altDown or evt.metaDown):
                                evt.stop()
                                self.historyPop()

I used ord to be sure of what characters I was getting...  Can anyone
else confirm this behavior on Win XP?

Platform: Win
Python Version: 2.5.2 on win32
Dabo Version: Version 0.8.4; Revision 4302
UI Version: 2.8.8.0 on wxMSW


_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/4bef56240807210959m29e59630v938abaf27fa5d02@...

[Paul McNett]

Ed Leafe wrote:
> On Jul 21, 2008, at 10:32 AM, Nate Lowrie wrote:
>
>> I get this error when I try to launch a dShell using the menu...
>
>
> OK, I see the problem if there is no previous history. I've posted a  
> fix. I am surprised that SQLite balked at creating a table with no data.

It didn't balk at creating the table, but when no records were returned
you got the 'no dataset table' error.

Paul


_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/4884CBE7.9080001@...

[Nate Lowrie]

On Mon, Jul 21, 2008 at 10:59 AM, Nate Lowrie <solodex2151@...> wrote:

> On Mon, Jul 21, 2008 at 10:48 AM, Ed Leafe <ed@...> wrote:
>> On Jul 21, 2008, at 11:47 AM, Nate Lowrie wrote:
>>
>>> Here is the issue.  evt.controlDown is registering and is set to true.
>>> However, it also registers as a key.  So, we get the ASCI value of 17
>>> passed as the key that is down.  Then, if you press R or any other key
>>> for that matter, wx doesn't register it.  It just records the Control
>>> key press.  Not sure what to do about this.
>>
>>
>>        That sounds very odd. How are you supposed to detect ctrl-R, or any
>> other key combo, for that matter?

I have a little bit more info.  I did some more testing, and it seems
like the dShell form is trapping all of the Ctrl+Character key
presses.  All of the menu keys will work, and if I bind Ctrl+R using
self.bindKey, everything works and I get the popup.  I posted a fix.
Please test the changes on Mac.

Also, on Windows, I am still having trouble in onListKey with the
return and numpad_enter key events propagating.  Events are fired as
getEventData is called, but something is stopping the event before it
makes it through.

Nate L.


_______________________________________________
Post Messages to: Dabo-dev@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/4bef56240807211211x2dc5ba34va951e529891ea3d8@...