public void Delete1()
{
var statement = Sql.Delete.Top(1).From(Sql.Name("foo.bar"));
var text = Provider.GenerateStatement(statement);
Assert.IsNotNull(text);
Assert.AreEqual("DELETE FROM \"foo\".\"bar\" LIMIT 1;", text);
}
public IStatement BeginCommitTransactions()
{
var statement = Sql.Statements(Sql.BeginTransaction(), Sql.CommitTransaction());
var text = Provider.GenerateStatement(statement);
Assert.IsNotNull(text);
Assert.AreEqual("BEGIN TRANSACTION;\r\nCOMMIT TRANSACTION;", text);
return(statement);
}
public static void AreEqual(IStatement statement, string script)
{
var text = Provider.GenerateStatement(statement);
Assert.NotNull(text);
Assert.Equal(script, text);
}
public void UpdateDefault()
{
var statement =
Sql.Update("foo.bar").Set(Sql.Name("a"), Sql.Scalar(1)).Where(Sql.Name("z").IsEqual(Sql.Scalar("b")));
var text = Provider.GenerateStatement(statement);
Assert.IsNotNull(text);
Assert.AreEqual("UPDATE \"foo\".\"bar\" SET \"a\" = 1 WHERE \"z\" = 'b';", text);
}
public IStatement CreateTable()
{
var statement = Sql.CreateTable(Sql.Name("tbl"), false)
.Columns(
TableColumn.Int("C1").NotNull().PrimaryKey().AutoIncrement()
, TableColumn.NVarChar("C2").Null().Default("foo"))
;
var text = Provider.GenerateStatement(statement);
Assert.IsNotNull(text);
Assert.AreEqual(
"CREATE TABLE \"tbl\" ( \"C1\" INTEGER PRIMARY KEY ASC AUTOINCREMENT NOT NULL, \"C2\" NVARCHAR NULL DEFAULT ( 'foo' ) );",
text);
return(statement);
}
public void InsertDefault()
{
var statement = Sql.Insert.Into(Sql.Name("foo.bar")).DefaultValues();
var text = Provider.GenerateStatement(statement);
Assert.IsNotNull(text);
Assert.AreEqual("INSERT INTO \"foo\".\"bar\" DEFAULT VALUES;", text);
}
public IStatement Select1()
{
var statement = Sql.Select.Output(Sql.Scalar(1));
var text = Provider.GenerateStatement(statement);
Assert.NotNull(text);
Assert.Equal("SELECT 1;", text);
return(statement);
}