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