public static void Test_CUBRIDCollections_Delete()
{
Configuration cfg = (new Configuration()).Configure().AddAssembly(typeof(TestCUBRIDCollectionType).Assembly);
//Create the database schema
using (CUBRIDConnection conn = new CUBRIDConnection(cfg.GetProperty(NHibernate.Cfg.Environment.ConnectionString)))
{
conn.Open();
TestCases.ExecuteSQL("drop table if exists TestCUBRIDCollectionType", conn);
TestCases.ExecuteSQL("create table TestCUBRIDCollectionType(id int not null auto_increment," +
"sequence_column sequence(int), " +
"set_column set(int), " +
"multiset_column multiset(string)," +
"primary key (id))", conn);
object[] insertSequence = { 0, 1, 2, 3 };
object[] insertSet = { 4, 5, 6, 7 };
object[] insertMultiset = { "CUBRID", "qwerty" };
TestCUBRIDCollectionType testCollections = new TestCUBRIDCollectionType()
{
seq = insertSequence,
set = insertSet,
multiset = insertMultiset
};
//Insert
ISessionFactory sessionFactory = cfg.BuildSessionFactory();
using (var session = sessionFactory.OpenSession())
{
using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted))
{
session.Save(testCollections);
trans.Commit();
}
}
//Check the the insert performed correctly
using (var session = sessionFactory.OpenSession())
{
//Retrieve the inserted information
IQuery queryAfterInsert = session.CreateQuery(" from TestCUBRIDCollectionType");
IList<TestCUBRIDCollectionType> testQueryAfterInsert = queryAfterInsert.List<TestCUBRIDCollectionType>();
Debug.Assert(testQueryAfterInsert.Count == 1);
}
//Delete the inserted information
using (var session = sessionFactory.OpenSession())
{
using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted))
{
session.Delete(testCollections);
trans.Commit();
}
}
using (var session = sessionFactory.OpenSession())
{
IQuery queryAfterDelete = session.CreateQuery("FROM TestCUBRIDCollectionType");
IList<TestCUBRIDClobType> testQueryAfterDelete = queryAfterDelete.List<TestCUBRIDClobType>();
Debug.Assert(testQueryAfterDelete.Count == 0);
}
//Clean the database schema
TestCases.ExecuteSQL("drop table if exists TestCUBRIDCollectionType", conn);
}
}
public static void Test_CUBRIDCollections_Delete()
{
Configuration cfg = (new Configuration()).Configure().AddAssembly(typeof(TestCUBRIDCollectionType).Assembly);
//Create the database schema
using (CUBRIDConnection conn = new CUBRIDConnection(cfg.GetProperty(NHibernate.Cfg.Environment.ConnectionString)))
{
conn.Open();
TestCases.ExecuteSQL("drop table if exists TestCUBRIDCollectionType", conn);
TestCases.ExecuteSQL("create table TestCUBRIDCollectionType(id int not null auto_increment," +
"sequence_column sequence(int), " +
"set_column set(int), " +
"multiset_column multiset(string)," +
"primary key (id))", conn);
object[] insertSequence = { 0, 1, 2, 3 };
object[] insertSet = { 4, 5, 6, 7 };
object[] insertMultiset = { "CUBRID", "qwerty" };
TestCUBRIDCollectionType testCollections = new TestCUBRIDCollectionType()
{
seq = insertSequence,
set = insertSet,
multiset = insertMultiset
};
//Insert
ISessionFactory sessionFactory = cfg.BuildSessionFactory();
using (var session = sessionFactory.OpenSession())
{
using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted))
{
session.Save(testCollections);
trans.Commit();
}
}
//Check the the insert performed correctly
using (var session = sessionFactory.OpenSession())
{
//Retrieve the inserted information
IQuery queryAfterInsert = session.CreateQuery(" from TestCUBRIDCollectionType");
IList <TestCUBRIDCollectionType> testQueryAfterInsert = queryAfterInsert.List <TestCUBRIDCollectionType>();
Debug.Assert(testQueryAfterInsert.Count == 1);
}
//Delete the inserted information
using (var session = sessionFactory.OpenSession())
{
using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted))
{
session.Delete(testCollections);
trans.Commit();
}
}
using (var session = sessionFactory.OpenSession())
{
IQuery queryAfterDelete = session.CreateQuery("FROM TestCUBRIDCollectionType");
IList <TestCUBRIDClobType> testQueryAfterDelete = queryAfterDelete.List <TestCUBRIDClobType>();
Debug.Assert(testQueryAfterDelete.Count == 0);
}
//Clean the database schema
TestCases.ExecuteSQL("drop table if exists TestCUBRIDCollectionType", conn);
}
}
public static void Test_CUBRIDCollections_Update()
{
Configuration cfg = (new Configuration()).Configure().AddAssembly(typeof(TestCUBRIDCollectionType).Assembly);
//Create the database schema
using (CUBRIDConnection conn = new CUBRIDConnection(cfg.GetProperty(NHibernate.Cfg.Environment.ConnectionString)))
{
conn.Open();
TestCases.ExecuteSQL("drop table if exists TestCUBRIDCollectionType", conn);
TestCases.ExecuteSQL("create table TestCUBRIDCollectionType(id int not null auto_increment," +
"sequence_column sequence(int), " +
"set_column set(int), " +
"multiset_column multiset(string)," +
"primary key (id))", conn);
object[] insertSequence = { 0, 1, 2, 3 };
object[] insertSet = { 4, 5, 6, 7 };
object[] insertMultiset = { "CUBRID", "qwerty" };
TestCUBRIDCollectionType testCollections = new TestCUBRIDCollectionType()
{
seq = insertSequence,
set = insertSet,
multiset = insertMultiset
};
//Insert
ISessionFactory sessionFactory = cfg.BuildSessionFactory();
using (var session = sessionFactory.OpenSession())
{
using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted))
{
session.Save(testCollections);
trans.Commit();
}
}
object[] updateSequence = { 10, 11, 12, 13 };
object[] updateSet = { 14, 15, 16, 17 };
object[] updateMultiset = { "ADO.NET", "NHibernate" };
testCollections.seq = updateSequence;
testCollections.set = updateSet;
testCollections.multiset = updateMultiset;
//Update
using (var session = sessionFactory.OpenSession())
{
using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted))
{
session.Update(testCollections);
trans.Commit();
}
}
//Check the the insert performed correctly
using (var session = sessionFactory.OpenSession())
{
//Retrieve the inserted information
IQuery query = session.CreateQuery(" from TestCUBRIDCollectionType");
IList<TestCUBRIDCollectionType> testQuery = query.List<TestCUBRIDCollectionType>();
int[] expectedSequence = { 10, 11, 12, 13 };
int[] expectedSet = { 14, 15, 16, 17 };
string[] expectedMultiset = { "ADO.NET", "NHibernate" };
Debug.Assert((int)testQuery[0].id == 1);
Debug.Assert((int)testQuery[0].seq[0] == expectedSequence[0]);
Debug.Assert((int)testQuery[0].seq[1] == expectedSequence[1]);
Debug.Assert((int)testQuery[0].seq[2] == expectedSequence[2]);
Debug.Assert((int)testQuery[0].seq[3] == expectedSequence[3]);
Debug.Assert((int)testQuery[0].set[0] == expectedSet[0]);
Debug.Assert((int)testQuery[0].set[1] == expectedSet[1]);
Debug.Assert((int)testQuery[0].set[2] == expectedSet[2]);
Debug.Assert((int)testQuery[0].set[3] == expectedSet[3]);
Debug.Assert((string)testQuery[0].multiset[0] == expectedMultiset[0]);
Debug.Assert((string)testQuery[0].multiset[1] == expectedMultiset[1]);
}
//Clean the database schema
TestCases.ExecuteSQL("drop table if exists TestCUBRIDCollectionType", conn);
}
}
public static void Test_CUBRIDCollections_Update()
{
Configuration cfg = (new Configuration()).Configure().AddAssembly(typeof(TestCUBRIDCollectionType).Assembly);
//Create the database schema
using (CUBRIDConnection conn = new CUBRIDConnection(cfg.GetProperty(NHibernate.Cfg.Environment.ConnectionString)))
{
conn.Open();
TestCases.ExecuteSQL("drop table if exists TestCUBRIDCollectionType", conn);
TestCases.ExecuteSQL("create table TestCUBRIDCollectionType(id int not null auto_increment," +
"sequence_column sequence(int), " +
"set_column set(int), " +
"multiset_column multiset(string)," +
"primary key (id))", conn);
object[] insertSequence = { 0, 1, 2, 3 };
object[] insertSet = { 4, 5, 6, 7 };
object[] insertMultiset = { "CUBRID", "qwerty" };
TestCUBRIDCollectionType testCollections = new TestCUBRIDCollectionType()
{
seq = insertSequence,
set = insertSet,
multiset = insertMultiset
};
//Insert
ISessionFactory sessionFactory = cfg.BuildSessionFactory();
using (var session = sessionFactory.OpenSession())
{
using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted))
{
session.Save(testCollections);
trans.Commit();
}
}
object[] updateSequence = { 10, 11, 12, 13 };
object[] updateSet = { 14, 15, 16, 17 };
object[] updateMultiset = { "ADO.NET", "NHibernate" };
testCollections.seq = updateSequence;
testCollections.set = updateSet;
testCollections.multiset = updateMultiset;
//Update
using (var session = sessionFactory.OpenSession())
{
using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted))
{
session.Update(testCollections);
trans.Commit();
}
}
//Check the the insert performed correctly
using (var session = sessionFactory.OpenSession())
{
//Retrieve the inserted information
IQuery query = session.CreateQuery(" from TestCUBRIDCollectionType");
IList <TestCUBRIDCollectionType> testQuery = query.List <TestCUBRIDCollectionType>();
int[] expectedSequence = { 10, 11, 12, 13 };
int[] expectedSet = { 14, 15, 16, 17 };
string[] expectedMultiset = { "ADO.NET", "NHibernate" };
Debug.Assert((int)testQuery[0].id == 1);
Debug.Assert((int)testQuery[0].seq[0] == expectedSequence[0]);
Debug.Assert((int)testQuery[0].seq[1] == expectedSequence[1]);
Debug.Assert((int)testQuery[0].seq[2] == expectedSequence[2]);
Debug.Assert((int)testQuery[0].seq[3] == expectedSequence[3]);
Debug.Assert((int)testQuery[0].set[0] == expectedSet[0]);
Debug.Assert((int)testQuery[0].set[1] == expectedSet[1]);
Debug.Assert((int)testQuery[0].set[2] == expectedSet[2]);
Debug.Assert((int)testQuery[0].set[3] == expectedSet[3]);
Debug.Assert((string)testQuery[0].multiset[0] == expectedMultiset[0]);
Debug.Assert((string)testQuery[0].multiset[1] == expectedMultiset[1]);
}
//Clean the database schema
TestCases.ExecuteSQL("drop table if exists TestCUBRIDCollectionType", conn);
}
}