Gammon Forum : MUSHclient : General : Binding SQLite3 parameters

Entire forum ➜ MUSHclient ➜ General ➜ Binding SQLite3 parameters

Binding SQLite3 parameters

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

Posted by

Artel USA (65 posts) Bio

Date

Mon 10 Oct 2016 08:36 PM (UTC)

Message

Is there a MUSHclient database function that binds values to a SQLite prepared statement? I.e., something that corresponds to the sqlite3_bind_*() functions in the SQLite3 C api.

Here are the other related methods in MUSHclient (from https://www.gammon.com.au/forum/?id=9262). I was expecting to find a DatabaseBind(BSTR Name, ...) or similar, but I can't find it.

long DatabasePrepare(BSTR Name, BSTR Sql);
long DatabaseStep(BSTR Name);
long DatabaseFinalize(BSTR Name);
long DatabaseReset(BSTR Name);

Artel.

Top

Posted by

Nick Gammon Australia (23,133 posts) Bio Forum Administrator

Date

Reply #1 on Mon 10 Oct 2016 08:53 PM (UTC)

Message

You can do it with the Lua SQLite3 interface rather than the generic one. The generic interface would be fiddly to implement because of the different data types, but in Lua you can pass different types down to a function.

http://www.gammon.com.au/scripts/doc.php?lua=stmt:bind

http://www.gammon.com.au/scripts/doc.php?lua=stmt:bind_names

http://www.gammon.com.au/scripts/doc.php?lua=stmt:bind_values

- Nick Gammon

www.gammon.com.au, www.mushclient.com

Top

Posted by Artel USA (65 posts) Bio

Date

Reply #2 on Mon 10 Oct 2016 09:37 PM (UTC)

Amended on Mon 10 Oct 2016 09:41 PM (UTC) by Artel

Message

Thanks! That's working perfectly.

Edit: added example snippet for reference


  local target_query = 'thalos'
  local select_statement = assert(db:prepare([[SELECT keyword FROM areas
    WHERE keyword LIKE ?]]))

  select_statement:bind_values(target_query)

  for row in select_statement:nrows() do
    -- do stuff
  end

Artel.

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.

12,127 views.

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

Go to topic: Search the forum

top