docs: def ingest(self):
          """*Ingest the ePESSTO Marshall transient stream into the catalogues database*
  
          The method first creates the tables for the various marshall feeder surveys in the sherlock-catalogues database (if they do not yet exist). Then the marshall database is queried for each transient survey and the results imported into the sherlock-catalogues tables,
  
          See the class docstring for usage
  
          .. todo ::
  
              - convert the directory_script_runner to 'load in file'
          """
          self.log.debug('starting the ``get`` method')
  
          # A YAML DICTIONARY OF sherlock-catalogues TABLE NAME AND THE SELECT
          # QUERY TO LIFT THE DATA FROM THE MARSHALL
          yamlFilePath = '/'.join(string.split(__file__, '/')
                                  [:-1]) + "/resources/pessto_marshall_table_selects.yaml"
          stream = file(yamlFilePath, 'r')
          marshallQueries = yaml.load(stream)
          stream.close()
          self.primaryIdColumnName = "primaryId"
          self.raColName = "raDeg"
          self.declColName = "decDeg"
  
          # CREATE THE MARSHALL IMPORT CATALOGUE TABLES (IF THEY DO NOT EXIST)
          directory_script_runner(
              log=self.log,
              pathToScriptDirectory='/'.join(string.split(__file__,
                                                          '/')[:-1]) + "/resources",
              databaseName=self.settings["database settings"][
                  "static catalogues"]["db"],
              loginPath=self.settings["database settings"][
                  "static catalogues"]["loginPath"],
              successRule="delete",
              failureRule="failed"
          )
  
          for k, v in marshallQueries["pessto queries"].iteritems():
              self.dbTableName = k
              self.databaseInsertbatchSize = 500
              dictList = self._create_dictionary_of_marshall(
                  marshallQuery=v["query"],
                  marshallTable=v["marshallTable"]
              )
  
              tableName = self.dbTableName
              self.add_data_to_database_table(
                  dictList=dictList
              )
  
          self.log.debug('completed the ``get`` method')
          return None