def test_file_has_creation_datetime_in_group_header(self, app):
# Given
offerer = create_offerer()
user = create_user()
venue = create_venue(offerer)
stock = create_stock_from_offer(create_offer_with_thing_product(venue))
booking = create_booking(user, stock)
payment1 = create_payment(booking,
offerer,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555')
payment2 = create_payment(booking,
offerer,
Decimal(20),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555')
payments = [payment1, payment2]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
assert find_node('//ns:GrpHdr/ns:CreDtTm', xml) == '2018-10-15T09:21:34', \
'The creation datetime should look like YYYY-MM-DDTHH:MM:SS"'
def test_file_has_custom_message_id_in_group_header(self, app):
# Given
offerer = create_offerer()
user = create_user()
venue = create_venue(offerer)
stock = create_stock_from_offer(create_offer_with_thing_product(venue))
booking = create_booking(user, stock)
payment1 = create_payment(booking,
offerer,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555')
payment2 = create_payment(booking,
offerer,
Decimal(20),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555')
payments = [payment1, payment2]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
assert find_node('//ns:GrpHdr/ns:MsgId', xml) == MESSAGE_ID, \
'The message id should look like "passCulture-SCT-YYYYMMDD-HHMMSS"'
def test_file_has_ultimate_debtor_in_transaction_info(self, app):
# Given
offerer = create_offerer()
user = create_user()
venue = create_venue(offerer)
stock = create_stock_from_offer(create_offer_with_thing_product(venue))
booking = create_booking(user, stock)
payment1 = create_payment(booking,
offerer,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555')
payment2 = create_payment(booking,
offerer,
Decimal(20),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555')
payments = [payment1, payment2]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
assert find_node('//ns:PmtInf/ns:CdtTrfTxInf/ns:UltmtDbtr/ns:Nm', xml) == 'pass Culture', \
'The ultimate debtor name should be "pass Culture"'
def test_file_has_initiating_party_in_group_header(self, app):
# Given
offerer = create_offerer()
user = create_user()
venue = create_venue(offerer)
stock = create_stock_from_offer(create_offer_with_thing_product(venue))
booking = create_booking(user, stock)
payment1 = create_payment(booking,
offerer,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555')
payment2 = create_payment(booking,
offerer,
Decimal(20),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555')
payments = [payment1, payment2]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
assert find_node('//ns:GrpHdr/ns:InitgPty/ns:Nm', xml) == 'pass Culture', \
'The initiating party should be "pass Culture"'
def test_read_message_name_in_message_file_returns_the_content_of_message_id_tag(
app):
# given
offerer = create_offerer()
user = create_user()
venue = create_venue(offerer)
stock = create_stock_from_offer(create_offer_with_thing_product(venue))
booking = create_booking(user, stock)
payment1 = create_payment(booking,
offerer,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555')
payment2 = create_payment(booking,
offerer,
Decimal(20),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555')
payments = [payment1, payment2]
xml_file = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# when
message_id = read_message_name_in_message_file(xml_file)
# then
assert message_id == MESSAGE_ID
def test_file_has_bic_in_credit_transfer_transaction_info(self, app):
# Given
offerer1 = create_offerer(name='first offerer')
offerer2 = create_offerer(name='second offerer')
offerer3 = create_offerer(name='third offerer')
user = create_user()
venue1 = create_venue(offerer1)
venue2 = create_venue(offerer2)
venue3 = create_venue(offerer3)
stock1 = create_stock_from_offer(
create_offer_with_thing_product(venue1))
stock2 = create_stock_from_offer(
create_offer_with_thing_product(venue2))
stock3 = create_stock_from_offer(
create_offer_with_thing_product(venue3))
booking1 = create_booking(user, stock1)
booking2 = create_booking(user, stock2)
booking3 = create_booking(user, stock3)
payments = [
create_payment(
booking1,
offerer1,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555',
transaction_label='remboursement 1ère quinzaine 09-2018'),
create_payment(
booking2,
offerer2,
Decimal(20),
iban='FR14WXCVBN123456',
bic='WXCVBN7B444',
transaction_label='remboursement 1ère quinzaine 09-2018'),
create_payment(
booking3,
offerer3,
Decimal(20),
iban=None,
bic=None,
transaction_label='remboursement 1ère quinzaine 09-2018')
]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
assert find_all_nodes('//ns:PmtInf/ns:CdtTrfTxInf/ns:RmtInf/ns:Ustrd', xml)[0] \
== 'remboursement 1ère quinzaine 09-2018'
assert find_all_nodes('//ns:PmtInf/ns:CdtTrfTxInf/ns:RmtInf/ns:Ustrd', xml)[1] \
== 'remboursement 1ère quinzaine 09-2018'
def test_file_has_recipient_name_and_siren_in_creditor_info(self, app):
# Given
offerer1 = create_offerer(name='first offerer', siren='123456789')
offerer2 = create_offerer(name='second offerer', siren='987654321')
offerer3 = create_offerer()
user = create_user()
venue1 = create_venue(offerer1)
venue2 = create_venue(offerer2)
venue3 = create_venue(offerer3)
stock1 = create_stock_from_offer(
create_offer_with_thing_product(venue1))
stock2 = create_stock_from_offer(
create_offer_with_thing_product(venue2))
stock3 = create_stock_from_offer(
create_offer_with_thing_product(venue3))
booking1 = create_booking(user, stock1)
booking2 = create_booking(user, stock2)
booking3 = create_booking(user, stock3)
payments = [
create_payment(booking1,
offerer1,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555'),
create_payment(booking2,
offerer2,
Decimal(20),
iban='FR14WXCVBN123456',
bic='WXCVBN7B444'),
create_payment(booking3,
offerer3,
Decimal(20),
iban=None,
bic=None)
]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
assert find_all_nodes('//ns:PmtInf/ns:CdtTrfTxInf/ns:Cdtr/ns:Nm',
xml)[0] == 'first offerer'
assert find_all_nodes(
'//ns:PmtInf/ns:CdtTrfTxInf/ns:Cdtr/ns:Id/ns:OrgId/ns:Othr/ns:Id',
xml)[0] == '123456789'
assert find_all_nodes('//ns:PmtInf/ns:CdtTrfTxInf/ns:Cdtr/ns:Nm',
xml)[1] == 'second offerer'
assert find_all_nodes(
'//ns:PmtInf/ns:CdtTrfTxInf/ns:Cdtr/ns:Id/ns:OrgId/ns:Othr/ns:Id',
xml)[1] == '987654321'
def test_file_has_iban_in_credit_transfer_transaction_info(self, app):
# Given
offerer1 = create_offerer()
offerer2 = create_offerer()
offerer3 = create_offerer()
user = create_user()
venue1 = create_venue(offerer1)
venue2 = create_venue(offerer2)
venue3 = create_venue(offerer3)
stock1 = create_stock_from_offer(
create_offer_with_thing_product(venue1))
stock2 = create_stock_from_offer(
create_offer_with_thing_product(venue2))
stock3 = create_stock_from_offer(
create_offer_with_thing_product(venue3))
booking1 = create_booking(user, stock1)
booking2 = create_booking(user, stock2)
booking3 = create_booking(user, stock3)
payments = [
create_payment(booking1,
offerer1,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555'),
create_payment(booking2,
offerer2,
Decimal(20),
iban='FR14WXCVBN123456',
bic='WXCVBN7B444'),
create_payment(booking3,
offerer3,
Decimal(20),
iban=None,
bic=None)
]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
assert find_all_nodes(
'//ns:PmtInf/ns:CdtTrfTxInf/ns:CdtrAcct/ns:Id/ns:IBAN',
xml)[0] == 'CF13QSDFGH456789'
assert find_all_nodes(
'//ns:PmtInf/ns:CdtTrfTxInf/ns:CdtrAcct/ns:Id/ns:IBAN',
xml)[1] == 'FR14WXCVBN123456'
def test_file_has_amount_in_credit_transfer_transaction_info(self, app):
# Given
offerer1 = create_offerer(name='first offerer')
offerer2 = create_offerer(name='second offerer')
user = create_user()
venue1 = create_venue(offerer1)
venue2 = create_venue(offerer2)
stock1 = create_stock_from_offer(
create_offer_with_thing_product(venue1))
stock2 = create_stock_from_offer(
create_offer_with_thing_product(venue1))
stock3 = create_stock_from_offer(
create_offer_with_thing_product(venue2))
booking1 = create_booking(user, stock1)
booking2 = create_booking(user, stock2)
booking3 = create_booking(user, stock3)
payments = [
create_payment(booking1,
offerer1,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555'),
create_payment(booking2,
offerer1,
Decimal(20),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555'),
create_payment(booking3,
offerer2,
Decimal(20),
iban='FR14WXCVBN123456',
bic='WXCVBN7B444')
]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
nodes_amount = find_all_nodes(
'//ns:PmtInf/ns:CdtTrfTxInf/ns:Amt/ns:InstdAmt', xml)
assert nodes_amount[0] == '30'
assert nodes_amount[1] == '20'
def test_generate_file_checksum_returns_a_checksum_of_the_file(
mocked_uuid, app):
# given
offerer1 = create_offerer(name='first offerer')
offerer2 = create_offerer(name='second offerer')
user = create_user()
venue1 = create_venue(offerer1)
venue2 = create_venue(offerer2)
stock1 = create_stock_from_offer(create_offer_with_thing_product(venue1))
stock2 = create_stock_from_offer(create_offer_with_thing_product(venue1))
stock3 = create_stock_from_offer(create_offer_with_thing_product(venue2))
booking1 = create_booking(user, stock1)
booking2 = create_booking(user, stock2)
booking3 = create_booking(user, stock3)
payments = [
create_payment(booking1,
offerer1,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555'),
create_payment(booking2,
offerer1,
Decimal(20),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555'),
create_payment(booking3,
offerer2,
Decimal(20),
iban='FR14WXCVBN123456',
bic='WXCVBN7B444')
]
uuid1 = UUID(hex='abcd1234abcd1234abcd1234abcd1234', version=4)
uuid2 = UUID(hex='cdef5678cdef5678cdef5678cdef5678', version=4)
mocked_uuid.side_effect = [uuid1, uuid2]
xml = generate_message_file(payments, 'BD12AZERTY123456', 'AZERTY9Q666',
MESSAGE_ID, '0000')
# when
checksum = generate_file_checksum(xml)
# then
assert checksum == b'\x16\x91\x0c\x11~Hs\xc5\x1a\xa3W1\x13\xbf!jq@\xea <h&\xef\x1f\xaf\xfc\x7fO\xc8\x82'
def test_file_has_number_of_transactions_in_payment_info(self, app):
# Given
offerer1 = create_offerer()
offerer2 = create_offerer()
offerer3 = create_offerer()
user = create_user()
venue1 = create_venue(offerer1)
venue2 = create_venue(offerer2)
venue3 = create_venue(offerer3)
stock1 = create_stock_from_offer(
create_offer_with_thing_product(venue1))
stock2 = create_stock_from_offer(
create_offer_with_thing_product(venue2))
stock3 = create_stock_from_offer(
create_offer_with_thing_product(venue3))
booking1 = create_booking(user, stock1)
booking2 = create_booking(user, stock2)
booking3 = create_booking(user, stock3)
payments = [
create_payment(booking1,
offerer1,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555'),
create_payment(booking2,
offerer2,
Decimal(20),
iban='FR14WXCVBN123456',
bic='WXCVBN7B444'),
create_payment(booking3,
offerer3,
Decimal(20),
iban=None,
bic=None)
]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
assert find_node('//ns:PmtInf/ns:NbOfTxs', xml) == '2', \
'The number of transactions should match the distinct number of IBANs'
def send_transactions(payments: List[Payment], pass_culture_iban: str,
pass_culture_bic: str, pass_culture_remittance_code: str,
recipients: List[str]) -> None:
if not pass_culture_iban or not pass_culture_bic or not pass_culture_remittance_code:
raise Exception(
'[BATCH][PAYMENTS] Missing PASS_CULTURE_IBAN[%s], PASS_CULTURE_BIC[%s] or PASS_CULTURE_REMITTANCE_CODE[%s] in environment variables'
% (pass_culture_iban, pass_culture_bic,
pass_culture_remittance_code))
message_name = 'passCulture-SCT-%s' % datetime.strftime(
datetime.utcnow(), "%Y%m%d-%H%M%S")
xml_file = generate_message_file(payments, pass_culture_iban,
pass_culture_bic, message_name,
pass_culture_remittance_code)
logger.info('[BATCH][PAYMENTS] Payment message name : %s' % message_name)
try:
validate_message_file_structure(xml_file)
except DocumentInvalid as e:
for payment in payments:
payment.setStatus(TransactionStatus.NOT_PROCESSABLE, detail=str(e))
PcObject.save(*payments)
raise
checksum = generate_file_checksum(xml_file)
message = generate_payment_message(message_name, checksum, payments)
logger.info(
'[BATCH][PAYMENTS] Sending file with message ID [%s] and checksum [%s]'
% (message.name, message.checksum.hex()))
logger.info('[BATCH][PAYMENTS] Recipients of email : %s' % recipients)
successfully_sent_payments = send_payment_message_email(
xml_file, checksum, recipients, send_raw_email)
if successfully_sent_payments:
for payment in payments:
payment.setStatus(TransactionStatus.SENT)
else:
for payment in payments:
payment.setStatus(TransactionStatus.ERROR,
detail="Erreur d'envoi à MailJet")
PcObject.save(message, *payments)
def test_file_has_hexadecimal_uuids_as_end_to_end_ids_in_transaction_info(
self, mocked_uuid, app):
# Given
user = create_user()
offerer1 = create_offerer(name='first offerer')
offerer2 = create_offerer(name='second offerer')
venue1 = create_venue(offerer1)
venue2 = create_venue(offerer2)
stock1 = create_stock_from_offer(
create_offer_with_thing_product(venue1))
stock2 = create_stock_from_offer(
create_offer_with_thing_product(venue2))
booking1 = create_booking(user, stock1)
booking2 = create_booking(user, stock2)
uuid1 = UUID(hex='abcd1234abcd1234abcd1234abcd1234', version=4)
uuid2 = UUID(hex='cdef5678cdef5678cdef5678cdef5678', version=4)
mocked_uuid.side_effect = [uuid1, uuid2]
payments = [
create_payment(booking1,
offerer1,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555'),
create_payment(booking2,
offerer1,
Decimal(20),
iban='FR14WXCVBN123456',
bic='WXCVBN7B444'),
]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
nodes_id = find_all_nodes(
'//ns:PmtInf/ns:CdtTrfTxInf/ns:PmtId/ns:EndToEndId', xml)
assert nodes_id[0] == uuid1.hex
assert nodes_id[1] == uuid2.hex
def test_file_has_control_sum_in_payment_info(self, app):
# Given
user = create_user()
offerer1 = create_offerer()
offerer2 = create_offerer()
venue1 = create_venue(offerer1)
venue2 = create_venue(offerer2)
stock1 = create_stock_from_offer(
create_offer_with_thing_product(venue1))
stock2 = create_stock_from_offer(
create_offer_with_thing_product(venue2))
booking1 = create_booking(user, stock1)
booking2 = create_booking(user, stock2)
payments = [
create_payment(booking1,
offerer1,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555'),
create_payment(booking1,
offerer1,
Decimal(20),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555'),
create_payment(booking2,
offerer2,
Decimal(30),
iban=None,
bic=None)
]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
assert find_node('//ns:PmtInf/ns:CtrlSum', xml) == '30', \
'The control sum should match the total amount of money to pay'
def test_file_has_payment_method_in_payment_info(self, app):
# Given
offerer = create_offerer()
user = create_user()
venue = create_venue(offerer)
stock = create_stock_from_offer(create_offer_with_thing_product(venue))
booking = create_booking(user, stock)
payments = [
create_payment(booking,
offerer,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555')
]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
assert find_node('//ns:PmtInf/ns:PmtMtd', xml) == 'TRF', \
'The payment method should be TRF because we want to transfer money'
def test_file_has_initiating_party_id_in_payment_info(self, app):
# Given
offerer = create_offerer()
user = create_user()
venue = create_venue(offerer)
stock = create_stock_from_offer(create_offer_with_thing_product(venue))
booking = create_booking(user, stock)
payments = [
create_payment(booking,
offerer,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555')
]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
assert find_node('//ns:InitgPty/ns:Id/ns:OrgId/ns:Othr/ns:Id', xml) == '0000', \
'The initiating party id should be 0000"'
def test_file_has_category_purpose_in_payment_info(self, app):
# Given
offerer = create_offerer()
user = create_user()
venue = create_venue(offerer)
stock = create_stock_from_offer(create_offer_with_thing_product(venue))
booking = create_booking(user, stock)
payments = [
create_payment(booking,
offerer,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555')
]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
assert find_node('//ns:PmtInf/ns:PmtTpInf/ns:CtgyPurp/ns:Cd', xml) == 'GOVT', \
'The category purpose should be GOVT since we handle government subventions'
def test_file_has_banque_de_france_iban_in_debtor_account(self, app):
# Given
offerer = create_offerer()
user = create_user()
venue = create_venue(offerer)
stock = create_stock_from_offer(create_offer_with_thing_product(venue))
booking = create_booking(user, stock)
payments = [
create_payment(booking,
offerer,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555')
]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
assert find_node('//ns:PmtInf/ns:DbtrAcct/ns:Id/ns:IBAN',
xml) == 'BD12AZERTY123456'
def test_file_has_requested_execution_datetime_in_payment_info(self, app):
# Given
offerer = create_offerer()
user = create_user()
venue = create_venue(offerer)
stock = create_stock_from_offer(create_offer_with_thing_product(venue))
booking = create_booking(user, stock)
payments = [
create_payment(booking,
offerer,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555')
]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
assert find_node('//ns:PmtInf/ns:ReqdExctnDt', xml) == '2018-10-22', \
'The requested execution datetime should be in one week from now'
def test_file_has_charge_bearer_in_payment_info(self, app):
# Given
offerer = create_offerer()
user = create_user()
venue = create_venue(offerer)
stock = create_stock_from_offer(create_offer_with_thing_product(venue))
booking = create_booking(user, stock)
payments = [
create_payment(booking,
offerer,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555')
]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
assert find_node('//ns:PmtInf/ns:ChrgBr', xml) == 'SLEV', \
'The charge bearer should be SLEV as in "following service level"'
def test_file_has_payment_info_id_in_payment_info(self, app):
# Given
offerer1 = create_offerer()
user = create_user()
venue1 = create_venue(offerer1)
stock1 = create_stock_from_offer(
create_offer_with_thing_product(venue1))
booking1 = create_booking(user, stock1)
payments = [
create_payment(booking1,
offerer1,
Decimal(10),
iban='CF13QSDFGH456789',
bic='QSDFGH8Z555')
]
# When
xml = generate_message_file(payments, 'BD12AZERTY123456',
'AZERTY9Q666', MESSAGE_ID, '0000')
# Then
assert find_node('//ns:PmtInf/ns:PmtInfId', xml) == MESSAGE_ID, \
'The payment info id should be the same as message id since we only send one payment per XML message'
