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