connecting a dictionary to my word-game app

Other
#1

How can I connect a dictionary to my word-game app so that word definitions, etc can be checked? [import]uid: 162950 topic_id: 31972 reply_id: 331972[/import]

#2

#1 - You can take what I have in ssk/factories/f_dbmgr.lua, extract the code, and modify it to meet your needs.

#2 - You can watch my RSS feed (on my site; link below) and wait till I finish the db mgr and post a tutorial.

I’m sorry I don’t have a better answer, but the code in f_dbmbr.lua is still WIP. It works for reading, but not writing/making changes to an existing DB.

Here is the code, extracted (you will want to modify it yourself):

-- =============================================================  
-- Copyright Roaming Gamer, LLC.  
-- =============================================================  
-- (Rudimentary) Database Manager Factory  
-- =============================================================  
-- Short and Sweet License:   
-- 1. You may use anything you find in the SSK library and sampler to make apps and games for free or $$.  
-- 2. You may not sell or distribute SSK or the sampler as your own work.  
-- 3. If you intend to use the art or external code assets, you must read and follow the licenses found in the  
-- various associated readMe.txt files near those assets.  
--  
-- Credit?: Mentioning SSK and/or Roaming Gamer, LLC. in your credits is not required, but it would be nice. Thanks!  
--  
-- =============================================================  
-- Last Modified: 29 AUG 2012  
-- =============================================================  
  
local sqlite3 = require "sqlite3"  
--[[   
function initDB( dbpath )  
function isWordInDB( word )  
function findWordInDB( word )  
function testSearchSpeed( iterations )  
--]]  
  
local dbMgr = {}  
  
 function dbMgr:newDB( dbpath )  
 print("\n\*\*\*\* DBMGR: initDB() -\> " .. dbpath .. "\n")  
 print( "version " .. sqlite3.version() )  
 self.path = system.pathForFile(dbpath)  
 self.db = sqlite3.open( path )   
  
 function db:isWordInDB( word )  
 local foundCount = 0  
 word = string.lower(word)  
  
 --local cmd = "SELECT \* FROM theWords where field1='" .. word .. "'"  
 local cmd = "SELECT \* FROM theWords WHERE field1 LIKE '" .. word .. "'"  
  
 print("CMD ==" .. cmd)  
 --print( self:nrows("SELECT \* FROM words where field1='" .. word .. "'") )  
  
 for row in self:nrows(cmd) do  
 foundCount = foundCount + 1  
 end  
 print( foundCount )  
  
 if( foundCount \> 0 ) then  
 return true  
 end  
 return false  
 end  
  
 function db:findWordInDB( word )  
 word = string.lower(word)  
 local foundCount = 0  
 --local cmd = "SELECT \* FROM theWords where field1='" .. word .. "'"  
 local cmd = "SELECT \* FROM theWords WHERE field1 LIKE '" .. word .. "'"  
  
 for row in self:nrows(cmd) do  
 foundCount = foundCount + 1  
 end  
 print( word .. " " .. foundCount )  
 return foundCount  
 end  
  
 function db:testSearchSpeed( iterations )  
 local testwords = {}  
 testwords[0] = "actor"  
 testwords[1] = "plenty"  
 testwords[2] = "dog"  
 testwords[3] = "cat"  
 testwords[4] = "penny"  
 testwords[5] = "quarter"  
 testwords[6] = "lane"  
 testwords[7] = "man"  
 testwords[8] = "woman"  
 testwords[9] = "exact"  
  
 local startTime = system.getTimer()  
 print( startTime )  
 for i=0, iterations do  
 self:findWordInDB( testwords[math.random (0, 9)] )  
 end  
 local endTime = system.getTimer()  
 print( endTime )  
  
 local result = "Did " .. iterations .. " searches in " .. endTime - startTime .. " ms"  
 print(result)  
  
 local t = display.newText(result, 20, 30, null, 32)  
 t:setTextColor(255,0,0)  
  
 end  
 end  
  
return dbMgr

Note: You can get a tool for making your own databases here: http://sqlitebrowser.sourceforge.net/ It can convert comma separated word lists into a word DB.

Cheers,
Ed
Roaming Gamer, LLC.
SSK for Corona SDK (github) (videos)
[import]uid: 110228 topic_id: 31972 reply_id: 127482[/import]

#3

