func (p *postgresql) FizzTranslator() fizz.Translator {
return translators.NewPostgres()
}
package translators_test
import (
"github.com/markbates/pop/fizz"
"github.com/markbates/pop/fizz/translators"
)
var _ fizz.Translator = (*translators.Postgres)(nil)
var pgt = translators.NewPostgres()
func (p *PostgreSQLSuite) Test_Postgres_CreateTable() {
r := p.Require()
ddl := `CREATE TABLE "users" (
"id" SERIAL PRIMARY KEY,
"created_at" timestamp NOT NULL,
"updated_at" timestamp NOT NULL,
"first_name" VARCHAR (255) NOT NULL,
"last_name" VARCHAR (255) NOT NULL,
"email" VARCHAR (20) NOT NULL,
"permissions" jsonb,
"age" integer DEFAULT '40'
);`
res, _ := fizz.AString(`
create_table("users", func(t) {
t.Column("first_name", "string", {})
t.Column("last_name", "string", {})
t.Column("email", "string", {"size":20})
t.Column("permissions", "jsonb", {"null": true})
t.Column("age", "integer", {"null": true, "default": 40})
})