test/test_db_mysql.py

   1 #!/usr/bin/env python2.6
   2 #Copyright (C) 2009-2010 :
   3 #    Gabes Jean, naparuba@gmail.com
   4 #    Gerhard Lausser, Gerhard.Lausser@consol.de
   5 #
   6 #This file is part of Shinken.
   7 #
   8 #Shinken is free software: you can redistribute it and/or modify
   9 #it under the terms of the GNU Affero General Public License as published by
  10 #the Free Software Foundation, either version 3 of the License, or
  11 #(at your option) any later version.
  12 #
  13 #Shinken is distributed in the hope that it will be useful,
  14 #but WITHOUT ANY WARRANTY; without even the implied warranty of
  15 #MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  16 #GNU Affero General Public License for more details.
  17 #
  18 #You should have received a copy of the GNU Affero General Public License
  19 #along with Shinken.  If not, see <http://www.gnu.org/licenses/>.
  20
  21 #
  22 # This file is used to test reading and processing of config files
  23 #
  24
  25 #It's ugly I know....
  26 from shinken_test import *
  27 from shinken.db_mysql import DBMysql
  28
  29 class TestConfig(ShinkenTest):
  30     #setUp is in shinken_test
  31
  32
  33     def create_db(self):
  34         self.db = DBMysql(host='localhost', user='root', password='root', database='merlin', character_set='utf8')
  35
  36
  37     def test_connect_database(self):
  38         self.create_db()
  39         try:
  40             self.db.connect_database()
  41         except Exception: # arg, no database here? sic!
  42             pass
  43
  44
  45     def test_execute_query(self):
  46         self.create_db()
  47         try:
  48             self.db.connect_database()
  49             q = "DELETE FROM service WHERE instance_id = '0'"
  50             self.db.execute_query(q)
  51         except Exception:
  52             pass
  53
  54
  55
  56 if __name__ == '__main__':
  57     unittest.main()
  58