public void BuildSQliteDatabase() { /** * NOTE: * This is VERY bad practice. * I would normally NEVER have straight sql commands inline like this. * It is much better practice to use stored procedures through a DataAccess Layer. * */ TwitterAPIDAO dao = new TwitterAPIDAO(); dao.ExecuteNonQuery("DROP TABLE IF EXISTS tweets"); dao.ExecuteNonQuery(@"CREATE TABLE tweets(id INTEGER PRIMARY KEY, text TEXT, date INTEGER, source TEXT, lang TEXT, like INTEGER, reTweet INTEGER, hasUrl INTEGER, hasImage INTEGER, hasEmoji INTEGER)"); dao.ExecuteNonQuery("DROP TABLE IF EXISTS hashtags"); dao.ExecuteNonQuery(@"CREATE TABLE hashtags(id INTEGER PRIMARY KEY, tag TEXT)"); dao.ExecuteNonQuery("DROP TABLE IF EXISTS urls"); dao.ExecuteNonQuery(@"CREATE TABLE urls(id INTEGER PRIMARY KEY, url TEXT, hostname TEXT)"); dao.ExecuteNonQuery("DROP TABLE IF EXISTS emojis"); dao.ExecuteNonQuery(@"CREATE TABLE emojis(id INTEGER PRIMARY KEY, value TEXT)"); dao.ExecuteNonQuery("DROP TABLE IF EXISTS mentions"); dao.ExecuteNonQuery(@"CREATE TABLE mentions(id INTEGER PRIMARY KEY, name TEXT)"); }
public void RunSQLiteCommand(string CommandText, List <SQLiteParameter> Parameters) { TwitterAPIDAO dao = new TwitterAPIDAO(); dao.ExecuteNonQuery(CommandText, Parameters); }