Ejemplo n.º 1
0
def recent_capsules(request):
    query_dict = request.GET
    limit = query_dict.get('limit', 10)
    to_time = int_or_none(query_dict.get('to_time'))
    to_time = datetime.datetime.fromtimestamp(to_time) if to_time else datetime.datetime.utcnow()
    to_time = to_time.replace(tzinfo=utc)
    capsules = Capsule.objects \
        .filter(authors=request.user, last_modified__lt=to_time) \
        .order_by('-last_modified')[:limit]
    caps = sanitize_capsule_list(capsules)
    return HttpResponse(json.dumps(caps, cls=MyEncoder),
                        content_type="application/json")
Ejemplo n.º 2
0
def filter_capsules(request):
    query_dict = request.GET
    limit = query_dict.get('limit', 10)
    author_ids = query_dict.get('author_ids', '').split(',')
    author_usernames = query_dict.get('author_usernames')
    author_usernames = author_username.split(',') if author_usernames else []
    author_ids = [int_or_none(aid) for aid in author_ids if int_or_none(aid) != None]
    authors = User.objects.filter(Q(pk__in=author_ids) | Q(username__in=author_usernames))
    # tags = query_dict.get('tags', '')
    title = query_dict.get('title')
    text = query_dict.get('text') # for now this sucks since it has to match exactly
    path = query_dict.get('path')
    created_before = int_or_none(query_dict.get('created_before'))
    created_after = int_or_none(query_dict.get('created_after'))
    modified_before = int_or_none(query_dict.get('modified_before'))
    modified_after = int_or_none(query_dict.get('modified_after'))
    # can have this crazy structure of capsule = capsule.filter(...) without
    # submitting many queries to the db because the django ORM is smart and only
    # actually performs a query when the variable's information is used.
    capsules = Capsule.objects.all()
    if authors:
        capsules = capsules.filter(authors__in=authors)
    # if tags:
    #     tags = tags.split(',')
    #     capsules = capsules.filter(tags__name__in=tags)
    if title:
        capsules = capsules.filter(title=title)
    if text:
        capsules = capsules.filter(text=text)
    if path:
        capsules = capsules.filter(path=path)
    if created_before:
        capsules = capsules.filter(first_created__lt=
                                   datetime.datetime.utcfromtimestamp(created_before) \
                                       .replace(tzinfo=utc))
    if created_after:
        capsules = capsules.filter(first_created__gt=
                                   datetime.datetime.utcfromtimestamp(created_after) \
                                       .replace(tzinfo=utc))
    if modified_before:
        capsules = capsules.filter(last_modified__lt=
                                   datetime.datetime.utcfromtimestamp(modified_before) \
                                       .Replace(tzinfo=utc))
    if modified_after:
        capsules = capsules.filter(last_modified__gt=
                                   datetime.datetime.utcfromtimestamp(modified_after) \
                                       .replace(tzinfo=utc))
    return HttpResponse(json.dumps(sanitize_capsule_list(capsules[:limit]),
                                   cls=MyEncoder),
                        content_type="application/json")
Ejemplo n.º 3
0
            current_insp.append(field)

        if j <= 7 and is_new_rest:
            current_rest.append(field)
        elif j > 7:
            current_insp.append(field)

    if len(current_rest) > 0:
        session.add(                                 \
            Restaurant(                              \
                id=int(current_rest[0]),             \
                name=current_rest[1],                \
                boro=current_rest[2],                \
                building=current_rest[3],            \
                street=current_rest[4],              \
                zip=int_or_none(current_rest[5]),    \
                phone=current_rest[6],               \
                cuisine=current_rest[7],             \
            )                                        \
        )

    session.add(                                                \
        Inspection(                                             \
            rest_id=int(current_insp[0]),                       \
            inspection_date=str_to_date(current_insp[1]),       \
            action=current_insp[2],                             \
            violation_code=current_insp[3],                     \
            violation_desc=current_insp[4],                     \
            is_critical=current_insp[5] == 'Critical',          \
            score=int_or_none(current_insp[6]),                 \
            grade=grade_or_none(current_insp[7]),               \