Projects tagged ‘dbixsimple’, ‘perl’, and ‘storedprocedure’

This Perl module allow your program to process text files containing one or many commands that execute SQL statements sequentially following the procedure you define. Please keep in mind that ... [More] DBIx::Simple::Procedure is an alternative to database stored procedures and not a replacement or emulation of them. Essentially it is an interface to execute and return data from multiple queries. Here is an example of how to setup and process a (sql) text file. EXAMPLE: use DBIx::Simple::Procedure; my $db = DBIx::Simple::Procedure->new($path_to_sqlfiles, 'dbi:SQLite:dbname=file.dat'); $db->queue($sql_file)->process_queue(@sql_parameters); foreach my $result (@{$db->cache(0)}){ $result->{...}; } [Less]