what I want to achieve is:
execute a test to registry a record using a given payload
execute another test with the same payload to throw a proposital error (the db doesnt accept duplicates)
but even cleaning the db before tests, sometimes the first request fails, sometimes it doesn’t, basically it seems like they occur randomly, sometimes all the tests pass, sometimes a few etc. I dont have idea on how to assure this flow
defmodule TestesPay.MyRouterTest do
use ExUnit.Case, async: false
use Plug.Test
alias MyApp.Repo
require Logger
@create_qr_url "https://sandbox.asaas.com/api/v3/pix/qrCodes/static"
@pix_key "ab09d852-14bd-43ac-91eb-d38b717e6aea"
@test_price 22
@payload "00020126580014br.gov.bcb.pix0136ab09d852-14bd-43ac-91eb-d38b717e6aea520400005303986540526.005802BR5914Pedro Henrique6005Macae62290525PEDROHEN00000000554994ASA6304AEBF"
defp clean_contracts(_) do
MyApp.Repo.delete_all(MyApp.Schemas.Contract)
Logger.info("Contratos limpos com sucesso!")
:ok
end
setup_all do
access_token = System.get_env("ACCESS_TOKEN")
Ecto.Adapters.SQL.Sandbox.mode(MyApp.Repo, {:shared, self()})
MyApp.Repo.delete_all(MyApp.Schemas.Contract)
:ok
{:ok, %{access_token: access_token}}
end
describe "database cleaning verification" do
test "ensure contracts table is empty before tests" do
all_records = MyApp.Repo.all(MyApp.Schemas.Contract)
Logger.info("Registros antes da limpeza: #{inspect(all_records)}")
MyApp.Repo.delete_all(MyApp.Schemas.Contract)
contracts_count = MyApp.Repo.aggregate(MyApp.Schemas.Contract, :count, :id)
Logger.info("Número de registros na tabela contracts: #{contracts_count}")
assert contracts_count == 0, "A tabela contracts não está vazia!"
end
end
describe "create contract teste1" do
Logger.info("[TESTE1] INIT")
Logger.info("[TESTE1] PAYLOAD: #{@payload}")
test "POST /api/create_contract" do
body = Jason.encode!(%{
"chain" => "eth",
"coin" => "eth",
"ref" => "my_referral",
"payload" => @payload
})
conn =
conn(:post, "/api/create_contract", body)
|> put_req_header("content-type", "application/json")
|> TestesPay.MyRouter.call(%{})
actual_response = Jason.decode!(conn.resp_body)
Logger.info("[TESTE1] Body: #{inspect(actual_response)}")
all_records = MyApp.Repo.all(MyApp.Schemas.Contract)
Logger.info("Registros depois do [TESTE1]: #{inspect(all_records)}")
assert conn.status == 203
end
end
describe "retorna erro pois registro ja existe" do
Logger.info("[TESTE2] INIT")
Logger.info("[TESTE2] PAYLOAD: #{@payload}")
all_records = MyApp.Repo.all(MyApp.Schemas.Contract)
Logger.info("[TESTE2] Registros no banco: #{inspect(all_records)}")
test "POST /api/create_contract com payload já existente retorna erro" do
initial_body = Jason.encode!(%{
"chain" => "eth",
"coin" => "eth",
"ref" => "my_referral",
"payload" => @payload
})
conn =
conn(:post, "/api/create_contract", initial_body)
|> put_req_header("content-type", "application/json")
|> TestesPay.MyRouter.call(%{})
actual_response = Jason.decode!(conn.resp_body)
Logger.info("[TESTE2] body: #{inspect(actual_response)}")
all_records = MyApp.Repo.all(MyApp.Schemas.Contract)
Logger.info("Registros depois do [TESTE2]: #{inspect(all_records)}")
assert conn.status == 400
end
end
describe "assure database state after payload test" do
test "database" do
Logger.info("database estado final")
all_records = MyApp.Repo.all(MyApp.Schemas.Contract)
contracts_count = MyApp.Repo.aggregate(MyApp.Schemas.Contract, :count, :id)
Logger.info("registro final: #{inspect(contracts_count)}")
Logger.info("numero final de contratos: #{inspect(contracts_count)}")
assert contracts_count == 1
end
end
end
15:32:31.867 [info] [TESTE1] INIT
15:32:31.867 [info] [TESTE1] PAYLOAD: 00020126580014br.gov.bcb.pix0136ab09d852-14bd-43ac-91eb-d38b717e6aea520400005303986540526.005802BR5914Pedro Henrique6005Macae62290525PEDROHEN00000000554994ASA6304AEBF
15:32:31.867 [info] [TESTE2] INIT
15:32:31.867 [info] [TESTE2] PAYLOAD: 00020126580014br.gov.bcb.pix0136ab09d852-14bd-43ac-91eb-d38b717e6aea520400005303986540526.005802BR5914Pedro Henrique6005Macae62290525PEDROHEN00000000554994ASA6304AEBF
15:32:32.025 [info] [TESTE2] Registros no banco: []
15:32:32.073 [info] database estado final
15:32:32.084 [info] registros finais: []
15:32:32.092 [info] numero final de contratos: 0
1) test assure database state after payload test database (TestesPay.MyRouterTest)
test/integration_test.exs:87
Assertion with == failed
code: assert contracts_count == 1
left: 0
right: 1
stacktrace:
test/integration_test.exs:93: (test)
"/api/create_contract"
15:32:33.345 [info] [TESTE2] body: %{"chain" => "eth", "coin" => "eth", "payload" => "00020126580014br.gov.bcb.pix0136ab09d852-14bd-43ac-91eb-d38b717e6aea520400005303986540526.005802BR5914Pedro Henrique6005Macae62290525PEDROHEN00000000554994ASA6304AEBF", "private" => "3jRrp8orhspK4yngX5vGv1JH3pSauZuwQPBgDpFcf8DwM4GtmdNpcjAB1XqGpwsVhp4yDZGttJaLrmfa2GJNBW8b", "public" => "7wyExYgwuRv8BS8qTZDi7XnayoFHZf8t2AUFXHUBVUDh", "ref" => "my_referral", "ref_fee" => 0.01, "transaction_charged" => 26.26, "transaction_value" => 26.0}
15:32:33.360 [info] Registros depois do [TESTE2]: [%MyApp.Schemas.Contract{__meta__: #Ecto.Schema.Metadata<:loaded, "contracts">, id: 258, chain: "eth", coin: "eth", transaction_value: Decimal.new("26.000"), transaction_charged: Decimal.new("26.260"), ref: "my_referral", ref_fee: Decimal.new("0.01"), payload: "00020126580014br.gov.bcb.pix0136ab09d852-14bd-43ac-91eb-d38b717e6aea520400005303986540526.005802BR5914Pedro Henrique6005Macae62290525PEDROHEN00000000554994ASA6304AEBF", public: "7wyExYgwuRv8BS8qTZDi7XnayoFHZf8t2AUFXHUBVUDh", private: "3jRrp8orhspK4yngX5vGv1JH3pSauZuwQPBgDpFcf8DwM4GtmdNpcjAB1XqGpwsVhp4yDZGttJaLrmfa2GJNBW8b", status: "pending"}]
2) test retorna erro pois registro ja existe POST /api/create_contract com payload já existente retorna erro (TestesPay.MyRouterTest)
test/integration_test.exs:64
Assertion with == failed
code: assert conn.status == 400
left: 203
right: 400
stacktrace:
test/integration_test.exs:81: (test)
15:32:33.361 [info] Registros antes da limpeza: [%MyApp.Schemas.Contract{__meta__: #Ecto.Schema.Metadata<:loaded, "contracts">, id: 258, chain: "eth", coin: "eth", transaction_value: Decimal.new("26.000"), transaction_charged: Decimal.new("26.260"), ref: "my_referral", ref_fee: Decimal.new("0.01"), payload: "00020126580014br.gov.bcb.pix0136ab09d852-14bd-43ac-91eb-d38b717e6aea520400005303986540526.005802BR5914Pedro Henrique6005Macae62290525PEDROHEN00000000554994ASA6304AEBF", public: "7wyExYgwuRv8BS8qTZDi7XnayoFHZf8t2AUFXHUBVUDh", private: "3jRrp8orhspK4yngX5vGv1JH3pSauZuwQPBgDpFcf8DwM4GtmdNpcjAB1XqGpwsVhp4yDZGttJaLrmfa2GJNBW8b", status: "pending"}]
15:32:33.366 [info] Número de registros na tabela contracts: 0
."/api/create_contract"
15:32:33.767 [info] [TESTE1] Body: %{"chain" => "eth", "coin" => "eth", "payload" => "00020126580014br.gov.bcb.pix0136ab09d852-14bd-43ac-91eb-d38b717e6aea520400005303986540526.005802BR5914Pedro Henrique6005Macae62290525PEDROHEN00000000554994ASA6304AEBF", "private" => "31owKnxfK2LuLjdTPDpJJFpnxXyED8d7LiZM7hnXyqSpQ8s5zBT5NoouGc8mBP5cJ6WA58TqUuJXTXqkG4qT9VEa", "public" => "DJZQv35VqtrKfHQ9MPx7Dy36uCG3VJqXkRLYsJHK7X3g", "ref" => "my_referral", "ref_fee" => 0.01, "transaction_charged" => 26.26, "transaction_value" => 26.0}
15:32:33.768 [info] Registros depois do [TESTE1]: [%MyApp.Schemas.Contract{__meta__: #Ecto.Schema.Metadata<:loaded, "contracts">, id: 259, chain: "eth", coin: "eth", transaction_value: Decimal.new("26.000"), transaction_charged: Decimal.new("26.260"), ref: "my_referral", ref_fee: Decimal.new("0.01"), payload: "00020126580014br.gov.bcb.pix0136ab09d852-14bd-43ac-91eb-d38b717e6aea520400005303986540526.005802BR5914Pedro Henrique6005Macae62290525PEDROHEN00000000554994ASA6304AEBF", public: "DJZQv35VqtrKfHQ9MPx7Dy36uCG3VJqXkRLYsJHK7X3g", private: "31owKnxfK2LuLjdTPDpJJFpnxXyED8d7LiZM7hnXyqSpQ8s5zBT5NoouGc8mBP5cJ6WA58TqUuJXTXqkG4qT9VEa", status: "pending"}]
.
Finished in 1.9 seconds (0.00s async, 1.9s sync)
4 tests, 2 failures
Randomized with seed 796590
reading the logs I have the feeling the tests run in random order
