DBIx::C...AutoCast(3)

🌸 NAME 🌸

okay bestie, this page is DBIx::C...AutoCast(3) from the User Contributed Perl Documentation, and the actual module is DBIx::Class::Storage::DBI::AutoCast β€” it’s the storage component for RDBMS requiring explicit placeholder typing. slay.

✨ SYNOPSIS ✨

  $schema->storage->auto_cast(1);

πŸ’– DESCRIPTION πŸ’–

So here’s the vibe: in some combinations of RDBMS and DBD drivers (e.g. FreeTDS and Sybase), statements with values bound to columns or conditions that are not strings will throw implicit type conversion errors. not iconic of them, but okay.

As long as a column data_type is defined and resolves to a base RDBMS native type via _native_data_type as defined in your Storage driver, the placeholder for this column will be converted to:

  CAST(? as $mapped_type)

This option can also be enabled in connect_info as:

on_connect_call => ['set_auto_cast']

πŸŽ€ connect_call_set_auto_cast πŸŽ€

This one executes:

$schema->storage->auto_cast(1);

on connection.

Used as:

    on_connect_call => ['set_auto_cast']

in connect_info.

πŸ’¬ FURTHER QUESTIONS? πŸ’¬

Check the list of additional DBIC resources. that’s the whole tea β˜•.

This module is free software copyright by the DBIx::Class (DBIC) authors. You can redistribute it and/or modify it under the same terms as the DBIx::Class library.


okay bye bestie πŸ’… β€” this page is from perl v5.42.0, dated 2025-01-22, and the footer label is DBIx::C...AutoCast(3). 🫢

πŸ“¦ where this page comes from