[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]  Lua test if table exists SQLite3
Home  |  Users  |  Search  |  FAQ
Username:
Register forum user name
Password:
Forgotten password?

Lua test if table exists SQLite3

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


Posted by Blainer   (191 posts)  [Biography] 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
[Go to top] top

Posted by Bast   (77 posts)  [Biography] 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
[Go to top] top

Posted by Nick Gammon   Australia  (21,378 posts)  [Biography] 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
[Go to top] top

Posted by Blainer   (191 posts)  [Biography] bio
Date Reply #3 on Sat 13 Jun 2009 03:07 AM (UTC)
Message
Great thanks.
[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,521 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]