squaresdb.gate.models module¶

class squaresdb.gate.models.Attendee(id, person, dance, time, payment)[source]¶

Bases: Model

Parameters:

id (BigAutoField) – Primary key: ID
time (DateTimeField) – Time

Relationship fields:

Parameters:

person (ForeignKey to Person) – Person (related name: attendee)
dance (ForeignKey to Dance) – Dance (related name: attendee)
payment (ForeignKey to Payment) – Payment (related name: attendee)

exception DoesNotExist¶: Bases: ObjectDoesNotExist

exception MultipleObjectsReturned¶: Bases: MultipleObjectsReturned

exception NotUpdated¶: Bases: ObjectNotUpdated, DatabaseError

dance¶

Type: ForeignKey to Dance

Dance (related name: attendee)

dance_id¶: Internal field, use dance instead.

get_next_by_time(*, field=<django.db.models.DateTimeField: time>, is_next=True, **kwargs)¶: Finds next instance based on time. See get_next_by_FOO() for more information.

get_previous_by_time(*, field=<django.db.models.DateTimeField: time>, is_next=False, **kwargs)¶: Finds previous instance based on time. See get_previous_by_FOO() for more information.

id¶

Type: BigAutoField

Primary key: ID

objects = <django.db.models.Manager object>¶

payment¶

Type: ForeignKey to Payment

Payment (related name: attendee)

payment_id¶: Internal field, use payment instead.

person¶

Type: ForeignKey to Person

Person (related name: attendee)

person_id¶: Internal field, use person instead.

time¶

Type: DateTimeField

Time

class squaresdb.gate.models.Dance(id, time, period, price_scheme)[source]¶

Bases: Model

Parameters:

id (BigAutoField) – Primary key: ID
time (DateTimeField) – Time

Relationship fields:

Parameters:

period (ForeignKey to SubscriptionPeriod) – Period (related name: dance)
price_scheme (ForeignKey to DancePriceScheme) – Price scheme (related name: dance)

Reverse relationships:

Parameters:

payment (Reverse ForeignKey from Payment) – All payments of this dance (related name of at_dance)
dancepayment (Reverse ForeignKey from DancePayment) – All dance payments of this dance (related name of for_dance)
attendee (Reverse ForeignKey from Attendee) – All attendees of this dance (related name of dance)

exception DoesNotExist¶: Bases: ObjectDoesNotExist

exception MultipleObjectsReturned¶: Bases: MultipleObjectsReturned

exception NotUpdated¶: Bases: ObjectNotUpdated, DatabaseError

attendee_set¶

Type: Reverse ForeignKey from Attendee

All attendees of this dance (related name of dance)

dancepayment_set¶

Type: Reverse ForeignKey from DancePayment

All dance payments of this dance (related name of for_dance)

get_next_by_time(*, field=<django.db.models.DateTimeField: time>, is_next=True, **kwargs)¶: Finds next instance based on time. See get_next_by_FOO() for more information.

get_previous_by_time(*, field=<django.db.models.DateTimeField: time>, is_next=False, **kwargs)¶: Finds previous instance based on time. See get_previous_by_FOO() for more information.

id¶

Type: BigAutoField

Primary key: ID

objects = <django.db.models.Manager object>¶

payment_set¶

Type: Reverse ForeignKey from Payment

All payments of this dance (related name of at_dance)

period¶

Type: ForeignKey to SubscriptionPeriod

Period (related name: dance)

period_id¶: Internal field, use period instead.

price_scheme¶

Type: ForeignKey to DancePriceScheme

Price scheme (related name: dance)

price_scheme_id¶: Internal field, use price_scheme instead.

time¶

Type: DateTimeField

Time

class squaresdb.gate.models.DancePayment(id, person, at_dance, time, payment_type, amount, fee_cat, notes, payment_ptr, for_dance)[source]¶

Bases: Payment

Parameters:

id (BigAutoField) – Primary key: ID
time (DateTimeField) – Time
amount (DecimalField) – Amount
notes (TextField) – Notes

Relationship fields:

Parameters:

person (ForeignKey to Person) – Person (related name: payment)
at_dance (ForeignKey to Dance) – At dance (related name: payment)
payment_type (ForeignKey to PaymentMethod) – Payment type (related name: payment)
fee_cat (ForeignKey to FeeCategory) – Fee cat (related name: payment)
payment_ptr (OneToOneField to Payment) – Primary key: Payment ptr (related name: dancepayment)
for_dance (ForeignKey to Dance) – For dance (related name: dancepayment)

