CREATE_TABLE |
= |
<<-SQL CREATE TABLE IF NOT EXISTS user ( id int NOT NULL, screen_name text, PRIMARY KEY (id) ); CREATE TABLE IF NOT EXISTS post ( post_id int NOT NULL, -- twitter側のpostのid created_at int, -- 日付(RubyでUNIX時間に変換) in_reply_to_status_id int, -- あったほうがよいらしい in_reply_to_user_id int, -- あったほうがよいらしい post_text text, user_id int NOT NULL, PRIMARY KEY (post_id) ); SQL |
FIND_USER_ID |
= |
<<-EOS select id, screen_name from user where id = ? EOS |
FIND_ID |
= |
<<-EOS select created_at, screen_name, post_text, in_reply_to_status_id, post_id, user_id from post inner join user on post.user_id = user.id where post_id = ? EOS |
FIND |
= |
<<-EOS select created_at, screen_name, post_text, in_reply_to_status_id, post_id, user_id from post inner join user on post.user_id = user.id where post_text like '%' || ? || '%' EOS |
FIND_USER |
= |
<<-EOS select created_at, screen_name, post_text, in_reply_to_status_id, post_id, user_id from post inner join user on post.user_id = user.id where EOS |