dave/eve-job-tracker
1
0
Fork 0
Code Issues 11 Pull Requests Actions Packages Projects Releases Wiki Activity

Figure out how the journal is wired up to transactions #12

New Issue
Closed
opened 2026-01-14 22:55:41 +00:00 by dave · 2 comments
dave commented 2026-01-14 22:55:41 +00:00
Owner
Copy Link

Example journal:

{"client_id":2123009930,"date":"2025-12-26 13:04:44","is_buy":false,"journal_ref_id":25012865046,"location_id":60003760,"quantity":500,"transaction_id":6698247109,"type_id":57457,"unit_price":4426,"created_at":"2026-01-13 18:17:03"}
{"client_id":2123009930,"date":"2025-12-26 13:04:44","is_buy":false,"journal_ref_id":25012865046,"location_id":60003760,"quantity":500,"transaction_id":6698247109,"type_id":57457,"unit_price":4426,"created_at":"2026-01-13 18:17:57"}
{"client_id":2123009930,"date":"2025-12-26 13:04:44","is_buy":false,"journal_ref_id":25012865046,"location_id":60003760,"quantity":500,"transaction_id":6698247109,"type_id":57457,"unit_price":4426,"created_at":"2026-01-13 18:35:50"}
{"client_id":2122582779,"date":"2025-12-26 13:06:03","is_buy":false,"journal_ref_id":25012869259,"location_id":60003760,"quantity":15,"transaction_id":6698247990,"type_id":57486,"unit_price":87280,"created_at":"2026-01-13 18:17:03"}
{"client_id":2122582779,"date":"2025-12-26 13:06:03","is_buy":false,"journal_ref_id":25012869259,"location_id":60003760,"quantity":15,"transaction_id":6698247990,"type_id":57486,"unit_price":87280,"created_at":"2026-01-13 18:17:57"}

Example transaction:

{"order_id":7163523201,"type_id":18,"issued":"2025-10-16 05:42:13","price":0,"volume_remain":100000,"volume_total":100000,"is_buy_order":true,"inserted_at":"2026-01-08 23:20:00"}
{"order_id":7163523201,"type_id":18,"issued":"2025-10-16 05:42:13","price":0,"volume_remain":100000,"volume_total":100000,"is_buy_order":true,"inserted_at":"2026-01-09 00:20:45"}
{"order_id":7163523201,"type_id":18,"issued":"2025-10-16 05:42:13","price":0,"volume_remain":100000,"volume_total":100000,"is_buy_order":true,"inserted_at":"2026-01-08 23:30:00"}
{"order_id":7163523201,"type_id":18,"issued":"2025-10-16 05:42:13","price":0,"volume_remain":100000,"volume_total":100000,"is_buy_order":true,"inserted_at":"2026-01-08 23:40:00"}
{"order_id":7163523201,"type_id":18,"issued":"2025-10-16 05:42:13","price":0,"volume_remain":100000,"volume_total":100000,"is_buy_order":true,"inserted_at":"2026-01-08 23:50:00"}

Neither make sense...
How are they related?

