public void _04_CanSaveOneToMany()
{
using (var session = TestDbSessionFactory.OpenSession()) {
using (var tx = session.BeginTransaction()) {
try {
var author = new Author();
author.Name = "beginor";
session.Save(author);
var book = new Book();
book.Title = "learning nhibernate";
book.Author = author;
session.Save(book);
session.Flush();
session.Delete(book);
session.Delete(author);
tx.Commit();
}
catch (Exception) {
tx.Rollback();
throw;
}
}
}
}
public void _03_CanQueryScalar()
{
using (var session = TestDbSessionFactory.OpenSession()) {
var query = session.GetNamedQuery("name_test_03");
var booksCount = query.List <long>().First();
Assert.True(booksCount > 0);
}
}
public void _01_CanQueryManyToOne()
{
using (var session = TestDbSessionFactory.OpenSession()) {
var query = session.Query <Book>().Select(b => b.Author);
var data = query.ToList();
Console.WriteLine(data.Count);
}
}
public void _01_CanQueryClass()
{
using (var session = TestDbSessionFactory.OpenSession()) {
var query = session.GetNamedQuery("name_test_01");
var books = query.List <Book>();
Assert.True(books.Count > 0);
}
}
public void _02_CanQueryClassWithParam()
{
using (var session = TestDbSessionFactory.OpenSession()) {
var query = session.GetNamedQuery("name_test_02");
query.SetInt32("authorid", 2);
var books = query.List <Book>();
Assert.True(books.Count > 0);
}
}
public void _05_CanQueryDynamicColumns()
{
using (var session = TestDbSessionFactory.OpenSession()) {
var query = session.GetNamedQuery("name_test_05");
var books = query.List();
Assert.True(books.Count > 0);
}
}
public void _04_CanQueryScalarWithParam()
{
using (var session = TestDbSessionFactory.OpenSession()) {
var query = session.GetNamedQuery("name_test_04");
Assert.True(query.NamedParameters.Length > 0);
query.SetInt32("authorid", 1);
Assert.True(query.NamedParameters.Length > 0);
var booksCount = query.List <long>().First();
Assert.True(booksCount > 0);
}
}
public void _02_CanInsertSnowFlakeId()
{
using (var session = TestDbSessionFactory.OpenSession()) {
var entity = new SnowFlakeTestEntity {
Name = Guid.NewGuid().ToString("N")
};
session.Save(entity);
Assert.True(entity.Id > 0);
Console.WriteLine($"Id: {entity.Id}");
}
}
public void _02_CanQueryOneToMany()
{
using (var session = TestDbSessionFactory.OpenSession()) {
var query = session.Query <Author>().Select(a => new {
Author = a,
Books = a.Books
});
var data = query.ToList();
Console.WriteLine(data.Count);
}
}
public void _01_CanQueryXmlEntity()
{
using var session = TestDbSessionFactory.OpenSession();
var entities = session.Query <XmlTestEntity>().ToList();
IsTrue(entities.Count >= 0);
foreach (var entity in entities)
{
Console.WriteLine($"id: {entity.Id}");
Console.WriteLine($"statement: {entity.Statement}");
}
}
public void _01_CanQuerySnowFlakeId()
{
using (var session = TestDbSessionFactory.OpenSession()) {
var entities = session.Query <SnowFlakeTestEntity>()
.ToList();
foreach (var entity in entities)
{
Assert.True(entity.Id > 0);
Console.WriteLine(JsonSerializer.Serialize(entity));
}
}
}
public void _02_CanSaveXmlEntity()
{
using var session = TestDbSessionFactory.OpenSession();
var xmlDoc = new XmlDocument();
xmlDoc.LoadXml("<Statement></Statement>");
var entity = new XmlTestEntity {
Statement = xmlDoc
};
session.Save(entity);
Greater(entity.Id, 0);
Console.WriteLine(entity.Id);
}
public void _03_CanQueryReference()
{
using (var session = TestDbSessionFactory.OpenSession()) {
var query = from book in session.Query <Book>()
select new {
BookId = book.BookId,
AuthorId = book.Author.AuthorId
};
var data = query.ToList();
foreach (var d in data)
{
Console.WriteLine($"{d.AuthorId}, {d.BookId}");
}
}
}
public void CanUseTypeHandler()
{
using (var session = TestDbSessionFactory.OpenSession()) {
var conn = session.Connection;
Dapper.DefaultTypeMap.MatchNamesWithUnderscores = true;
SqlMapper.AddTypeHandler(new DateTimeHandler());
var entity = conn.Query <TestTableEntity>(
"select * from public.test_table order by update_time limit 1"
).FirstOrDefault();
Assert.NotNull(entity);
var updated = conn.Execute(
"update public.test_table set update_time = @updateTime where id = @id",
new { id = entity.Id, updateTime = DateTime.Now }
);
Assert.AreEqual(1, updated);
}
}
public void CanQueryAuthors()
{
using (var session = TestDbSessionFactory.OpenSession()) {
var conn = session.Connection;
var authors = conn.Query <AuthorEntity>(
"select * from public.authors"
);
Assert.Greater(authors.Count(), 0);
authors = conn.Query <AuthorEntity>(
"select * from public.authors where authorid = any(@Ids)",
new {
Ids = new [] { 1, 2, 3 }.AsEnumerable()
}
);
Assert.LessOrEqual(authors.Count(), 3);
}
}
public void _01_CanSetupSessionFactory()
{
Assert.IsNotNull(TestDbSessionFactory);
var dvdRentalSession = TestDbSessionFactory.OpenSession();
var connStr = dvdRentalSession.Connection.ConnectionString;
Console.WriteLine(connStr);
dvdRentalSession.Close();
var testDbSession = TestDbSessionFactory.OpenSession();
var connStr2 = testDbSession.Connection.ConnectionString;
Console.WriteLine(connStr2);
testDbSession.Close();
Assert.AreNotEqual(connStr, connStr2);
}
public void _07_CanQueryMoniData()
{
using (var session = TestDbSessionFactory.OpenSession()) {
var moniData = new MoniData {
MoniTime = DateTime.Now,
StationId = 1,
ItemId = 1,
Value = (decimal)0.003d,
Description = "test"
};
session.Save(moniData);
session.Flush();
var query = session.Query <MoniData>();
var data = query.ToList();
Assert.True(data.Count > 0);
session.Delete(moniData);
session.Flush();
}
}
public void _01_CanDoCrud()
{
using (var session = TestDbSessionFactory.OpenSession()) {
var entity = new TestEntity {
Name = "Test 1",
Tags = new [] { "hello", "world" },
JsonField = JsonSerializer.Deserialize <JsonElement>("{ \"val\": 1 }"),
JsonbField = JsonSerializer.Deserialize <JsonElement>("{ \"val\": 1 }"),
UpdateTime = DateTime.Now,
Int16Arr = new short[] { 1, 2, 3 },
Int32Arr = new [] { 1, 2, 3 },
Int64Arr = new [] { 1L, 2L, 3L },
FloatArr = new [] { 1.1F, 2.2F, 3.3F },
DoubleArr = new [] { 1.1, 2.2, 3.3 },
BooleanArr = new [] { true, false }
};
session.Save(entity);
session.Flush();
session.Clear();
Assert.True(entity.Id > 0);
Console.WriteLine($"entity id: {entity.Id}");
}
using (var session = TestDbSessionFactory.OpenSession()) {
var query = session.Query <TestEntity>();
var entities = query.ToList();
Assert.NotNull(entities);
Console.WriteLine($"Entity count: {entities.Count}");
using (var tx = session.BeginTransaction()) {
foreach (var e in entities)
{
Console.WriteLine(JsonSerializer.Serialize(e));
session.Delete(e);
}
tx.Commit();
}
}
}
public void _02_CanSaveTypedJson()
{
using var session = TestDbSessionFactory.OpenSession();
var json = new JsonValue {
Value = new ConnectionString {
Server = "127.0.0.1",
Port = 1433,
Database = "northwind",
Username = "******",
Password = "******"
}
};
session.Save(json);
session.Flush();
Assert.Greater(json.Id, 0);
Console.WriteLine(json.Id);
var val = session.Get <JsonValue>(json.Id);
Assert.NotNull(val);
Assert.AreEqual(json.Id, val.Id);
session.Delete(json);
session.Flush();
}
private ISession OpenSession()
{
return(TestDbSessionFactory.OpenSession());
}
