Marijana Glavica [Fri, 14 Nov 2008 07:20:27 +0000 (08:20 +0100)]
fil-signature/01-01.sql
Marijana Glavica [Fri, 14 Nov 2008 07:20:27 +0000 (08:20 +0100)]
fil-signature/02-02.sql
Marijana Glavica [Fri, 14 Nov 2008 07:20:27 +0000 (08:20 +0100)]
fil-signature/03-03.sql
Marijana Glavica [Fri, 14 Nov 2008 07:20:27 +0000 (08:20 +0100)]
fil-signature/04-04.sql
Marijana Glavica [Fri, 14 Nov 2008 07:20:27 +0000 (08:20 +0100)]
fil-signature/05-05.sql
Marijana Glavica [Fri, 14 Nov 2008 07:20:27 +0000 (08:20 +0100)]
fil-signature/99-BA.sql
Marijana Glavica [Fri, 14 Nov 2008 07:20:23 +0000 (08:20 +0100)]
fil-signature/sr.sh
Marijana Glavica [Fri, 14 Nov 2008 07:12:39 +0000 (08:12 +0100)]
ang-signature/sr.sh
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/00-00.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/01-01.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/02-02.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/03-03.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/04-04.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/05-05.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/06-06.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/07-07.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/08-08.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/09-09.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/10-10.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/11-11.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/12-12.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/13-13.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/14-14.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/15-15.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/16-16.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/17-17.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/18-18.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/19-19.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/20-20.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/21-21.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/22-22.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/23-23.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/24-24.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/25-25.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/26-26.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/27-27.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/28-28.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/29-29.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/30-30.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/99-BD.sql
Marijana Glavica [Fri, 14 Nov 2008 07:03:48 +0000 (08:03 +0100)]
tal-signature-duple/00-duple-signature.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/00-00.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/01-01.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/02-02.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/03-03.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/04-04.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/05-05.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/06-06.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/07-07.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/08-08.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/09-09.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/10-10.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/11-11.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/12-12.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/13-13.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/14-14.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/15-15.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/16-16.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/17-17.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/18-18.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/19-19.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/20-20.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/21-21.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/99-FD.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:02 +0000 (08:00 +0100)]
tal-signature/sr.sh
Marijana Glavica [Mon, 10 Nov 2008 13:54:39 +0000 (14:54 +0100)]
pov-signature-duple/00-duple-signature.sql
Marijana Glavica [Mon, 10 Nov 2008 12:13:31 +0000 (13:13 +0100)]
ger-signature/07-07.sql
Marijana Glavica [Mon, 10 Nov 2008 12:13:23 +0000 (13:13 +0100)]
ger-signature/06-06.sql
Marijana Glavica [Mon, 10 Nov 2008 12:13:16 +0000 (13:13 +0100)]
ger-signature/05-05.sql
Marijana Glavica [Mon, 10 Nov 2008 12:13:10 +0000 (13:13 +0100)]
ger-signature/04-04.sql
Marijana Glavica [Mon, 10 Nov 2008 12:12:54 +0000 (13:12 +0100)]
ger-signature/02-02.sql
Marijana Glavica [Mon, 10 Nov 2008 12:12:45 +0000 (13:12 +0100)]
ger-signature/03-03.sql
Marijana Glavica [Mon, 10 Nov 2008 12:12:27 +0000 (13:12 +0100)]
ger-signature/01-01.sql
Marijana Glavica [Mon, 10 Nov 2008 12:12:07 +0000 (13:12 +0100)]
ger-signature/00-00.sql
Marijana Glavica [Mon, 10 Nov 2008 12:02:59 +0000 (13:02 +0100)]
ger-signature/99-FB.sql
Marijana Glavica [Mon, 10 Nov 2008 12:02:55 +0000 (13:02 +0100)]
ger-signature/sr.sh
Marijana Glavica [Fri, 7 Nov 2008 13:32:05 +0000 (14:32 +0100)]
src-signature-duple/00-duple-signature.sql
Marijana Glavica [Wed, 5 Nov 2008 15:09:54 +0000 (16:09 +0100)]
izn-signature-duple/00-duple-signature.sql
Dobrica Pavlinusic [Thu, 27 Dec 2012 12:57:01 +0000 (12:57 +0000)]
escape data which looks like formula
git-svn-id: svn://svn.rot13.org/SQL2XLS@28
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Tue, 28 Dec 2010 13:56:16 +0000 (13:56 +0000)]
initial port to Excel::Writer::XLSX
Which doesn't seem to work as-is yet!
git-svn-id: svn://svn.rot13.org/SQL2XLS@27
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Tue, 28 Dec 2010 13:35:57 +0000 (13:35 +0000)]
begin porting to Excel::Writer::XLSX
git-svn-id: svn://svn.rot13.org/SQL2XLS@26
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Thu, 12 Feb 2009 10:56:03 +0000 (10:56 +0000)]
re-introduce $sth->rows > 0 check which PostgreSQL needs
to detect queries which doesn't return results
(like create temporary table)
git-svn-id: svn://svn.rot13.org/SQL2XLS@25
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Thu, 6 Nov 2008 10:53:59 +0000 (10:53 +0000)]
more output when running without debug
git-svn-id: svn://svn.rot13.org/SQL2XLS@24
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Thu, 6 Nov 2008 10:49:02 +0000 (10:49 +0000)]
support $db_encoding for Pg and mysql DBI drivers
git-svn-id: svn://svn.rot13.org/SQL2XLS@23
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Thu, 6 Nov 2008 10:37:17 +0000 (10:37 +0000)]
use "set names '$db_encoding'" to for MySQL to get
correct character encoding in generated Excel
git-svn-id: svn://svn.rot13.org/SQL2XLS@22
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Mon, 3 Nov 2008 23:19:40 +0000 (23:19 +0000)]
support multiple SQL queries in one file, for example
to use create temporary time to speedup reporting
git-svn-id: svn://svn.rot13.org/SQL2XLS@21
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Mon, 3 Nov 2008 22:31:47 +0000 (22:31 +0000)]
strip \d+[-_] from beginning of SQL file before creating sheet name
git-svn-id: svn://svn.rot13.org/SQL2XLS@20
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Mon, 3 Nov 2008 22:29:05 +0000 (22:29 +0000)]
use heuristics to guess date time fields if we don't
have correct type from database (as from MySQL, sigh!)
git-svn-id: svn://svn.rot13.org/SQL2XLS@19
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Mon, 3 Nov 2008 22:26:57 +0000 (22:26 +0000)]
split require_config into own sub, so we now read global
and local config (within directory)
git-svn-id: svn://svn.rot13.org/SQL2XLS@18
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Mon, 3 Nov 2008 22:24:11 +0000 (22:24 +0000)]
remove dependency on CGI
git-svn-id: svn://svn.rot13.org/SQL2XLS@17
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Mon, 3 Nov 2008 21:53:30 +0000 (21:53 +0000)]
undef $db_encoding to disable decode of encoding
git-svn-id: svn://svn.rot13.org/SQL2XLS@16
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Mon, 3 Nov 2008 21:39:44 +0000 (21:39 +0000)]
untaint config_path
git-svn-id: svn://svn.rot13.org/SQL2XLS@15
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Mon, 3 Nov 2008 20:42:55 +0000 (20:42 +0000)]
added configuration example and improved pod a bit
git-svn-id: svn://svn.rot13.org/SQL2XLS@14
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Mon, 3 Nov 2008 20:32:44 +0000 (20:32 +0000)]
implement sub-reports which are simply directories and SQL queries,
each generating single XLS file
git-svn-id: svn://svn.rot13.org/SQL2XLS@13
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Mon, 3 Nov 2008 20:15:09 +0000 (20:15 +0000)]
suggest ScriptAlias to get nice URLs
git-svn-id: svn://svn.rot13.org/SQL2XLS@12
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Mon, 3 Nov 2008 19:30:12 +0000 (19:30 +0000)]
implement 31 char limit for sheet name with warning
git-svn-id: svn://svn.rot13.org/SQL2XLS@11
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Mon, 3 Nov 2008 19:19:39 +0000 (19:19 +0000)]
read config.pl file if it exists
git-svn-id: svn://svn.rot13.org/SQL2XLS@10
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Mon, 3 Nov 2008 18:55:36 +0000 (18:55 +0000)]
added Makefile.PL to check dependencies
since we don't require building of anything
git-svn-id: svn://svn.rot13.org/SQL2XLS@9
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Mon, 3 Nov 2008 18:51:49 +0000 (18:51 +0000)]
strip spaces around comments
git-svn-id: svn://svn.rot13.org/SQL2XLS@8
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b
Dobrica Pavlinusic [Mon, 3 Nov 2008 18:50:02 +0000 (18:50 +0000)]
fix warning
git-svn-id: svn://svn.rot13.org/SQL2XLS@7
2e857b76-582b-47e5-ad5c-
b3ba0f0ee29b