[Home] [Downloads] [Search] [Help/forum]

Gammon Forum

See www.mushclient.com/spam for dealing with forum spam. Please read the MUSHclient FAQ!

[Folder]  Entire forum
-> [Folder]  MUSHclient
. -> [Folder]  Lua
. . -> [Subject]  Using SQLite3 in MUSHclient
Home  |  Users  |  Search  |  FAQ
Username:
Register forum user name
Password:
Forgotten password?

Using SQLite3 in MUSHclient

It is now over 60 days since the last post. This thread is closed.     [Refresh] Refresh page


Posted by Meerkat   (8 posts)  [Biography] bio
Date Mon 22 Sep 2008 04:54 AM (UTC)
Message
What I want is one of these:

http://nessie.de/mroth/lua-sqlite3/index.html

http://luaforge.net/frs/?group_id=75&release_id=796

Just SQLite3 or even SQLite2 functionality. It would really help me out. How would I go about installing it so MUSHclient would be compatible?
[Go to top] top

Posted by Nick Gammon   Australia  (21,322 posts)  [Biography] bio   Forum Administrator
Date Reply #1 on Mon 22 Sep 2008 05:16 AM (UTC)
Message
See:

http://www.gammon.com.au/forum/?id=5983

Although that discusses mySQL, the concept is the same. You might need to change the loadlib to load a different DLL (and now it is package.loadlib instead of loadlib).

- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top

Posted by Meerkat   (8 posts)  [Biography] bio
Date Reply #2 on Mon 22 Sep 2008 05:27 AM (UTC)

Amended on Mon 22 Sep 2008 05:56 AM (UTC) by Meerkat

Message
It's just the following that I don't know how to do properly:

-- load the MySQL dll
loadlib ("mysql.dll", "luaopen_luasqlmysql") ()

And other related loading.

I have the sqlite3.dll from http://www.keplerproject.org/luasql/ in the same dir as MUSHclient. What is the second arg I pass to package.loadlib? I just can't figure it out.

I'm really new to Lua as well as MUSHclient, so I don't have experience with any of this. The documentation for LuaSQL is pretty lacking.

If you could figure it out for me, I would appreciate that very much.

EDIT: Also, is there anything I need to do in the Sandbox?
[Go to top] top

Posted by Meerkat   (8 posts)  [Biography] bio
Date Reply #3 on Mon 22 Sep 2008 06:07 AM (UTC)

Amended on Mon 22 Sep 2008 06:23 AM (UTC) by Meerkat

Message
I got a bit further.

Wiped out the whole sandbox.

Then I did this:

package.loadlib("sqlite3.dll", "luaopen_luasql_sqlite3")

Seemed to work. Not sure where to go from there though.

EDIT: Got it.

package.loadlib("sqlite3.dll", "luaopen_luasql_sqlite3")()

env = assert (luasql.sqlite3())
[Go to top] top

Posted by Nick Gammon   Australia  (21,322 posts)  [Biography] bio   Forum Administrator
Date Reply #4 on Mon 22 Sep 2008 06:41 AM (UTC)

Amended on Mon 22 Sep 2008 06:47 AM (UTC) by Nick Gammon

Message
You shouldn't need to wipe the entire sandbox. Maybe set it to permit DLLs to be loaded, and to trust the main world file. Anyway, with the sqlite3.dll placed in the same directory as MUSHclient, the following example worked for me:


assert (package.loadlib("sqlite3.dll", "luaopen_luasql_sqlite3")) ()

-- create environment object
env = assert (luasql.sqlite3())

-- connect to data source
con = assert (env:connect ("databasename.sqlite3", "username", "password"))


-- empty our table
res = con:execute"DROP TABLE players"

res = assert (con:execute[[
  CREATE TABLE players(
    name  varchar(50),
    class varchar(50)
  )
]])


-- add a few elements
list = {
  { name="Nick Gammon", class="mage", },
  { name="David Haley", class="warrior", },
  { name="Shadowfyr", class="priest", },
}

for i, p in pairs (list) do
  res = assert (con:execute(string.format([[
    INSERT INTO players
    VALUES ('%s', '%s')]], p.name, p.class)
  ))
end

-- retrieve a cursor
cur = assert (con:execute ("SELECT * from players" ))

-- print all rows, the rows will be indexed by field names
row = cur:fetch ({}, "a")

while row do
  print ("\n------ new row ---------\n")
  table.foreach (row, print)
  
  -- reusing the table of results
  row = cur:fetch (row, "a")
end

-- close everything
cur:close()
con:close()
env:close()


Results were:


------ new row ---------

name Nick Gammon
class mage

------ new row ---------

name David Haley
class warrior

------ new row ---------

name Shadowfyr
class priest


This code created the database file "databasename.sqlite3" in the same directory that MUSHclient.exe was in.


- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top

Posted by WillFa   USA  (525 posts)  [Biography] bio
Date Reply #5 on Sat 13 Dec 2008 09:05 PM (UTC)
Message
The sqlite3.dll should be in lua\luasql\sqlite3.dll, just a few subdirs from where Mushclient.exe is located.

Here's the same example with a few minor tweaks.


require "luasql.sqlite3"  --much simpler

-- create environment object
env = assert (luasql.sqlite3())

-- connect to data source
con = assert (env:connect ("databasename.sqlite3")) -- sqlite doesn't implement usernames and pw's. not needed.


-- empty our table
res = con:execute"DROP TABLE players"

res = assert (con:execute[[
  CREATE TABLE players(
    name  varchar(50),
    class varchar(50)
  )
]])


-- add a few elements
list = {
  { name="Nick Gammon", class="mage", },
  { name="David Haley", class="warrior", },
  { name="Shadowfyr", class="priest", },
  { name="Spellbound", class="ranger"},  --Me too, Me too!
}

for i, p in pairs (list) do
  res = assert (con:execute(string.format([[
    INSERT INTO players
    VALUES ('%s', '%s')]], p.name, p.class)
  ))
end

-- retrieve a cursor
cur = assert (con:execute ("SELECT * from players" ))

-- print all rows, the rows will be indexed by field names
cur:fetch (row, "a") --redundant to do row = :fetch(row) though output parameters aren't typical to Lua.

while row do
  print ("\n------ new row ---------\n")
  for k,v in pairs(row) do print(k,v) end 
  
  -- reusing the table of results
  row = cur:fetch (row, "a")
end

-- close everything
cur:close()
con:close()
env:close()


[Go to top] top

The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).

To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.


6,801 views.

It is now over 60 days since the last post. This thread is closed.     [Refresh] Refresh page

Go to topic:           Search the forum


[Go to top] top

Quick links: MUSHclient. MUSHclient help. Forum shortcuts. Posting templates. Lua modules. Lua documentation.

Information and images on this site are licensed under the Creative Commons Attribution 3.0 Australia License unless stated otherwise.

[Home]


Written by Nick Gammon - 5K   profile for Nick Gammon on Stack Exchange, a network of free, community-driven Q&A sites   Marriage equality

Comments to: Gammon Software support
[RH click to get RSS URL] Forum RSS feed ( https://gammon.com.au/rss/forum.xml )

[Best viewed with any browser - 2K]    [Hosted at FutureQuest]