Parent Directory | Revision Log
Links to HEAD: | (view) (annotate) |
Sticky Revision: |
re-introduce $sth->rows > 0 check which PostgreSQL needs to detect queries which doesn't return results (like create temporary table)
more output when running without debug
support $db_encoding for Pg and mysql DBI drivers
use "set names '$db_encoding'" to for MySQL to get correct character encoding in generated Excel
support multiple SQL queries in one file, for example to use create temporary time to speedup reporting
strip \d+[-_] from beginning of SQL file before creating sheet name
use heuristics to guess date time fields if we don't have correct type from database (as from MySQL, sigh!)
split require_config into own sub, so we now read global and local config (within directory)
undef $db_encoding to disable decode of encoding
untaint config_path
added configuration example and improved pod a bit
implement sub-reports which are simply directories and SQL queries, each generating single XLS file
suggest ScriptAlias to get nice URLs
implement 31 char limit for sheet name with warning
read config.pl file if it exists
strip spaces around comments
fix warning
disconnect from database before next connect, support unknown types
cleanup mode in preparation for first release - move pod documentation to top - check GATEWAY_INTERFACE to detect cgi, so it works as simple command-line xls dumper again - disabled AutoCommit so we can't corrupt data by invoking reports
- support for \c database just like psql does (you can pipe sql into psql and it will work!) - better support for multi-line SQL queries
convert SQL date into excel dates (with format dd.mm.yyyy)
fix encoding of characters in generated sheet
begin work on web reports which return SQL queries as XLS table (readable in Gnumeric also :-)
This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.
ViewVC Help | |
Powered by ViewVC 1.1.26 |