An ActiveRecord style Sqlite Library using FMDB, extracted from internal project

check lib/sqlite.rb for the code

$ rake
....

# class Wordlist < Sqlite
# ...."create table wordlist (id INTEGER PRIMARY KEY, word varchar(20),length int, UNIQUE(word));"
#end

(main)>> 
s = Wordlist.new
s.createTable
s.insert_data('Shweta')
s.insert_data('Sampoorna')
s.insert_data('Senthil')
s.insert_data('WORLD')
s.insert_data('WORLD')

results= s.find(:all)
[{"word"=>"Shweta", "id"=>"1", "length"=>"6"}, {"word"=>"Sampoorna", "id"=>"2", "length"=>"9"}, {"word"=>"Senthil", "id"=>"3", "length"=>"7"},{"word"=>"HELLO", "id"=>"4", "length"=>"5"},{"word"=>"WORLD", "id"=>"5", "length"=>"5"}]

• create table
• insert data
• find(:first), find(:last),find(:all)
• result is a array of hash with the key corresponding to the column name

• data is not persisted beyond a session
• no exception handling, so if you have any sqlite constraints like unique then gives error, or if table already exists
• data type conversion
• need to plan for migration
• pre-populated data
• currently table structure is hardcoded in the class, hope I would get models to extend from the base model, with least duplication of the code

• get word lists
• write a script to build the sqlite database
• search by word length and letters included
• anagram builder