def GetJSONFileAndExecQueries()

in framework/resources/Functional/odbcTest.py [0:0]

• 16 lines of code
• 8 McCabe index (conditional complexity)

def GetJSONFileAndExecQueries(queryDir):
  for root, dirnames, filenames in os.walk(queryDir):
    # find the json files
    for filename in fnmatch.filter(filenames, '*.json'):
      json_file = os.path.join(queryDir, filename)
      queryFile, queryFileExt, expectedFile, expectedFileExt, schema, \
        outputFileExt = ParseJSONFile(json_file)
      # execute SQL statement to "use" the schema specified by
      # the JSON file
      cursor.execute("use %s" % schema)

      # get list of query files for this json file
      # these will have absolute paths
      if queryFileExt:
        queryFiles = glob.glob("%s/*%s" % (queryDir,queryFileExt))
      else:
        # check if file specified by json file matches the file requested by user
        # if so, then execute the requested file using the information in this
        # json file
        queryFiles = glob.glob("%s/%s" % (queryDir, queryFile))
      queryFileRegex = re.compile(".*/(.*)")
      for queryFileWithPath in queryFiles:
        queryFileRegexSearch = queryFileRegex.search(queryFileWithPath)
        queryFile = queryFileRegexSearch.group(1)
        # execute each query file
        ExecuteQuery(queryDir, queryFile, outputFileExt, resultFileCreated)