public void TestTableCreate() { CrateDataReader reader = null; List <Table> schemadata = null; var tabledesc = (CrateTable)Attribute.GetCustomAttribute(typeof(CreatTestTable), typeof(CrateTable)); Assert.IsNotNull(tabledesc); TableUtils.DropTable(tabledesc.Name); using (var conn = TestCrateConnection()) { conn.Open(); conn.CreateTable <CreatTestTable>(); var sql = "SELECT * FROM information_schema.tables WHERE table_name= '" + tabledesc.Name + "'"; using (var cmd = new CrateCommand(sql, conn)) { reader = (CrateDataReader)cmd.ExecuteReader(); schemadata = reader.ToList <Table>(); } } Assert.IsNotNull(reader); Assert.IsNotNull(schemadata); Assert.Greater(schemadata.Count, 0); Assert.AreEqual(EnumHelpers.Replication(tabledesc.NumberOfReplicas), schemadata[0].NumberOfReplicas); Assert.AreEqual(tabledesc.NumberOfShards, schemadata[0].NumberOfShards); }
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 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 void TestSelect() { using (var conn = TestCrateConnection()) { conn.Open(); using (var cmd = new CrateCommand("select name from sys.cluster", conn)) { var reader = cmd.ExecuteReader(); reader.Read(); string clusterName = reader.GetString(0); Assert.AreEqual(clusterName, "crate"); } } }
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 } }