def __setup__(cls):
super().__setup__()
t = cls.__table__()
cls._sql_constraints = [
('email_list_unique', Unique(t, t.email, t.list_),
'marketing.msg_email_list_unique'),
]
def __setup__(cls):
super(Line, cls).__setup__()
t = cls.__table__()
cls._sql_constraints = [
('uuid_unique', Unique(t,
t.uuid), 'timesheet.msg_line_uuid_unique'),
]
cls._order.insert(0, ('date', 'DESC'))
def __setup__(cls):
super(UserSession, cls).__setup__()
table = cls.__table__()
cls.__rpc__ = {}
cls._sql_constraints += [
('key_unique', Unique(table, table.key),
'web_user.msg_user_session_key_unique'),
]
def __setup__(cls):
super(GeneVariantPhenotype, cls).__setup__()
t = cls.__table__()
cls._sql_constraints = [
('code', Unique(t,t.name),
'This code already exists'),
]
def __setup__(cls):
super(Sale, cls).__setup__()
t = cls.__table__()
cls._sql_constraints.extend([
('number_external_uniq', Unique(t, t.shop, t.number_external),
'There is another sale with the same number external.\n'
'The number external of the sale must be unique!')
])
def __setup__(cls):
super(Token, cls).__setup__()
t = cls.__table__()
cls._sql_constraints += [('token_uniq_key', Unique(t, t.key),
'api_token.msg_token_uniq_key')]
cls._buttons.update({
'generate_key': {},
})
def __setup__(cls):
super(ProteinDisease, cls).__setup__()
t = cls.__table__()
cls._sql_constraints = [
('name_unique', Unique(t,t.name),
'The Disease Code name must be unique'),
]
def __setup__(cls):
super(ForecastLine, cls).__setup__()
cls.__access__.add('forecast')
t = cls.__table__()
cls._sql_constraints += [
('forecast_product_uniq', Unique(t, t.forecast, t.product),
'stock_forecast.msg_forecast_line_product_unique'),
]
def __setup__(cls):
super().__setup__()
t = cls.__table__()
cls._sql_constraints = [
('size_unique', Unique(t, t.avatar, t.size),
'ir.msg_avatar_size_unique'),
]
cls._order.append(('size', 'ASC'))
def __setup__(cls):
super(Factor, cls).__setup__()
cls._order.insert(0, ('unit', 'ASC'))
t = cls.__table__()
cls._sql_constraints += [
('factor_uniq', Unique(t, t.unit, t.condofactor),
'This factor is already defined for this apartment/unit!')
]
def __setup__(cls):
super(CondoParty, cls).__setup__()
cls._order.insert(0, ('unit', 'ASC'))
t = cls.__table__()
cls._sql_constraints += [
('party_uniq', Unique(t, t.unit, t.party),
'Party must be unique in each apartment/unit!')
]
def __setup__(cls):
super(InvoiceChorus, cls).__setup__()
t = cls.__table__()
cls._sql_constraints = [
('invoice_unique', Unique(t, t.invoice),
'account_fr_chorus.msg_invoice_unique'),
]
def __setup__(cls):
super(FederationObject, cls).__setup__()
t = cls.__table__()
cls._sql_constraints = [('model_uniq', Unique(t, t.model),
'The Model is already defined !')]
cls.__rpc__.update({
'get_object_fields': RPC(check_access=False),
})
def __setup__(cls):
super(Party, cls).__setup__()
t = cls.__table__()
cls._sql_constraints = [
('code_uniq', Unique(t, t.code),
'The code of the party must be unique.')
]
cls._order.insert(0, ('name', 'ASC'))
def __setup__(cls):
super(DiseaseGene, cls).__setup__()
t = cls.__table__()
cls._sql_constraints = [
('name_unique', Unique(t, t.name),
'The Official Symbol name must be unique'),
]
def __setup__(cls):
super().__setup__()
cls.symbol.size = 30
t = cls.__table__()
cls._sql_constraints += [
('symbol_uniq', Unique(t,
t.symbol), 'lims.msg_uom_symbol_unique_id'),
]
def __setup__(cls):
super(Dunning, cls).__setup__()
table = cls.__table__()
cls._sql_constraints = [
('line_unique', Unique(table, table.line),
'account_dunning.msg_dunning_line_unique'),
]
cls._active_field = 'active'
def __setup__(cls):
super(Journal, cls).__setup__()
cls._order.insert(0, ('name', 'ASC'))
t = cls.__table__()
cls._sql_constraints = [
('bank_account_unique', Unique(t, t.bank_account, t.company),
'account_statement.msg_journal_bank_account_unique'),
]
def __setup__(cls):
super(Move, cls).__setup__()
t = cls.__table__()
cls._sql_constraints += [
('report_unique', Unique(t, t.group, t.period),
'Report repeated. You only can have one report by month and cruch. '),
]
cls._check_modify_exclude = []
cls._order.insert(0, ('date', 'DESC'))
cls._order.insert(1, ('number', 'DESC'))
cls._error_messages.update({
'post_empty_move': ('You can not post move "%s" because it is '
'empty.'),
'amount_can_not_be_zero': ('Amount to record can not be zero.'),
'modify_move': ('You can not modify move "%s" because '
'it is posted or cancelled.'),
'delete_cancel': ('Move "%s" must be cancelled before '
'deletion.'),
'delete_numbered': ('The numbered move "%s" can not be '
'deleted.'),
'date_outside_period': ('You can not create move "%(move)s" '
'because its date is outside its period.'),
})
cls._transitions |= set((
('draft', 'quotation'),
('draft', 'canceled'),
('quotation', 'posted'),
('quotation', 'draft'),
('quotation', 'canceled'),
('posted', 'quotation'),
))
cls._buttons.update({
'cancel': {
'invisible': ~Eval('state').in_(['draft', 'quotation']),
'icon': 'tryton-cancel',
'depends': ['state'],
},
'draft': {
'invisible': Eval('state').in_(['draft','posted','canceled']),
'icon': If(Eval('state') == 'canceled',
'tryton-clear', 'tryton-go-previous'),
'depends': ['state'],
},
'quote': {
'invisible': Eval('state') != 'draft',
'icon': 'tryton-go-next',
'depends': ['state'],
},
'post': {
'invisible': Eval('state') != 'quotation',
'icon': 'tryton-ok',
'depends': ['state'],
},
})
cls.__rpc__.update({
'post': RPC(
readonly=False, instantiate=0, fresh_session=True),
})
def __setup__(cls):
super(EmployeeCostPrice, cls).__setup__()
t = cls.__table__()
cls._sql_constraints = [
('employee_date_cost_price_uniq',
Unique(t, t.employee, t.date, t.cost_price),
'A employee can only have one cost price by date.'),
]
cls._order.insert(0, ('date', 'DESC'))
def __setup__(cls):
super(EmployeeCostPrice, cls).__setup__()
t = cls.__table__()
cls._sql_constraints = [
('employee_date_cost_price_uniq',
Unique(t, t.employee, t.date, t.cost_price),
'timesheet_cost.msg_employee_unique_cost_price_date'),
]
cls._order.insert(0, ('date', 'DESC'))
def __setup__(cls):
super(Unit, cls).__setup__()
cls._order.insert(0, ('company', 'ASC'))
cls._order.insert(1, ('name', 'ASC'))
t = cls.__table__()
cls._sql_constraints += [
('unit_unique', Unique(t, t.company, t.name),
'The apartment/unit must be unique in each condominium!')
]
def __setup__(cls):
super().__setup__()
cls._order.insert(0, ('party', 'ASC'))
cls._order.insert(1, ('name', 'ASC'))
t = cls.__table__()
cls._sql_constraints = [
('name_unique', Unique(t, t.party, t.name),
'lims_industry.msg_plant_name_unique'),
]
def __setup__(cls):
super(Party, cls).__setup__()
t = cls.__table__()
cls._sql_constraints = [('code_uniq', Unique(t, t.code),
'party.msg_party_code_unique')]
cls._order.insert(0, ('name', 'ASC'))
cls.active.states.update({
'readonly': Bool(Eval('replaced_by')),
})
cls.active.depends.append('replaced_by')
def __setup__(cls):
super().__setup__()
t = cls.__table__()
cls._sql_constraints += [
('sale_shipment_cost_unique',
Unique(t, t.sale, t.shipment_cost),
'sale_shipment_cost.msg_sale_shipment_cost_unique'),
]
# shipment_cost is needed to compute the unit_price
cls.unit_price.depends.add('shipment_cost')
def __setup__(cls):
super(Rate, cls).__setup__()
t = cls.__table__()
cls._sql_constraints = [
('date_currency_uniq', Unique(t, t.date, t.currency),
'A currency can only have one rate by date.'),
('check_currency_rate', Check(t, t.rate >= 0),
'The currency rate must greater than or equal to 0'),
]
cls._order.insert(0, ('date', 'DESC'))
def __setup__(cls):
"""
Setup the class before adding to pool
"""
super(ChannelPaymentGateway, cls).__setup__()
table = cls.__table__()
cls._sql_constraints += [
('code_channel_unique', Unique(table, table.code, table.channel),
'Payment gateway already exists for this channel')
]
def __setup__(cls):
super(Rate, cls).__setup__()
t = cls.__table__()
cls._sql_constraints = [
('date_currency_uniq', Unique(t, t.date, t.currency),
'currency.msg_currency_unique_rate_date'),
('check_currency_rate', Check(t, t.rate >= 0),
'currency.msg_currency_rate_positive'),
]
cls._order.insert(0, ('date', 'DESC'))
def __setup__(cls):
super(FederationQueue, cls).__setup__()
t = cls.__table__()
cls._sql_constraints = [
('msgid_uniq', Unique(t,t.msgid), \
'The Message ID must be unique !'),]
cls._buttons.update({
'send': {'invisible': Equal(Eval('state'), 'sent')}
})
def __setup__(cls):
super(BankAccountNumber, cls).__setup__()
t = cls.__table__()
cls._sql_constraints += [('bankaccountnumber_uniq',
Unique(t, t.type, t.number_compact),
'This bank account number already exists!')]
cls._error_messages.update({
'invalid_iban': 'Invalid IBAN "%s".',
'invalid_bban': 'Invalid BBAN "%s".'
})
