Any Corona Sample Apps with SQLite?

Getting Started Newbie Questions
#1

Hi…

I could not see any project examples or downloads for database apps built with Corona and SQLite? Can anyone point me?

Thanks!!!

John Popadiuk
Chicago, IL

[import]uid: 10265 topic_id: 4372 reply_id: 304372[/import]

#2

In the latest release there’s one in the sample code/storage folder, here it is

[blockcode]

– Project: SQLite demo

– Date: August 24, 2010

– Version: 1.0

– File name: main.lua

– Author: Ansca Mobile

– Abstract: Shows how to create and read a SQLite database

– Demonstrates: database create and read APIs

– File dependencies: none

– Target devices: Simulator (results onscreen and in Console) and on Device

– Limitations: none

– Update History:

– Comments:

– Sample code is MIT licensed, see http://developer.anscamobile.com/code/license
– Copyright © 2010 ANSCA Inc. All Rights Reserved.

– Add onscreen text
local label1 = display.newText( “SQLite demo”, 20, 30, native.systemFontBold, 20 )
label1:setTextColor( 190, 190, 255 )
local label2 = display.newText( “Creates or opens a local database”, 20, 50, native.systemFont, 14 )
label2:setTextColor( 190, 190, 255 )
local label3 = display.newText( “(Data is shown below)”, 20, 90, native.systemFont, 14 )
label3:setTextColor( 255, 255, 190 )

–Include sqlite
require “sqlite3”
–Open data.db. If the file doesn’t exist it will be created
local path = system.pathForFile(“data.db”, system.DocumentsDirectory)
db = sqlite3.open( path )

–Handle the applicationExit event to close the db
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 test (id INTEGER PRIMARY KEY, content, content2);]]
print(tablesetup)
db:exec( tablesetup )

–Add rows with a auto index in ‘id’. You don’t need to specify a set of values because we’re populating all of them
local testvalue = {}
testvalue[1] = ‘Hello’
testvalue[2] = ‘World’
testvalue[3] = ‘Lua’
local tablefill =[[INSERT INTO test VALUES (NULL, ‘]]…testvalue[1]…[[’,’]]…testvalue[2]…[[’);]]
local tablefill2 =[[INSERT INTO test VALUES (NULL, ‘]]…testvalue[2]…[[’,’]]…testvalue[1]…[[’);]]
local tablefill3 =[[INSERT INTO test VALUES (NULL, ‘]]…testvalue[1]…[[’,’]]…testvalue[3]…[[’);]]
db:exec( tablefill )
db:exec( tablefill2 )
db:exec( tablefill3 )

–print the sqlite version to the terminal
print( "version " … sqlite3.version() )

–print all the table contents
for row in db:nrows(“SELECT * FROM test”) do
local text = row.content…" "…row.content2
local t = display.newText(text, 20, 120 + (20 * row.id), native.systemFont, 16)
t:setTextColor(255,0,255)
end

–setup the system listener to catch applicationExit
Runtime:addEventListener( “system”, onSystemEvent )
[/blockcode]
[import]uid: 9371 topic_id: 4372 reply_id: 13656[/import]

#3

Hi…

Great i will go through, was looking for something a little more robust in table design and keyboard editing…

Super!

John Popadiuk
Chicago, IL [import]uid: 10265 topic_id: 4372 reply_id: 13660[/import]

#4

@nanoschoolboy

Did you ever come up with some good database examples?

I am new to ansca, but don’t want to write games. I want to do apps that will use a database, etc.

For example, a simple todo list, where I have a list of categories, the user presses one, and the detail list of items shows up, they press the check box, and the item disappears. I would like to use a database to do this.

Any thoughts or ideas of places to help me get started would be great.

Alan
[import]uid: 34715 topic_id: 4372 reply_id: 20777[/import]