public void CanReplaceNullReplacementsWithNulls() { InsertQueryMaker queryMaker = new InsertQueryMaker(new ValueRenderer(new[] { "n/a" })); Record record = Utils.GetTable(name: "N/A").Records[0]; string query = queryMaker.GenerateQuery(record); query.Should().Be("INSERT INTO EMPLOYEES (ID, NAME) VALUES (1, NULL);\n"); }
public void CanMakeQuery() { InsertQueryMaker queryMaker = new InsertQueryMaker(new ValueRenderer(new string[] { })); Record record = Utils.GetTable().Records[0]; string query = queryMaker.GenerateQuery(record); query.Should().Be("INSERT INTO EMPLOYEES (ID, NAME) VALUES (1, 'bilal');\n"); }
public void CanReplaceSingleQuoteWithDoubleQuote() { InsertQueryMaker queryMaker = new InsertQueryMaker(new ValueRenderer(new string[] { })); Record record = Utils.GetTable(name: "sky's blue").Records[0]; string query = queryMaker.GenerateQuery(record); query.Should().Be("INSERT INTO EMPLOYEES (ID, NAME) VALUES (1, 'sky''s blue');\n"); }
public void CanMakeQuery() { OracleMergeQueryMaker queryMaker = new OracleMergeQueryMaker(new ValueRenderer(new string[] { })); Record record = Utils.GetTable().Records[0]; string query = queryMaker.GenerateQuery(record); query.Should().Be(@"MERGE INTO EMPLOYEES T USING (SELECT 1 ID, 'bilal' NAME FROM DUAL) D ON (T.ID = D.ID) WHEN MATCHED THEN UPDATE SET T.NAME = D.NAME WHEN NOT MATCHED THEN INSERT (ID, NAME) VALUES (D.ID, D.NAME); "); }