public static void Test_CUBRIDClob_Update() { Configuration cfg = (new Configuration()).Configure().AddAssembly(typeof(TestCUBRIDClobType).Assembly); //Create the database schema using (CUBRIDConnection conn = new CUBRIDConnection(cfg.GetProperty(NHibernate.Cfg.Environment.ConnectionString))) { conn.Open(); TestCases.ExecuteSQL("drop table if exists TestCUBRIDClob", conn); TestCases.ExecuteSQL("create table TestCUBRIDClob(c_integer int not null auto_increment," + "c_clob CLOB," + "primary key (c_integer))", conn); TestCUBRIDClobType test = new TestCUBRIDClobType { c_clob = new CUBRIDClob(conn) }; StreamReader originalFileReader = new StreamReader("../../BSD License.txt"); string clobStringToInsert = originalFileReader.ReadToEnd(); originalFileReader.Close(); test.c_clob.SetString(1, clobStringToInsert); //Insert ISessionFactory sessionFactory = cfg.BuildSessionFactory(); using (var session = sessionFactory.OpenSession()) { using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted)) { session.Save(test); trans.Commit(); } TestCUBRIDClobType pGet = session.Get <TestCUBRIDClobType>(test.c_integer); pGet.c_clob = new CUBRIDClob(conn); StreamReader updateFileReader = new StreamReader("../../BSD License Updated.txt"); string clobStringToUpdate = updateFileReader.ReadToEnd(); updateFileReader.Close(); test.c_clob.SetString(1, clobStringToUpdate); using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted)) { session.Update(pGet); trans.Commit(); } //Retrieve the inserted information IQuery query = session.CreateQuery("FROM TestCUBRIDClobType"); IList <TestCUBRIDClobType> testQuery = query.List <TestCUBRIDClobType>(); Debug.Assert(testQuery[0].c_integer == 1); string clobStringUpdated = testQuery[0].c_clob.GetString(1, (int)testQuery[0].c_clob.ClobLength); Debug.Assert(clobStringToUpdate.Length == clobStringUpdated.Length); Debug.Assert(clobStringToUpdate == clobStringUpdated); } //Clean the database schema TestCases.ExecuteSQL("drop table if exists TestCUBRIDBlob", conn); } }
public static void Test_CUBRIDClob_Insert() { 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 TestCUBRIDClob", conn); TestCases.ExecuteSQL("create table TestCUBRIDClob(c_integer int not null auto_increment," + "c_clob CLOB," + "primary key (c_integer))", conn); TestCUBRIDClobType test = new TestCUBRIDClobType { c_clob = new CUBRIDClob(conn) }; StreamReader originalFileReader = new StreamReader("../../BSD License.txt"); string clobStringToInsert = originalFileReader.ReadToEnd(); originalFileReader.Close(); test.c_clob.SetString(1, clobStringToInsert); //Insert ISessionFactory sessionFactory = cfg.BuildSessionFactory(); using (var session = sessionFactory.OpenSession()) { using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted)) { session.Save(test); trans.Commit(); } } const string sql2 = "SELECT c_clob from TestCUBRIDClob"; CUBRIDCommand cmd2 = new CUBRIDCommand(sql2, conn); DbDataReader reader = cmd2.ExecuteReader(); while (reader.Read()) { CUBRIDClob cString = (CUBRIDClob)reader[0]; string clobStringInserted = cString.GetString(1, (int)cString.ClobLength); Debug.Assert(clobStringToInsert.Length == clobStringInserted.Length); Debug.Assert(clobStringToInsert == clobStringInserted); } //Clean the database schema TestCases.ExecuteSQL("drop table if exists TestCUBRIDClob", conn); } }
public static void Test_CUBRIDClob_Delete() { Configuration cfg = (new Configuration()).Configure().AddAssembly(typeof(TestCUBRIDClobType).Assembly); //Create the database schema using (CUBRIDConnection conn = new CUBRIDConnection(cfg.GetProperty(NHibernate.Cfg.Environment.ConnectionString))) { conn.Open(); TestCases.ExecuteSQL("drop table if exists TestCUBRIDClob", conn); TestCases.ExecuteSQL("create table TestCUBRIDClob(c_integer int not null auto_increment," + "c_clob CLOB," + "primary key (c_integer))", conn); TestCUBRIDClobType test = new TestCUBRIDClobType { c_clob = new CUBRIDClob(conn) }; StreamReader updateFileReader = new StreamReader("../../BSD License.txt"); string clobStringToInsert = updateFileReader.ReadToEnd(); updateFileReader.Close(); test.c_clob.SetString(1, clobStringToInsert); //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 TestCUBRIDClobType"); IList<TestCUBRIDClobType> testQuery = query.List<TestCUBRIDClobType>(); 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 TestCUBRIDClobType"); IList<TestCUBRIDClobType> testQueryAfterDelete = queryAfterDelete.List<TestCUBRIDClobType>(); Debug.Assert(testQueryAfterDelete.Count == 0); } //Clean the database schema TestCases.ExecuteSQL("drop table if exists TestCUBRIDClob", conn); } }
public static void Test_CUBRIDClob_Insert() { 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 TestCUBRIDClob", conn); TestCases.ExecuteSQL("create table TestCUBRIDClob(c_integer int not null auto_increment," + "c_clob CLOB," + "primary key (c_integer))", conn); TestCUBRIDClobType test = new TestCUBRIDClobType { c_clob = new CUBRIDClob(conn) }; StreamReader originalFileReader = new StreamReader("../../BSD License.txt"); string clobStringToInsert = originalFileReader.ReadToEnd(); originalFileReader.Close(); test.c_clob.SetString(1, clobStringToInsert); //Insert ISessionFactory sessionFactory = cfg.BuildSessionFactory(); using (var session = sessionFactory.OpenSession()) { using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted)) { session.Save(test); trans.Commit(); } } const string sql2 = "SELECT c_clob from TestCUBRIDClob"; CUBRIDCommand cmd2 = new CUBRIDCommand(sql2, conn); DbDataReader reader = cmd2.ExecuteReader(); while (reader.Read()) { CUBRIDClob cString = (CUBRIDClob)reader[0]; string clobStringInserted = cString.GetString(1, (int)cString.ClobLength); Debug.Assert(clobStringToInsert.Length == clobStringInserted.Length); Debug.Assert(clobStringToInsert == clobStringInserted); } //Clean the database schema TestCases.ExecuteSQL("drop table if exists TestCUBRIDClob", conn); } }