DBIx-Custom / README /
Newer Older
53 lines | 1.259kb
improved documents
Yuki Kimoto authored on 2012-11-24
1
DBIx::Custom
packaging one directory
yuki-kimoto authored on 2009-11-16
2

            
improved documents
Yuki Kimoto authored on 2012-11-24
3
  DBIx::Custom is Perl module to execute insert, update, delete, and
4
  select easily.
packaging one directory
yuki-kimoto authored on 2009-11-16
5

            
improved documents
Yuki Kimoto authored on 2012-11-24
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
yuki-kimoto authored on 2009-11-16
22

            
improved documents
Yuki Kimoto authored on 2012-11-24
23
  # Select
24
  my $result = $dbi->select(table => 'book');
25
  my $rows = $result->all;
26

            
27
INSTALLATION
packaging one directory
yuki-kimoto authored on 2009-11-16
28

            
improved documents
Yuki Kimoto authored on 2012-11-24
29
  cpan DBIx::Custom
30
  
31
FEATURES
packaging one directory
yuki-kimoto authored on 2009-11-16
32

            
improved documents
Yuki Kimoto authored on 2012-11-24
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
yuki-kimoto authored on 2009-11-16
43

            
improved documents
Yuki Kimoto authored on 2012-11-24
44
DOCUMENTS
packaging one directory
yuki-kimoto authored on 2009-11-16
45

            
improved documents
Yuki Kimoto authored on 2012-11-24
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