code: def dump2sqlite(records, output_file):
      
      results_keys = list(records.results[0].keys())
      pad_data = []
  
      for key in REQUIRED_KEYS:
          if key not in results_keys:
              results_keys.append(key)
              pad_data.append("")
  
      conn = sqlite3.connect(os.path.expanduser(output_file), detect_types=sqlite3.PARSE_DECLTYPES)
  
      # in each row there needs to be data for every column
      # last column is current time
      pad_data.append(datetime.datetime.utcnow())
  
      to_db = [list(row.values()) + pad_data for row in records.results]
  
      cur = conn.cursor()
      cur.execute(
          "CREATE TABLE testcases ({},sqltime TIMESTAMP)".format(
              ",".join("{} TEXT".format(key) for key in results_keys)
          )
      )
      cur.executemany(
          "INSERT INTO testcases VALUES ({},?)".format(",".join(["?"] * len(results_keys))), to_db
      )
  
      if records.testrun:
          cur.execute("CREATE TABLE testrun (testrun TEXT)")
          cur.execute("INSERT INTO testrun VALUES (?)", (records.testrun,))
  
      conn.commit()
      conn.close()
  
      logger.info("Data written to '%s'", output_file)
docs: Dumps tests results to database.