DBIx::Custom

DBIx::Custom --Easy access to database with SQL

DBIx::Custom is a module to simplify queries to databases such as "insert, update, delete, select". As a O / R mapper , you can write something close to raw SQL with little to remember.

DBIx::Custom has the following useful features.

1. Easily execute insert, update, delete, select, fast insert statement, bulk insert support
2. Flexible Where clause generation, flexible order by clause generation, support for named placeholders
3. Supports MySQL, PostgreSQL, SQLite, Oracle, Microsoft SQL Server, Microsoft Access

See the sample code.

use DBIx::Custom;
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(where => {id => 1}, table =>'book');

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

It will be easy to write.

Installation

Let's "install" DBIx::Custom.

• Install DBIx::Custom

Connection to database

Explains how to "connect to the database" with DBIx::Custom. It can also be used in various databases.

• Connect to the database

Executing a query

I will explain how to execute a query with DBIx::Custom. Remember the insert, update, delete, select statements.

• Select row select
• Insert line insert
• Line update update
• Delete line delete
• Execute SQL execute

Row fetch

I will explain how to "fetch rows" with DBIx::Custom.

• Fetch rows

Dynamic creation of Where clauses

I will explain how to "dynamically create a where clause" with DBIx::Custom.

• Dynamically generate Where clause

Dynamic generation of Order By clause

I will explain how to "dynamically create an order by clause" with DBIx::Custom.

• Order By clause generation

Model

I will explain how to use "model" with DBIx::Custom.

• Use "model"

Applied functions

Introducing the "advanced features" of DBIx::Custom.

SQL generation

Here's a handy method for "generating SQL" with DBIx::Custom.

• Introduction of methods for "generating SQL" with DBIx::Custom

Filtering

I will explain how to use "filtering" with DBIx::Custom.

• Use "filtering"

Table and column information

I will introduce a method to check "table and column information" of DBIx::Custom.

• Method to check the information of "table" and "column" of DBIx::Custom

Utilities

Introducing the "utility" method of DBIx::Custom.

• Introduction of DBIx::Custom's "utility" method