#!/usr/bin/python2

import os, sys
import MySQLdb

#=== GLOBALS ================================================================

class connection:

    def __init__( self, login ):
        self.db = MySQLdb.connect( login['host'], login['user'],
                                   login['pass'], login['db'] )

    def send( self, query ):

        if not self.db: print "You must use sql.open() before sql.send()"

        # create a cursor
        self.cursor = self.db.cursor()

        # execute SQL statement
        self.cursor.execute( query )

        # get the resultset as a tuple
        return self.cursor.fetchall()