branches/erry-devel/SrSv/MySQL.pm

   1 #       This file is part of SurrealServices.
   2 #
   3 #       SurrealServices is free software; you can redistribute it and/or modify
   4 #       it under the terms of the GNU General Public License as published by
   5 #       the Free Software Foundation; either version 2 of the License, or
   6 #       (at your option) any later version.
   7 #
   8 #       SurrealServices is distributed in the hope that it will be useful,
   9 #       but WITHOUT ANY WARRANTY; without even the implied warranty of
  10 #       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  11 #       GNU General Public License for more details.
  12 #
  13 #       You should have received a copy of the GNU General Public License
  14 #       along with SurrealServices; if not, write to the Free Software
  15 #       Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  16
  17 package SrSv::MySQL;
  18
  19 use strict;
  20
  21 use Exporter 'import';
  22 BEGIN { our @EXPORT_OK = qw($dbh) }
  23
  24 use DBI;
  25
  26 use SrSv::Process::Init;
  27
  28 use SrSv::Conf::Parameters sql => [
  29         qw(mysql_user mysql_pass mysql_db),
  30         [server_prepare => 0],
  31 ];
  32
  33 use SrSv::Conf 'sql';
  34
  35 our $dbh;
  36
  37 proc_init {
  38         $dbh = DBI->connect(
  39                 "DBI:mysql:".$sql_conf{'mysql-db'}.($sql_conf{server_prepare} ? ":mysql_server_prepare=1" : ''),
  40                 $sql_conf{'mysql-user'},
  41                 $sql_conf{'mysql-pass'},
  42                 {
  43                         AutoCommit => 1,
  44                         RaiseError => 0,
  45                         mysql_auto_reconnect => 1,
  46                 }
  47         );
  48         # Prevent timeout
  49         $dbh->do("SET wait_timeout=(86400*365)");
  50 };
  51
  52 1;