Example journal: ``` {"client_id":2123009930,"date":"2025-12-26 13:04:44","is_buy":false,"journal_ref_id":25012865046,"location_id":60003760,"quantity":500,"transaction_id":6698247109,"type_id":57457,"unit_price":4426,"created_at":"2026-01-13 18:17:03"} {"client_id":2123009930,"date":"2025-12-26 13:04:44","is_buy":false,"journal_ref_id":25012865046,"location_id":60003760,"quantity":500,"transaction_id":6698247109,"type_id":57457,"unit_price":4426,"created_at":"2026-01-13 18:17:57"} {"client_id":2123009930,"date":"2025-12-26 13:04:44","is_buy":false,"journal_ref_id":25012865046,"location_id":60003760,"quantity":500,"transaction_id":6698247109,"type_id":57457,"unit_price":4426,"created_at":"2026-01-13 18:35:50"} {"client_id":2122582779,"date":"2025-12-26 13:06:03","is_buy":false,"journal_ref_id":25012869259,"location_id":60003760,"quantity":15,"transaction_id":6698247990,"type_id":57486,"unit_price":87280,"created_at":"2026-01-13 18:17:03"} {"client_id":2122582779,"date":"2025-12-26 13:06:03","is_buy":false,"journal_ref_id":25012869259,"location_id":60003760,"quantity":15,"transaction_id":6698247990,"type_id":57486,"unit_price":87280,"created_at":"2026-01-13 18:17:57"} ``` Example transaction: ``` {"order_id":7163523201,"type_id":18,"issued":"2025-10-16 05:42:13","price":0,"volume_remain":100000,"volume_total":100000,"is_buy_order":true,"inserted_at":"2026-01-08 23:20:00"} {"order_id":7163523201,"type_id":18,"issued":"2025-10-16 05:42:13","price":0,"volume_remain":100000,"volume_total":100000,"is_buy_order":true,"inserted_at":"2026-01-09 00:20:45"} {"order_id":7163523201,"type_id":18,"issued":"2025-10-16 05:42:13","price":0,"volume_remain":100000,"volume_total":100000,"is_buy_order":true,"inserted_at":"2026-01-08 23:30:00"} {"order_id":7163523201,"type_id":18,"issued":"2025-10-16 05:42:13","price":0,"volume_remain":100000,"volume_total":100000,"is_buy_order":true,"inserted_at":"2026-01-08 23:40:00"} {"order_id":7163523201,"type_id":18,"issued":"2025-10-16 05:42:13","price":0,"volume_remain":100000,"volume_total":100000,"is_buy_order":true,"inserted_at":"2026-01-08 23:50:00"} ``` Neither make sense... How are they related?
dave added the
Priority
Low
4
 label 2026-01-14 23:00:57 +00:00
dave commented 2026-01-15 00:08:28 +00:00
Author
Owner
Copy Link

I was looking at the wrong fucking table
The correct shit is:

SELECT *
FROM wallet_transactions wt
LIMIT 5
format jsoneachrow;


SELECT *
FROM wallet_journal wt
LIMIT 5
format jsoneachrow;

Which:

{"client_id":2123009930,"date":"2025-12-26 13:04:44","is_buy":false,"journal_ref_id":25012865046,"location_id":60003760,"quantity":500,"transaction_id":6698247109,"type_id":57457,"unit_price":4426,"created_at":"2026-01-13 18:17:03"}
{"client_id":2123009930,"date":"2025-12-26 13:04:44","is_buy":false,"journal_ref_id":25012865046,"location_id":60003760,"quantity":500,"transaction_id":6698247109,"type_id":57457,"unit_price":4426,"created_at":"2026-01-13 18:17:57"}
{"client_id":2123009930,"date":"2025-12-26 13:04:44","is_buy":false,"journal_ref_id":25012865046,"location_id":60003760,"quantity":500,"transaction_id":6698247109,"type_id":57457,"unit_price":4426,"created_at":"2026-01-13 18:35:50"}
{"client_id":2122582779,"date":"2025-12-26 13:06:03","is_buy":false,"journal_ref_id":25012869259,"location_id":60003760,"quantity":15,"transaction_id":6698247990,"type_id":57486,"unit_price":87280,"created_at":"2026-01-13 18:17:03"}
{"client_id":2122582779,"date":"2025-12-26 13:06:03","is_buy":false,"journal_ref_id":25012869259,"location_id":60003760,"quantity":15,"transaction_id":6698247990,"type_id":57486,"unit_price":87280,"created_at":"2026-01-13 18:17:57"}


