how to use preloaded sqlite db

Getting Started Newbie Questions
#1

I have my app data in a preloaded sqlite. Where should I put it so the build will contain the sqlite file and installed in right location in mobiles? In dev I can figure out the physical location of the following line. But after deploy the app to iPhone, it obvious did not find the db file.

system.pathForFile(“thecrazeapp.db”, system.DocumentsDirectory)

Thanks

#2

local path = system.pathForFile(“report_types.db”, system.ResourcesDirectory)

db = sqlite3.open( path )  

    for row2 in db:nrows(“SELECT id, description, quickdesc FROM tbEventTypes ORDER BY sortorder ASC, description ASC”) do

        print("caption: " … row2.description … ", id: " … row2.id, ", quickdesc: " … row2.quickdesc )

end

db:close()

#3

Thanks. 

#4

local path = system.pathForFile(“report_types.db”, system.ResourcesDirectory)

db = sqlite3.open( path )  

    for row2 in db:nrows(“SELECT id, description, quickdesc FROM tbEventTypes ORDER BY sortorder ASC, description ASC”) do

        print("caption: " … row2.description … ", id: " … row2.id, ", quickdesc: " … row2.quickdesc )

end

db:close()

#5

Thanks.