Function GetSetWaitTimeout

driver/mysql/sql/sqlutils.go:415–428

GetSetWaitTimeout sets session wait_timeout to `WaitTimeout` unless it is larger.

(db QueryAble)

// GetSetWaitTimeout sets session wait_timeout to `WaitTimeout` unless it is larger.
func GetSetWaitTimeout(db QueryAble) (originVal int, err error) {
	row := db.QueryRowContext(context.TODO(), "select @@wait_timeout")
	err = row.Scan(&originVal)
	if err != nil {
		return originVal, err
	}
	if originVal < WaitTimeout {
		_, err = db.ExecContext(context.TODO(), fmt.Sprintf("set wait_timeout = %v", WaitTimeout))
		if err != nil {
			return originVal, err
		}
	}
	return originVal, nil
}

func ShowCreateTable(ctx context.Context, db QueryAble, dbName, tbName string) (r string, err error) {
	query := fmt.Sprintf("SHOW CREATE TABLE %s.%s", mysqlconfig.EscapeName(dbName), mysqlconfig.EscapeName(tbName))