public void SqlServer_QueryCompiler_Compile_AddColumnMissingNUllableTest()
{
var part = new ValueCollectionQueryPart(OperationType.AddColumn);
part.AddValue(KeyValuePart.MemberName, "ColumnName");
part.AddValue(KeyValuePart.MemberType, "int");
var parts = new QueryPartsContainer();
parts.Add(part);
var compiler = new QueryCompiler();
var query = compiler.Compile(parts, new InterceptorCollection());
Assert.AreEqual(query.QueryString, "ADD ColumnName int");
}
public void SqliteQueryCompilerCompileAddColumnNullableTest()
{
var part = new ValueCollectionQueryPart(OperationType.AddColumn);
part.AddValue(KeyValuePart.MemberName, "ColumnName");
part.AddValue(KeyValuePart.MemberType, "int");
part.AddValue(KeyValuePart.Nullable, true.ToString());
var parts = new QueryPartsContainer();
parts.Add(part);
var compiler = new QueryCompiler();
var query = compiler.Compile(parts, new InterceptorCollection());
Assert.AreEqual(query.QueryString, "ADD COLUMN ColumnName int");
}
public void QueryCompilerCompileUpdateValueWithValueCollectionTest()
{
var part = new ValueCollectionQueryPart(OperationType.UpdateValue);
part.AddValue(KeyValuePart.MemberName, "Member");
part.AddValue(KeyValuePart.Value, "Value");
var parts = new QueryPartsContainer();
parts.Add(part);
var compiler = new QueryCompiler();
var query = compiler.Compile(parts, new InterceptorCollection());
Assert.AreEqual(query.QueryString, "Member = Value");
}
public void SqlServer_QueryCompiler_Compile_ColumnMultipleTest()
{
var part = new QueryPart(OperationType.None);
var part1 = new ValueCollectionQueryPart(OperationType.Column);
part1.AddValue(KeyValuePart.MemberName, "ColumnName1");
part1.AddValue(KeyValuePart.MemberType, "int");
part1.AddValue(KeyValuePart.Nullable, false.ToString());
part.Add(part1);
var part2 = new ValueCollectionQueryPart(OperationType.Column);
part2.AddValue(KeyValuePart.MemberName, "ColumnName2");
part2.AddValue(KeyValuePart.MemberType, "VARCHAR(20)");
part2.AddValue(KeyValuePart.Nullable, true.ToString());
part.Add(part2);
var parts = new QueryPartsContainer();
parts.Add(part);
var compiler = new QueryCompiler();
var query = compiler.Compile(parts, new InterceptorCollection());
Assert.AreEqual(query.QueryString, "ColumnName1 int NOT NULL, ColumnName2 VARCHAR(20)");
}
public void SqlServer_QueryCompiler_Compile_ForeignKeyTest()
{
var part = new ValueCollectionQueryPart(OperationType.ForeignKey);
part.AddValue(KeyValuePart.MemberName, "ColumnName");
part.AddValue(KeyValuePart.ReferenceTable, "RefTable");
part.AddValue(KeyValuePart.ReferenceMember, "RefColumn");
var parts = new QueryPartsContainer();
parts.Add(part);
var compiler = new QueryCompiler();
var query = compiler.Compile(parts, new InterceptorCollection());
Assert.AreEqual(query.QueryString, "FOREIGN KEY(ColumnName) REFERENCES RefTable(RefColumn)");
}
public void SqlServer_QueryCompiler_Compile_ColumnWithNullableFalseTest()
{
var part = new ValueCollectionQueryPart(OperationType.Column);
part.AddValue(KeyValuePart.MemberName, "ColumnName");
part.AddValue(KeyValuePart.MemberType, "int");
part.AddValue(KeyValuePart.Nullable, false.ToString());
var parts = new QueryPartsContainer();
parts.Add(part);
var compiler = new QueryCompiler();
var query = compiler.Compile(parts, new InterceptorCollection());
Assert.AreEqual(query.QueryString, "ColumnName int NOT NULL");
}
public void SqliteQueryCompilerCompileRenameTableTest()
{
var part = new ValueCollectionQueryPart(OperationType.RenameTable);
part.AddValue(KeyValuePart.Key, "OriginalTable");
part.AddValue(KeyValuePart.Value, "NewTable");
var parts = new QueryPartsContainer();
parts.Add(part);
var compiler = new QueryCompiler();
var query = compiler.Compile(parts, new InterceptorCollection());
Assert.AreEqual(query.QueryString, "ALTER TABLE OriginalTable RENAME TO NewTable");
}
