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