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

Apprentice Joined: 11 Oct 2007 Posts: 154

Dharkael here is a workable in memory alias that you can run... the returns are not in my data, however I tried the trim just to be sure but it still does it.

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

Hey Xekon, I tried your in memory example and I can't reproduce the problems you're having.

This is what's displayed on my screen

Have you tried running your example alias in an empty session?
Maybe some other trigger or something is modifying the display.
I noticed that in the picture you showed the problem appears only after items who's name ends in a / or a >

Apprentice Joined: 11 Oct 2007 Posts: 154

Yes, I just tried it in an empty session, that did not work, then something Dawned on me, it happens when in your com object

_CMUDFormat = True

when thats set to true, i set it to true because i do use cmud, however if i set it to false then it works the way it should.... maybe i should just leave it to false then? what exactely does this variable do?

Also I will note that its the updown bar the pipe that causes it | or lots of quotes being in the name

Apprentice Joined: 11 Oct 2007 Posts: 154

DOH! Cmudformat is what fixed this issue

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

Yeah there was an issue was in how I was formating the data returned when using the CMUDFormat.
For the curious I was calling the Utility function CMUD_LIE once and passing the key separator and value as one argument.
What I should have been doing was encoding each seperately, Which I've now corrected.

Xekon, in the future I'd recommend you not modify the source if you're going to seek help from me or someone else using the component.
If we're not using the same component, then any problems reported, troubleshooting steps tried and resolved may not be relevant.
If you want to change the CMUDFormat then do something like stuff.CMUDFormat=1 to set it Smile

Apprentice Joined: 11 Oct 2007 Posts: 154

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

It's an exposed property, its been made both readable and writable.
All properties and methods that are accessible with the COM object are described in the first entry to this thread.
This includes anything new that I've added since the first post.

Apprentice Joined: 11 Oct 2007 Posts: 154

Well Dharkael, I owe you a huge thank you, with your last bug fix I now have a nearly finished equipment database script.... and its all in super awesome sqlite3...

All that is left for me to do is polish a couple of things.

I don't know what all you have cooked up or weather or not you even play Aardwolf, but let me know if you want a copy of what Ive done so far...

I know that your more than capable of doing any of this stuff yourself, but if what i have made could save you some time then that would be cool.

Also I am not sure if you use cmud or zmud primarily. This has been written in Cmud, but could probably be brought over to zmud fairly easily.

but again one big THANK YOU for sharing this and for you work on making it a polished finished product.

Apprentice Joined: 11 Oct 2007 Posts: 154

When I walk into rooms with this script enabled it checks to see if the mob is in my db, if it is not then it subs a clickable add button to the end of their name.
I was thinking this would be a very good time for me to use an index, also Im thinking I am probably not using the quickest sql statment and theres probably a better way of doing this.

Dharkael, was wondering if you could show me how to do this so that it is as fast as possible, I still have not created an index but was thinking I should on the roomdesc field... do index's have to be updated every so often, or do they update on their own after records are added to the table?

Posted: Tue May 06, 2008 7:16 pm

I believe they're updated automatically. That means that indices cause adding data to be slower (because the index has to be updated) but makes lookups quicker.

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

Fang is right on the money.
You can create indexes(or indices if you prefer) using (unsurprisingly) the CREATE INDEX command.
To create an index on the roomdesc column of the mobdb table using something like:

Apprentice Joined: 11 Oct 2007 Posts: 154

Thank you very much for the create index and better way of query the db using the count on only roomdesc, this is making it go much quicker!

You Sir are correct, I just checked all my data and it inserted double '' The reason I was escaping it before sending it is because if you do a "#sub <send alias var" and the var has single quotes that are not escaped then the output on the screen goes nuts... so this is probably the only time that its a good idea for me to use the "%format and the &s" OR I could after passing the variable to the alias with the sub send, do a reverse replace that replaces double '' with a single ' before insertion....

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

Posted: Wed May 07, 2008 12:10 am

You didn't close your %replace function, Dharkael. I assume you meant to have the closing bracket after (39)" and before '.

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

Thanks!
I actually fixed it in my test alias but forgot to do that in the the text file I was working from.

Good Eye! btw

Posted: Wed May 07, 2008 12:52 am

Here is an odd situation, Dharkael. I have created a table which is has exactly the same data as another table, that is I've made a duplicate by running the script that created the original table, just used another name. The reason for this is that I want to make so changes to the data and don't want to blow the original if something goes wrong, even though the original table has some errors, it is still usable. However, when I query the new table, it cannot find the data. Neither can the SQLite Expert program. It shows the table with all the data there but when I use WHERE on the name field (Name Text), it fails to locate the record, no matter where I place the field on the table. No such problem if I use any other column as the key. Using the name field works just fine on the original table
The first time I run the script, it always comes back with TABLE xxxx does not exist. It works the second time around, though. That is, it doesn't complain about it.
The only difference is that I am using the new COM object. I am going to back out the version and run the script again to see if it makes a difference. The other table was created with a much older object. I've also tried giving the column a different name and it didn't matter. I also checked to see that the data in the column was trimmed, and it was.

EDIT: OK, I've backed the COM object as far back as the object I created on 04/22/08. Still the same result. I've also found out that if I use WHERE Name LIKE 'xxxx%', it will find the row.

EDIT: OK, it is obviously my error. I re-ran the table create with a %trim() for the Name field and now the table queries work correctly.
It is peculiar, though, that length(Name) returns the correct length, that is it does not return the length including the offending blanks, though they are obviously there, else the query would not have failed.

EDIT: Another problem now. When I read the data

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

That is peculiar, I wonder if it's a bug in sqlite or known limitation?

Posted: Wed May 07, 2008 2:16 am

Well, I've found that using column names that are "reserved" as per the list you provided, and others, will cause the Create Table to fail. I notice that trim(), ltrim(), rtrim() are available functions. I Didn't see that in the documentation here. I've used max(length()) with success.

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

Well when in doubt go to the source but that's a good little resource.
In the case of "reserved" words use quotes "" or brackets [] as in create table sometable ([trim] text,[rtrim] integer)

Posted: Wed May 07, 2008 2:26 am

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

I'm sure thats quick and easy but thats ignoring the root cause and no solution at all for the reasons stated above.

Apprentice Joined: 11 Oct 2007 Posts: 154

w00ts, this is working perfect for me:

Posted: Wed May 07, 2008 8:16 am

OK, I have fixed the problem. I was just setting the value improperly. I was treating it as a function and not as a value.

Posted: Thu May 08, 2008 1:32 am

Here is something new I've discovered:
I created a view as follows:

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

I'm not sure what the issue is?