{"id":25064643204,"amount":200000000,"balance":200000000,"context_id":2121773620,"context_id_type":"character_id","date":"2026-01-07 14:13:42","description":"Locksmith Joe transferred cash from Black Rise Industial Association's corporate account to Black Rise Industial Association's account","first_party_id":98755111,"reason":"","ref_type":"corporation_account_withdrawal","second_party_id":98755111,"created_at":"2026-01-14 23:47:29"}
{"id":25064643204,"amount":200000000,"balance":200000000,"context_id":2121773620,"context_id_type":"character_id","date":"2026-01-07 14:13:42","description":"Locksmith Joe transferred cash from Black Rise Industial Association's corporate account to Black Rise Industial Association's account","first_party_id":98755111,"reason":"","ref_type":"corporation_account_withdrawal","second_party_id":98755111,"created_at":"2026-01-14 23:47:49"}
{"id":25064643204,"amount":200000000,"balance":200000000,"context_id":2121773620,"context_id_type":"character_id","date":"2026-01-07 14:13:42","description":"Locksmith Joe transferred cash from Black Rise Industial Association's corporate account to Black Rise Industial Association's account","first_party_id":98755111,"reason":"","ref_type":"corporation_account_withdrawal","second_party_id":98755111,"created_at":"2026-01-14 23:47:52"}
{"id":25064643204,"amount":200000000,"balance":200000000,"context_id":2121773620,"context_id_type":"character_id","date":"2026-01-07 14:13:42","description":"Locksmith Joe transferred cash from Black Rise Industial Association's corporate account to Black Rise Industial Association's account","first_party_id":98755111,"reason":"","ref_type":"corporation_account_withdrawal","second_party_id":98755111,"created_at":"2026-01-14 23:48:08"}
{"id":25064643204,"amount":200000000,"balance":200000000,"context_id":2121773620,"context_id_type":"character_id","date":"2026-01-07 14:13:42","description":"Locksmith Joe transferred cash from Black Rise Industial Association's corporate account to Black Rise Industial Association's account","first_party_id":98755111,"reason":"","ref_type":"corporation_account_withdrawal","second_party_id":98755111,"created_at":"2026-01-15 00:35:16"}
I was looking at the wrong fucking table The correct shit is: ``` SELECT * FROM wallet_transactions wt LIMIT 5 format jsoneachrow; SELECT * FROM wallet_journal wt LIMIT 5 format jsoneachrow; ``` Which: ``` {"client_id":2123009930,"date":"2025-12-26 13:04:44","is_buy":false,"journal_ref_id":25012865046,"location_id":60003760,"quantity":500,"transaction_id":6698247109,"type_id":57457,"unit_price":4426,"created_at":"2026-01-13 18:17:03"} {"client_id":2123009930,"date":"2025-12-26 13:04:44","is_buy":false,"journal_ref_id":25012865046,"location_id":60003760,"quantity":500,"transaction_id":6698247109,"type_id":57457,"unit_price":4426,"created_at":"2026-01-13 18:17:57"} {"client_id":2123009930,"date":"2025-12-26 13:04:44","is_buy":false,"journal_ref_id":25012865046,"location_id":60003760,"quantity":500,"transaction_id":6698247109,"type_id":57457,"unit_price":4426,"created_at":"2026-01-13 18:35:50"} {"client_id":2122582779,"date":"2025-12-26 13:06:03","is_buy":false,"journal_ref_id":25012869259,"location_id":60003760,"quantity":15,"transaction_id":6698247990,"type_id":57486,"unit_price":87280,"created_at":"2026-01-13 18:17:03"} {"client_id":2122582779,"date":"2025-12-26 13:06:03","is_buy":false,"journal_ref_id":25012869259,"location_id":60003760,"quantity":15,"transaction_id":6698247990,"type_id":57486,"unit_price":87280,"created_at":"2026-01-13 18:17:57"} {"id":25064643204,"amount":200000000,"balance":200000000,"context_id":2121773620,"context_id_type":"character_id","date":"2026-01-07 14:13:42","description":"Locksmith Joe transferred cash from Black Rise Industial Association's corporate account to Black Rise Industial Association's account","first_party_id":98755111,"reason":"","ref_type":"corporation_account_withdrawal","second_party_id":98755111,"created_at":"2026-01-14 23:47:29"} {"id":25064643204,"amount":200000000,"balance":200000000,"context_id":2121773620,"context_id_type":"character_id","date":"2026-01-07 14:13:42","description":"Locksmith Joe transferred cash from Black Rise Industial Association's corporate account to Black Rise Industial Association's account","first_party_id":98755111,"reason":"","ref_type":"corporation_account_withdrawal","second_party_id":98755111,"created_at":"2026-01-14 23:47:49"} {"id":25064643204,"amount":200000000,"balance":200000000,"context_id":2121773620,"context_id_type":"character_id","date":"2026-01-07 14:13:42","description":"Locksmith Joe transferred cash from Black Rise Industial Association's corporate account to Black Rise Industial Association's account","first_party_id":98755111,"reason":"","ref_type":"corporation_account_withdrawal","second_party_id":98755111,"created_at":"2026-01-14 23:47:52"} {"id":25064643204,"amount":200000000,"balance":200000000,"context_id":2121773620,"context_id_type":"character_id","date":"2026-01-07 14:13:42","description":"Locksmith Joe transferred cash from Black Rise Industial Association's corporate account to Black Rise Industial Association's account","first_party_id":98755111,"reason":"","ref_type":"corporation_account_withdrawal","second_party_id":98755111,"created_at":"2026-01-14 23:48:08"} {"id":25064643204,"amount":200000000,"balance":200000000,"context_id":2121773620,"context_id_type":"character_id","date":"2026-01-07 14:13:42","description":"Locksmith Joe transferred cash from Black Rise Industial Association's corporate account to Black Rise Industial Association's account","first_party_id":98755111,"reason":"","ref_type":"corporation_account_withdrawal","second_party_id":98755111,"created_at":"2026-01-15 00:35:16"} ```
dave commented 2026-01-15 00:17:56 +00:00
Author
Owner
Copy Link

