public void TestDropTable() { Db.CreateTable("newtable", Pairing.Of("name", "text"), Pairing.Of("number", "int")).Execute(); Db.DropTable("newtable").Execute(); var table = Db.Take("information_schema.tables").Where(Pairing.Of("table_name", "newtable")).Execute(); Assert.AreEqual(0, table[0].Count); }
void CreateTestTable() { Db.CreateTable("test", Pairing.Of("name", "text"), Pairing.Of("age", "int")).Execute(); Db.Insert("test", Pairing.Of("name", "Marla"), Pairing.Of("age", 36)).Execute(); Db.Insert("test", Pairing.Of("name", "Susan"), Pairing.Of("age", 100)).Execute(); Db.Insert("test", Pairing.Of("name", "John"), Pairing.Of("age", 67)).Execute(); Db.Insert("test", Pairing.Of("name", "Jenna"), Pairing.Of("age", 34)).Execute(); Db.Insert("test", Pairing.Of("name", "RJ"), Pairing.Of("age", 29)).Execute(); }
public void TestInsert() { Db.Insert("test", Pairing.Of("name", "Bob")).Execute(); var results = Db.Take("test").Where(Pairing.Of("name", "Bob")).Execute(); Assert.IsNotNull(results); Assert.AreEqual("Bob", results[1][0]); Assert.AreEqual(1, results[0].Count); Db.Delete("test").Where(Pairing.Of("name", "Bob")).Execute(); }
public void TestDelete() { Db.Insert("test", Pairing.Of("name", "Bob")).Execute(); Db.Delete("test").Where(Pairing.Of("name", "Bob")).Execute(); var results1 = Db.Take("test").Where(Pairing.Of("name", "Bob")).Execute(); var results2 = Db.Take("test").Execute(); Assert.AreEqual(0, results1[0].Count); Assert.AreEqual(5, results2[0].Count); Assert.AreEqual("Marla", results2[1].Find(name => name == "Marla")); Assert.AreEqual(-1, results2[1].FindIndex(name => name == "Bob")); }
// Starting place public PostgreSQLConnection DropTable(string table) { var result = Take("information_schema.tables").Where(Pairing.Of("table_name", $"{table}")).Execute(); // Table is in the database so we can delete it if (result[0].Count > 0) { SQL = $"drop table {table}"; IsQuery = false; } return(this); }
public void TestWhere() { var results = Db.Take("test").Where(Pairing.Of("name", "Susan"), Pairing.Of("id", 2)).Execute(); Assert.IsNotNull(results); Assert.AreEqual(1, results[0].Count); Assert.AreEqual("Susan", results[1][0]); results = Db.Take("test").Where(Pairing.Of("age", 100)).Execute(); Assert.IsNotNull(results); Assert.AreEqual(1, results[0].Count); Assert.AreEqual("Susan", results[1][0]); }
// Starting place public PostgreSQLConnection CreateTable(string table, params KeyValuePair <string, object>[] columnTypes) { var result = Take("information_schema.tables").Where(Pairing.Of("table_name", $"{table}")).Execute(); if (result[0].Count == 0) { SQL = $"create table {table}();" + $" alter table {table} add column id bigserial primary key;"; foreach (var columnType in columnTypes) { SQL = SQL + $" alter table {table} add column {columnType.Key} {columnType.Value.ToString()};"; } } return(this); }