public void CreateCatalog()
{
var connectionString = "Filename=./sqlite.db; Mode=ReadWriteCreate";
var catalog = new Catalog("test_db");
var schema = catalog.AddSchema(_schemaName);
var table = schema.AddTable("Test");
var colPk = table.AddColumn("TestId", DbType.Int64);
colPk.IsPrimaryKey = true;
var colName = table.AddColumn("Name", DbType.String);
colName.MaxLength = 256;
colName.IsNullable = false;
var builder = new SqliteScriptBuilder();
var sql = builder.BuildCreateScript(catalog);
IParameterFactory parameterFactory = new SqliteParameterFactory();
IConnectionFactory connectionFactory = new SqliteConnectionFactory();
using (var connection = connectionFactory.Open(connectionString))
using (var command = new Command(connection, parameterFactory))
{
var affected = command.Execute(sql);
//Assert.IsNotNull(dataSet);
//Assert.AreEqual(1, dataSet.Tables.Count);
//Assert.IsTrue(dataSet.Tables[0].Rows.Count > 0);
}
}
public void Constructor()
{
IParameterFactory parameterFactory = new SqliteParameterFactory();
IConnectionFactory connectionFactory = new SqliteConnectionFactory();
using (var connection = connectionFactory.Open(_connectionString))
using (var command = new Command(connection, parameterFactory))
{
Assert.IsNotNull(command);
}
}
public void ExecuteScalor()
{
IParameterFactory parameterFactory = new SqliteParameterFactory();
IConnectionFactory connectionFactory = new SqliteConnectionFactory();
ISqlStatementBuilder sqlBuilder = new SqliteStatementBuilder(parameterFactory);
using (var connection = connectionFactory.Open(_connectionString))
using (var command = new Command(connection, parameterFactory))
{
var sql = sqlBuilder.GetExistsStatement <Test>();
var exists = command.ExecuteScalar <bool>(sql);
Assert.IsTrue(exists);
sql = sqlBuilder.GetExistsStatement <DoesNotExist>();
exists = command.ExecuteScalar <bool>(sql);
Assert.IsFalse(exists);
}
}
