NAME

Term::ShellKit::DBI - Simple DBI shell

SYNOPSIS

            

              
              
> perl -Iblib/lib -MTerm::ShellKit -eshell "kit DBI"
Term::ShellKit: Starting interactive shell; commands include help, exit.
Activating Term::ShellKit::Commands
Activating Term::ShellKit::DBI
Term::ShellKit> dbi_connect dbi:AnyData:
DBI::db=HASH(0x33ed90)
Term::ShellKit> create table foo ( id int, name varchar(42) )
Query affected 0 rows
Term::ShellKit> insert into foo values (3, 'Joe')
Query affected 1 rows
Term::ShellKit> insert into foo values (?, ?)      
Parameter 1: 5
Parameter 2: Dave
Query affected 1 rows
Term::ShellKit> select * from foo
+----+------+
| id | name |
+----+------+
| 3  | Joe  |
| 5  | Dave |
+----+------+
Term::ShellKit> drop table foo
Query affected 0 rows
Term::ShellKit> exit
            
          

DESCRIPTION

This module ties Term::ShellKit to DBI's general-purpose SQL execution framework.

SEE ALSO

Term::ShellKit