require "sqlite3"
require "toggle"
 
local path = system.pathForFile("thegolfwar.db", system.DocumentsDirectory)
db = sqlite3.open( path ) 
 
local function onSystemEvent( event )
        if( event.type == "applicationExit" ) then              
            db:close()
        end
end
 
--Setup the table if it doesn't exist
local tablesetup = [[CREATE TABLE IF NOT EXISTS audio (id INTEGER PRIMARY KEY, wartosc);]]
local pointsStore = [[CREATE TABLE IF NOT EXISTS points (id INTEGER PRIMARY KEY, current, best);]]
db:exec( tablesetup )
db:exec( pointsStore )
 
--First time sound init
local soundInit = function()
        local row_inConfig_count = 0 
        for row in db:nrows('SELECT * FROM audio') do 
                row_inConfig_count = row_inConfig_count + 1
        end
 
        local audioStartConfig = [[INSERT INTO audio VALUES(1, 1);]]
        
        if (row_inConfig_count == 0) then 
                db:exec( audioStartConfig )
                for i=1,36 do 
                        local pointsStoreInit = [[INSERT INTO points VALUES(']]..i..[[', 0, 0);]]
                        db:exec( pointsStoreInit )
                end
        end
end