Log of /sql2xls.cgi

---

Revision 28 - (view) (annotate) - [select for diffs]
Modified Thu Dec 27 12:57:01 2012 UTC (10 years, 11 months ago) by dpavlin
File length: 6385 byte(s)
Diff to previous 25

escape data which looks like formula

---

Revision 25 - (view) (annotate) - [select for diffs]
Modified Thu Feb 12 10:56:03 2009 UTC (14 years, 9 months ago) by dpavlin
File length: 6302 byte(s)
Diff to previous 24

re-introduce $sth->rows > 0 check which PostgreSQL needs
to detect queries which doesn't return results
(like create temporary table)

---

Revision 24 - (view) (annotate) - [select for diffs]
Modified Thu Nov 6 10:53:59 2008 UTC (15 years ago) by dpavlin
File length: 6278 byte(s)
Diff to previous 23

more output when running without debug

---

Revision 23 - (view) (annotate) - [select for diffs]
Modified Thu Nov 6 10:49:02 2008 UTC (15 years ago) by dpavlin
File length: 6308 byte(s)
Diff to previous 22

support $db_encoding for Pg and mysql DBI drivers

---

Revision 22 - (view) (annotate) - [select for diffs]
Modified Thu Nov 6 10:37:17 2008 UTC (15 years ago) by dpavlin
File length: 6116 byte(s)
Diff to previous 21

use "set names '$db_encoding'" to for MySQL to get
correct character encoding in generated Excel

---

Revision 21 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 23:19:40 2008 UTC (15 years, 1 month ago) by dpavlin
File length: 6025 byte(s)
Diff to previous 20

support multiple SQL queries in one file, for example
to use create temporary time to speedup reporting

---

Revision 20 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 22:31:47 2008 UTC (15 years, 1 month ago) by dpavlin
File length: 5673 byte(s)
Diff to previous 19

strip \d+[-_] from beginning of SQL file before creating sheet name

---

Revision 19 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 22:29:05 2008 UTC (15 years, 1 month ago) by dpavlin
File length: 5670 byte(s)
Diff to previous 18

use heuristics to guess date time fields if we don't
have correct type from database (as from MySQL, sigh!)

---

Revision 18 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 22:26:57 2008 UTC (15 years, 1 month ago) by dpavlin
File length: 5454 byte(s)
Diff to previous 16

split require_config into own sub, so we now read global
and local config (within directory)

---

Revision 16 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 21:53:30 2008 UTC (15 years, 1 month ago) by dpavlin
File length: 5394 byte(s)
Diff to previous 15

undef $db_encoding to disable decode of encoding

---

Revision 15 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 21:39:44 2008 UTC (15 years, 1 month ago) by dpavlin
File length: 5359 byte(s)
Diff to previous 14

untaint config_path

---

Revision 14 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 20:42:55 2008 UTC (15 years, 1 month ago) by dpavlin
File length: 5330 byte(s)
Diff to previous 13

added configuration example and improved pod a bit

---

Revision 13 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 20:32:44 2008 UTC (15 years, 1 month ago) by dpavlin
File length: 4836 byte(s)
Diff to previous 12

implement sub-reports which are simply directories and SQL queries,
each generating single XLS file

---

Revision 12 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 20:15:09 2008 UTC (15 years, 1 month ago) by dpavlin
File length: 4332 byte(s)
Diff to previous 11

suggest ScriptAlias to get nice URLs

---

Revision 11 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 19:30:12 2008 UTC (15 years, 1 month ago) by dpavlin
File length: 4019 byte(s)
Diff to previous 10

implement 31 char limit for sheet name with warning

---

Revision 10 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 19:19:39 2008 UTC (15 years, 1 month ago) by dpavlin
File length: 3913 byte(s)
Diff to previous 8

read config.pl file if it exists

---

Revision 8 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 18:51:49 2008 UTC (15 years, 1 month ago) by dpavlin
File length: 3792 byte(s)
Diff to previous 7

strip spaces around comments

---

Revision 7 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 18:50:02 2008 UTC (15 years, 1 month ago) by dpavlin
File length: 3743 byte(s)
Diff to previous 6

fix warning

---

Revision 6 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 18:44:42 2008 UTC (15 years, 1 month ago) by dpavlin
File length: 3738 byte(s)
Diff to previous 5

disconnect from database before next connect, support unknown types

---

Revision 5 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 18:31:58 2008 UTC (15 years, 1 month ago) by dpavlin
File length: 3683 byte(s)
Diff to previous 4

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

---

Revision 4 - (view) (annotate) - [select for diffs]
Modified Mon Mar 24 23:02:15 2008 UTC (15 years, 8 months ago) by dpavlin
File length: 3457 byte(s)
Diff to previous 3

- 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

---

Revision 3 - (view) (annotate) - [select for diffs]
Modified Mon Mar 24 16:35:29 2008 UTC (15 years, 8 months ago) by dpavlin
File length: 3195 byte(s)
Diff to previous 2

convert SQL date into excel dates (with format dd.mm.yyyy)

---

Revision 2 - (view) (annotate) - [select for diffs]
Modified Mon Mar 24 15:57:14 2008 UTC (15 years, 8 months ago) by dpavlin
File length: 2745 byte(s)
Diff to previous 1

fix encoding of characters in generated sheet

---

Revision 1 - (view) (annotate) - [select for diffs]
Added Mon Mar 24 14:05:54 2008 UTC (15 years, 8 months ago) by dpavlin
File length: 2663 byte(s)

begin work on web reports which return SQL queries
as XLS table (readable in Gnumeric also :-)