Changes for version v0.10.0 - 2021-08-29

  • Added method get_sql_type() to get driver specific constant called in DB::Object::Query and sub classes
  • Added support for sub-query in tables/view fields operations in DB::Object::Fields::Field
  • Added support for disabling and enabling triggers in DB::Object::Postgres::Table
  • Added support for temporarily disabling and enabling triggers on an existing query in DB::Object::Postgres::Statement
  • Added method promise in DB::Object::Statement to perform asynchronous query and returning a promise (Promise::Me) object
  • Added method types_const() in DB::Object::Tables, which is a column name to hash of data type constant and name properties created by DB::Object::Tables->structure. This is then shared with the DB::Object::Fields::Field object and enables better placeholder management
  • Added method constant in DB::Object::Fields::Field which returns an hash object with the following properties: constant (integer), name (string), and type (string)

Documentation

SQL Query Clause Object

Modules

SQL API
Tables Fields Object Accessor
Table Field Object
Mysql Database Object
Query Object for MySQL
Statement Object for MySQL
MySQL Table Object
Query Object for PostgreSQL
PostgreSQL Statement Object
PostgreSQL Table Object
Query Object
DB Object SQLite Driver
SQLite Query Object
SQLite Statement Object
SQLite Table Object
Statement Object
Database Table Object

Provides

in lib/DB/Object.pm
in lib/DB/Object.pm
in lib/DB/Object.pm
in lib/DB/Object.pm
in lib/DB/Object/Query.pm