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