DBIx::Custom Documents

DBIx::Custom Documents

DBIx::Custom is a DBI extended class to execute insert, update, delete, and select statement easily. DBIx::Custom has many useful features. Compared to other O/R mapper modules, it is easy to learn, because DBIx::Custom has many SQL-like syntax.

This is an example.

use DBIx::Custom;

# Connect to database
my $dbi = DBIx::Custom->connect(dsn => $dsn);

# Insert
$dbi->insert({id => 1, title => 'Perl'}, table => 'book');

# Update
$dbi->update({title => 'Perl'}, table => 'book', where => {id => 1});

# Delete
$dbi->delete(table => 'book', where => {id => 1});

# Select
my $rows = $dbi->select(table => 'book')->all;

Features

DBIx::Custom have the following features.

• Execute insert, update, delete, or select statement easily

• Create where clause flexibly

• Named place holder support

• Model support

• Connection manager support

• Choice your favorite relational database management system, MySQL, SQLite, PostgreSQL, Oracle, Microsoft SQL Server, Microsoft Access, DB2 or anything,

• Filtering by data type or column name

• Create order by clause flexibly

• Fast multiple data insert support

• Bulk insert support (MySQL, PostgreSQL)

If you search O/R mapper like Ruby's ActiveRecord or think DBIx::Custom is very complex or think DBIx::Simple don't have enough features, I recommend DBIx::Custom for you. DBIx::Custom also have SQL generation features like SQL::Abstruct. DBIx::Custom is not depended on specific RDBMS. you can use this module with any RDMBS.

Installation

• Installation of DBIx::Custom

Connect to database

• Connect to Database

  • Connect to MySQL

  • Connect to PostgreSQL

  • Connect to SQLite

  • Connect to Oracle

  • Connect to Microsoft SQL Server

  • Connect to Microsoft Access

  • Connect to DB2

Query execution

• Execute SQL

  • execute method options

• Insert row

• Update row

• Update all rows

• Delete row

• Delete all rows

• Select row

  • where option detail

• Count rows

Fetching rows

• Fetch row

• Useful fetching ways

Where clause

• How to create where clause

• where clause examples

Order by clause

• How to create order by clause

Filter

• Column name based filter

• Column type based filter

Model

• Create model

• Include models

• Setup models

Parameter mapping

• Parameter mapping

Connection manager

• Use DBIx::Connector

Performance

• Speed up many insert statements

• Improve performance by stopping deprecated tag parsing feature

Debug

• Get last executed SQL

• Print executed SQL to STDERR

Advanced

Generate SQL

• Create column clause easily

• Create values clause in insert statement

• Create assigning part in update statement

• Change quote for reserved word

• Change separator between table name and column name

• Register subroutine to create current time

Table and column information

• Show all tables

• Get table information

• Get table information in order

• Get column information

• Get column information in order

• Set column information for user

• Show type name from table name

• Show data type from table name

• Get type name list

• Get data type list

Web site

DBIx::Custom - Perl O/R Mapper