require "sqlite3"

local test =
{
    1229,1230,731,738,1231,735,734,2171,736,750,751,4135,3840,4134,2205,1225,1233,1232,1234,2197,1228,3841,1226,1227
}

-- Does the database exist in the documents directory (allows updating and persistance)
local path = system.pathForFile("kalori.sqlite", system.DocumentsDirectory )
file = io.open( path, "r" )
   if( file == nil )then
    -- Doesn't Already Exist, So Copy it In From Resource Directory
    pathSource     = system.pathForFile( "kalori.sqlite", system.ResourceDirectory )
    fileSource = io.open( pathSource, "r" )
    contentsSource = fileSource:read( "*a" )
        --Write Destination File in Documents Directory
        pathDest = system.pathForFile( "kalori.sqlite", system.DocumentsDirectory )
        fileDest = io.open( pathDest, "w" )
        fileDest:write( contentsSource )
         -- Done
        io.close( fileSource )
        io.close( fileDest )
   end

local db = sqlite3.open( path )

for i = 1, #test do
    db:exec([[UPDATE Food SET Maincat=2 WHERE ID = ']]..test[i]..[[';]])
end