<commit_before>#########################################################################
# HOUSE TABLE
#########################################################################
db.define_table(
 'house',
 Field('Name', 'string', default=''),
 Field('Address', 'string', default=''),
 Field('City', 'string', default=''),
 Field('State', 'string', default=''),
 Field('ZIP', 'integer', default='0'),
 Field('Members', 'list:reference auth_user'),
 format = '%(name)s House',
 singular = 'House',
 plural = 'Houses',
)

db.house.Name.requires = db.house.Members.requires = IS_NOT_EMPTY()

#########################################################################
# TRANSACTION TABLE
#########################################################################
db.define_table(
 'transaction_table',
 Field('author', 'reference auth_user'),
 Field('total', 'double', default='0.0'),
 Field('title', 'string', default='New Transaction'),
)

#db.transaction_table.author.requires = IS_NOT_EMPTY()


#########################################################################
# PAYMENT TABLE
#########################################################################
db.define_table(
 'payment',
 Field('transaction_n', 'reference  transaction_table'),
 Field('payer', 'reference  auth_user'),
 Field('amount', 'double', default='0.0'),
 Field('receiver', 'reference  auth_user'),
 Field('state', 'string', default='null'),
)

db.payment.transaction_n.requires = db.payment.payer.requires = IS_NOT_EMPTY()
db.payment.receiver.requires = IS_NOT_EMPTY()<commit_msg>fixed payment table so payer and receiver work. There was an extra space in the database -__-<commit_after>#########################################################################
# HOUSE TABLE
#########################################################################
db.define_table(
 'house',
 Field('Name', 'string', default=''),
 Field('Address', 'string', default=''),
 Field('City', 'string', default=''),
 Field('State', 'string', default=''),
 Field('ZIP', 'integer', default='0'),
 Field('Members', 'list:reference auth_user'),
 format = '%(name)s House',
 singular = 'House',
 plural = 'Houses',
)

db.house.Name.requires = db.house.Members.requires = IS_NOT_EMPTY()

#########################################################################
# TRANSACTION TABLE
#########################################################################
db.define_table(
 'transaction_table',
 Field('author', 'reference auth_user'),
 Field('total', 'double', default='0.0'),
 Field('title', 'string', default='New Transaction'),
)

#db.transaction_table.author.requires = IS_NOT_EMPTY()


#########################################################################
# PAYMENT TABLE
#########################################################################
db.define_table(
 'payment',
 Field('transaction_n', 'reference  transaction_table'),
 Field('payer', 'reference auth_user'),
 Field('amount', 'double', default='0.0'),
 Field('receiver', 'reference auth_user'),
 Field('state', 'string', default='null'),
)

db.payment.transaction_n.requires = db.payment.payer.requires = IS_NOT_EMPTY()
db.payment.receiver.requires = IS_NOT_EMPTY()
{'fraction_non_alphanumeric': 0.4166666666666667, 'fraction_numerical': 0.0031446540880503146, 'mean_word_length': 9.395424836601308, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4177245', 'n_tokens_mistral': 821, 'n_tokens_neox': 786, 'n_words': 161}