public void TearDwon()
{
using (var db = new OrmLiteConnectionFactory(ConnectionString, FirebirdDialect.Provider).Open())
{
db.DropTable <TypeWithOnDeleteAndUpdateCascade>();
db.DropTable <TypeWithOnDeleteSetNull>();
db.DropTable <TypeWithOnDeleteSetDefault>();
db.DropTable <TypeWithOnDeleteRestrict>();
db.DropTable <TypeWithOnDeleteNoAction>();
db.DropTable <TypeWithOnDeleteCascade>();
db.DropTable <TypeWithSimpleForeignKey>();
db.DropTable <ReferencedType>();
}
}
public void Can_create_ModelWithAutoId_table()
{
using (var db = new OrmLiteConnectionFactory(ConnectionString, Firebird4Dialect.Provider).OpenDbConnection())
{
db.CreateTable <ModelWithAutoId>(true);
Assert.That(
OrmLiteConfig.DialectProvider.DoesTableExist(db, nameof(ModelWithAutoId)),
Is.True);
db.DropTable <ModelWithAutoId>();
Assert.That(
OrmLiteConfig.DialectProvider.DoesTableExist(db, nameof(ModelWithAutoId)),
Is.False);
}
}
public void Does_table_Exists()
{
using var db = new OrmLiteConnectionFactory(ConnectionString, FirebirdDialect.Provider).Open();
db.DropTable <ModelWithIdOnly>();
Assert.That(
OrmLiteConfig.DialectProvider.DoesTableExist(db, nameof(ModelWithIdOnly)),
Is.False);
db.CreateTable <ModelWithIdOnly>(true);
Assert.That(
OrmLiteConfig.DialectProvider.DoesTableExist(db, nameof(ModelWithIdOnly)),
Is.True);
}
public void Does_table_Exists()
{
using (var db = new OrmLiteConnectionFactory(ConnectionString, FirebirdDialect.Provider).Open())
{
db.DropTable<ModelWithIdOnly>();
Assert.That(
OrmLiteConfig.DialectProvider.DoesTableExist(db, typeof(ModelWithIdOnly).Name),
Is.False);
db.CreateTable<ModelWithIdOnly>(true);
Assert.That(
OrmLiteConfig.DialectProvider.DoesTableExist(db, typeof(ModelWithIdOnly).Name),
Is.True);
}
}
public void Does_table_Exists()
{
using (var db = new OrmLiteConnectionFactory(ConnectionString, Firebird4Dialect.Provider).OpenDbConnection())
{
db.DropTable <ModelWithAutoIncrement>();
Assert.That(
OrmLiteConfig.DialectProvider.DoesTableExist(db, typeof(ModelWithAutoIncrement).Name),
Is.False);
db.CreateTable <ModelWithAutoIncrement>(true);
Assert.That(
OrmLiteConfig.DialectProvider.DoesTableExist(db, typeof(ModelWithAutoIncrement).Name),
Is.True);
}
}
public void Shippers_UseCase()
{
using (var db = new OrmLiteConnectionFactory("User=SYSDBA;Password=masterkey;Database=ormlite-tests.fdb;DataSource=localhost;Dialect=3;charset=ISO8859_1;", FirebirdDialect.Provider).Open())
{
const bool overwrite = false;
db.DropTable <Shipper>();
db.DropTable <ShipperType>();
db.CreateTables(overwrite, typeof(ShipperType), typeof(Shipper)); // ShipperType must be created first!
int trainsTypeId, planesTypeId;
//Playing with transactions
using (IDbTransaction dbTrans = db.BeginTransaction())
{
db.Insert(new ShipperType {
Name = "Trains"
});
trainsTypeId = (int)db.LastInsertId();
db.Insert(new ShipperType {
Name = "Planes"
});
planesTypeId = (int)db.LastInsertId();
dbTrans.Commit();
}
using (IDbTransaction dbTrans = db.BeginTransaction(IsolationLevel.ReadCommitted))
{
db.Insert(new ShipperType {
Name = "Automobiles"
});
Assert.That(db.Select <ShipperType>(), Has.Count.EqualTo(3));
dbTrans.Rollback();
}
Assert.That(db.Select <ShipperType>(), Has.Count.EqualTo(2));
//Performing standard Insert's and Selects
db.Insert(new Shipper {
CompanyName = "Trains R Us", Phone = "555-TRAINS", ShipperTypeId = trainsTypeId
});
db.Insert(new Shipper {
CompanyName = "Planes R Us", Phone = "555-PLANES", ShipperTypeId = planesTypeId
});
db.Insert(new Shipper {
CompanyName = "We do everything!", Phone = "555-UNICORNS", ShipperTypeId = planesTypeId
});
var trainsAreUs = db.Single <Shipper>("\"Type\" = @id", new { id = trainsTypeId });
Assert.That(trainsAreUs.CompanyName, Is.EqualTo("Trains R Us"));
Assert.That(db.Select <Shipper>("CompanyName = @company OR Phone = @phone",
new { company = "Trains R Us", phone = "555-UNICORNS" }), Has.Count.EqualTo(2));
Assert.That(db.Select <Shipper>("\"Type\" = @id", new { id = planesTypeId }), Has.Count.EqualTo(2));
//Lets update a record
trainsAreUs.Phone = "666-TRAINS";
db.Update(trainsAreUs);
Assert.That(db.SingleById <Shipper>(trainsAreUs.Id).Phone, Is.EqualTo("666-TRAINS"));
//Then make it dissappear
db.Delete(trainsAreUs);
Assert.That(db.SingleById <Shipper>(trainsAreUs.Id), Is.Null);
//And bring it back again
db.Insert(trainsAreUs);
//Performing custom queries
//Select only a subset from the table
var partialColumns = db.Select <SubsetOfShipper>(typeof(Shipper), "\"Type\" = @id", new { id = planesTypeId });
Assert.That(partialColumns, Has.Count.EqualTo(2));
//Select into another POCO class that matches sql
var rows = db.Select <ShipperTypeCount>(
"SELECT \"Type\" as ShipperTypeId, COUNT(*) AS Total FROM ShippersT GROUP BY \"Type\" ORDER BY COUNT(*)");
Assert.That(rows, Has.Count.EqualTo(2));
Assert.That(rows[0].ShipperTypeId, Is.EqualTo(trainsTypeId));
Assert.That(rows[0].Total, Is.EqualTo(1));
Assert.That(rows[1].ShipperTypeId, Is.EqualTo(planesTypeId));
Assert.That(rows[1].Total, Is.EqualTo(2));
//And finally lets quickly clean up the mess we've made:
db.DeleteAll <Shipper>();
db.DeleteAll <ShipperType>();
Assert.That(db.Select <Shipper>(), Has.Count.EqualTo(0));
Assert.That(db.Select <ShipperType>(), Has.Count.EqualTo(0));
}
}
public void TearDwon()
{
using (var db = new OrmLiteConnectionFactory(ConnectionString, FirebirdDialect.Provider).Open())
{
db.DropTable<TypeWithOnDeleteAndUpdateCascade>();
db.DropTable<TypeWithOnDeleteSetNull>();
db.DropTable<TypeWithOnDeleteSetDefault>();
db.DropTable<TypeWithOnDeleteRestrict>();
db.DropTable<TypeWithOnDeleteNoAction>();
db.DropTable<TypeWithOnDeleteCascade>();
db.DropTable<TypeWithSimpleForeignKey>();
db.DropTable<ReferencedType>();
}
}
