Zugg Software :: View topic - Python Sqlite COM Component for ZMUD/CMUD

Posted: Thu May 08, 2008 3:00 am

Yes, it makes sense and I should have known since that is the way I fetch values when I use functions, though I don't enclose the key name in quotes in that situation. It concerns me, though, that this seems inconsistent because the query against the underlying table returns an unqualified column value. That means that the processing script has to be aware that the data came from a view and not a real table.

NOTE: I did include the query against both the view and the table in my post.

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

Posted: Thu May 08, 2008 3:39 am

I understand your idea and I will use it. There is no confict between those two tables. The qualification in the WHERE clause is due to a collision between Portals Anaristos and Areas. Thanks for your help. I am still learning SQL.

Posted: Fri May 09, 2008 8:08 am

I installed CMUD 2.25, one problem I have run into is that the COM variable that I use keeps getting stale. For one thing, under 2.18 I was using the OnLoad event to create the object, and that would last me the entire session unless there was a catastrophic error on the Python side, in which case Phtyon would close the connection. But under 2.25, I have to continuously keep issuing %comcreate.

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

We keep revisiting old issues.
about 3 weeks ago you said you were having the same issue, then you said nothing at all.
COM objects don't go stale they remain fresh as the day they were baked Razz

.

You say you have to keep using %comcreate, what gives you that idea Question

Do some troubleshooting isolate when and how it stops working and If you can't resolve the issue
then create a test case in an empty session, if you can demonstrate with that, then paste the code you're using
without modification and I'll see if I can spot the problem.

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

I manually created a connection and filled it with data from the Testwarrior script you previously gave.
Left it all day then came back and ran the alias again without creating another connection, no problems.

Posted: Fri May 09, 2008 10:53 pm

OK, let me qualify my statement about the COM object. It is not stale in the sense that it is not representing a connection. When I do

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

What are the OLE errors? when do you get them?
Do you have a procedure to demonstrate?
Without these things I can't be of any assistance

Apprentice Joined: 11 Oct 2007 Posts: 154

Ive been running smoothly for a few days it seems now. :)

I started to convert what I've written from cmud back over to zmud for some friends.

Dharkael the code snippet you wrote for me works wonderfully in cmud but I dont understand what i should change for zmud:

#if ((@mobdb.Execute("SELECT COUNT(roomdesc) AS Count FROM mobdb WHERE roomdesc=?",%1).Count) < 1) {#show "its true so do something"}

the output i get from this in cmud is an integer and in my case either a 0 or 1, so it works

however in zmud instead of a 0 or 1 im getting (Count1)

Apprentice Joined: 11 Oct 2007 Posts: 154

Let me know if what I need to change is not obvious, and I will post a workable example for zmud.

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

Posted: Sun May 11, 2008 7:52 pm

OK, Dharkael, now that we know why my COM object stopped working, I can get to mention the problem that gets me the Python/OLE error. This one is no big deal but after I saw your code snippet above, it makes me wonder.
You used:

Posted: Sun May 11, 2008 8:48 pm

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

I know what you mean Anaristos thats a CMUD problem.
The script I gave to Xekon was meant for ZMUD.

It's not something specific to my COM object either, In CMUD 2.18 It just gave an error that you could recover from if I remember correctly(I foolishly did not save a copy of 2.18),
now in CMUD 2.25 it locks up and I have to Force Quit the CMUD process.
Here's an example using another COM object

Posted: Sun May 11, 2008 9:19 pm

OK, thanks Dharkael. I guess I am not going crazy after all.
If you have time, would you consider adding a SetPath() function to the API? This would set up an implicit path if none were given. I suppose that calling the method without a parameter would just return the current default path. Just an idea.

EDIT:
That's a tough technicality, Fang. Semantically, object methods are as functions since they are forced to return something even if it's a Void. Black-hole methods are not OOP-sanctioned, though I am sure there is a truckload of them out there. Of course when I said SELECT, I referred to the object of the method, and not the method itself, because I felt this was an unambiguous nuance. Wink

Apprentice Joined: 11 Oct 2007 Posts: 154

Regex Trigger: mobs without auras...

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

I think I need to see more to help Xekon
Because using the pattern and the code above in a trigger I had no problems inserting
A Whitecloak screams "DARKFRIEND!!!" and attacks!
Of course I can't see what you're doing in your addmobdb alias
Mine looks like this.

Apprentice Joined: 11 Oct 2007 Posts: 154

Sometimes its the easy stuff that escapes us for whatever reason... I should have checked my code better, the problem was being so used to and comfortable with cmud.

I had:

Posted: Thu Jun 19, 2008 2:26 am

Dharkael, I've noticed that code like this is not working and I was under the impression that it was fixed

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

Those are properties.
Try calling them without the parens à la:

Beginner Joined: 06 Jan 2006 Posts: 24

I have some issues when I select some records whose data contain carriage returns: they are split into different records.
I need that, because I'm connecting to the mapper db.

I think that the problem is in the join process in GetData().
I'm using CMUD, and I set

Posted: Wed Feb 04, 2009 2:56 am

It seems that when one uses an array to pass binding paramters to SQL, the array must be explicitly declared in the EXEC statement. It falis for me when I insert an array variable instead.

Apprentice Joined: 11 Oct 2007 Posts: 154

Windows 7 and activepython, com object worked under xp with activepython 2.5.4.3

Under windows XP I installed activepython 2.5.4.3 and registered my com object (where you right click on the file and select register).

Since then I have decided to try out Windows 7 beta (build 7077), and I knew going in that there would be things to work out, remarkable all my driver and applications are working so far with the exception of this python com object. If anyone can give any help I would greatly appreciate it. I have included as much detail of the problem as I can think of
First I get a popup that says:

Apprentice Joined: 11 Oct 2007 Posts: 154

instead of trying to get the com object to work I stumbled across this post: http://forums.zuggsoft.com/forums/viewtopic.php?t=31518

and I am now in the process of rewriting my eqdb script with lua

Newbie Joined: 28 Sep 2009 Posts: 2

I'm getting the same errors as Xekon and have tried everything to get the file to work. I have all the correct privileges, using vista.