def METHOD_NAME(sqlite_copy, project, inventory, job_template):
    """
    Ensure that various unified job types are in the output of the query.
    """
    time_start = now() - timedelta(hours=9)
    inv_src = InventorySource.objects.create(name="inventory_update1", inventory=inventory, source="gce")
    project_update_name = ProjectUpdate.objects.create(project=project, name="project_update1").name
    inventory_update_name = inv_src.create_unified_job().name
    job_name = job_template.create_unified_job().name
    with tempfile.TemporaryDirectory() as tmpdir:
        collectors.unified_jobs_table(time_start, tmpdir, until=now() + timedelta(seconds=1))
        with open(os.path.join(tmpdir, "unified_jobs_table.csv")) as f:
            lines = "".join([line for line in f])
            assert project_update_name in lines
            assert inventory_update_name in lines
            assert job_name in lines