config

type Config struct {
	// distributed transaction support
	DistributedTransaction bool `yaml:"distributed_transaction"`
	// map table name and configuration
	Tables map[string]*TableConfig `yaml:"tables"`
	// if true skip auto create database
	SkipAutoSetup bool `yaml:"skip_auto_setup"`
}

type DatabaseConfig struct {
	// database name of MySQL or database file path of SQLite
	NameOrPath string `yaml:"database"`

	// adapter name ( 'mysql' or 'sqlite3' )
	Adapter string `yaml:"adapter"`

	// database encoding like utf8mb4
	Encoding string `yaml:"encoding"`

	// login user name to database server
	Username string `yaml:"username"`

	// login password to database server
	Password string `yaml:"password"`

	// master server's dsn list ( currently support single master only )
	Masters []string `yaml:"master"`

	// slave server's dsn list ( currently not support )
	Slaves []string `yaml:"slave"`

	// backup server's dsn list ( currently not support )
	Backups []string `yaml:"backup"`
}

type TableConfig struct {
	DatabaseConfig `yaml:",inline"`

	// enable sharding in this table
	IsShard bool `yaml:"shard"`

	// unique id's column for all shards. id is published by sequencer
	ShardColumnName string `yaml:"shard_column"`

	// column name for deciding sharding target
	// this column's value is passed to sharding algorithm
	// if not specified, shard_column value is used as shard_key
	ShardKeyColumnName string `yaml:"shard_key"`

	// sharding algorithm ( default: modulo )
	Algorithm string `yaml:"algorithm"`

	// support unique id in between all shards
	Sequencer *DatabaseConfig `yaml:"sequencer"`

	// shard configurations
	Shards []map[string]*DatabaseConfig `yaml:"shards"`
}