Table Comparison

Table: recordobts

{ "id": 55, "payer_fio_address": "0x1229fcfe99f07177b46bc0efb0a12fdd", "payee_fio_address": "0x5abb55b94fbb7c1faecd604e249380ef", "payer_fio_address_hex_str": "0x1229fcfe99f07177b46bc0efb0a12fdd", "payee_fio_address_hex_str": "0x5abb55b94fbb7c1faecd604e249380ef", "payer_fio_address_with_time": "0xd06fa28fac9bb131119af64d0c773b5c", "payee_fio_address_with_time": "0xb499f7eb8162943f49094c53fe595ac0", "content": "IyzpxZIZuBWl6pRMRgGPVJYY6swYI4LT3iryFRkwNdnab/1gumUMK/U0eM6zhcX7VMv1ajqTAu+KJQGBvcVd7FaSklSyI8nrOSDtXkgCkeLZU3jdfNayKxLE6/scuS04lu7PSr9JxeC+UBF5pNMwt1bKlHVmU1U1TxuJeQcSbSa7xXmav8I0Zl6wyIucze/BRzu7iLL+2wjhwWKJMJBM4uAlBXRTGXQDk/Sos30JrHjI29Yi58Wz0yOpSDq16pqTxJ1dcpnr0pCrveB2EQlEJw==", "time_stamp": 1588006848, "payer_fio_addr": "bob@fiotestnet", "payee_fio_addr": "alice@fiotestnet", "payer_key": "FIO8Hv6Cxy1rFXx4TmRzGruWtFNDuGH29DaYW8Jf4Dc6De5CLNgo8", "payee_key": "FIO7SLtXbRet5viHXLoU6abXr6CX3BHHo739kD38pKj9Kd9pSiLAb" }

“OBT” Content:

  • payer_public_address: string

  • payee_public_address: string

  • amount: string

  • chain_code: string

  • token_code: string

  • status: string (sent_to_blockchain)

  • obt_id

  • memo

  • hash

  • offline_url

Table: fioreqctxts (fiorequestContextTable)

{ "fio_request_id": 163, "payer_fio_address": "0xc329a8a6a45f1b5ff03b886dcd951143", "payee_fio_address": "0xc66c8e61c527844a9e147feed132dfc6", "payer_fio_address_hex_str": "0xc329a8a6a45f1b5ff03b886dcd951143", "payee_fio_address_hex_str": "0xc66c8e61c527844a9e147feed132dfc6", "payer_fio_address_with_time": "0xe973d12bdb52ad4b7f845a36c455ec62", "payee_fio_address_with_time": "0xda3898ab4d1235fe9fe522744c56b481", "content": "TOW7alp/BoM8qUv1dYPpK+soYupVMsTcr4AQ/NfNpvYRRmFwl3HsT5z+kS0LKGyttXDORVPc0uONgTbmMGDTyG1f5jPOKLocl4VD18YOjXYLrHVlBZBwJ7rZKJxCj37u+99khMIvKVZmPV57EGT7vr3IwJ0FgbtrBCTOizjZBQA=", "time_stamp": 1586449682, "payer_fio_addr": "testing6t@fiotestnet", "payee_fio_addr": "testing56t@fiotestnet", "payer_key": "FIO7pdE1qgKiynthV4cvHf1DG3ASt3r5zSHdYgMrE4dExcJupc4Gp", "payee_key": "FIO88neEop1f5tM6GCepcAdxLpfETqBxsUhPESbUdfZu3joB4M6HB" }

“Request” Content:

  • payee_public_address: string

  • amount: string

  • chain_code: string

  • token_code: string

  • memo: string

  • hash: string

  • offline_url: string

  • figure_use1-5: string

Table: fioreqstss (fiorequestStatusTable)

{ "id": 137, "fio_request_id": 161, "status": 2, (0=requested, 1=rejected, 2=sent_to_blockchain) "metadata": "rwHmtCuS7PgUmMO9p4AB+IWuOnSFc3hvbvc/bW+QJ3+pvDxcAl1XQCEptc38dmtzNbrjhA7PnO1anZpVX2A867zsRR81gjVkA3r5gVnROXJWfAsWb1mowGFYiXguqcqZ9c4uTxjR6A4cBj1kcwxbM6/XDUHAuAOCweFLXhuaCPkzW3lWtxurQpJfmfzsPHp5t/pYjr4ZSAVykar1s/5Uz9qop9NZkx3hAxHTC2qeyRA=", "time_stamp": 1586381357500000 }

“OBT” Content:

  • payer_public_address: string

  • payee_public_address: string

  • amount: string

  • chain_code: string

  • token_code: string

  • status: string (sent_to_blockchain)

  • obt_id

  • memo

  • hash

  • offline_url

Table: fiotrxts (New Request and OBT Table)

fio_data_type

  • 0 = requested
    1 = rejected
    2 = sent_to_blockchain
    3 = cancelled
    4 = OBT Action

EB:

  • call it request_content and obt_content?

  •  

  •  

Tests cases: (Done)

  • /get_sent_fio_requests

    • fio_request_id =

    • payer_fio_address =

    • payee_fio_address =

    • payer_fio_public_key =

    • payee_fio_public_key =

    • content =

    • time_stamp =

    • status = rejected, cancelled, requested, sent_to_blockchain

  • /get_cancelled_fio_requests

    • fio_request_id =

    • payer_fio_address =

    • payee_fio_address =

    • payer_fio_public_key =

    • payee_fio_public_key =

    • content =

    • time_stamp =

    • status = cancelled

  • /get_pending_fio_requests (no status returned)

    • fio_request_id =

    • payer_fio_address =

    • payee_fio_address =

    • payer_fio_public_key =

    • payee_fio_public_key =

    • content =

    • time_stamp =

  • /get_received_fio_requests

    • fio_request_id =

    • payer_fio_address =

    • payee_fio_address =

    • payer_fio_public_key =

    • payee_fio_public_key =

    • content =

    • time_stamp =

    • status =

  • /get_obt_data

    • fio_request_id =

    • payer_fio_address =

    • payee_fio_address =

    • payer_fio_public_key =

    • payee_fio_public_key =

    • content =

    • time_stamp =

    • status =

For Bob and Alice in each case check:

  • /get_sent_fio_requests

  • /get_cancelled_fio_requests

  • /get_pending_fio_requests

  • /get_received_fio_requests

  • /get_obt_data

Reject (Done: Fio-request.js)

  • Alice sends new_funds_request to bob

  • Bob rejects funds request

Respond to request by paying and sending OBT (Done: Fio-request.js > A. Send fio request from userA1 to userA2. userA2 responds with OBT Record)

  • Alice sends new_funds_request to bob

  • Bob transfers funds and sends record_obt_data

Cancel (Done: Fio-request.js)

  • Alice sends new_funds_request to bob

  • Alice cancels funds request

Direct send (Done: record-out-data.js > A. Test OBT DAta)

  • Alice sends new_funds_request to bob