squaresdb.membership.models module¶
- class squaresdb.membership.models.FeeCategory(slug, name)[source]¶
Bases:
ModelReverse relationships:
- Parameters:
person (Reverse
ForeignKeyfromPerson) – All people of this fee category (related name offee_cat)subscriptionperiodprice (Reverse
ForeignKeyfromSubscriptionPeriodPrice) – All subscription period prices of this fee category (related name offee_cat)danceprice (Reverse
ForeignKeyfromDancePrice) – All dance prices of this fee category (related name offee_cat)payment (Reverse
ForeignKeyfromPayment) – All payments of this fee category (related name offee_cat)
- exception DoesNotExist¶
Bases:
ObjectDoesNotExist
- exception MultipleObjectsReturned¶
Bases:
MultipleObjectsReturned
- exception NotUpdated¶
Bases:
ObjectNotUpdated,DatabaseError
- danceprice_set¶
Type: Reverse
ForeignKeyfromDancePriceAll dance prices of this fee category (related name of
fee_cat)
- objects = <django.db.models.Manager object>¶
- payment_set¶
Type: Reverse
ForeignKeyfromPaymentAll payments of this fee category (related name of
fee_cat)
- person_set¶
Type: Reverse
ForeignKeyfromPersonAll people of this fee category (related name of
fee_cat)
- subscriptionperiodprice_set¶
Type: Reverse
ForeignKeyfromSubscriptionPeriodPriceAll subscription period prices of this fee category (related name of
fee_cat)
- class squaresdb.membership.models.MITAffil(slug, name, student)[source]¶
Bases:
Model- Parameters:
slug (SlugField) – Primary key: Slug
name (CharField) – Name
student (BooleanField) – Student
Reverse relationships:
- Parameters:
person (Reverse
ForeignKeyfromPerson) – All people of this MIT affiliation (related name ofmit_affil)
- exception DoesNotExist¶
Bases:
ObjectDoesNotExist
- exception MultipleObjectsReturned¶
Bases:
MultipleObjectsReturned
- exception NotUpdated¶
Bases:
ObjectNotUpdated,DatabaseError
- objects = <django.db.models.Manager object>¶
- person_set¶
Type: Reverse
ForeignKeyfromPersonAll people of this MIT affiliation (related name of
mit_affil)
- student¶
Type:
BooleanFieldStudent
- class squaresdb.membership.models.Person(id, name, email, level, status, join_date, mit_affil, grad_year, fee_cat, frequency, last_marked_correct)[source]¶
Bases:
Model- Parameters:
id (BigAutoField) – Primary key: ID
name (CharField) – Name
email (EmailField) – Email
join_date (DateTimeField) – Join date
grad_year (IntegerField) – Year (expected or actual) graduated from MIT
last_marked_correct (DateTimeField) – Last marked correct
Relationship fields:
- Parameters:
level (
ForeignKeytoSquareLevel) – Highest level (related name:person)status (
ForeignKeytoPersonStatus) – Membership status (related name:person)mit_affil (
ForeignKeytoMITAffil) – MIT affiliation (related name:person)fee_cat (
ForeignKeytoFeeCategory) – Fee cat (related name:person)frequency (
ForeignKeytoPersonFrequency) – Attendance frequency (related name:person)
Reverse relationships:
- Parameters:
comments (Reverse
ForeignKeyfromPersonComment) – All comments of this person (related name ofperson)auth_links (Reverse
ForeignKeyfromPersonAuthLink) – All auth links of this person (related name ofperson)class_coord (Reverse
ForeignKeyfromTSClass) – All class coord of this person (related name ofcoordinator)class_assist (Reverse
ManyToManyFieldfromTSClass) – All class assist of this person (related name ofassistants)classes (Reverse
ManyToManyFieldfromTSClass) – All classes of this person (related name ofstudents)tsclassassist (Reverse
ForeignKeyfromTSClassAssist) – All Tech Squares class assistants of this person (related name ofassistant)tsclassmember (Reverse
ForeignKeyfromTSClassMember) – All Tech Squares class members of this person (related name ofstudent)payment (Reverse
ForeignKeyfromPayment) – All payments of this person (related name ofperson)attendee (Reverse
ForeignKeyfromAttendee) – All attendees of this person (related name ofperson)subscriptionlineitem (Reverse
ForeignKeyfromSubscriptionLineItem) – All subscription line items of this person (related name ofperson)
- exception DoesNotExist¶
Bases:
ObjectDoesNotExist
- exception MultipleObjectsReturned¶
Bases:
MultipleObjectsReturned
- exception NotUpdated¶
Bases:
ObjectNotUpdated,DatabaseError
- attendee_set¶
Type: Reverse
ForeignKeyfromAttendeeAll attendees of this person (related name of
person)
- auth_links¶
Type: Reverse
ForeignKeyfromPersonAuthLinkAll auth links of this person (related name of
person)
- class_assist¶
Type: Reverse
ManyToManyFieldfromTSClassAll class assist of this person (related name of
assistants)
- class_coord¶
Type: Reverse
ForeignKeyfromTSClassAll class coord of this person (related name of
coordinator)
- classes¶
Type: Reverse
ManyToManyFieldfromTSClassAll classes of this person (related name of
students)
- comments¶
Type: Reverse
ForeignKeyfromPersonCommentAll comments of this person (related name of
person)
- email¶
Type:
EmailFieldEmail
- fee_cat¶
Type:
ForeignKeytoFeeCategoryFee cat (related name:
person)
- frequency¶
Type:
ForeignKeytoPersonFrequencyAttendance frequency (related name:
person)
- grad_year¶
Type:
IntegerFieldYear (expected or actual) graduated from MIT
- grad_year_verbose = 'year (expected or actual) graduated from MIT'¶
- id¶
Type:
BigAutoFieldPrimary key: ID
- join_date¶
Type:
DateTimeFieldJoin date
- last_marked_correct¶
Type:
DateTimeFieldLast marked correct
- level¶
Type:
ForeignKeytoSquareLevelHighest level (related name:
person)
- mit_affil¶
Type:
ForeignKeytoMITAffilMIT affiliation (related name:
person)
- objects = <django.db.models.Manager object>¶
- payment_set¶
Type: Reverse
ForeignKeyfromPaymentAll payments of this person (related name of
person)
- status¶
Type:
ForeignKeytoPersonStatusMembership status (related name:
person)
- subscriptionlineitem_set¶
Type: Reverse
ForeignKeyfromSubscriptionLineItemAll subscription line items of this person (related name of
person)
- tsclassassist_set¶
Type: Reverse
ForeignKeyfromTSClassAssistAll Tech Squares class assistants of this person (related name of
assistant)
- tsclassmember_set¶
Type: Reverse
ForeignKeyfromTSClassMemberAll Tech Squares class members of this person (related name of
student)
- class squaresdb.membership.models.PersonAuthLink(id, person, secret, allowed_ip, expire_time, state_hash, create_user, create_ip, create_time, create_reason_basic, create_reason_detail)[source]¶
Bases:
Model- Parameters:
id (BigAutoField) – Primary key: ID
secret (CharField) – Secret
allowed_ip (GenericIPAddressField) – Allowed ip
expire_time (DateTimeField) – Expire time
state_hash (CharField) – State hash
create_ip (GenericIPAddressField) – Create ip
create_time (DateTimeField) – Create time
create_reason_basic (CharField) – Create reason basic
create_reason_detail (CharField) – Create reason detail
Relationship fields:
- Parameters:
person (
ForeignKeytoPerson) – Person (related name:auth_links)create_user (
ForeignKeytoUser) – Create user (related name:auth_links_created)
- exception DoesNotExist¶
Bases:
ObjectDoesNotExist
- exception MultipleObjectsReturned¶
Bases:
MultipleObjectsReturned
- exception NotUpdated¶
Bases:
ObjectNotUpdated,DatabaseError
- allowed_ip¶
Type:
GenericIPAddressFieldAllowed ip
- create_ip¶
Type:
GenericIPAddressFieldCreate ip
- create_time¶
Type:
DateTimeFieldCreate time
- create_user¶
Type:
ForeignKeytoUserCreate user (related name:
auth_links_created)
- create_user_id¶
Internal field, use
create_userinstead.
- expire_time¶
Type:
DateTimeFieldExpire time
- classmethod get_link(secret, request_ip)[source]¶
Get a PersonAuthLink and confirm its validity
Returns a tuple, with elements: (1) Validity: True (valid) or False (invalid) (2) Object: PersonAuthLink object if the secret was found and None otherwise
If validity is False but object is non-None, one should next typically call send_new_auth_link to generate a replacement.
- get_next_by_create_time(*, field=<django.db.models.DateTimeField: create_time>, is_next=True, **kwargs)¶
Finds next instance based on
create_time. Seeget_next_by_FOO()for more information.
- get_next_by_expire_time(*, field=<django.db.models.DateTimeField: expire_time>, is_next=True, **kwargs)¶
Finds next instance based on
expire_time. Seeget_next_by_FOO()for more information.
- get_previous_by_create_time(*, field=<django.db.models.DateTimeField: create_time>, is_next=False, **kwargs)¶
Finds previous instance based on
create_time. Seeget_previous_by_FOO()for more information.
- get_previous_by_expire_time(*, field=<django.db.models.DateTimeField: expire_time>, is_next=False, **kwargs)¶
Finds previous instance based on
expire_time. Seeget_previous_by_FOO()for more information.
- id¶
Type:
BigAutoFieldPrimary key: ID
- objects = <django.db.models.Manager object>¶
- person¶
Type:
ForeignKeytoPersonPerson (related name:
auth_links)
- class squaresdb.membership.models.PersonComment(id, author, timestamp, body, person)[source]¶
Bases:
Model- Parameters:
id (BigAutoField) – Primary key: ID
timestamp (DateTimeField) – Timestamp
body (TextField) – Body
Relationship fields:
- Parameters:
author (
ForeignKeytoUser) – Author (related name:comments_written)person (
ForeignKeytoPerson) – Person (related name:comments)
- exception DoesNotExist¶
Bases:
ObjectDoesNotExist
- exception MultipleObjectsReturned¶
Bases:
MultipleObjectsReturned
- exception NotUpdated¶
Bases:
ObjectNotUpdated,DatabaseError
- author¶
Type:
ForeignKeytoUserAuthor (related name:
comments_written)
- get_next_by_timestamp(*, field=<django.db.models.DateTimeField: timestamp>, is_next=True, **kwargs)¶
Finds next instance based on
timestamp. Seeget_next_by_FOO()for more information.
- get_previous_by_timestamp(*, field=<django.db.models.DateTimeField: timestamp>, is_next=False, **kwargs)¶
Finds previous instance based on
timestamp. Seeget_previous_by_FOO()for more information.
- id¶
Type:
BigAutoFieldPrimary key: ID
- objects = <django.db.models.Manager object>¶
- person¶
Type:
ForeignKeytoPersonPerson (related name:
comments)
- timestamp¶
Type:
DateTimeFieldTimestamp
- class squaresdb.membership.models.PersonFrequency(slug, name, order)[source]¶
Bases:
Model- Parameters:
slug (SlugField) – Primary key: Slug
name (CharField) – Name
order (IntegerField) – Order
Reverse relationships:
- Parameters:
person (Reverse
ForeignKeyfromPerson) – All people of this person frequency (related name offrequency)
- exception DoesNotExist¶
Bases:
ObjectDoesNotExist
- exception MultipleObjectsReturned¶
Bases:
MultipleObjectsReturned
- exception NotUpdated¶
Bases:
ObjectNotUpdated,DatabaseError
- objects = <django.db.models.Manager object>¶
- order¶
Type:
IntegerFieldOrder
- person_set¶
Type: Reverse
ForeignKeyfromPersonAll people of this person frequency (related name of
frequency)
- class squaresdb.membership.models.PersonStatus(slug, name, member)[source]¶
Bases:
Model- Parameters:
slug (SlugField) – Primary key: Slug
name (CharField) – Name
member (BooleanField) – Member
Reverse relationships:
- Parameters:
person (Reverse
ForeignKeyfromPerson) – All people of this person status (related name ofstatus)
- exception DoesNotExist¶
Bases:
ObjectDoesNotExist
- exception MultipleObjectsReturned¶
Bases:
MultipleObjectsReturned
- exception NotUpdated¶
Bases:
ObjectNotUpdated,DatabaseError
- member¶
Type:
BooleanFieldMember
- objects = <django.db.models.Manager object>¶
- person_set¶
Type: Reverse
ForeignKeyfromPersonAll people of this person status (related name of
status)
- class squaresdb.membership.models.SquareLevel(slug, name, order)[source]¶
Bases:
Model- Parameters:
slug (SlugField) – Primary key: Slug
name (CharField) – Name
order (IntegerField) – Order
Reverse relationships:
- Parameters:
person (Reverse
ForeignKeyfromPerson) – All people of this square level (related name oflevel)
- exception DoesNotExist¶
Bases:
ObjectDoesNotExist
- exception MultipleObjectsReturned¶
Bases:
MultipleObjectsReturned
- exception NotUpdated¶
Bases:
ObjectNotUpdated,DatabaseError
- objects = <django.db.models.Manager object>¶
- order¶
Type:
IntegerFieldOrder
- person_set¶
Type: Reverse
ForeignKeyfromPersonAll people of this square level (related name of
level)
- class squaresdb.membership.models.TSClass(id, label, coordinator, start_date, end_date)[source]¶
Bases:
Model- Parameters:
id (BigAutoField) – Primary key: ID
label (CharField) – Label
start_date (DateField) – Start date
end_date (DateField) – End date
Relationship fields:
- Parameters:
coordinator (
ForeignKeytoPerson) – Coordinator (related name:class_coord)assistants (
ManyToManyFieldtoPerson) – Assistants (related name:class_assist)students (
ManyToManyFieldtoPerson) – Students (related name:classes)
Reverse relationships:
- Parameters:
tsclassassist (Reverse
ForeignKeyfromTSClassAssist) – All Tech Squares class assistants of this Tech Squares class (related name ofclas)tsclassmember (Reverse
ForeignKeyfromTSClassMember) – All Tech Squares class members of this Tech Squares class (related name ofclas)
- exception DoesNotExist¶
Bases:
ObjectDoesNotExist
- exception MultipleObjectsReturned¶
Bases:
MultipleObjectsReturned
- exception NotUpdated¶
Bases:
ObjectNotUpdated,DatabaseError
- assistants¶
Type:
ManyToManyFieldtoPersonAssistants (related name:
class_assist)
- coordinator¶
Type:
ForeignKeytoPersonCoordinator (related name:
class_coord)
- coordinator_id¶
Internal field, use
coordinatorinstead.
- id¶
Type:
BigAutoFieldPrimary key: ID
- objects = <django.db.models.Manager object>¶
- students¶
Type:
ManyToManyFieldtoPersonStudents (related name:
classes)
- tsclassassist_set¶
Type: Reverse
ForeignKeyfromTSClassAssistAll Tech Squares class assistants of this Tech Squares class (related name of
clas)
- tsclassmember_set¶
Type: Reverse
ForeignKeyfromTSClassMemberAll Tech Squares class members of this Tech Squares class (related name of
clas)
- class squaresdb.membership.models.TSClassAssist(id, assistant, clas, role)[source]¶
Bases:
Model- Parameters:
id (BigAutoField) – Primary key: ID
role (CharField) – Role
Relationship fields:
- Parameters:
assistant (
ForeignKeytoPerson) – Assistant (related name:tsclassassist)clas (
ForeignKeytoTSClass) – Class (related name:tsclassassist)
- exception DoesNotExist¶
Bases:
ObjectDoesNotExist
- exception MultipleObjectsReturned¶
Bases:
MultipleObjectsReturned
- exception NotUpdated¶
Bases:
ObjectNotUpdated,DatabaseError
- assistant¶
Type:
ForeignKeytoPersonAssistant (related name:
tsclassassist)
- clas¶
Type:
ForeignKeytoTSClassClass (related name:
tsclassassist)
- id¶
Type:
BigAutoFieldPrimary key: ID
- objects = <django.db.models.Manager object>¶
- class squaresdb.membership.models.TSClassMember(id, student, clas, pe)[source]¶
Bases:
Model- Parameters:
id (BigAutoField) – Primary key: ID
pe (BooleanField) – Taking class as PE student?
Relationship fields:
- Parameters:
student (
ForeignKeytoPerson) – Student (related name:tsclassmember)clas (
ForeignKeytoTSClass) – Class (related name:tsclassmember)
- exception DoesNotExist¶
Bases:
ObjectDoesNotExist
- exception MultipleObjectsReturned¶
Bases:
MultipleObjectsReturned
- exception NotUpdated¶
Bases:
ObjectNotUpdated,DatabaseError
- clas¶
Type:
ForeignKeytoTSClassClass (related name:
tsclassmember)
- id¶
Type:
BigAutoFieldPrimary key: ID
- objects = <django.db.models.Manager object>¶
- pe¶
Type:
BooleanFieldTaking class as PE student?
- student¶
Type:
ForeignKeytoPersonStudent (related name:
tsclassmember)