sqlite3

type Driver struct {
	DataSource string
}

type SQLiteCheck struct {
	Name   string `parser:"@Ident"`
	Values []int  `parser:"'IN' '(' @Number ',' @Number ')'"`
}

type SQLiteConstraint struct {
	Name            string `parser:"@Ident"`
	Key             string `parser:"('FOREIGN' | 'PRIMARY') 'KEY' '(' @Ident ')'"`
	ReferencedTable string `parser:"('REFERENCES' @Ident)?"`
	ReferencedField string `parser:"('(' @Ident ')')?"`
}

type SQLiteCreateTable struct {
	TableName        string                   `parser:"'CREATE' 'TABLE' ( 'IF' 'NOT' 'EXISTS' )? @Ident"`
	FieldExpressions []*SQLiteFieldExpression `parser:"'(' @@ ( ',' @@ )* ( ',' )?"`
	PrimaryKeys      []string                 `parser:"( 'PRIMARY' 'KEY' '(' @Ident ( ',' @Ident )* ')' ( ',' )? )?"`
	ForeignKeys      []*SQLiteForeignKey      `parser:"( 'FOREIGN' 'KEY' @@ ( ',' 'FOREIGN' 'KEY' @@ )* ( ',' )? )?"`
	Constraints      []*SQLiteConstraint      `parser:"( 'CONSTRAINT' @@ ( ',' 'CONSTRAINT' @@ )* ( ',' )? )?"`
	Checks           []*SQLiteCheck           `parser:"( 'CHECK' '(' @@ ')' ( ',' 'CHECK' '(' @@ ')' )* )? ')'"`
}

type SQLiteFieldExpression struct {
	Name          string `parser:"@Ident"`
	Type          string `parser:"@Ident"`
	Limit         string `parser:"( '(' Number ')' )?"`
	NotNull       bool   `parser:"( @'NOT' 'NULL' | @'NOT_NULL'"`
	Default       string `parser:"| 'DEFAULT' '(' @Ident ')'"`
	AutoIncrement bool   `parser:"| @'AUTO_INCREMENT' )*"`
}

type SQLiteForeignKey struct {
	ForeignKey      string `parser:"'(' @Ident ')'"`
	ReferencedTable string `parser:"'REFERENCES' @Ident"`
	ReferencedField string `parser:"'(' @Ident ')'"`
}

type SQLiteTable struct {
	// contains filtered or unexported fields
}