Gammon Forum : MUSHclient : Lua : Lua test if table exists SQLite3

Entire forum ➜ MUSHclient ➜ Lua ➜ Lua test if table exists SQLite3

Lua test if table exists SQLite3

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

Posted by

Blainer (191 posts) Bio

Date

Tue 09 Jun 2009 03:27 PM (UTC)

Message

Anyone know how to use Lua to test if a table exists in a SQLite db?
Not the sql: CREATE TABLE IF NOT EXISTS

I want: if "table exists in database" then

Top

Posted by Bast (78 posts) Bio

Date Reply #1 on Tue 09 Jun 2009 03:35 PM (UTC)

Message

I use a function like this in a db class that I have


function Sqlitedb:checkfortable(tablename)
  if self:open() then
    for a in self.db:nrows('SELECT name FROM sqlite_master') do
      if a['name'] == tablename then
        self:close()
        return true
      end
    end
    self:close()
  end
  return false
end

Bast

Bast

Scripts: http://github.com/endavis

Top

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

Date Reply #2 on Tue 09 Jun 2009 09:45 PM (UTC)

Message

To save reading the whole table you could probably do something like:


SELECT * FROM sqlite_master WHERE name = 'whatever' AND type = 'table'

Then just see if you get a row back or not.

- Nick Gammon

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

Top

Posted by

Blainer (191 posts) Bio

Date

Reply #3 on Sat 13 Jun 2009 03:07 AM (UTC)

Message

Great thanks.

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.

18,219 views.

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

Go to topic: Search the forum

top