Mathias Kende > SQL-Exec > SQL::Exec::SQLite

Download:
SQL-Exec/SQL-Exec-0.10.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Source  

NAME ^

SQL::Exec::SQLite - Specific support for the DBD::SQLite DBI driver in SQL::Exec

SYNOPSIS ^

  use SQL::Exec::SQLite;
  
  SQL::Exec::SQLite::connect('/tmp/my.db');

DESCRIPTION ^

The SQL::Exec::SQLite package is an extension of the SQL::Exec package. This mean that in an OO context SQL::Exec::SQLite is a sub-classe of SQL::Exec (so all methods of the later can be used in the former). Also, in a functionnal context, all functions of SQL::Exec can be accessed through SQL::Exec::SQLite.

CONSTRUCTOR ^

  my $c = SQL::Exec::SQLite->new(file);
  my $c = SQL::Exec::SQLite->new(file, opts);

The new constructor of this package takes only a single argument which is the name of the file to use as a database. The constructor can also takes an optionnal argument wich contains option to apply to the created database handle, either as a hash or as a reference to a hash.

The database file is created automatically if it does not already exist. Also you may use the special file name ':memory' to use a in-memory database. In that case, all your data will be destroyed when you close the database handle.

FUNCTIONS ^

The function described here are either functions specific to this database driver or special version of a SQL::Exec function adapted for the database driver.

However, all the function of SQL::Exec are accessible in this package, either with the object oriented interface or with the functionnal one. This package can also exports all the function of the SQL::Exec package and the :all tag contains all exportable functions from both SQL::Exec and this package.

connect

  connect(file);
  $c->connect(file);

As the connect function in SQL::Exec this function will either connect the default handle of the library or connect a specific handle that is already created.

This function takes the same arguments as the new constructor, except that the optionnal options hash must be given as a hash reference and that it applies only for the duration of the call (this is the same as the connect function in SQL::Exec).

test_driver

  my $t = test_driver();

This function returns a boolean value indicating if the DBD::SQLite database driver is installed.

BUGS ^

Please report any bugs or feature requests to bug-sql-exec@rt.cpan.org, or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=SQL-Exec.

SEE ALSO ^

For the main documentation of this module ond for a list of all available functions, please check the SQL::Exec module.

For details about the SQLite database driver, you should check the documentation for DBD::SQLite

COPYRIGHT & LICENSE ^

Copyright 2013 © Mathias Kende. All rights reserved.

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

syntax highlighting: