creating in sqlite3 db in LUA

Question

I have problem in creating a database I find no errors but still no database in my documents folder

here is my code :

local sqlite3 = require "sqlite3"

local path = system.pathForFile( "data.db", system.DocumentsDirectory )
local db = sqlite3.open( path )

possible duplicate of How do I create an Sqlite3 database using luasql? — Oliver
– Oliver, Commented Feb 11, 2014 at 17:18

K09P · Accepted Answer · 2014-02-13 10:07:35Z

0

Try to check this out:

http://sqlite.org/cintro.html

I know it is aiming to C and C++. But maybe you can translate from one language to another. I'd do it for you, but I don't actually know Lua =/

Also, check the value of system.DocumentsDirectory to be sure you're looking in the right place (and why not, check for user rights)

answered Feb 13, 2014 at 10:07

K09P

4905 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user4306752 · Accepted Answer · 2014-12-10 18:30:47Z

0

You have to add some data to create it.

local tablesetup = [[CREATE TABLE IF NOT EXISTS place (id INTEGER PRIMARY KEY, name, xcor, ycor);]]
db:exec( tablesetup )

local testvalue = {}
testvalue[1] = 'Name6'
testvalue[2] = 'x'
testvalue[3] = 'y'
local tablefill =[[INSERT INTO place VALUES (']]..x..[[',']]..testvalue[1]..[[',']]..testvalue[2]..[[',']]..testvalue[3]..[[')  ]]

also remember to use this to close it after app exits.

local function onSystemEvent( event )
        if( event.type == "applicationExit" ) then              
            db:close()
        end
end

Runtime:addEventListener( "system", onSystemEvent )

answered Dec 10, 2014 at 18:30

user4306752

Collectives™ on Stack Overflow

creating in sqlite3 db in LUA

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related