Ed,
thank you for your help… trying it now.
Brett [import]uid: 162950 topic_id: 31972 reply_id: 127578[/import]

#4

#1 - You can take what I have in ssk/factories/f_dbmgr.lua, extract the code, and modify it to meet your needs.

#2 - You can watch my RSS feed (on my site; link below) and wait till I finish the db mgr and post a tutorial.

I’m sorry I don’t have a better answer, but the code in f_dbmbr.lua is still WIP. It works for reading, but not writing/making changes to an existing DB.

Here is the code, extracted (you will want to modify it yourself):

-- =============================================================  
-- Copyright Roaming Gamer, LLC.  
-- =============================================================  
-- (Rudimentary) Database Manager Factory  
-- =============================================================  
-- Short and Sweet License:   
-- 1. You may use anything you find in the SSK library and sampler to make apps and games for free or $$.  
-- 2. You may not sell or distribute SSK or the sampler as your own work.  
-- 3. If you intend to use the art or external code assets, you must read and follow the licenses found in the  
-- various associated readMe.txt files near those assets.  
--  
-- Credit?: Mentioning SSK and/or Roaming Gamer, LLC. in your credits is not required, but it would be nice. Thanks!  
--  
-- =============================================================  
-- Last Modified: 29 AUG 2012  
-- =============================================================  
  
local sqlite3 = require "sqlite3"  
--[[   
function initDB( dbpath )  
function isWordInDB( word )  
function findWordInDB( word )  
function testSearchSpeed( iterations )  
--]]  
  
local dbMgr = {}  
  
 function dbMgr:newDB( dbpath )  
 print("\n\*\*\*\* DBMGR: initDB() -\> " .. dbpath .. "\n")  
 print( "version " .. sqlite3.version() )  
 self.path = system.pathForFile(dbpath)  
 self.db = sqlite3.open( path )   
  
 function db:isWordInDB( word )  
 local foundCount = 0  
 word = string.lower(word)  
  
 --local cmd = "SELECT \* FROM theWords where field1='" .. word .. "'"  
 local cmd = "SELECT \* FROM theWords WHERE field1 LIKE '" .. word .. "'"  
  
 print("CMD ==" .. cmd)  
 --print( self:nrows("SELECT \* FROM words where field1='" .. word .. "'") )  
  
 for row in self:nrows(cmd) do  
 foundCount = foundCount + 1  
 end  
 print( foundCount )  
  
 if( foundCount \> 0 ) then  
 return true  
 end  
 return false  
 end  
  
 function db:findWordInDB( word )  
 word = string.lower(word)  
 local foundCount = 0  
 --local cmd = "SELECT \* FROM theWords where field1='" .. word .. "'"  
 local cmd = "SELECT \* FROM theWords WHERE field1 LIKE '" .. word .. "'"  
  
 for row in self:nrows(cmd) do  
 foundCount = foundCount + 1  
 end  
 print( word .. " " .. foundCount )  
 return foundCount  
 end  
  
 function db:testSearchSpeed( iterations )  
 local testwords = {}  
 testwords[0] = "actor"  
 testwords[1] = "plenty"  
 testwords[2] = "dog"  
 testwords[3] = "cat"  
 testwords[4] = "penny"  
 testwords[5] = "quarter"  
 testwords[6] = "lane"  
 testwords[7] = "man"  
 testwords[8] = "woman"  
 testwords[9] = "exact"  
  
 local startTime = system.getTimer()  
 print( startTime )  
 for i=0, iterations do  
 self:findWordInDB( testwords[math.random (0, 9)] )  
 end  
 local endTime = system.getTimer()  
 print( endTime )  
  
 local result = "Did " .. iterations .. " searches in " .. endTime - startTime .. " ms"  
 print(result)  
  
 local t = display.newText(result, 20, 30, null, 32)  
 t:setTextColor(255,0,0)  
  
 end  
 end  
  
return dbMgr

Note: You can get a tool for making your own databases here: http://sqlitebrowser.sourceforge.net/ It can convert comma separated word lists into a word DB.

Cheers,
Ed
Roaming Gamer, LLC.
SSK for Corona SDK (github) (videos)
[import]uid: 110228 topic_id: 31972 reply_id: 127482[/import]

#5

Ed,
thank you for your help… trying it now.
Brett [import]uid: 162950 topic_id: 31972 reply_id: 127578[/import]