proxysql

type Conn struct {
	Addr      string
	Port      uint64
	User      string
	Password  string
	Database  string
	Charset   string
	Collation string
	DBI       string
	Retry     uint64
}

type PsStatus struct {
	Active_Transactions          int64 `db:"Active_Transactions" json:"Active_Transactions"`
	Backend_query_time_nsec      int64 `db:"Backend_query_time_nsec" json:"Backend_query_time_nsec"`
	Client_Connections_aborted   int64 `db:"Client_Connections_aborted" json:"Client_Connections_aborted"`
	Client_Connections_connected int64 `db:"Client_Connections_connected" json:"Client_Connections_connected"`
	Client_Connections_created   int64 `db:"Client_Connections_created" json:"Client_Connections_created"`
	Client_Connections_non_idle  int64 `db:"Client_Connections_non_idle" json:"Client_Connections_non_idle"`
	Com_autocommit               int64 `db:"Com_autocommit" json:"Com_autocommit"`
	Com_autocommit_filtered      int64 `db:"Com_autocommit_filtered" json:"Com_autocommit_filtered"`
	Com_commit                   int64 `db:"Com_commit" json:"Com_commit"`
	Com_commit_filtered          int64 `db:"Com_commit_filtered" json:"Com_commit_filtered"`
	Com_rollback                 int64 `db:"Com_rollback" json:"Com_rollback"`
	Com_rollback_filtered        int64 `db:"Com_rollback_filtered" json:"Com_rollback_filtered"`
	Com_stmt_close               int64 `db:"Com_stmt_close" json:"Com_stmt_close"`
	Com_stmt_execute             int64 `db:"Com_stmt_execute" json:"Com_stmt_execute"`
	Com_stmt_prepare             int64 `db:"Com_stmt_prepare" json:"Com_stmt_prepare"`
	ConnPool_get_conn_failure    int64 `db:"ConnPool_get_conn_failure" json:"ConnPool_get_conn_failure"`
	ConnPool_get_conn_immediate  int64 `db:"ConnPool_get_conn_immediate" json:"ConnPool_get_conn_immediate"`
	ConnPool_get_conn_success    int64 `db:"ConnPool_get_conn_success" json:"ConnPool_get_conn_success"`
	ConnPool_memory_bytes        int64 `db:"ConnPool_memory_bytes" json:"ConnPool_memory_bytes"`
	MySQL_Monitor_Workers        int64 `db:"MySQL_Monitor_Workers" json:"MySQL_Monitor_Workers"`
	MySQL_Thread_Workers         int64 `db:"MySQL_Thread_Workers" json:"MySQL_Thread_Workers"`
	ProxySQL_Uptime              int64 `db:"ProxySQL_Uptime" json:"ProxySQL_Uptime"`
	Queries_backends_bytes_recv  int64 `db:"Queries_backends_bytes_recv" json:"Queries_backends_bytes_recv"`
	Queries_backends_bytes_sent  int64 `db:"Queries_backends_bytes_sent" json:"Queries_backends_bytes_sent"`
	Query_Cache_Entries          int64 `db:"Query_Cache_Entries" json:"Query_Cache_Entries"`
	Query_Cache_Memory_bytes     int64 `db:"Query_Cache_Memory_bytes" json:"Query_Cache_Memory_bytes"`
	Query_Cache_Purged           int64 `db:"Query_Cache_Purged" json:"Query_Cache_Purged"`
	Query_Cache_bytes_IN         int64 `db:"Query_Cache_bytes_IN" json:"Query_Cache_bytes_IN"`
	Query_Cache_bytes_OUT        int64 `db:"Query_Cache_bytes_OUT" json:"Query_Cache_bytes_OUT"`
	Query_Cache_count_GET        int64 `db:"Query_Cache_count_GET" json:"Query_Cache_count_GET"`
	Query_Cache_count_GET_OK     int64 `db:"Query_Cache_count_GET_OK" json:"Query_Cache_count_GET_OK"`
	Query_Cache_count_SET        int64 `db:"Query_Cache_count_SET" json:"Query_Cache_count_SET"`
	Query_Processor_time_nsec    int64 `db:"Query_Processor_time_nsec" json:"Query_Processor_time_nsec"`
	Questions                    int64 `db:"Questions" json:"Questions"`
	SQLite3_memory_bytes         int64 `db:"SQLite3_memory_bytes" json:"SQLite3_memory_bytes"`
	Server_Connections_aborted   int64 `db:"Server_Connections_aborted" json:"Server_Connections_aborted"`
	Server_Connections_connected int64 `db:"Server_Connections_connected" json:"Server_Connections_connected"`
	Server_Connections_created   int64 `db:"Server_Connections_created" json:"Server_Connections_created"`
	Servers_table_version        int64 `db:"Servers_table_version" json:"Servers_table_version"`
	Slow_queries                 int64 `db:"Slow_queries" json:"Slow_queries"`
	Stmt_Active_Total            int64 `db:"Stmt_Active_Total" json:"Stmt_Active_Total"`
	Stmt_Active_Unique           int64 `db:"Stmt_Active_Unique" json:"Stmt_Active_Unique"`
	Stmt_Max_Stmt_id             int64 `db:"Stmt_Max_Stmt_id" json:"Stmt_Max_Stmt_id"`
	Mysql_backend_buffers_bytes  int64 `db:"mysql_backend_buffers_bytes" json:"mysql_backend_buffers_bytes"`
	Mysql_frontend_buffers_bytes int64 `db:"mysql_frontend_buffers_bytes" json:"mysql_frontend_buffers_bytes"`
	Mysql_session_internal_bytes int64 `db:"mysql_session_internal_bytes" json:"mysql_session_internal_bytes"`
}