Reverse relationships:

Parameters:: attendee (Reverse ForeignKey from Attendee) – All attendees of this payment (related name of payment)

exception DoesNotExist¶: Bases: DoesNotExist

exception MultipleObjectsReturned¶: Bases: MultipleObjectsReturned

exception NotUpdated¶: Bases: NotUpdated

for_dance¶

Type: ForeignKey to Dance

For dance (related name: dancepayment)

for_dance_id¶: Internal field, use for_dance instead.

payment_ptr¶

Type: OneToOneField to Payment

Primary key: Payment ptr (related name: dancepayment)

payment_ptr_id¶: Internal field, use payment_ptr instead.

class squaresdb.gate.models.DancePrice(id, price_scheme, fee_cat, low, high)[source]¶

Bases: Model

Parameters:

id (BigAutoField) – Primary key: ID
low (IntegerField) – Low
high (IntegerField) – High

Relationship fields:

Parameters:

price_scheme (ForeignKey to DancePriceScheme) – Price scheme (related name: danceprice)
fee_cat (ForeignKey to FeeCategory) – Fee cat (related name: danceprice)

exception DoesNotExist¶: Bases: ObjectDoesNotExist

exception MultipleObjectsReturned¶: Bases: MultipleObjectsReturned

exception NotUpdated¶: Bases: ObjectNotUpdated, DatabaseError

fee_cat¶

Type: ForeignKey to FeeCategory

Fee cat (related name: danceprice)

fee_cat_id¶: Internal field, use fee_cat instead.

high¶

Type: IntegerField

High

id¶

Type: BigAutoField

Primary key: ID

low¶

Type: IntegerField

Low

objects = <django.db.models.Manager object>¶

price_scheme¶

Type: ForeignKey to DancePriceScheme

Price scheme (related name: danceprice)

price_scheme_id¶: Internal field, use price_scheme instead.

class squaresdb.gate.models.DancePriceScheme(id, name, notes, active)[source]¶

Bases: Model

Parameters:

id (BigAutoField) – Primary key: ID
name (CharField) – Name
notes (TextField) – Notes
active (BooleanField) – Active

Reverse relationships:

Parameters:

danceprice (Reverse ForeignKey from DancePrice) – All dance prices of this dance price scheme (related name of price_scheme)
dance (Reverse ForeignKey from Dance) – All dances of this dance price scheme (related name of price_scheme)

exception DoesNotExist¶: Bases: ObjectDoesNotExist

exception MultipleObjectsReturned¶: Bases: MultipleObjectsReturned

exception NotUpdated¶: Bases: ObjectNotUpdated, DatabaseError

active¶

Type: BooleanField

Active

dance_set¶

Type: Reverse ForeignKey from Dance

All dances of this dance price scheme (related name of price_scheme)

danceprice_set¶

Type: Reverse ForeignKey from DancePrice

All dance prices of this dance price scheme (related name of price_scheme)

id¶

Type: BigAutoField

Primary key: ID

name¶

Type: CharField

Name

notes¶

Type: TextField

Notes

objects = <django.db.models.Manager object>¶

class squaresdb.gate.models.Payment(id, person, at_dance, time, payment_type, amount, fee_cat, notes)[source]¶

Bases: Model

Parameters:

id (BigAutoField) – Primary key: ID
time (DateTimeField) – Time
amount (DecimalField) – Amount
notes (TextField) – Notes

Relationship fields:

Parameters:

person (ForeignKey to Person) – Person (related name: payment)
at_dance (ForeignKey to Dance) – At dance (related name: payment)
payment_type (ForeignKey to PaymentMethod) – Payment type (related name: payment)
fee_cat (ForeignKey to FeeCategory) – Fee cat (related name: payment)

Reverse relationships:

Parameters:

subscriptionpayment (Reverse OneToOneField from SubscriptionPayment) – The subscription payment of this payment (related name of payment_ptr)
dancepayment (Reverse OneToOneField from DancePayment) – The dance payment of this payment (related name of payment_ptr)
attendee (Reverse ForeignKey from Attendee) – All attendees of this payment (related name of payment)

exception DoesNotExist¶: Bases: ObjectDoesNotExist

exception MultipleObjectsReturned¶: Bases: MultipleObjectsReturned

exception NotUpdated¶: Bases: ObjectNotUpdated, DatabaseError

amount¶

Type: DecimalField

Amount

at_dance¶

Type: ForeignKey to Dance

At dance (related name: payment)

at_dance_id¶: Internal field, use at_dance instead.

attendee_set¶

Type: Reverse ForeignKey from Attendee

All attendees of this payment (related name of payment)

dancepayment¶

Type: Reverse OneToOneField from DancePayment

The dance payment of this payment (related name of payment_ptr)

fee_cat¶

Type: ForeignKey to FeeCategory

Fee cat (related name: payment)

fee_cat_id¶: Internal field, use fee_cat instead.

get_next_by_time(*, field=<django.db.models.DateTimeField: time>, is_next=True, **kwargs)¶: Finds next instance based on time. See get_next_by_FOO() for more information.

get_previous_by_time(*, field=<django.db.models.DateTimeField: time>, is_next=False, **kwargs)¶: Finds previous instance based on time. See get_previous_by_FOO() for more information.

id¶

Type: BigAutoField

Primary key: ID

notes¶

Type: TextField

Notes

objects = <django.db.models.Manager object>¶

payment_type¶

Type: ForeignKey to PaymentMethod

Payment type (related name: payment)

payment_type_id¶: Internal field, use payment_type instead.

person¶

Type: ForeignKey to Person

Person (related name: payment)

person_id¶: Internal field, use person instead.

subscriptionpayment¶

Type: Reverse OneToOneField from SubscriptionPayment

The subscription payment of this payment (related name of payment_ptr)

time¶

Type: DateTimeField

Time

class squaresdb.gate.models.PaymentMethod(slug, name, in_gate)[source]¶

Bases: Model

Parameters:

slug (SlugField) – Primary key: Slug
name (CharField) – Name
in_gate (BooleanField) – In gate

Reverse relationships:

Parameters:: payment (Reverse ForeignKey from Payment) – All payments of this payment method (related name of payment_type)

exception DoesNotExist¶: Bases: ObjectDoesNotExist

exception MultipleObjectsReturned¶: Bases: MultipleObjectsReturned

exception NotUpdated¶: Bases: ObjectNotUpdated, DatabaseError

in_gate¶

Type: BooleanField

In gate

name¶

Type: CharField

Name

objects = <django.db.models.Manager object>¶

payment_set¶

Type: Reverse ForeignKey from Payment

All payments of this payment method (related name of payment_type)

slug¶

Type: SlugField

Primary key: Slug

class squaresdb.gate.models.SubscriptionLineItem(id, transaction, amount, account_name, label, notes, lineitem_ptr, sub_period, subscriber_name, person)[source]¶

Bases: LineItem

Parameters:

id (BigAutoField) – Primary key: ID
amount (DecimalField) – Amount
account_name (CharField) – Account name
label (CharField) – Label
notes (TextField) – Notes
subscriber_name (CharField) – Subscriber name

Relationship fields:

Parameters:

transaction (ForeignKey to Transaction) – Transaction (related name: lineitem)
lineitem_ptr (OneToOneField to LineItem) – Primary key: Lineitem ptr (related name: subscriptionlineitem)
sub_period (ForeignKey to SubscriptionPeriod) – Sub period (related name: subscriptionlineitem)
person (ForeignKey to Person) – Person (related name: subscriptionlineitem)

exception DoesNotExist¶: Bases: DoesNotExist

exception MultipleObjectsReturned¶: Bases: MultipleObjectsReturned

exception NotUpdated¶: Bases: NotUpdated

lineitem_ptr¶

Type: OneToOneField to LineItem

Primary key: Lineitem ptr (related name: subscriptionlineitem)

lineitem_ptr_id¶: Internal field, use lineitem_ptr instead.

person¶

Type: ForeignKey to Person

Person (related name: subscriptionlineitem)

person_id¶: Internal field, use person instead.

sub_period¶

Type: ForeignKey to SubscriptionPeriod

Sub period (related name: subscriptionlineitem)

sub_period_id¶: Internal field, use sub_period instead.

subscriber_name¶

Type: CharField

Subscriber name

class squaresdb.gate.models.SubscriptionPayment(id, person, at_dance, time, payment_type, amount, fee_cat, notes, payment_ptr)[source]¶

Bases: Payment

Parameters:

id (BigAutoField) – Primary key: ID
time (DateTimeField) – Time
amount (DecimalField) – Amount
notes (TextField) – Notes

Relationship fields:

Parameters:

person (ForeignKey to Person) – Person (related name: payment)
at_dance (ForeignKey to Dance) – At dance (related name: payment)
payment_type (ForeignKey to PaymentMethod) – Payment type (related name: payment)
fee_cat (ForeignKey to FeeCategory) – Fee cat (related name: payment)
payment_ptr (OneToOneField to Payment) – Primary key: Payment ptr (related name: subscriptionpayment)
periods (ManyToManyField to SubscriptionPeriod) – Periods (related name: subscriptionpayment)

Reverse relationships:

Parameters:: attendee (Reverse ForeignKey from Attendee) – All attendees of this payment (related name of payment)

exception DoesNotExist¶: Bases: DoesNotExist

exception MultipleObjectsReturned¶: Bases: MultipleObjectsReturned

exception NotUpdated¶: Bases: NotUpdated

payment_ptr¶

Type: OneToOneField to Payment

Primary key: Payment ptr (related name: subscriptionpayment)

payment_ptr_id¶: Internal field, use payment_ptr instead.

periods¶

Type: ManyToManyField to SubscriptionPeriod

Periods (related name: subscriptionpayment)

class squaresdb.gate.models.SubscriptionPeriod(slug, name, start_date, end_date)[source]¶

Bases: Model

Parameters:

slug (SlugField) – Primary key: Slug
name (CharField) – Name
start_date (DateField) – Start date
end_date (DateField) – End date

Reverse relationships:

Parameters:

subscriptionperiodprice (Reverse ForeignKey from SubscriptionPeriodPrice) – All subscription period prices of this subscription period (related name of period)
dance (Reverse ForeignKey from Dance) – All dances of this subscription period (related name of period)
subscriptionpayment (Reverse ManyToManyField from SubscriptionPayment) – All subscription payments of this subscription period (related name of periods)
subscriptionlineitem (Reverse ForeignKey from SubscriptionLineItem) – All subscription line items of this subscription period (related name of sub_period)

exception DoesNotExist¶: Bases: ObjectDoesNotExist

exception MultipleObjectsReturned¶: Bases: MultipleObjectsReturned

exception NotUpdated¶: Bases: ObjectNotUpdated, DatabaseError

dance_set¶

Type: Reverse ForeignKey from Dance

All dances of this subscription period (related name of period)

end_date¶

Type: DateField

End date

get_absolute_url()[source]¶

get_next_by_end_date(*, field=<django.db.models.DateField: end_date>, is_next=True, **kwargs)¶: Finds next instance based on end_date. See get_next_by_FOO() for more information.

get_next_by_start_date(*, field=<django.db.models.DateField: start_date>, is_next=True, **kwargs)¶: Finds next instance based on start_date. See get_next_by_FOO() for more information.

get_previous_by_end_date(*, field=<django.db.models.DateField: end_date>, is_next=False, **kwargs)¶: Finds previous instance based on end_date. See get_previous_by_FOO() for more information.

get_previous_by_start_date(*, field=<django.db.models.DateField: start_date>, is_next=False, **kwargs)¶: Finds previous instance based on start_date. See get_previous_by_FOO() for more information.

name¶

Type: CharField

Name

objects = <django.db.models.Manager object>¶

slug¶

Type: SlugField

Primary key: Slug

start_date¶

Type: DateField

Start date

subscriptionlineitem_set¶

Type: Reverse ForeignKey from SubscriptionLineItem

All subscription line items of this subscription period (related name of sub_period)

subscriptionpayment_set¶

Type: Reverse ManyToManyField from SubscriptionPayment

All subscription payments of this subscription period (related name of periods)

subscriptionperiodprice_set¶

Type: Reverse ForeignKey from SubscriptionPeriodPrice

All subscription period prices of this subscription period (related name of period)

class squaresdb.gate.models.SubscriptionPeriodPrice(id, period, fee_cat, low, high)[source]¶

Bases: Model

Parameters:

id (BigAutoField) – Primary key: ID
low (IntegerField) – Low
high (IntegerField) – High

Relationship fields:

Parameters:

period (ForeignKey to SubscriptionPeriod) – Period (related name: subscriptionperiodprice)
fee_cat (ForeignKey to FeeCategory) – Fee cat (related name: subscriptionperiodprice)