public SQLiteTestTable(SQLiteProcessor processor, string schemaName, params string[] columnDefinitions)
{
_schemaName = schemaName;
Connection = ( IDbConnection )processor.Connection;
Transaction = ( IDbTransaction )processor.Transaction;
Name = "Table" + Guid.NewGuid().ToString("N");
Create(columnDefinitions);
}
public void CallingProcessWithPerformDBOperationExpressionWhenInPreviewOnlyModeWillNotMakeDbChanges()
{
var output = new StringWriter();
var connection = new SQLiteConnection(IntegrationTestOptions.SqlLite.ConnectionString);
var processor = new SQLiteProcessor(
connection,
new SQLiteGenerator(),
new TextWriterAnnouncer(output),
new ProcessorOptions {
PreviewOnly = true
},
new SQLiteDbFactory());
bool tableExists;
try
{
var expression =
new PerformDBOperationExpression
{
Operation = (con, trans) =>
{
var command = con.CreateCommand();
command.CommandText = "CREATE TABLE ProcessTestTable (test int NULL) ";
command.Transaction = trans;
command.ExecuteNonQuery();
}
};
processor.Process(expression);
tableExists = processor.TableExists("", "ProcessTestTable");
}
finally
{
processor.RollbackTransaction();
}
tableExists.ShouldBeFalse();
Assert.That(output.ToString(), Is.StringContaining(@"/* Performing DB Operation */"));
}
protected static void ExecuteWithSqlite(Action <IMigrationProcessor> test, IntegrationTestOptions.DatabaseServerOptions serverOptions)
{
if (!serverOptions.IsEnabled)
{
return;
}
var announcer = new TextWriterAnnouncer(System.Console.Out);
announcer.Heading("Testing Migration against SQLite");
var factory = new SQLiteDbFactory();
using (var connection = factory.CreateConnection(serverOptions.ConnectionString))
{
var processor = new SQLiteProcessor(connection, new SQLiteGenerator(), announcer, new ProcessorOptions(), factory);
test(processor);
}
}
public void SetUp()
{
// This connection used in the tests
_dbFactory = new SQLiteDbFactory();
_connection = _dbFactory.CreateConnection(IntegrationTestOptions.SqlLite.ConnectionString);
_connection.Open();
_command = _connection.CreateCommand();
// SUT
_processor = new SQLiteProcessor(_connection, new SQLiteGenerator(), new TextWriterAnnouncer(TestContext.Out), new ProcessorOptions(), _dbFactory);
column = new Mock <ColumnDefinition>();
tableName = "NewTable";
tableNameThanMustBeEscaped = "123NewTable";
columnName = "ColumnName";
column.SetupGet(c => c.Name).Returns(columnName);
column.SetupGet(c => c.IsNullable).Returns(true);
column.SetupGet(c => c.Type).Returns(DbType.Int32);
}
public void SetUp()
{
// This connection used in the tests
var factory = new SQLiteDbFactory();
_connection = factory.CreateConnection("Data Source=:memory:;Version=3;New=True;");
_connection.Open();
_command = _connection.CreateCommand();
// SUT
_processor = new SQLiteProcessor(_connection, new SQLiteGenerator(), new TextWriterAnnouncer(System.Console.Out), new ProcessorOptions(), factory);
column = new Mock <ColumnDefinition>();
tableName = "NewTable";
tableNameThanMustBeEscaped = "123NewTable";
columnName = "ColumnName";
column.SetupGet(c => c.Name).Returns(columnName);
column.SetupGet(c => c.IsNullable).Returns(true);
column.SetupGet(c => c.Type).Returns(DbType.Int32);
}
public SqliteSchemaDumper(SQLiteProcessor processor, IAnnouncer announcer)
{
Announcer = announcer;
Processor = processor;
}
public void SetUp()
{
ServiceScope = ServiceProvider.CreateScope();
Processor = ServiceScope.ServiceProvider.GetRequiredService <SQLiteProcessor>();
}
public SqliteSchemaDumper(SQLiteProcessor processor)
{
Processor = processor;
}