Yea that was totally it.

SELECT
  wj.id,
  anyLast(wt.client_id) as wt_client_id,
  anyLast(wt.date) as wt_date,
  anyLast(wt.is_buy) as wt_is_buy,
  anyLast(wt.journal_ref_id) as wt_journal_ref_id,
  anyLast(wt.location_id) as wt_location_id,
  anyLast(wt.quantity) as wt_quantity,
  anyLast(wt.transaction_id) as wt_transaction_id,
  anyLast(wt.type_id) as wt_type_id,
  anyLast(wt.unit_price) as wt_unit_price,
  anyLast(wt.created_at) as wt_created_at,
  anyLast(wj.amount) as wj_amount,
  anyLast(wj.balance) as wj_balance,
  anyLast(wj.context_id) as wj_context_id,
  anyLast(wj.context_id_type) as wj_context_id_type,
  anyLast(wj.date) as wj_date,
  anyLast(wj.description) as wj_description,
  anyLast(wj.first_party_id) as wj_first_party_id,
  anyLast(wj.reason) as wj_reason,
  anyLast(wj.ref_type) as wj_ref_type,
  anyLast(wj.second_party_id) as wj_second_party_id,
  anyLast(wj.created_at) as wj_created_at
FROM wallet_journal wj
LEFT JOIN wallet_transactions wt ON wt.journal_ref_id = wj.id
GROUP BY wj.id
LIMIT 50

Works like a charm
Absolute idiot

Yea that was totally it. ``` SELECT wj.id, anyLast(wt.client_id) as wt_client_id, anyLast(wt.date) as wt_date, anyLast(wt.is_buy) as wt_is_buy, anyLast(wt.journal_ref_id) as wt_journal_ref_id, anyLast(wt.location_id) as wt_location_id, anyLast(wt.quantity) as wt_quantity, anyLast(wt.transaction_id) as wt_transaction_id, anyLast(wt.type_id) as wt_type_id, anyLast(wt.unit_price) as wt_unit_price, anyLast(wt.created_at) as wt_created_at, anyLast(wj.amount) as wj_amount, anyLast(wj.balance) as wj_balance, anyLast(wj.context_id) as wj_context_id, anyLast(wj.context_id_type) as wj_context_id_type, anyLast(wj.date) as wj_date, anyLast(wj.description) as wj_description, anyLast(wj.first_party_id) as wj_first_party_id, anyLast(wj.reason) as wj_reason, anyLast(wj.ref_type) as wj_ref_type, anyLast(wj.second_party_id) as wj_second_party_id, anyLast(wj.created_at) as wj_created_at FROM wallet_journal wj LEFT JOIN wallet_transactions wt ON wt.journal_ref_id = wj.id GROUP BY wj.id LIMIT 50 ``` Works like a charm Absolute idiot
dave closed this issue 2026-01-15 00:17:59 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Compat/Breaking
Breaking change that won't be backward compatible
 Kind/Bug
Something is not working
 Kind/Documentation
Documentation changes
 Kind/Enhancement
Improve existing functionality
 Kind/Feature
New functionality
 Kind/Security
This is security issue
 Kind/Testing
Issue or pull request related to testing
Priority
Critical
1
The priority is critical
Priority
High
2
The priority is high
Priority
Low
4
The priority is low
Priority
Medium
3
The priority is medium
Reviewed
Confirmed
1
Issue has been confirmed
Reviewed
Duplicate
2
This issue or pull request already exists
Reviewed
Invalid
3
Invalid issue
Reviewed
Won't Fix
3
This issue won't be fixed
Status
Abandoned
3
Somebody has started to work on this but abandoned work
Status
Blocked
1
Something is blocking this issue or pull request
Status
Need More Info
2
Feedback is required to reproduce issue or to continue work
No Label
Priority
Low
4
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
dave
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: dave/eve-job-tracker#12
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?