DBIx-Custom / README /
29ecfa4 12 years ago
2 contributor
53 lines | 1.259kb
  1. DBIx::Custom
  2.  
  3. DBIx::Custom is Perl module to execute insert, update, delete, and
  4. select easily.
  5.  
  6. EXAMPLE
  7.  
  8. use DBIx::Custom;
  9. # Connect
  10. my $dbi = DBIx::Custom->connect(dsn => "dbi:SQLite:dbname=$database");
  11.  
  12. # Insert
  13. $dbi->insert({title => 'Perl', author => 'Ken'}, table => 'book');
  14. # Update
  15. $dbi->update({title => 'Perl', author => 'Ken'}, table => 'book',
  16. where => {id => 5});
  17. # Delete
  18. $dbi->delete(table => 'book', where => {author => 'Ken'});
  19.  
  20. # Select
  21. my $result = $dbi->select(table => 'book');
  22. my $rows = $result->all;
  23.  
  24. INSTALLATION
  25.  
  26. cpan DBIx::Custom
  27. FEATURES
  28.  
  29. - Execute insert, update, delete, or select statement easily
  30. - Create where clause flexibly
  31. - Named place holder support
  32. - Model support
  33. - Connection manager support
  34. - Choice your favorite relational database management system, MySQL,
  35. SQLite, PostgreSQL, Oracle, Microsoft SQL Srver, Microsoft Access,
  36. or anything,
  37. - Filtering by data type or column name
  38. - Create order by clause flexibly
  39.  
  40. DOCUMENTS
  41.  
  42. DBIx::Custom Documents
  43. https://github.com/yuki-kimoto/DBIx-Custom/wiki
  44. API reference
  45. http://search.cpan.org/~kimoto/DBIx-Custom/
  46. CPAN
  47. http://search.cpan.org/~kimoto/DBIx-Custom/lib/DBIx/Custom.pm