private void insertTestData(KeyValuePair <string, List <string> > table) { string insertQueryTpl = "INSERT INTO {0} ({1}) VALUES({2})"; string[] columns = table.Value.Select(x => "@" + x).ToArray(); string insertQuery = String.Format(insertQueryTpl, table.Key, String.Join(",", table.Value.ToArray()), String.Join(",", columns) ); for (int i = 1; i <= nRows; i++) { Dictionary <string, object> data = new Dictionary <string, object>(); foreach (string column in columns) { data.Add(column, i); } TestDB.runSQLNoneQuery(config, insertQuery, data); } }
private void cleanupMainTable(string tableName) { TestDB.runSQLNoneQuery(config, String.Format("DELETE FROM {0}", tableName)); TestDB.runSQLNoneQuery(config, String.Format("DELETE FROM ecpr_{0}_logs", tableName)); }