parser

type Command struct {
	Database       *Database    `"DATABASE" @@`
	Roles          *Roles       `| "ROLES" @@`
	Extensions     *Extensions  `| "EXTENSIONS" @@`
	Schemas        *Schemas     `| "SCHEMAS" @@`
	ForeignKeys    *ForeignKeys `| ("FOREIGN" "KEYS") @@`
	Schema         *Name        `| "SCHEMA" @@`
	TablesInSchema *Name        `| "TABLES" "IN" @@`
	ViewsInSchema  *Name        `| "VIEWS" "IN" @@`
	Table          *SchemaItem  `| "TABLE" @@`
	View           *SchemaItem  `| "VIEW" @@`
	Indexes        *SchemaItem  `| "INDEXES" "ON" @@`
	Constraints    *SchemaItem  `| "CONSTRAINTS" "ON" @@`
}

type DDSL struct {
	Create  *Command     `"CREATE" @@`
	Drop    *Command     `| "DROP" @@`
	Migrate *Migrate     `| "MIGRATE" @@`
	Sql     *string      `| "SQL" @Sql`
	Seed    *SeedCommand `| "SEED" @@`
}

type Database struct {
	Ref *Ref `[@@]`
}

type Extensions struct {
	Ref *Ref `[@@]`
}

type ForeignKeys struct {
	Ref *Ref `[@@]`
}

type Migrate struct {
	Top    bool `@"TOP"`
	Bottom bool `| @"BOTTOM"`
	Up     *int `| "UP" @Int`
	Down   *int `| "DOWN" @Int`
}

type Name struct {
	Name string `@Ident`
	Ref  *Ref   `[@@]`
}

type Ref struct {
	Ref string `@Ref`
}

type Roles struct {
	Ref *Ref `[@@]`
}

type SchemaItem struct {
	Item        string `@SchemaItem`
	Ref         *Ref   `[@@]`
	TableOrView string
	Schema      string
}

type Schemas struct {
	Ref *Ref `[@@]`
}

type SeedCommand struct {
	Table          *SchemaItem `"TABLE" @@`
	TablesInSchema *Name       `| "TABLES" "IN" @@`
}