public static void InsertIntoIpGeoTable() { using (var conn = BaseSetup.TestCrateConnection()) { conn.Open(); using (var cmd = new CrateCommand("insert into ip_geopoint (id,ip_addr,pin,dateutc) values ('1','192.168.2.1',[ 46.5, 26.4 ],'1969-12-06')", conn)) { cmd.ExecuteNonQuery(); } } }
public static void CreateIpGeoTable() { using (var conn = BaseSetup.TestCrateConnection()) { conn.Open(); using (var cmd = new CrateCommand("CREATE TABLE ip_geopoint ( id integer, ip_addr string, pin geo_point,dateutc timestamp) with (number_of_replicas = 0)", conn)) { cmd.ExecuteNonQuery(); } } }
public static void DropTable(string name) { try { using (var conn = BaseSetup.TestCrateConnection()) { using (var cmd = new CrateCommand("drop table " + name, conn)) { cmd.ExecuteNonQuery(); } } } catch (Exception) { //Bad solution for drop if exists } }