models

type O2TConfigModel struct {
	Id                   int       `json:"id" gorm:"type:int;autoIncrement,primaryKey"`
	TableSchemaTidb      string    `json:"table_schema_tidb" gorm:"type:varchar(64);uniqueIndex:uk_tab,priority:1;not null"`
	TableNameTidb        string    `json:"table_name_tidb" gorm:"type:varchar(64);uniqueIndex:uk_tab,priority:2;not null"`
	TableSchemaOracle    string    `json:"table_schema_oracle" gorm:"type:varchar(64)"`
	DumpStatus           string    `json:"dump_status" gorm:"type:varchar(20);not null"`
	DumpDuration         int       `json:"dump_duration" gorm:"type:int"`
	DumpFilterClauseOra  string    `json:"dump_filter_clause_ora" gorm:"type:varchar(128)"`
	LastDumpTime         time.Time `json:"last_dump_time" gorm:"type:datetime;default:'1999-01-01 00:00:00'"`
	GenerateConfStatus   string    `json:"generate_conf_status" gorm:"type:varchar(20);not null"`
	GenerateDuration     int       `json:"generate_conf_duration" gorm:"type:int"`
	LastGenerateConfTime time.Time `json:"last_generate_conf_time" gorm:"type:datetime;default:'1999-01-01 00:00:00'"`
	LoadStatus           string    `json:"load_status" gorm:"type:varchar(20);not null"`
	LoadDuration         int       `json:"load_duration" gorm:"type:int"`
	LastLoadTime         time.Time `json:"last_load_time" gorm:"type:datetime;default:'1999-01-01 00:00:00'"`
	OracleRowsCount      int       `json:"oracle_rows_count" gorm:"type:int;default:-1"`
	TidbRowsCount        int       `json:"tidb_rows_count" gorm:"type:int;default:-1"`
	DumpExtraCols        string    `json:"dump_extra_cols" gorm:"type:varchar(500)"`
}

type SyncdiffConfigModel struct {
	Id                int       `json:"id" gorm:"type:int;autoIncrement,primaryKey"`
	TableSchema       string    `json:"table_schema" gorm:"type:varchar(64);uniqueIndex:uk_tab,priority:1;not null"`
	TableNameTidb     string    `json:"table_name" gorm:"column:table_name;type:varchar(64);uniqueIndex:uk_tab,priority:2;not null"`
	TableSchemaOracle string    `json:"table_schema_oracle" gorm:"type:varchar(64)"`
	Batchid           string    `json:"batchid" gorm:"type:varchar(128)"`
	TableCount        int       `json:"table_count" gorm:"type:int"`
	SyncStatus        string    `json:"sync_status" gorm:"type:varchar(32)"`
	SyncStarttime     time.Time `json:"sync_starttime" gorm:"type:datetime;default:'1999-01-01 00:00:00'"`
	SyncEndtime       time.Time `json:"sync_endtime" gorm:"type:datetime;default:'1999-01-01 00:00:00'"`
	SyncDuration      int       `json:"sync_duration" gorm:"type:int"`
	SyncMessages      string    `json:"sync_messages" gorm:"type:varchar(1000)"`
	JobStarttime      time.Time `json:"job_starttime" gorm:"type:datetime;default:'1999-01-01 00:00:00'"`
	ChunkNum          int       `json:"chunk_num" gorm:"type:int"`
	CheckSuccessNum   int       `json:"check_success_num" gorm:"type:int"`
	CheckFailedNum    int       `json:"check_failed_num" gorm:"type:int"`
	CheckIgnoreNum    int       `json:"check_ignore_num" gorm:"type:int"`
	State             string    `json:"state" gorm:"type:varchar(32)"`
	ConfigHash        string    `gorm:"config_hash;type:varchar(50)" json:"config_hash"`
	UpdateTime        time.Time `gorm:"update_time;type:datetime;default:'1999-01-01 00:00:00'" json:"update_time"`
	IgnoreColumns     string    `gorm:"ignore_columns;type:varchar(128)" json:"ignore_columns"`
	FilterClauseTidb  string    `gorm:"filter_clause_tidb;type:varchar(500)" json:"filter_clause_tidb"`
	FilterClauseOra   string    `gorm:"filter_clause_ora;type:varchar(500)" json:"filter_clause_ora"`
	OracleHint        string    `gorm:"oracle_hint;type:varchar(500)" json:"oracle_hint"`
	TidbHint          string    `gorm:"tidb_hint;type:varchar(500)" json:"tidb_hint"`
	IndexFields       string    `gorm:"index_fields;type:varchar(128)" json:"index_fields"`
	ChunkSize         int       `gorm:"chunk_size;type:int;default:1000" json:"chunk_size"`
	CheckThreadCount  int       `gorm:"check_thread_count;type:int;default:10" json:"check_thread_count"`
	UseSnapshot       string    `gorm:"use_snapshot;type:varchar(10)" json:"use_snapshot"`
	SnapshotSource    string    `gorm:"snapshot_source;type:varchar(100)" json:"snapshot_source"`
	SnapshotTarget    string    `gorm:"snapshot_target;type:varchar(100)" json:"snapshot_target"`
	UseTso            string    `gorm:"use_tso;type:varchar(10)" json:"use_tso"`
	TsoInfo           string    `gorm:"tso_info;type:varchar(100)" json:"tso_info"`
	SourceInfo        string    `gorm:"source_info;type:varchar(256)" json:"source_info"`
	TargetInfo        string    `gorm:"target_info;type:varchar(256)" json:"target_info"`
	ContainDatatypes  string    `gorm:"contain_datatypes;type:varchar(256)" json:"contain_datatypes"`
	TableLabel        string    `gorm:"table_label;type:varchar(128)" json:"table_label"`
	Remark            string    `gorm:"remark;type:varchar(128)" json:"remark"`
}

type T2OConfigModel struct {
	Id                  int       `json:"id" gorm:"type:int;autoIncrement,primaryKey"`
	TableSchemaTidb     string    `json:"table_schema_tidb" gorm:"type:varchar(64);uniqueIndex:uk_tab,priority:1;not null"`
	TableNameTidb       string    `json:"table_name_tidb" gorm:"type:varchar(64);uniqueIndex:uk_tab,priority:2;not null"`
	TableSchemaOracle   string    `json:"table_schema_oracle" gorm:"type:varchar(64)"`
	DumpStatus          string    `json:"dump_status" gorm:"type:varchar(20);not null"`
	DumpDuration        int       `json:"dump_duration" gorm:"type:int"`
	LastDumpTime        time.Time `json:"last_dump_time" gorm:"type:datetime;default:'1999-01-01 00:00:00'"`
	GenerateCtlStatus   string    `json:"generate_ctl_status" gorm:"type:varchar(20);not null"`
	GenerateCtlDuration int       `json:"generate_ctl_duration" gorm:"type:int"`
	LastGenerateCtlTime time.Time `json:"last_generate_ctl_time" gorm:"type:datetime;default:'1999-01-01 00:00:00'"`
	LoadStatus          string    `json:"load_status" gorm:"type:varchar(20);not null"`
	LoadDuration        int       `json:"load_duration" gorm:"type:int"`
	LastLoadTime        time.Time `json:"last_load_time" gorm:"type:datetime;default:'1999-01-01 00:00:00'"`
	OracleRowsCount     int       `json:"oracle_rows_count" gorm:"type:int;default:-1"`
	TidbRowsCount       int       `json:"tidb_rows_count" gorm:"type:int;default:-1"`
}