DBIx::Custom DBIx::Custom is Perl module to execute insert, update, delete, and select easily. EXAMPLE use DBIx::Custom; # Connect my $dbi = DBIx::Custom->connect( "dbi:mysql:database=dbname", 'ken', '!LFKD%$&', {mysql_enable_utf8 => 1} ); # Create model $dbi->create_model('book'); # Insert $dbi->model('book')->insert({title => 'Perl', author => 'Ken'}); # Update $dbi->model('book')->update({title => 'Perl', author => 'Ken'}, where => {id => 5}); # Delete $dbi->model('book')->delete(where => {author => 'Ken'}); # Select my $result = $dbi->model('book')->select(['title', 'author'], where => {author => 'Ken'}); # Select, more complex # select book.title as book.title, # book.author as book.author, # comnapy.name as company.name # form book # left outer join company on book.company_id = company.id # where book.author = ? # order by id limit 0, 5 my $result = $dbi->model('book')->select( [ {book => [qw/title author/]}, {company => ['name']} ], where => {'book.author' => 'Ken'}, join => ['left outer join company on book.company_id = company.id'], append => 'order by id limit 0, 5' ); # Get all rows or only one row my $rows = $result->all; my $row = $result->one; # Execute SQL with named place holder my $result = $dbi->execute( "select id from book where author = :author and title like :title", {author => 'ken', title => '%Perl%'} ); INSTALLATION cpan DBIx::Custom 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 Srver, Microsoft Access, or anything, - Filtering by data type or column name - Create order by clause flexibly DOCUMENTS DBIx::Custom Documents https://github.com/yuki-kimoto/DBIx-Custom/wiki API reference http://search.cpan.org/~kimoto/DBIx-Custom/ CPAN http://search.cpan.org/~kimoto/DBIx-Custom/lib/DBIx/Custom.pm WEB SITE DBIx::Custom - Perl O/R Mapper http://dbix-custom.hateblo.jp/