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
}
}
