private void CreateTables()
{
var c = CacheDatabaseConnection.CreateCommand();
//TODO : よりスタイリッシュな方法の探索
CacheContext.ExecuteCommand("CREATE TABLE IF NOT EXISTS Favorites(ID UNIQUE,DATE,NAME);");
CacheContext.ExecuteCommand("CREATE TABLE IF NOT EXISTS Retweets(ID UNIQUE,ORIGINALID,DATE,NAME);");
CacheContext.ExecuteCommand("CREATE TABLE IF NOT EXISTS Bookmarks(ID UNIQUE,DATE,SCREENNAME,NAME,STATUS);");
AddFavoriteCacheCommand = CacheDatabaseConnection.CreateCommand();
AddFavoriteCacheCommand.CommandText = "INSERT OR IGNORE INTO Favorites(ID,DATE,NAME) VALUES(@Id,@Date,@Name)";
AddFavoriteCacheCommand.Parameters.Add("Id", DbType.Int64);
AddFavoriteCacheCommand.Parameters.Add("Date", DbType.DateTime);
AddFavoriteCacheCommand.Parameters.Add("Name", DbType.String);
AddRetweetCacheCommand = CacheDatabaseConnection.CreateCommand();
AddRetweetCacheCommand.CommandText = "INSERT OR IGNORE INTO Retweets(ID,ORIGINALID,DATE,NAME) VALUES(@Id,@OriginalId,@Date,@Name)";
AddRetweetCacheCommand.Parameters.Add("Id", DbType.Int64);
AddRetweetCacheCommand.Parameters.Add("OriginalId", DbType.Int64);
AddRetweetCacheCommand.Parameters.Add("Date", DbType.DateTime);
AddRetweetCacheCommand.Parameters.Add("Name", DbType.String);
RemoveFavoriteCacheCommand = CacheDatabaseConnection.CreateCommand();
RemoveFavoriteCacheCommand.CommandText = "DELETE FROM Favorites WHERE ID=@Id";
RemoveFavoriteCacheCommand.Parameters.Add("Id", DbType.Int64);
RemoveRetweetCacheCommand = CacheDatabaseConnection.CreateCommand();
RemoveRetweetCacheCommand.CommandText = "DELETE FROM Retweets WHERE ID=@Id";
RemoveRetweetCacheCommand.Parameters.Add("Id", DbType.Int64);
IsFavoritedCommand = CacheDatabaseConnection.CreateCommand();
IsFavoritedCommand.CommandText = "SELECT * FROM Favorites WHERE ID=@Id";
IsFavoritedCommand.Parameters.Add("Id", DbType.Int64);
IsRetweetedCommand = CacheDatabaseConnection.CreateCommand();
IsRetweetedCommand.CommandText = "SELECT * FROM Retweets WHERE ORIGINALID=@OriginalId";
IsRetweetedCommand.Parameters.Add("OriginalId", DbType.Int64);
IsMyRetweetCommand = CacheDatabaseConnection.CreateCommand();
IsMyRetweetCommand.CommandText = "SELECT * FROM Retweets WHERE ID=@Id";
IsMyRetweetCommand.Parameters.Add("Id", DbType.Int64);
}
