SQLite Database not Opening on Android

[sgeos]

My LuaSQL sample runs on OSX and iOS. FWIW, this sample should run on a vanilla installation of Moai. When I try to open an SQL database on the Android host, I get the following error:
unable to open database file

Do I need to do anything special to use SQLite databases on Android?

EDIT: It looks like the short answer is yes. What does a person need to do to get a SQLite database to work on Android with Moai? Should there be some sort of an initialization call that moves the database to the correct location if the DB exists and the script is running on Android?

[sgeos]

In case anyone else runs into the same problem, this is what I wound up using.

Code: Select all

1. require "luasql"


2.  


3. -- Database File Parameters


4. dbname = "mydatabase.db"


5. dbpath = "./"


6.  


7. -- Special Handling for Android


8. if "Android" == MOAIEnvironment.osBrand then


9.   local systemdbpath = MOAIEnvironment.documentDirectory:gsub("/files", "/databases/")


10.   if not MOAIFileSystem.checkFileExists(systemdbpath .. dbname) then


11.     MOAIFileSystem.copy(dbpath .. dbname, systemdbpath .. dbname)


12.   end


13.   dbpath = systemdbpath


14. end


15.  


16. -- Create Environment and Connect to DB


17. environment = assert ( luasql.sqlite3 () )


18. connection  = assert ( environment:connect ( dbpath .. dbname ) )


19.  


20. -- Queries Here

[ibisum]

Great, thanks for sorting that out - exactly this problem was causing me a bit of trouble earlier this week on Android and now I know why.