blob: ac6f001fdc4097c019008a8d3120355a6d08c433 [file] [log] [blame]
indexes:
# used to retrieve User entities
- kind: User
properties:
- name: account
- name: status
# used to retrieve User entities
- kind: User
properties:
- name: user_id
- name: status
# used to figure out which proposals to accept
- kind: GSoCProposal
properties:
- name: accept_as_project
- name: org
- name: status
- name: score
direction: desc
# used to figure out which proposals to accept
- kind: GSoCProposal
properties:
- name: accept_as_project
- name: has_mentor
- name: org
- name: status
- name: score
direction: desc
# Used to update StudentProjects with the grade_decsion contained in a
# GradingRecord.
- kind: GradingRecord
properties:
- name: grading_survey_group
- name: __key__
# used to get the proposal comments in the order of the date of submission
- kind: GSoCComment
ancestor: yes
properties:
- name: created
# used to order GCIComments under a GCITask with that GCITask being
# its ancestor entity in the entity group.
- kind: GCIComment
ancestor: yes
properties:
- name: created_on
# used to order GCIWorkSubmissions under a GCITask with that GCITask being
# its ancestor entity in the entity group.
- kind: GCIWorkSubmission
ancestor: yes
properties:
- name: submitted_on
# used to fetch all the valid tasks for a given mentor under a program
- kind: GCITask
properties:
- name: mentors
- name: program
- name: status
# used to determine the winners of GCI, top N scores are chosen as winners
# where N is set in the program settings.
- kind: GCIScore
properties:
- name: program
- name: points
direction: desc
# Add a new index for querying the tasks based on student profile
# and task status IN query.
- kind: GCITask
properties:
- name: student
- name: status
# Used to obtain all tasks for the specified mentor and status.
- kind: GCITask
properties:
- name: mentors
- name: status
# Used to obtain all messages for the specified connection (ancestor) ordered
# by creation date
- kind: ConnectionMessage
ancestor: yes
properties:
- name: created
- kind: GCIMessage
properties:
- name: conversation
- name: sent_on
- kind: GCIMessage
properties:
- name: conversation
- name: sent_on
direction: desc
- kind: Profile
properties:
- name: is_student
- name: program
- name: student_data.number_of_projects
- kind: Profile
properties:
- name: is_student
- name: program
- name: student_data.number_of_completed_tasks
# AUTOGENERATED
# This index.yaml is automatically updated whenever the dev_appserver
# detects that a new type of query is run. If you want to manage the
# index.yaml file manually, remove the above marker line (the line
# saying "# AUTOGENERATED"). If you want to manage some indexes
# manually, move them above the marker line. The index.yaml file is
# automatically uploaded to the admin console when you next deploy
# your application using appcfg.py.
- kind: GCITask
properties:
- name: program
- name: status
- name: closed_on
- kind: GCITask
properties:
- name: program
- name: status
- name: modified_on
- kind: Project
properties:
- name: mentors
- name: status
- kind: Project
properties:
- name: organization
- name: status
- kind: Proposal
properties:
- name: accept_as_project
- name: has_mentor
- name: organization
- name: status
- name: total_score
direction: desc
- kind: Proposal
properties:
- name: organization
- name: status
- kind: Proposal
ancestor: yes
properties:
- name: status
- kind: StudentTaskCountForOrg
properties:
- name: organization
- name: completed_tasks_count
direction: desc