<filename>jumpbox/configuration.example.py<gh_stars>1-10
# Copyright (C) 2017 <NAME> <<EMAIL>>
#
# This file is part of Jumpbox
#
# Jumpbox is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program.  If not, see <http://www.gnu.org/licenses/>.
"""This module handles database connectivity"""

import psycopg2


class DBConnect(object):

    # This function makes the connection to the database
    def fetcher(self, query):
        try:
            conn = psycopg2.connect("user = 'username' host = '127.0.0.1'")
            cur = conn.cursor()
            cur.execute(query)
            rows = cur.fetchall()

            return rows

        except psycopg2.DatabaseError as err:
            print 'Error %s' % err
            sys.exit(1)

        finally:
            if conn:
                conn.close()
