public void CanGetProperTextBetweenBrackets()
{
var text1 = @"CREATE INDEX [IDX_USERS_LastLogin] ON [Users]([LastLogin] DESC)";
var result1 = SqliteSchemaDumper.GetTextBeteenBrackets(text1);
Assert.AreEqual(result1, "[LastLogin] DESC");
}
public void CanGenerateColumnDefinitionsFromTableDDL()
{
List <ColumnDefinition> schema = SqliteSchemaDumper.GetColumnDefinitionsForTableDDL(CreateTableSql);
Assert.IsNotNull(schema, "ColumnDefinition can't be null");
Assert.IsNotEmpty(schema, "ColumnDefinition must have elements");
Assert.AreEqual(schema.Count, 9, "Schema must have 9 columns");
}
public void Setup()
{
Connection = new SQLiteConnection(IntegrationTestOptions.SqlLite.ConnectionString);
Processor = new SqliteProcessor(Connection, new SqliteGenerator(), new TextWriterAnnouncer(System.Console.Out),
new ProcessorOptions(), new SqliteDbFactory());
SchemaDumper = new SqliteSchemaDumper(Processor, new TextWriterAnnouncer(System.Console.Out));
Connection.Open();
}
public void CanGetIndexeColumnsFromIndexDDLSimple()
{
//var indexDDL1 = @"CREATE INDEX [IDX_USERS_LastLogin] ON [Users]([LastLogin] DESC)";
var indexDDL1 = @"[LastLogin] DESC";
var columns11 = SqliteSchemaDumper.GetIndexColumnsFromIndexDDL(indexDDL1);
Assert.IsNotEmpty(columns11);
columns11.Count.ShouldBe(1);
var index1 = columns11.First();
index1.Name.ShouldBe("LastLogin");
index1.Direction.ShouldBe(Direction.Descending);
}
public void CanGetIndexeColumnsFromIndexDDLComplex()
{
var indexDDL1 = @"[FirstName] ASC,[LastName] DESC";
var columns11 = SqliteSchemaDumper.GetIndexColumnsFromIndexDDL(indexDDL1);
Assert.IsNotEmpty(columns11);
Assert.AreEqual(columns11.Count, 2, "Should have 2 index column!");
var index1 = columns11.First();
Assert.AreEqual(index1.Name, "FirstName");
Assert.AreEqual(index1.Direction, Direction.Ascending);
var index2 = columns11.Last();
Assert.AreEqual(index2.Name, "LastName");
Assert.AreEqual(index2.Direction, Direction.Descending);
}
public void CanGetTableDdlByName()
{
var tableName = "Author";
using (var conn = Processor.Connection)
{
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = CreateTableSql;
cmd.ExecuteNonQuery();
}
var schema = new SqliteSchemaDumper(Processor, new TextWriterAnnouncer(System.Console.Out));
var tableDDL = schema.GetTableDDL(tableName);
Assert.IsFalse(string.IsNullOrEmpty(tableDDL));
Assert.IsTrue(SqliteSchemaDumper.HasValidSimpleTableDDL(ref tableDDL));
}
}
public void Setup()
{
Subject = new SqliteSchemaDumper(null, null);
}
