Function TestCreateTableSqlBuilder_ToSQL

db/create_test.go:134–146

(t *testing.T)

}

func TestCreateTableSqlBuilder_ToSQL(t *testing.T) {
	sql, err := DialectMySQL.
		Table("foo").
		SetIfNotExists(true).
		Column(DialectMySQL.Column("bar", ColumnTypeInteger, UnsetSize).SetPrimaryKey(true)).
		Column(DialectMySQL.Column("baz", ColumnTypeText, UnsetSize)).
		Column(DialectMySQL.Column("qux", ColumnTypeDateTime, UnsetSize).SetDefault("NOW()")).
		UniqueConstraint("bar").
		UniqueConstraint("bar", "baz").
		ToSQL()
	assert.NoError(t, err)
	assert.Equal(t, "CREATE TABLE IF NOT EXISTS foo ( bar INT NOT NULL PRIMARY KEY, baz TEXT NOT NULL, qux DATETIME NOT NULL DEFAULT NOW(), UNIQUE(bar), UNIQUE(bar,baz) )", sql)
}