jonathanyee

CREATE TABLE playlists (_id INTEGER PRIMARY KEY AUTOINCREMENT, cache_date INTEGER, pubDate INTEGER, guid VARCHAR(255), title VARCHAR(255), description VARCHAR(1024), osplaylistId INTEGER, image_url VARCHAR(1024), feed_url VARCHAR(255), feed_type INTEGER, playlist_type INTEGER, is_default INTEGER, sort_order INTEGER, UNIQUE (title, feed_url) ON CONFLICT REPLACE);


CREATE TABLE playlist_items (_id INTEGER PRIMARY KEY AUTOINCREMENT, guid VARCHAR(50), title VARCHAR(255), description VARCHAR(1024), pubDate INTEGER, duration INTEGER, regular_video_url VARCHAR(512), high_video_url VARCHAR(512), hls_video_url VARCHAR(512), thumbnail_url VARCHAR(512), more_xml VARCHAR(512), playlist_id INTEGER, UNIQUE (playlist_id, guid), FOREIGN KEY(playlist_id) REFERENCES playlists(_id) ON DELETE CASCADE);


Error inserting guid=4965352 pubDate=1347906812000 thumbnail_url=http://images.1sfx.net/1202735/1202735_DA_OTU1OTEzNTQ=.jpg duration=381000 title=World's Most Beautiful Sunrises and Sunsets more_xml=null _id=399 hls_video_url=n

jonathanyee

String createPlaylistItemsTable = "CREATE TABLE " + PlaylistItems.TABLE_NAME + " ("
                    + PlaylistItems.COLUMN_NAME_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
                    + PlaylistItems.COLUMN_NAME_GUID + " VARCHAR(50), " + PlaylistItems.COLUMN_NAME_TITLE
                    + " VARCHAR(255), " + PlaylistItems.COLUMN_NAME_DESCRIPTION + " VARCHAR(1024), "
                    + PlaylistItems.COLUMN_NAME_PUB_DATE + " INTEGER, " + PlaylistItems.COLUMN_NAME_DURATION
                    + " INTEGER, " + PlaylistItems.COLUMN_NAME_REGULAR_VIDEO_URL + " VARCHAR(512), "
                    + PlaylistItems.COLUMN_NAME_HIGH_VIDEO_URL + " VARCHAR(512), "
                    + PlaylistItems.COLUMN_NAME_HLS_VIDEO_URL + " VARCHAR(512), "
                    + PlaylistItems.COLUMN_NAME_THUMBNAIL_URL + " VARCHAR(512), " + PlaylistItems.COLUMN_NAME_MORE_XML
                    + " VARCHAR(512), " + PlaylistItems.COLUMN_NAME_PLAYLIST_ID + " INTEGER, UNIQUE ("

jonathanyee

unless ARGV.size == 2                                              
  puts "USAGE: ruby guess.rb ACKRCKOOLCWZ 5"                       
  exit 1                                                           
end                                                                
                                                                   
letters = ARGV[0].downcase.split(//).sort
length = ARGV[1].to_i                                              

words = []                                                         
File.open('/usr/share/dict/words') do |file|