dbmap

type Column struct {
	TableName       string
	TableSchema     string
	ColumnName      string
	OrdinalPosition int
	DataType        string
	UdtName         string
	ColumnDefault   string
	IsNullable      bool
	IsSequence      bool
	IsPrimaryKey    bool
}

type Config struct {
	Database struct {
		Provider string `yaml:"provider"`
		Host     string `yaml:"host"`
		Port     string `yaml:"port"`
		Database string `yaml:"database"`
		Username string `yaml:"user"`
		Password string `yaml:"password"`
	} `yaml:"database"`
	Output struct {
		Path   string `yaml:"path"`
		Suffix string `yaml:"suffix"`
		Lang   string `yaml:"lang"`
	} `yaml:"output"`
	EmbedRelationships bool `yaml:"embed_relationships"`
	Proto              struct {
		Path        string `yaml:"path"`
		JavaPackage string `yaml:"java_package"`
		ObjCPrefix  string `yaml:"objc_prefix"`
		Version     string `yaml:"version"`
	} `yaml:"proto"`
	Generator struct {
		Schemas         []string `yaml:"schemas"`
		ExcludedTables  []string `yaml:"excluded_tables"`
		IndexedLookups  bool     `yaml:"indexed_lookups"`
		ExcludedColumns []struct {
			Tablename string   `yaml:"table"`
			Columns   []string `yaml:"columns"`
		} `yaml:"excluded_columns"`
		Mapping []struct {
			Tablename string `yaml:"table"`
			Queries   []struct {
				Name  string `yaml:"name"`
				Query string `yaml:"query"`
			} `yaml:"queries"`
		} `yaml:"mapping"`
		Transforms []struct {
			Tablename string `yaml:"table"`
			Xforms    struct {
				Select []struct {
					Columnname string `yaml:"column"`
					Datatype   string `yaml:"data_type"`
					Xform      string `yaml:"xform"`
				} `yaml:"select"`
				Insert []struct {
					Columnname string `yaml:"column"`
					Datatype   string `yaml:"data_type"`
					Xform      string `yaml:"xform"`
				}
				Update []struct {
					Columnname string `yaml:"column"`
					Datatype   string `yaml:"data_type"`
					Xform      string `yaml:"xform"`
				}
			} `yaml:"xforms"`
		} `yaml:"transforms"`
	} `yaml:"generator"`
}

type Database struct {
	DB      *sql.DB
	Schemas []Schema
}

type ForeignColumns struct {
	ForeignColumn   string
	LocalColumn     string
	OrdinalPosition int32
}

type ForeignRelation struct {
	ForeignSchema string
	ForeignTable  string
	MapName       string
	Columns       []ForeignColumns
	RelationType  RelationType
}

type Index struct {
	TableSchema string
	TableName   string
	IndexName   string
	IndexType   IndexType
	Columns     []string
}

type IndexType int

type Provider interface {
	ReadDatabase() *Database
}

type RelationType int

type Schema struct {
	SchemaName string
	Tables     []Table
}

type Table struct {
	TableName   string
	TableSchema string
	Columns     []Column
	Indexes     []Index
	Relations   []ForeignRelation
}