public override void CallingConstraintExistsCanAcceptTableNameWithSingleQuote()
{
using (var table = new SqlServerCeTestTable("Test'Table", Processor, "id int"))
{
table.WithUniqueConstraintOn("id");
Processor.ConstraintExists("NOTUSED", table.Name, "UC_id").ShouldBeTrue();
}
}
public void CallingConstraintExistsReturnsFalseIfConstraintDoesNotExist()
{
using (var table = new SqlServerCeTestTable(Processor, "id int"))
{
table.WithUniqueConstraintOn("id");
Processor.ConstraintExists(null, table.Name, "DoesNotExist").ShouldBeFalse();
}
}
public override void CallingIndexExistsReturnsFalseIfIndexDoesNotExistWithSchema()
{
using (var table = new SqlServerCeTestTable(Processor, "id int"))
{
table.WithIndexOn("id");
Processor.IndexExists("NOTUSED", table.Name, "DoesNotExist").ShouldBeFalse();
}
}
public override void CallingIndexExistsCanAcceptIndexNameWithSingleQuote()
{
using (var table = new SqlServerCeTestTable(Processor, "id int"))
{
table.WithIndexOn("id", "UI'id");
Processor.IndexExists("NOTUSED", table.Name, "UI'id").ShouldBeTrue();
}
}
public override void CallingColumnExistsReturnsTrueIfColumnExistsWithSchema()
{
using (var table = new SqlServerCeTestTable(Processor, Quoter.QuoteColumnName("id") + " int"))
Processor.ColumnExists("NOTUSED", table.Name, "id").ShouldBeTrue();
}
public override void CallingColumnExistsReturnsFalseIfColumnDoesNotExistWithSchema()
{
using (var table = new SqlServerCeTestTable(Processor, "id int"))
Processor.ColumnExists("NOTUSED", table.Name, "DoesNotExist").ShouldBeFalse();
}
public override void CallingColumnExistsCanAcceptTableNameWithSingleQuote()
{
using (var table = new SqlServerCeTestTable("Test'Table", Processor, Quoter.QuoteColumnName("id") + " int"))
Processor.ColumnExists("NOTUSED", table.Name, "id").ShouldBeTrue();
}
public override void CallingTableExistsReturnsTrueIfTableExistsWithSchema()
{
using (var table = new SqlServerCeTestTable(Processor, "id int"))
Processor.TableExists("NOTUSED", table.Name).ShouldBeTrue();
}
public override void CallingTableExistsCanAcceptTableNameWithSingleQuote()
{
using (var table = new SqlServerCeTestTable("Test'Table", Processor, "id int"))
Processor.TableExists("NOTUSED", table.Name).ShouldBeTrue();
}
public void CallingColumnExistsReturnsTrueIfColumnExists()
{
using (var table = new SqlServerCeTestTable(Processor, "\"id\" int"))
Processor.ColumnExists(null, table.Name, "id").ShouldBeTrue();
}
public void CallingColumnExistsReturnsFalseIfColumnDoesNotExist()
{
using (var table = new SqlServerCeTestTable(Processor, "id int"))
Processor.ColumnExists(null, table.Name, "DoesNotExist").ShouldBeFalse();
}
public void CallingTableExistsReturnsTrueIfTableExists()
{
using (var table = new SqlServerCeTestTable(Processor, "id int"))
Processor.TableExists(null, table.Name).ShouldBeTrue();
}
public void CallingIndexExistsReturnsTrueIfIndexExistWithSchema()
{
using (var table = new SqlServerCeTestTable(Processor, "id int"))
{
table.WithIndexOn("id");
Processor.IndexExists("NOTUSED", table.Name, "UI_id").ShouldBeTrue();
}
}
public void CallingIndexExistsReturnsFalseIfIndexDoesNotExist()
{
using (var table = new SqlServerCeTestTable(Processor, "id int"))
{
table.WithIndexOn("id");
Processor.IndexExists(null, table.Name, "DoesNotExist").ShouldBeFalse();
}
}
public void CallingConstraintExistsReturnsTrueIfConstraintExistWithSchema()
{
using (var table = new SqlServerCeTestTable(Processor, "id int"))
{
table.WithUniqueConstraintOn("id");
Processor.ConstraintExists("NOTUSED", table.Name, "UC_id").ShouldBeTrue();
}
}
public override void CallingIndexExistsReturnsTrueIfIndexExists()
{
using (var table = new SqlServerCeTestTable(Processor, "id int"))
{
table.WithIndexOn("id");
Processor.IndexExists(null, table.Name, "UI_id").ShouldBeTrue();
}
}
