Notice: Any messages purporting to come from this site telling you that your password has expired, or that you need to verify your details, confirm your email, resolve issues, making threats, or asking for money, are
spam. We do not email users with any such messages. If you have lost your password you can obtain a new one by using the
password reset link.
Due to spam on this forum, all posts now need moderator approval.
Entire forum
➜ MUSHclient
➜ Lua
➜ Check for existing database?
|
Check for existing database?
|
It is now over 60 days since the last post. This thread is closed.
Refresh page
| Posted by
| Renny
Canada (26 posts) Bio
|
| Date
| Tue 30 Sep 2014 07:40 PM (UTC) |
| Message
| | I'm using the Lua sqlite3 interface, I was wondering if there is an easy way to check if there is already an existing database, and if not create it and create required tables/columns. | | Top |
|
| Posted by
| Nick Gammon
Australia (23,158 posts) Bio
Forum Administrator |
| Date
| Reply #1 on Tue 30 Sep 2014 07:50 PM (UTC) Amended on Tue 30 Sep 2014 07:51 PM (UTC) by Nick Gammon
|
| Message
| What I usually do is:
CREATE TABLE IF NOT EXISTS ...
That way it automatically gets created if necessary. Also the database is automatically created anyway if it isn't there.
If there is other initialization you want to do (eg. populate a table) you can check if a specific table exists:
SELECT name FROM sqlite_master WHERE type='table' AND name='table_name';
If you get a row back, then the table exists. |
- Nick Gammon
www.gammon.com.au, www.mushclient.com | | 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.
9,315 views.
It is now over 60 days since the last post. This thread is closed.
Refresh page
![[Go to top]](/images/gototop.gif)
top