code: def setup_database_connection(
          pathToYamlFile):
      
      import sys
      import logging
      import pymysql as ms
  
      # IMPORT THE YAML CONNECTION DICTIONARY
      try:
          logging.info(
              'importing the yaml database connection dictionary from ' + pathToYamlFile)
          stream = file(pathToYamlFile, 'r')
          connDict = yaml.load(stream)
      except:
          logging.critical(
              'could not load the connect dictionary from ' + pathToYamlFile)
          sys.exit(1)
      # ESTABLISH A DB CONNECTION
      try:
          logging.info('connecting to the ' + connDict[
                       'db'] + ' database on ' + connDict['host'])
          dbConn = ms.connect(
              host=connDict['host'],
              user=connDict['user'],
              passwd=connDict['password'],
              db=connDict['db'],
              use_unicode=True,
              charset='utf8',
              local_infile=1,
              client_flag=ms.constants.CLIENT.MULTI_STATEMENTS,
              connect_timeout=36000
          )
          dbConn.autocommit(True)
      except Exception as e:
          logging.critical('could not connect to the ' + connDict['db'] + ' database on ' + connDict['host'] + ' : '
                           + str(e) + '\n')
      return dbConn
docs: *Start a database connection using settings in yaml file* 
  
      Given the location of a YAML dictionary containing database credientials, this function will setup and return the connection*
  
      **Key Arguments:**
          - ``pathToYamlFile`` -- path to the YAML dictionary.
  
      **Return:**
          - ``dbConn`` -- connection to the MySQL database.
  
      **Usage:**
  
          The settings file should be in this form, with all keyword values set:
  
          .. code-block:: yaml
  
              db: dryx_unit_testing
              host: localhost
              user: unittesting
              password: utpass
  
          And here's how to generate the connection object:
  
          .. code-block:: python 
  
              from fundamentals.mysql import setup_database_connection
              dbConn = setup_database_connection(
                  pathToYamlFile=pathToMyYamlFile
              )