From e7d247d861481d9506d51a531ac0e5e3f79941e0 Mon Sep 17 00:00:00 2001 From: erickson Date: Wed, 28 Sep 2005 19:30:50 +0000 Subject: [PATCH] shared initialization code git-svn-id: svn://svn.open-ils.org/ILS/trunk@1880 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- .../src/reporter/templates/logic_header.ttk | 31 +++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 Open-ILS/src/reporter/templates/logic_header.ttk diff --git a/Open-ILS/src/reporter/templates/logic_header.ttk b/Open-ILS/src/reporter/templates/logic_header.ttk new file mode 100644 index 0000000000..2fc450d607 --- /dev/null +++ b/Open-ILS/src/reporter/templates/logic_header.ttk @@ -0,0 +1,31 @@ +[% + +BLOCK logme_block; + "\n\t\n"; +END; + +MACRO logme(a) PROCESS logme_block x = a.list.join(', '); + +USE CGI; +USE DBI; +USE WebSession; +USE utils = WebUtils; +USE config = XML.LibXML(config_xml, expand_xinclude => 1); + +dir = '/reporter/setup/files/' _ stage_dir; +dir = config.findvalue(dir); + +dbname = config.findvalue('/reporter/setup/database/name'); +dbhost = config.findvalue('/reporter/setup/database/host'); +d_u = config.findvalue('/reporter/setup/database/user'); +d_p = config.findvalue('/reporter/setup/database/password'); + +dsn = "dbi:Pg:dbname=" _ dbname _';host=' _ dbhost; + +logme([dsn,d_u,d_p]); + +DBI.connect(dsn,d_u,d_p); + +stage2_insert = 'INSERT INTO reporter.stage2 (stage1, params, owner, pub)' _ + ' VALUES ( ?,?,?,? )'; +%] -- 2.43.2