query_sql.rbs

# auto-generated by sqlc - do not edit
module PgCodegen
  GET_AUTHOR_SQL: ::String

  class GetAuthorRow
    attr_reader id: ::Integer
    attr_reader name: ::String
    attr_reader bio: ::String?
    def initialize: (  ::Integer id, ::String name, ::String? bio) -> void
  end

  LIST_AUTHORS_SQL: ::String

  class ListAuthorsRow
    attr_reader id: ::Integer
    attr_reader name: ::String
    attr_reader bio: ::String?
    def initialize: (  ::Integer id, ::String name, ::String? bio) -> void
  end

  CREATE_AUTHOR_SQL: ::String

  class CreateAuthorRow
    attr_reader id: ::Integer
    attr_reader name: ::String
    attr_reader bio: ::String?
    def initialize: (  ::Integer id, ::String name, ::String? bio) -> void
  end

  DELETE_AUTHOR_SQL: ::String

  INSERT_POSTGRES_NUMERIC_TYPES_SQL: ::String

  GET_POSTGRES_NUMERIC_TYPES_SQL: ::String

  class GetPostgresNumericTypesRow
    attr_reader c_boolean: bool?
    attr_reader c_smallint: ::Integer?
    attr_reader c_integer: ::Integer?
    attr_reader c_bigint: ::Integer?
    attr_reader c_serial: ::Integer?
    attr_reader c_decimal: ::BigDecimal?
    attr_reader c_numeric: ::BigDecimal?
    attr_reader c_real: ::Float?
    attr_reader c_double_precision: ::Float?
    attr_reader c_money: ::String?
    attr_reader c_oid: ::Integer?
    attr_reader c_positive: untyped
    def initialize: (
        bool? c_boolean,
        ::Integer? c_smallint,
        ::Integer? c_integer,
        ::Integer? c_bigint,
        ::Integer? c_serial,
        ::BigDecimal? c_decimal,
        ::BigDecimal? c_numeric,
        ::Float? c_real,
        ::Float? c_double_precision,
        ::String? c_money,
        ::Integer? c_oid,
        untyped c_positive
    ) -> void
  end

  INSERT_POSTGRES_STRING_TYPES_SQL: ::String

  GET_POSTGRES_STRING_TYPES_SQL: ::String

  class GetPostgresStringTypesRow
    attr_reader c_char: ::String?
    attr_reader c_varchar: ::String?
    attr_reader c_text: ::String?
    attr_reader c_not_null: ::String
    attr_reader c_xml: ::String?
    attr_reader c_tsvector: ::String?
    attr_reader c_ltree: ::String?
    attr_reader c_hstore: ::String?
    attr_reader c_regclass: ::String?
    def initialize: (
        ::String? c_char,
        ::String? c_varchar,
        ::String? c_text,
        ::String c_not_null,
        ::String? c_xml,
        ::String? c_tsvector,
        ::String? c_ltree,
        ::String? c_hstore,
        ::String? c_regclass
    ) -> void
  end

  INSERT_POSTGRES_DATETIME_TYPES_SQL: ::String

  GET_POSTGRES_DATETIME_TYPES_SQL: ::String

  class GetPostgresDatetimeTypesRow
    attr_reader c_date: ::Date?
    attr_reader c_time: ::String?
    attr_reader c_timetz: ::String?
    attr_reader c_timestamp: ::Time?
    attr_reader c_timestamptz: ::Time?
    attr_reader c_interval: ::String?
    def initialize: (
        ::Date? c_date,
        ::String? c_time,
        ::String? c_timetz,
        ::Time? c_timestamp,
        ::Time? c_timestamptz,
        ::String? c_interval
    ) -> void
  end

  INSERT_POSTGRES_JSON_TYPES_SQL: ::String

  GET_POSTGRES_JSON_TYPES_SQL: ::String

  class GetPostgresJSONTypesRow
    attr_reader c_json: untyped
    attr_reader c_jsonb: untyped
    def initialize: (  untyped c_json, untyped c_jsonb) -> void
  end

  TOGGLE_POSTGRES_JSONB_TYPE_SQL: ::String

  INSERT_POSTGRES_ARRAY_TYPES_SQL: ::String

  LIST_POSTGRES_ARRAY_TYPES_SQL: ::String

  class ListPostgresArrayTypesRow
    attr_reader id: ::Integer
    attr_reader c_boolean: bool?
    attr_reader c_double_precision: ::Float?
    attr_reader c_text_array: ::Array[::String]?
    attr_reader c_integer_array: ::Array[::Integer]?
    attr_reader c_uuid_array: ::Array[::String]?
    attr_reader c_bio_type_array: ::Array[::String]?
    attr_reader c_bytea_array: ::Array[::String]?
    attr_reader c_jsonb_array: ::Array[untyped]?
    attr_reader c_numeric_array: ::Array[::BigDecimal]?
    attr_reader c_timestamptz_array: ::Array[::Time]?
    attr_reader c_integer_matrix: ::Array[::Array[::Integer]]?
    attr_reader c_text_matrix: ::Array[::Array[::String]]?
    def initialize: (
        ::Integer id,
        bool? c_boolean,
        ::Float? c_double_precision,
        ::Array[::String]? c_text_array,
        ::Array[::Integer]? c_integer_array,
        ::Array[::String]? c_uuid_array,
        ::Array[::String]? c_bio_type_array,
        ::Array[::String]? c_bytea_array,
        ::Array[untyped]? c_jsonb_array,
        ::Array[::BigDecimal]? c_numeric_array,
        ::Array[::Time]? c_timestamptz_array,
        ::Array[::Array[::Integer]]? c_integer_matrix,
        ::Array[::Array[::String]]? c_text_matrix
    ) -> void
  end

  INSERT_POSTGRES_ARRAY_TYPES_BATCH_SQL: ::String

  class InsertPostgresArrayTypesBatchArgs
    attr_reader id: ::Integer
    attr_reader c_boolean: bool?
    attr_reader c_double_precision: ::Float?
    attr_reader c_bytea_array: ::Array[::String]?
    attr_reader c_jsonb_array: ::Array[untyped]?
    attr_reader c_integer_array: ::Array[::Integer]?
    attr_reader c_numeric_array: ::Array[::BigDecimal]?
    attr_reader c_timestamptz_array: ::Array[::Time]?
    def initialize: (
        ::Integer id,
        bool? c_boolean,
        ::Float? c_double_precision,
        ::Array[::String]? c_bytea_array,
        ::Array[untyped]? c_jsonb_array,
        ::Array[::Integer]? c_integer_array,
        ::Array[::BigDecimal]? c_numeric_array,
        ::Array[::Time]? c_timestamptz_array
    ) -> void
  end

  class CopyPostgresArrayTypesArgs
    attr_reader id: ::Integer
    attr_reader c_boolean: bool?
    attr_reader c_double_precision: ::Float?
    attr_reader c_bytea_array: ::Array[::String]?
    attr_reader c_jsonb_array: ::Array[untyped]?
    attr_reader c_integer_array: ::Array[::Integer]?
    attr_reader c_numeric_array: ::Array[::BigDecimal]?
    attr_reader c_timestamptz_array: ::Array[::Time]?
    def initialize: (
        ::Integer id,
        bool? c_boolean,
        ::Float? c_double_precision,
        ::Array[::String]? c_bytea_array,
        ::Array[untyped]? c_jsonb_array,
        ::Array[::Integer]? c_integer_array,
        ::Array[::BigDecimal]? c_numeric_array,
        ::Array[::Time]? c_timestamptz_array
    ) -> void
  end

  COUNT_POSTGRES_ARRAY_TYPES_ABOVE_SQL: ::String

  class CountPostgresArrayTypesAboveRow
    attr_reader count: ::Integer
    def initialize: (  ::Integer count) -> void
  end

  INSERT_POSTGRES_SPECIAL_TYPES_SQL: ::String

  GET_POSTGRES_SPECIAL_TYPES_SQL: ::String

  class GetPostgresSpecialTypesRow
    attr_reader c_bytea: ::String?
    attr_reader c_bit: ::String?
    attr_reader c_varbit: ::String?
    attr_reader c_uuid: ::String?
    attr_reader c_inet: ::IPAddr?
    attr_reader c_cidr: ::IPAddr?
    attr_reader c_macaddr: ::String?
    attr_reader c_point: ::String?
    attr_reader c_int4range: ::String?
    attr_reader c_dimensions: ::String?
    def initialize: (
        ::String? c_bytea,
        ::String? c_bit,
        ::String? c_varbit,
        ::String? c_uuid,
        ::IPAddr? c_inet,
        ::IPAddr? c_cidr,
        ::String? c_macaddr,
        ::String? c_point,
        ::String? c_int4range,
        ::String? c_dimensions
    ) -> void
  end

  TRUNCATE_TEST_TABLES_SQL: ::String

  PAUSE_QUERY_SQL: ::String

  class PauseQueryRow
    attr_reader pg_sleep: untyped
    def initialize: (  untyped pg_sleep) -> void
  end

  LIST_AUTHORS_PAGED_SQL: ::String

  class ListAuthorsPagedRow
    attr_reader id: ::Integer
    attr_reader name: ::String
    attr_reader bio: ::String?
    def initialize: (  ::Integer id, ::String name, ::String? bio) -> void
  end

  GET_AUTHOR_BY_NAME_PATTERN_SQL: ::String

  class GetAuthorByNamePatternRow
    attr_reader id: ::Integer
    attr_reader name: ::String
    attr_reader bio: ::String?
    def initialize: (  ::Integer id, ::String name, ::String? bio) -> void
  end

  GET_AUTHORS_BY_OPTIONAL_NAME_SQL: ::String

  class GetAuthorsByOptionalNameRow
    attr_reader id: ::Integer
    attr_reader name: ::String
    attr_reader bio: ::String?
    def initialize: (  ::Integer id, ::String name, ::String? bio) -> void
  end

  CREATE_AUTHOR_RETURN_ID_SQL: ::String

  class CreateAuthorReturnIdRow
    attr_reader id: ::Integer
    def initialize: (  ::Integer id) -> void
  end

  UPDATE_AUTHOR_BIOS_SQL: ::String

  GET_AUTHORS_BY_IDS_SQL: ::String

  class GetAuthorsByIdsRow
    attr_reader id: ::Integer
    attr_reader name: ::String
    attr_reader bio: ::String?
    def initialize: (  ::Integer id, ::String name, ::String? bio) -> void
  end

  GET_AUTHORS_BY_IDS_AND_NAMES_SQL: ::String

  class GetAuthorsByIdsAndNamesRow
    attr_reader id: ::Integer
    attr_reader name: ::String
    attr_reader bio: ::String?
    def initialize: (  ::Integer id, ::String name, ::String? bio) -> void
  end

  class CopyAuthorsArgs
    attr_reader name: ::String
    attr_reader bio: ::String?
    def initialize: (  ::String name, ::String? bio) -> void
  end

  TRUNCATE_AUTHORS_SQL: ::String

  CREATE_BOOK_SQL: ::String

  class CreateBookRow
    attr_reader id: ::String
    def initialize: (  ::String id) -> void
  end

  CREATE_DEFERRED_BOOK_SQL: ::String

  LIST_ALL_AUTHORS_BOOKS_SQL: ::String

  class ListAllAuthorsBooksRow
    attr_reader author: Author
    attr_reader book: Book
    def initialize: (  Author author, Book book) -> void
  end

  GET_DUPLICATE_AUTHORS_SQL: ::String

  class GetDuplicateAuthorsRow
    attr_reader author: Author
    attr_reader author2: Author
    def initialize: (  Author author, Author author2) -> void
  end

  GET_AUTHORS_BY_BOOK_NAME_SQL: ::String

  class GetAuthorsByBookNameRow
    attr_reader id: ::Integer
    attr_reader name: ::String
    attr_reader bio: ::String?
    attr_reader book: Book
    def initialize: (  ::Integer id, ::String name, ::String? bio, Book book) -> void
  end

  CREATE_EXTENDED_BIO_SQL: ::String

  GET_FIRST_EXTENDED_BIO_BY_TYPE_SQL: ::String

  class GetFirstExtendedBioByTypeRow
    attr_reader author_name: ::String
    attr_reader name: ::String
    attr_reader bio_type: ::String?
    def initialize: (  ::String author_name, ::String name, ::String? bio_type) -> void
  end

  LIST_AUTHORS_WITH_OPTIONAL_BOOK_SQL: ::String

  class ListAuthorsWithOptionalBookRow
    attr_reader author: Author?
    attr_reader book: Book?
    def initialize: (  Author? author, Book? book) -> void
  end

  LIST_AUTHORS_BETWEEN_IDS_SQL: ::String

  class ListAuthorsBetweenIdsRow
    attr_reader id: ::Integer
    attr_reader name: ::String
    attr_reader bio: ::String?
    def initialize: (  ::Integer id, ::String name, ::String? bio) -> void
  end

  CREATE_AUTHOR_RESULT_SQL: ::String

  CREATE_AUTHORS_BATCH_SQL: ::String

  class CreateAuthorsBatchArgs
    attr_reader name: ::String
    attr_reader bio: ::String?
    def initialize: (  ::String name, ::String? bio) -> void
  end

  GET_AUTHOR_BATCH_SQL: ::String

  class GetAuthorBatchRow
    attr_reader id: ::Integer
    attr_reader name: ::String
    attr_reader bio: ::String?
    def initialize: (  ::Integer id, ::String name, ::String? bio) -> void
  end

  class GetAuthorBatchArgs
    attr_reader id: ::Integer
    def initialize: (  ::Integer id) -> void
  end

  LIST_AUTHORS_BY_NAME_BATCH_SQL: ::String

  class ListAuthorsByNameBatchRow
    attr_reader id: ::Integer
    attr_reader name: ::String
    attr_reader bio: ::String?
    def initialize: (  ::Integer id, ::String name, ::String? bio) -> void
  end

  class ListAuthorsByNameBatchArgs
    attr_reader name: ::String
    def initialize: (  ::String name) -> void
  end

  CREATE_REGRESSION_SQL: ::String

  class CreateRegressionRow
    attr_reader id: ::Integer
    attr_reader order: ::String
    attr_reader payload: ::String?
    attr_reader doc: untyped
    attr_reader bio_types: ::Array[::String]?
    attr_reader uids: ::Array[::String]?
    attr_reader step: ::String?
    def initialize: (
        ::Integer id,
        ::String order,
        ::String? payload,
        untyped doc,
        ::Array[::String]? bio_types,
        ::Array[::String]? uids,
        ::String? step
    ) -> void
  end

  CREATE_REGRESSION_IF_NEW_SQL: ::String

  class CreateRegressionIfNewRow
    attr_reader id: ::Integer
    def initialize: (  ::Integer id) -> void
  end

  class CopyRegressionsArgs
    attr_reader id: ::Integer
    attr_reader order: ::String
    attr_reader payload: ::String?
    attr_reader doc: untyped
    def initialize: (  ::Integer id, ::String order, ::String? payload, untyped doc) -> void
  end

  CREATE_REGRESSIONS_BATCH_SQL: ::String

  class CreateRegressionsBatchArgs
    attr_reader id: ::Integer
    attr_reader order: ::String
    attr_reader payload: ::String?
    attr_reader doc: untyped
    def initialize: (  ::Integer id, ::String order, ::String? payload, untyped doc) -> void
  end

  LIST_REGRESSIONS_SQL: ::String

  class ListRegressionsRow
    attr_reader id: ::Integer
    attr_reader order: ::String
    attr_reader payload: ::String?
    attr_reader doc: untyped
    attr_reader bio_types: ::Array[::String]?
    attr_reader uids: ::Array[::String]?
    attr_reader step: ::String?
    def initialize: (
        ::Integer id,
        ::String order,
        ::String? payload,
        untyped doc,
        ::Array[::String]? bio_types,
        ::Array[::String]? uids,
        ::String? step
    ) -> void
  end

  SET_REGRESSION_STEP_SQL: ::String

  class SetRegressionStepRow
    attr_reader step: ::String?
    def initialize: (  ::String? step) -> void
  end

  INSERT_NAME_CASE_SQL: ::String

  GET_NAME_CASE_SQL: ::String

  class GetNameCaseRow
    attr_reader id: ::Integer
    attr_reader class_: ::String
    attr_reader end: ::String
    attr_reader hash_: ::String
    attr_reader method_: ::String
    attr_reader count: ::Integer
    attr_reader camelCase: ::String
    attr_reader HTTPServer: ::String
    attr_reader initialize_: ::String
    def initialize: (
        ::Integer id,
        ::String class_,
        ::String end,
        ::String hash_,
        ::String method_,
        ::Integer count,
        ::String camelCase,
        ::String HTTPServer,
        ::String initialize_
    ) -> void
  end

  GET_HTTP_SERVER_SQL: ::String

  class GetHTTPServerRow
    attr_reader id: ::Integer
    attr_reader class_: ::String
    attr_reader end: ::String
    attr_reader hash_: ::String
    attr_reader method_: ::String
    attr_reader count: ::Integer
    attr_reader camelCase: ::String
    attr_reader HTTPServer: ::String
    attr_reader initialize_: ::String
    def initialize: (
        ::Integer id,
        ::String class_,
        ::String end,
        ::String hash_,
        ::String method_,
        ::Integer count,
        ::String camelCase,
        ::String HTTPServer,
        ::String initialize_
    ) -> void
  end

  class CopyMixedCaseCopiesArgs
    attr_reader id: ::Integer
    attr_reader some_value: ::String?
    def initialize: (  ::Integer id, ::String? some_value) -> void
  end

  LIST_MIXED_CASE_COPIES_SQL: ::String

  class ListMixedCaseCopiesRow
    attr_reader Id: ::Integer
    attr_reader SomeValue: ::String?
    def initialize: (  ::Integer Id, ::String? SomeValue) -> void
  end

  GET_UNNAMED_COLUMNS_SQL: ::String

  class GetUnnamedColumnsRow
    attr_reader column_1: ::Integer
    attr_reader column_2: ::String
    def initialize: (  ::Integer column_1, ::String column_2) -> void
  end

  GET_QUOTED_ALIAS_SQL: ::String

  class GetQuotedAliasRow
    attr_reader it_s: ::Integer
    def initialize: (  ::Integer it_s) -> void
  end

  CREATE_EXCEPTION_SQL: ::String

  COUNT_EXCEPTIONS_SQL: ::String

  class CountExceptionsRow
    attr_reader n: ::Integer
    def initialize: (  ::Integer n) -> void
  end

  TRUNCATE_EXCEPTIONS_SQL: ::String

  CREATE_LATE_FEELING_SQL: ::String

  GET_LATE_FEELING_SQL: ::String

  class GetLateFeelingRow
    attr_reader moods: ::Array[::String]
    def initialize: (  ::Array[::String] moods) -> void
  end

  HAS_AUTHORS_SQL: ::String

  class HasAuthorsRow
    attr_reader has_any: bool
    def initialize: (  bool has_any) -> void
  end

  class QuerySql
    class NotFound < ::StandardError
    end

    def self.connect: (::Hash[untyped, untyped] | ::String pg_params, ?logger: untyped, **untyped pool_options) -> instance

    def initialize: (untyped db, ?logger: untyped) -> void

    def transaction: [T] (?isolation: (:read_uncommitted | :read_committed | :repeatable_read | :serializable)?) { (self) -> T } -> T

    class ExecResult
      attr_reader rows_affected: ::Integer
      attr_reader last_insert_id: ::Integer?
      def initialize: (  ::Integer rows_affected, ::Integer? last_insert_id) -> void
    end

    def get_author: (id: ::Integer) -> GetAuthorRow?

    def get_author!: (id: ::Integer) -> GetAuthorRow

    def list_authors: -> ::Array[ListAuthorsRow]

    def create_author: (name: ::String, bio: ::String?) -> CreateAuthorRow?

    def create_author!: (name: ::String, bio: ::String?) -> CreateAuthorRow

    def delete_author: (id: ::Integer) -> void

    def insert_postgres_numeric_types: (c_boolean: bool?, c_smallint: ::Integer?, c_integer: ::Integer?, c_bigint: ::Integer?, c_decimal: ::BigDecimal?, c_numeric: ::BigDecimal?, c_real: ::Float?, c_double_precision: ::Float?, c_money: ::String?, c_oid: ::Integer?, c_positive: untyped) -> void

    def get_postgres_numeric_types: -> GetPostgresNumericTypesRow?

    def get_postgres_numeric_types!: -> GetPostgresNumericTypesRow

    def insert_postgres_string_types: (c_char: ::String?, c_varchar: ::String?, c_text: ::String?, c_not_null: ::String, c_xml: ::String?, c_tsvector: ::String?, c_ltree: ::String?, c_hstore: ::String?, c_regclass: ::String?) -> void

    def get_postgres_string_types: -> GetPostgresStringTypesRow?

    def get_postgres_string_types!: -> GetPostgresStringTypesRow

    def insert_postgres_datetime_types: (c_date: ::Date?, c_time: ::String?, c_timetz: ::String?, c_timestamp: ::Time?, c_timestamptz: ::Time?, c_interval: ::String?) -> void

    def get_postgres_datetime_types: -> GetPostgresDatetimeTypesRow?

    def get_postgres_datetime_types!: -> GetPostgresDatetimeTypesRow

    def insert_postgres_json_types: (id: ::Integer, c_json: untyped, c_jsonb: untyped) -> void

    def get_postgres_json_types: (id: ::Integer) -> GetPostgresJSONTypesRow?

    def get_postgres_json_types!: (id: ::Integer) -> GetPostgresJSONTypesRow

    def toggle_postgres_jsonb_type: (id: ::Integer) -> void

    def insert_postgres_array_types: (id: ::Integer, c_boolean: bool?, c_double_precision: ::Float?, c_text_array: ::Array[::String]?, c_integer_array: ::Array[::Integer]?, c_uuid_array: ::Array[::String]?, c_bio_type_array: ::Array[::String]?, c_bytea_array: ::Array[::String]?, c_jsonb_array: ::Array[untyped]?, c_numeric_array: ::Array[::BigDecimal]?, c_timestamptz_array: ::Array[::Time]?, c_integer_matrix: ::Array[::Array[::Integer]]?, c_text_matrix: ::Array[::Array[::String]]?) -> void

    def list_postgres_array_types: -> ::Array[ListPostgresArrayTypesRow]

    def insert_postgres_array_types_batch: (::Array[InsertPostgresArrayTypesBatchArgs] rows) -> void

    def copy_postgres_array_types: (::Array[CopyPostgresArrayTypesArgs] rows) -> void

    def count_postgres_array_types_above: (min_id: ::Integer) -> CountPostgresArrayTypesAboveRow?

    def count_postgres_array_types_above!: (min_id: ::Integer) -> CountPostgresArrayTypesAboveRow

    def insert_postgres_special_types: (c_bytea: ::String?, c_bit: ::String?, c_varbit: ::String?, c_uuid: ::String?, c_inet: ::IPAddr?, c_cidr: ::IPAddr?, c_macaddr: ::String?, c_point: ::String?, c_int4range: ::String?, c_dimensions: ::String?) -> void

    def get_postgres_special_types: -> GetPostgresSpecialTypesRow?

    def get_postgres_special_types!: -> GetPostgresSpecialTypesRow

    def truncate_test_tables: -> void

    def pause_query: (seconds: ::Float) -> void

    def list_authors_paged: (offset: ::Integer, limit: ::Integer) -> ::Array[ListAuthorsPagedRow]

    def get_author_by_name_pattern: (?name_pattern: ::String?) -> ::Array[GetAuthorByNamePatternRow]

    def get_authors_by_optional_name: (lim: ::Integer, ?name_filter: ::String?) -> ::Array[GetAuthorsByOptionalNameRow]

    def create_author_return_id: (name: ::String, bio: ::String?) -> ::Integer?

    def update_author_bios: (bio: ::String?) -> ::Integer

    def get_authors_by_ids: (param1: ::Array[::Integer]) -> ::Array[GetAuthorsByIdsRow]

    def get_authors_by_ids_and_names: (param1: ::Array[::Integer], param2: ::Array[::String]) -> ::Array[GetAuthorsByIdsAndNamesRow]

    def copy_authors: (::Array[CopyAuthorsArgs] rows) -> void

    def truncate_authors: -> void

    def create_book: (name: ::String, author_id: ::Integer) -> ::String?

    def create_deferred_book: (author_id: ::Integer) -> void

    def list_all_authors_books: -> ::Array[ListAllAuthorsBooksRow]

    def get_duplicate_authors: -> ::Array[GetDuplicateAuthorsRow]

    def get_authors_by_book_name: (name: ::String) -> ::Array[GetAuthorsByBookNameRow]

    def create_extended_bio: (author_name: ::String, name: ::String, bio_type: ::String?) -> void

    def get_first_extended_bio_by_type: (bio_type: ::String?) -> GetFirstExtendedBioByTypeRow?

    def get_first_extended_bio_by_type!: (bio_type: ::String?) -> GetFirstExtendedBioByTypeRow

    def list_authors_with_optional_book: -> ::Array[ListAuthorsWithOptionalBookRow]

    def list_authors_between_ids: (id: ::Integer, id_2: ::Integer) -> ::Array[ListAuthorsBetweenIdsRow]

    def create_author_result: (name: ::String, bio: ::String?) -> ExecResult

    def create_authors_batch: (::Array[CreateAuthorsBatchArgs] rows) -> void

    def get_author_batch: (::Array[GetAuthorBatchArgs] rows) -> ::Array[GetAuthorBatchRow?]

    def list_authors_by_name_batch: (::Array[ListAuthorsByNameBatchArgs] rows) -> ::Array[::Array[ListAuthorsByNameBatchRow]]

    def create_regression: (id: ::Integer, order: ::String, payload: ::String?, doc: untyped, bio_types: ::Array[::String]?, uids: ::Array[::String]?) -> CreateRegressionRow?

    def create_regression!: (id: ::Integer, order: ::String, payload: ::String?, doc: untyped, bio_types: ::Array[::String]?, uids: ::Array[::String]?) -> CreateRegressionRow

    def create_regression_if_new: (id: ::Integer, order: ::String) -> ::Integer?

    def copy_regressions: (::Array[CopyRegressionsArgs] rows) -> void

    def create_regressions_batch: (::Array[CreateRegressionsBatchArgs] rows) -> void

    def list_regressions: (?order_name: ::String?) -> ::Array[ListRegressionsRow]

    def set_regression_step: (id: ::Integer, step: ::String?) -> SetRegressionStepRow?

    def set_regression_step!: (id: ::Integer, step: ::String?) -> SetRegressionStepRow

    def insert_name_case: (id: ::Integer, class_: ::String, end_: ::String, hash: ::String, method: ::String, count: ::Integer, camel_case: ::String, http_server: ::String, initialize: ::String) -> void

    def get_name_case: (id: ::Integer, class_: ::String, end_: ::String, hash: ::String, method: ::String, count: ::Integer, http_server: ::String, camel_case: ::String, initialize: ::String) -> GetNameCaseRow?

    def get_name_case!: (id: ::Integer, class_: ::String, end_: ::String, hash: ::String, method: ::String, count: ::Integer, http_server: ::String, camel_case: ::String, initialize: ::String) -> GetNameCaseRow

    def get_http_server: (id: ::Integer) -> GetHTTPServerRow?

    def get_http_server!: (id: ::Integer) -> GetHTTPServerRow

    def copy_mixed_case_copies: (::Array[CopyMixedCaseCopiesArgs] rows) -> void

    def list_mixed_case_copies: -> ::Array[ListMixedCaseCopiesRow]

    def get_unnamed_columns: -> GetUnnamedColumnsRow?

    def get_unnamed_columns!: -> GetUnnamedColumnsRow

    def get_quoted_alias: -> GetQuotedAliasRow?

    def get_quoted_alias!: -> GetQuotedAliasRow

    def create_exception: -> void

    def count_exceptions: -> CountExceptionsRow?

    def count_exceptions!: -> CountExceptionsRow

    def truncate_exceptions: -> void

    def create_late_feeling: (id: ::Integer, moods: ::Array[::String]) -> void

    def get_late_feeling: (id: ::Integer) -> GetLateFeelingRow?

    def get_late_feeling!: (id: ::Integer) -> GetLateFeelingRow

    def has_authors: -> HasAuthorsRow?

    def has_authors!: -> HasAuthorsRow

    private

    def instrument: [T] (::String name) { () -> T } -> T

    def with_client: [T] (::String name) { (untyped) -> T } -> T

    def bound_to: (TransactionConnection connection) -> self

    def configure: (untyped client) -> void

    def string_arrays: (untyped client) -> untyped

    def run_prepared: (untyped client, ::String name, ::String sql, ?::Array[untyped] params) -> untyped
    def prepare: (untyped client, ::String name, ::String sql) -> void

    def encode_bytea: (::String? value) -> ::String?

    def encode_json: (untyped value) -> untyped

    def encode_timestamp: (untyped value) -> untyped

    def encode_float: (untyped value) -> untyped

    def encode_array: (::Array[untyped]? value, ?::Symbol kind) -> untyped

    def array_elements: (::Array[untyped] values, ::Symbol kind) -> ::Array[untyped]
  end
end