Python dump_queryset_to_static_csv Examples

Example #1

def rectified_normal_csv_url():
    entries = ShapeRectifiedNormalLabel.objects.filter(time_ms__isnull=False,
                                                       automatic=False)

    return dump_queryset_to_static_csv(
        entries, ['time_ms', 'correct_score'],
        'analytics/shaperectifiednormallabel.csv')

Example #2

File: views.py Project: CV-IP/opensurfaces

def rectified_normal_csv_url():
    entries = ShapeRectifiedNormalLabel.objects.filter(
        time_ms__isnull=False, automatic=False)

    return dump_queryset_to_static_csv(
        entries, ['time_ms', 'correct_score'],
        'analytics/shaperectifiednormallabel.csv')

Example #3

File: views.py Project: CV-IP/opensurfaces

def material_shape_csv_url():
    entries = MaterialShape.objects.filter(
        time_ms__isnull=False, correct=True)

    return dump_queryset_to_static_csv(
        entries, ['time_ms', 'num_vertices', 'planar_score'],
        'analytics/materialshape.csv')

Example #4

def bsdf_wd_csv_url():
    entries = ShapeBsdfLabel_wd.objects.filter(time_ms__isnull=False,
                                               edit_nnz__gt=2)

    return dump_queryset_to_static_csv(entries, [
        'time_ms', 'doi', 'contrast', 'color_correct_score',
        'gloss_correct_score'
    ], 'analytics/shapebsdflabel_wd.csv')

Example #5

def admin_assignment_csv_url():
    return dump_queryset_to_static_csv(
        MtAssignment.objects.filter(time_ms__isnull=False), [
            'time_ms',
            'time_load_ms',
            'wage',
            ('hit__hit_type__experiment__slug', 'experiment_slug'),
            ('hit__num_contents', 'num_contents'),
        ], 'mturk-admin-assignment.csv')

Example #6

File: admin.py Project: CV-IP/opensurfaces

def admin_assignment_csv_url():
    return dump_queryset_to_static_csv(
        MtAssignment.objects.filter(time_ms__isnull=False),
        [
            'time_ms', 'time_load_ms', 'wage',
            ('hit__hit_type__experiment__slug', 'experiment_slug'),
            ('hit__num_contents', 'num_contents'),
        ],
        'mturk-admin-assignment.csv')

Example #7

File: views.py Project: CV-IP/opensurfaces

def bsdf_wd_csv_url():
    entries = ShapeBsdfLabel_wd.objects.filter(
        time_ms__isnull=False, edit_nnz__gt=2)

    return dump_queryset_to_static_csv(
        entries, [
            'time_ms', 'doi', 'contrast', 'color_correct_score',
            'gloss_correct_score'
        ], 'analytics/shapebsdflabel_wd.csv')

Example #8

def material_shape_csv_url():
    entries = MaterialShape.objects.filter(time_ms__isnull=False, correct=True)

    return dump_queryset_to_static_csv(
        entries, ['time_ms', 'num_vertices', 'planar_score'],
        'analytics/materialshape.csv')