Development
SQL::Bibliosoph
A SQL statement library. The module prepare declared statement at initialization, for performance reason. SQL statement can use bind paramenters. Currently it is only tested using MySQL.
Features
- Simple SQL syntax with no extra markup (bb files)
- MySQL 5.x compatible
- Bind parameters in statements are allowed
- Bind parameters can be reordered and reutilized
- Statements are prepared construction, for performance
- Statements definitions can use user's defined PERL constant
- Inserts statements returns LAST_INSERTED_ID
- Updates statements returns ROW_COUND (modifies rows)
Download
SQL::Biblosoph is freely available at CPAN.VIM
To make VIM correcly highlight the Bibliosoph files (.bb), create the following file at your /vim/syntax directory:
Download VIM Bibliosoph highlight definition file.
CTags
In order to get your SQL statements indexed by ctags you can add the following to the command line:
--langmap=sql_bibliosoph:.bb,html_template:.tmpl,perl2:.pl:.pm:.t
--regex-sql_bibliosoph=/^--\[\s*(.*)\]/\1/d,definition/i
--regex-sql_bibliosoph=/^--\[\s*(.*)\]/row_\1/d,definition/i
INSTALL
perl Makefile.PL
make
make test
make install
COPYRIGHT
Copyright (c) 2007 Matias Alejo Garcia. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
PREREQUISITES
Object::InsideOut
DBI
DBD:mysql
MISC
