public static void Test_DataTypesStandard_Delete() { Configuration cfg = (new Configuration()).Configure().AddAssembly(typeof(TestCUBRIDBlobType).Assembly); //Create the database schema using (CUBRIDConnection conn = new CUBRIDConnection(cfg.GetProperty(NHibernate.Cfg.Environment.ConnectionString))) { conn.Open(); TestCases.ExecuteSQL("drop table if exists TestDataTypesStandard", conn); TestCases.ExecuteSQL("create table TestDataTypesStandard (" + "c_integer integer," + "c_smallint smallint," + "c_bigint bigint," + "c_numeric numeric(10,2)," + "c_float float," + "c_decimal decimal(19,5)," + "c_double double," + "c_char char(1)," + "c_varchar varchar(30)," + "c_time time," + "c_date date," + "c_timestamp timestamp," + "c_datetime datetime," + "c_monetary monetary," + "c_string string," + "c_bit BIT(8)," + "c_varbit bit varying(8)," + "primary key (c_integer))", conn); TestDataTypesStandard test = new TestDataTypesStandard { c_bigint = 1, c_char = "a", c_date = new DateTime(2012, 06, 19), c_datetime = new DateTime(2012, 06, 19, 12, 05, 14), c_decimal = (decimal)0.5, c_double = 1.5, c_float = 1.5f, c_integer = 14, c_monetary = 50, c_numeric = (decimal)20.12, c_smallint = 1, c_string = "qwerty", c_time = new DateTime(2012, 06, 19, 12, 05, 14), c_timestamp = new DateTime(2012, 06, 19, 12, 05, 14), c_varchar = "qwerty", c_bit = 1, c_varbit = 1, }; //Insert ISessionFactory sessionFactory = cfg.BuildSessionFactory(); using (var session = sessionFactory.OpenSession()) { using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted)) { session.Save(test); trans.Commit(); } //Retrieve the inserted information IQuery query = session.CreateQuery("FROM TestDataTypesStandard"); IList <TestDataTypesStandard> testQuery = query.List <TestDataTypesStandard>(); Debug.Assert(testQuery.Count == 1); //Delete the inserted information using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted)) { session.Delete(test); trans.Commit(); } IQuery queryAfterDelete = session.CreateQuery("FROM TestDataTypesStandard"); IList <TestDataTypesStandard> testQueryAfterDelete = queryAfterDelete.List <TestDataTypesStandard>(); Debug.Assert(testQueryAfterDelete.Count == 0); } //Clean the database schema TestCases.ExecuteSQL("drop table if exists TestDataTypesStandard", conn); } }
public static void Test_DataTypesStandard_Select() { Configuration cfg = (new Configuration()).Configure().AddAssembly(typeof(TestCUBRIDBlobType).Assembly); //Create the database schema using (CUBRIDConnection conn = new CUBRIDConnection(cfg.GetProperty(NHibernate.Cfg.Environment.ConnectionString))) { conn.Open(); TestCases.ExecuteSQL("drop table if exists TestDataTypesStandard", conn); TestCases.ExecuteSQL("create table TestDataTypesStandard (" + "c_integer integer," + "c_smallint smallint," + "c_bigint bigint," + "c_numeric numeric(10,2)," + "c_float float," + "c_decimal decimal(19,5)," + "c_double double," + "c_char char(1)," + "c_varchar varchar(30)," + "c_time time," + "c_date date," + "c_timestamp timestamp," + "c_datetime datetime," + "c_monetary monetary," + "c_string string," + "c_bit BIT(8)," + "c_varbit bit varying(8)," + "primary key (c_integer))", conn); TestDataTypesStandard test = new TestDataTypesStandard { c_bigint = 1, c_char = "a", c_date = new DateTime(2012, 06, 19), c_datetime = new DateTime(2012, 06, 19, 12, 05, 14), c_decimal = (decimal)0.5, c_double = 1.5, c_float = 1.5f, c_integer = 14, c_monetary = 50, c_numeric = (decimal)20.12, c_smallint = 1, c_string = "qwerty", c_time = new DateTime(2012, 06, 19, 12, 05, 14), c_timestamp = new DateTime(2012, 06, 19, 12, 05, 14), c_varchar = "qwerty", c_bit = 1, c_varbit = 1, }; //Insert ISessionFactory sessionFactory = cfg.BuildSessionFactory(); using (var session = sessionFactory.OpenSession()) { using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted)) { session.Save(test); trans.Commit(); } //Retrieve the inserted information IQuery query = session.CreateQuery("FROM TestDataTypesStandard"); IList<TestDataTypesStandard> testQuery = query.List<TestDataTypesStandard>(); Debug.Assert(testQuery.Count == 1); Debug.Assert(testQuery[0].c_integer == 14); Debug.Assert(testQuery[0].c_bigint == 1); Debug.Assert(testQuery[0].c_char == "a"); Debug.Assert(testQuery[0].c_date == new DateTime(2012, 06, 19)); Debug.Assert(testQuery[0].c_datetime == new DateTime(2012, 06, 19, 12, 05, 14)); Debug.Assert(testQuery[0].c_decimal == (decimal)0.5); Debug.Assert(testQuery[0].c_double.Equals(1.5)); Debug.Assert(testQuery[0].c_float.Equals(1.5f)); Debug.Assert(testQuery[0].c_monetary == 50); Debug.Assert(testQuery[0].c_numeric == (decimal)20.12); Debug.Assert(testQuery[0].c_smallint == 1); Debug.Assert(testQuery[0].c_string == "qwerty"); Debug.Assert(testQuery[0].c_time == new DateTime(2012, 06, 19, 12, 05, 14)); Debug.Assert(testQuery[0].c_timestamp == new DateTime(2012, 06, 19, 12, 05, 14)); Debug.Assert(testQuery[0].c_varchar == "qwerty"); Debug.Assert(testQuery[0].c_bit == (byte)1); Debug.Assert(testQuery[0].c_varbit == (byte)1); } //Clean the database schema TestCases.ExecuteSQL("drop table if exists TestDataTypesStandard", conn); } }