|
|
1.
|
|
|
Code should always set a variable named `result` with the result of your test, that can be a list or 
a dictionary. If `result` is an empty list, it means that the test was succesful. Otherwise it will
try to translate and print what is inside `result`.
If the result of your test is a dictionary, you can set a variable named `column_order` to choose in
what order you want to print `result`'s content.
Should you need them, you can also use the following variables into your code:
* cr: cursor to the database
* uid: ID of the current user
In any ways, the code must be legal python statements with correct indentation (if needed).
Example:
sql = '''SELECT id, name, ref, date
FROM account_move_line
WHERE account_id IN (SELECT id FROM account_account WHERE type = 'view')
'''
cr.execute(sql)
result = cr.dictfetchall() |
|
|
module: account_test
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
|
De code dient altijd een variabele in te stellen, met de naam 'result'. deze bevat het resultaat van de test. Dit kan een lijst of een woordenboek zijn. Indien 'result' een lege lijst is, betekend het dat de test succesvol was. Anders zal het proberen het resultaat te vertalen en af te drukken.
Als het resultaat van uw test een woordenboek is, kunt u een variabele met de naam 'column_order' instellen, om in te stellen in welke volgorde u de inhoud van 'result' wilt afdrukken.
Indien u ze nodig heeft kunt u de volgende variabelen in uw code gebruiken:
* cr: cursor to the database
* uid: ID of the current user
In ieder geval moet de code correcte python statements bevatten met de juiste inspringingen (indien nodig).
Voorbeeld:
sql = '''SELECT id, name, ref, date
FROM account_move_line
WHERE account_id IN (SELECT id FROM account_account WHERE type = 'view')
'''
cr.execute(sql)
result = cr.dictfetchall() |
|
Translated by
Christophe Simonis (OpenERP)
|
|
|
|
Located in
view:accounting.assert.test:0
|
|
|
2.
|
|
|
Test 2: Opening a fiscal year
|
|
|
module: account_test
|
|
|
|
|
Test 2: Open een boekjaar
|
|
Translated by
Christophe Simonis (OpenERP)
|
|
|
|
Located in
model:accounting.assert.test,name:account_test.account_test_02
|
|
|
3.
|
|
|
Check that reconciled invoice for Sales/Purchases has reconciled entries for Payable and Receivable Accounts
|
|
|
module: account_test
|
|
|
|
|
Controleer of afgeletterde factuur van verkoop/inkoop een afgeletterde regel heeft op de crediteuren en debiteuren rekening.
|
|
Translated by
Christophe Simonis (OpenERP)
|
|
|
|
Located in
model:accounting.assert.test,desc:account_test.account_test_05
|
|
|
4.
|
|
|
Check if movement lines are balanced and have the same date and period
|
|
|
module: account_test
|
|
|
|
|
Controleer of boekingen in balans zijn en dezelfde datum en periode hebben
|
|
Translated by
Christophe Simonis (OpenERP)
|
|
|
|
Located in
model:accounting.assert.test,desc:account_test.account_test_03
|
|
|
5.
|
|
|
Test Name
|
|
|
module: account_test
|
|
|
|
|
Test naam
|
|
Translated by
Christophe Simonis (OpenERP)
|
|
|
|
Located in
field:accounting.assert.test,name:0
|
|
|
6.
|
|
|
Accouting tests on
|
|
|
module: account_test
|
|
|
|
|
Financiële test op
|
|
Translated by
Christophe Simonis (OpenERP)
|
|
|
|
Located in
report:account.test.assert.print:0
|
|
|
7.
|
|
|
Test 1: General balance
|
|
|
module: account_test
|
|
|
|
|
Test 1: Algemene balans
|
|
Translated by
Christophe Simonis (OpenERP)
|
|
|
|
Located in
model:accounting.assert.test,name:account_test.account_test_01
|
|
|
8.
|
|
|
Check that paid/reconciled invoices are not in 'Open' state
|
|
|
module: account_test
|
|
|
|
|
Controleer of betaalde/afgeletterde facturen zich niet in de 'Open' staat bevinden
|
|
Translated by
Christophe Simonis (OpenERP)
|
|
|
|
Located in
model:accounting.assert.test,desc:account_test.account_test_06
|
|
|
9.
|
|
|
Check that reconciled account moves, that define Payable and Receivable accounts, are belonging to reconciled invoices
|
|
|
module: account_test
|
|
|
|
|
Controleer of afgelletterde boekingen op de crediteuren en debiteuren rekeningen, behoren aan afgeletterde facturen.
|
|
Translated by
Christophe Simonis (OpenERP)
|
|
|
|
Located in
model:accounting.assert.test,desc:account_test.account_test_05_2
|
|
|
10.
|
|
|
Tests
|
|
|
module: account_test
|
|
|
|
|
Testen
|
|
Translated by
Christophe Simonis (OpenERP)
|
|
|
|
Located in
view:accounting.assert.test:0
|