type QueryRules struct {
	Rule_id               uint64 `db:"rule_id" json:"rule_id"`
	Active                uint64 `db:"active" json:"active"`
	Username              string `db:"username" json:"username"`
	Schemaname            string `db:"schemaname" json:"schemaname"`
	FlagIN                uint64 `db:"flagIN" json:"flagIN"`
	Client_addr           string `db:"client_addr" json:"client_addr"`
	Proxy_addr            string `db:"proxy_addr" json:"proxy_addr"`
	Proxy_port            string `db:"proxy_port" json:"proxy_port"`
	Digest                string `db:"digest" json:"digest"`
	Match_digest          string `db:"match_digest" json:"match_digest"`
	Match_pattern         string `db:"match_pattern" json:"match_pattern"`
	Negate_match_pattern  uint64 `db:"negate_match_pattern" json:"negate_match_pattern"`
	FlagOUT               string `db:"flagOUT" json:"flagOUT"`
	Replace_pattern       string `db:"replace_pattern" json:"replace_pattern"`
	Destination_hostgroup string `db:"destination_hostgroup" json:"destination_hostgroup"`
	Cache_ttl             string `db:"cache_ttl" json:"cache_ttl"`
	Reconnect             string `db:"reconnect" json:"reconnect"`
	Timeout               string `db:"timeout" json:"timeout"`
	Retries               string `db:"retries" json:"retries"`
	Delay                 string `db:"delay" json:"delay"`
	Mirror_flagOUT        string `db:"mirror_flagOUT" json:"mirror_flagOUT"`
	Mirror_hostgroup      string `db:"mirror_hostgroup" json:"mirror_hostgroup"`
	Error_msg             string `db:"error_msg" json:"error_msg"`
	Log                   string `db:"log" json:"log"`
	Apply                 uint64 `db:"apply" json:"apply"`
	Comment               string `db:"comment" json:"comment"`
}

type ReplicationHostgroup struct {
	WriterHostgroup uint64 `json:"writer_hostgroup" db:"writer_hostgroup"`
	ReaderHostgroup uint64 `json:"reader_hostgroup" db:"reader_hostgroup"`
	Comment         string `json:"comment" db:"comment"`
}

type Schedulers struct {
	Id         int64  `json:"id" db:"id"`
	Active     int64  `json:"active" db:"active"`
	IntervalMs int64  `json:"interval_ms" db:"interval_ms"`
	FileName   string `json:"filename" db:"filename"`
	Arg1       string `json:"arg1" db:"arg1"`
	Arg2       string `json:"arg2" db:"arg2"`
	Arg3       string `json:"arg3" db:"arg3"`
	Arg4       string `json:"arg4" db:"arg4"`
	Arg5       string `json:"arg5" db:"arg5"`
	Comment    string `json:"comment" db:"comment"`
}

type Servers struct {
	HostGroupId       uint64 `db:"hostgroup_id,omitempty" json:"hostgroup_id"`
	HostName          string `db:"hostname" json:"hostname"`
	Port              uint64 `db:"port" json:"port"`
	Status            string `db:"status" json:"status"`
	Weight            uint64 `db:"weight" json:"weight"`
	Compression       uint64 `db:"compression" json:"compression"`
	MaxConnections    uint64 `db:"max_connections" json:"max_connections"`
	MaxReplicationLag uint64 `db:"max_replication_lag" json:"max_replication_lag"`
	UseSsl            uint64 `db:"use_ssl" json:"use_ssl"`
	MaxLatencyMs      uint64 `db:"max_latency_ms" json:"max_latency_ms"`
	Comment           string `db:"comment" json:"comment"`
}

type Status struct {
	VariablesName string `db:"Variable_name" json:"Variable_name"`
	Value         int64  `db:"Value" json:"Value"`
}

type Users struct {
	Username              string `db:"username" json:"username"`
	Password              string `db:"password" json:"password"`
	Active                uint64 `db:"active" json:"active"`
	UseSsl                uint64 `db:"use_ssl" json:"use_ssl"`
	DefaultHostgroup      uint64 `db:"default_hostgroup" json:"default_hostgroup"`
	DefaultSchema         string `db:"default_schema" json:"default_schema"`
	SchemaLocked          uint64 `db:"schema_locked" json:"schema_locked"`
	TransactionPersistent uint64 `db:"transaction_persistent" json:"transaction_persistent"`
	FastForward           uint64 `db:"fast_forward" json:"fast_forward"`
	Backend               uint64 `db:"backend" json:"backend"`
	Frontend              uint64 `db:"frontend" json:"frontend"`
	MaxConnections        uint64 `db:"max_connections" json:"max_connections"`
}

type Variables struct {
	VariablesName string `db:"Variable_name" json:"variable_name"`
	Value         string `db:"Value" json:"variable_value"`
}