Open-ILS/src/reporter/templates/logic_header.ttk

   1 <style>
   2 *  {    font-family: sans-serif;
   3                 font-size: 10pt;
   4 }
   5 </style>
   6 [%
   7
   8 BLOCK logme_block;
   9         "\n\t<!-- " _ x _ " -->\n";
  10 END;
  11
  12 MACRO logme(a) PROCESS logme_block x = a.list.join(', ');
  13
  14 USE CGI;
  15 USE DBI;
  16 USE WebSession;
  17 USE utils = WebUtils;
  18 USE config = XML.LibXML(config_xml, expand_xinclude => 1);
  19
  20 dir = '/reporter/setup/files/' _ stage_dir;
  21 dir = config.findvalue(dir);
  22
  23 dbname = config.findvalue('/reporter/setup/database/name');
  24 dbhost = config.findvalue('/reporter/setup/database/host');
  25 d_u = config.findvalue('/reporter/setup/database/user');
  26 d_p = config.findvalue('/reporter/setup/database/password');
  27
  28 dsn = "dbi:Pg:dbname=" _ dbname _';host=' _ dbhost;
  29
  30 logme([dsn,d_u,d_p]);
  31
  32 DBI.connect(dsn,d_u,d_p);
  33
  34 stage2_insert = 'INSERT INTO reporter.stage2 (stage1, params, owner, pub)' _
  35                                                 ' VALUES ( ?,?,?,? )';
  36
  37 stage3_insert = 'INSERT INTO reporter.stage3 (stage2, params, owner, pub, runtime, recurrence)' _
  38                                                 ' VALUES ( ?,?,?,?,?,? )';
  39 %]