public void emptyString2nullableDatetime() { schema.Add(new dcp.lib.Formatters.Sql.Column(1, true, "datetime", "colname")); var row = new dcp.lib.Row(); row.Add(" "); Assert.Equal("INSERT INTO [testTable] VALUES (NULL);", formatter.Format(row)); }
public void EscapesStringWithSingleQuote() { schema.Add(new dcp.lib.Formatters.Sql.Column(1, true, "varchar", "colname")); var row = new dcp.lib.Row(); row.Add("tw'o"); Assert.Equal("INSERT INTO [testTable] VALUES ('tw''o');", formatter.Format(row)); }
public void DoesNotQuoteStringTwice() { schema.Add(new dcp.lib.Formatters.Sql.Column(1, true, "varchar", "colname")); var row = new dcp.lib.Row(); row.Add("\"here\""); Assert.Equal("INSERT INTO [testTable] VALUES ('here');", formatter.Format(row)); }
public void whitespaceString2string() { schema.Add(new dcp.lib.Formatters.Sql.Column(1, true, "varchar", "colname")); var row = new dcp.lib.Row(); row.Add(" "); Assert.Equal("INSERT INTO [testTable] VALUES (' ');", formatter.Format(row)); }