ActiveRecord::ConnectionAdapters::AbstractMysqlAdapter < ActiveRecord::ConnectionAdapters::AbstractAdapter

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 27
      class_attribute :emulate_booleans, default: true

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 54
      def initialize(connection, logger, connection_options, config)
        super(connection, logger, config)
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 269
      def charset
        show_variable "character_set_database"
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 413
      def check_constraints(table_name)
        if supports_check_constraints?
          scope = quoted_scope(table_name)

          sql = <<~SQL
            SELECT cc.constraint_name AS 'name',
                  cc.check_clause AS 'expression'
            FROM information_schema.check_constraints cc
            JOIN information_schema.table_constraints tc
            USING (constraint_schema, constraint_name)
            WHERE tc.table_schema = #{scope[:schema]}
              AND tc.table_name = #{scope[:name]}
              AND cc.constraint_schema = #{scope[:schema]}
          SQL
          sql += " AND cc.table_name = #{scope[:name]}" if mariadb?

          chk_info = exec_query(sql, "SCHEMA")

          chk_info.map do |row|
            options = {
              name: row["name"]
            }
            expression = row["expression"]
            expression = expression[1..-2] if expression.start_with?("(") && expression.end_with?(")")
            expression = strip_whitespace_characters(expression)
            CheckConstraintDefinition.new(table_name, expression, options)
          end
        else
          raise NotImplementedError
        end
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 274
      def collation
        show_variable "collation_database"
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 244
      def create_database(name, options = {})
        if options[:collation]
          execute "CREATE DATABASE #{quote_table_name(name)} DEFAULT COLLATE #{quote_table_name(options[:collation])}"
        elsif options[:charset]
          execute "CREATE DATABASE #{quote_table_name(name)} DEFAULT CHARACTER SET #{quote_table_name(options[:charset])}"
        elsif row_format_dynamic_by_default?
          execute "CREATE DATABASE #{quote_table_name(name)} DEFAULT CHARACTER SET `utf8mb4`"
        else
          raise "Configure a supported :charset and ensure innodb_large_prefix is enabled to support indexes on varchar(255) string columns."
        end
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 264
      def current_database
        query_value("SELECT database()", "SCHEMA")
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 321
      def drop_table(table_name, **options)
        schema_cache.clear_data_source_cache!(table_name.to_s)
        execute "DROP#{' TEMPORARY' if options[:temporary]} TABLE#{' IF EXISTS' if options[:if_exists]} #{quote_table_name(table_name)}#{' CASCADE' if options[:force] == :cascade}"
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 194
      def execute(sql, name = nil, async: false)
        raw_execute(sql, name, async: async)
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 377
      def foreign_keys(table_name)
        raise ArgumentError unless table_name.present?

        scope = quoted_scope(table_name)

        fk_info = exec_query(<<~SQL, "SCHEMA")
          SELECT fk.referenced_table_name AS 'to_table',
                 fk.referenced_column_name AS 'primary_key',
                 fk.column_name AS 'column',
                 fk.constraint_name AS 'name',
                 rc.update_rule AS 'on_update',
                 rc.delete_rule AS 'on_delete'
          FROM information_schema.referential_constraints rc
          JOIN information_schema.key_column_usage fk
          USING (constraint_schema, constraint_name)
          WHERE fk.referenced_column_name IS NOT NULL
            AND fk.table_schema = #{scope[:schema]}
            AND fk.table_name = #{scope[:name]}
            AND rc.constraint_schema = #{scope[:schema]}
            AND rc.table_name = #{scope[:name]}
        SQL

        fk_info.map do |row|
          options = {
            column: unquote_identifier(row["column"]),
            name: row["name"],
            primary_key: row["primary_key"]
          }

          options[:on_update] = extract_foreign_key_action(row["on_update"])
          options[:on_delete] = extract_foreign_key_action(row["on_delete"])

          ForeignKeyDefinition.new(table_name, unquote_identifier(row["to_table"]), options)
        end
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 153
      def index_algorithms
        {
          default: "ALGORITHM = DEFAULT",
          copy:    "ALGORITHM = COPY",
          inplace: "ALGORITHM = INPLACE",
          instant: "ALGORITHM = INSTANT",
        }
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 149
      def native_database_types
        NATIVE_DATABASE_TYPES
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 230
      def recreate_database(name, options = {})
        drop_database(name)
        sql = create_database(name, options)
        reconnect!
        sql
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 326
      def rename_index(table_name, old_name, new_name)
        if supports_rename_index?
          validate_index_length!(table_name, new_name)

          execute "ALTER TABLE #{quote_table_name(table_name)} RENAME INDEX #{quote_table_name(old_name)} TO #{quote_table_name(new_name)}"
        else
          super
        end
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 299
      def rename_table(table_name, new_name)
        schema_cache.clear_data_source_cache!(table_name.to_s)
        schema_cache.clear_data_source_cache!(new_name.to_s)
        execute "RENAME TABLE #{quote_table_name(table_name)} TO #{quote_table_name(new_name)}"
        rename_table_indexes(table_name, new_name)
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 475
      def show_variable(name)
        query_value("SELECT @@#{name}", "SCHEMA")
      rescue ActiveRecord::StatementInvalid
        nil
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 526
      def strict_mode?
        self.class.type_cast_config_to_boolean(@config.fetch(:strict, true))
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 129
      def supports_advisory_locks?
        true
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 68
      def supports_bulk_alter?
        true
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 96
      def supports_check_constraints?
        if mariadb?
          database_version >= "10.2.1"
        else
          database_version >= "8.0.16"
        end
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 121
      def supports_common_table_expressions?
        if mariadb?
          database_version >= "10.2.1"
        else
          database_version >= "8.0.1"
        end
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 108
      def supports_datetime_with_precision?
        mariadb? || database_version >= "5.6.4"
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 84
      def supports_explain?
        true
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 76
      def supports_expression_index?
        !mariadb? && database_version >= "8.0.13"
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 92
      def supports_foreign_keys?
        true
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 72
      def supports_index_sort_order?
        !mariadb? && database_version >= "8.0.1"
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 88
      def supports_indexes_in_create?
        true
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 133
      def supports_insert_on_duplicate_skip?
        true
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 137
      def supports_insert_on_duplicate_update?
        true
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 117
      def supports_optimizer_hints?
        !mariadb? && database_version >= "5.7.7"
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 80
      def supports_transaction_isolation?
        true
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 104
      def supports_views?
        true
      end

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 112
      def supports_virtual_columns?
        mariadb? || database_version >= "5.7.5"
      end