Matthew Simon Cavalletto > Term-ShellKit-1.002 > Term::ShellKit::DBI

Download:
Term-ShellKit-1.002.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Source  

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

syntax highlighting: