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"); }