| 7002 | } |
| 7003 | |
| 7004 | static u64 insert_chain_mvt(struct lightningd *ld, |
| 7005 | struct db *db, |
| 7006 | const struct chain_coin_mvt *chain_mvt) |
| 7007 | { |
| 7008 | struct db_stmt *stmt; |
| 7009 | u64 id; |
| 7010 | |
| 7011 | stmt = db_prepare_v2(db, |
| 7012 | SQL("INSERT INTO chain_moves (" |
| 7013 | " id," |
| 7014 | " account_channel_id," |
| 7015 | " account_nonchannel_id," |
| 7016 | " tag_bitmap," |
| 7017 | " credit_or_debit," |
| 7018 | " timestamp," |
| 7019 | " utxo," |
| 7020 | " spending_txid," |
| 7021 | " peer_id," |
| 7022 | " payment_hash," |
| 7023 | " block_height," |
| 7024 | " output_sat," |
| 7025 | " originating_channel_id," |
| 7026 | " originating_nonchannel_id," |
| 7027 | " output_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")); |
| 7028 | id = chain_mvt_index_created(ld, db, |
| 7029 | &chain_mvt->account, |
| 7030 | chain_mvt->credit, chain_mvt->debit); |
| 7031 | db_bind_u64(stmt, id); |
| 7032 | db_bind_mvt_account_id(stmt, db, &chain_mvt->account); |
| 7033 | db_bind_mvt_tags(stmt, chain_mvt->tags); |
| 7034 | db_bind_credit_debit(stmt, chain_mvt->credit, chain_mvt->debit); |
| 7035 | db_bind_u64(stmt, chain_mvt->timestamp); |
| 7036 | db_bind_outpoint(stmt, &chain_mvt->outpoint); |
| 7037 | if (chain_mvt->spending_txid) |
| 7038 | db_bind_txid(stmt, chain_mvt->spending_txid); |
| 7039 | else |
| 7040 | db_bind_null(stmt); |
| 7041 | if (chain_mvt->peer_id) |
| 7042 | db_bind_node_id(stmt, chain_mvt->peer_id); |
| 7043 | else |
| 7044 | db_bind_null(stmt); |
| 7045 | if (chain_mvt->payment_hash) |
| 7046 | db_bind_sha256(stmt, chain_mvt->payment_hash); |
| 7047 | else |
| 7048 | db_bind_null(stmt); |
| 7049 | db_bind_int(stmt, chain_mvt->blockheight); |
| 7050 | db_bind_amount_sat(stmt, chain_mvt->output_val); |
| 7051 | if (chain_mvt->originating_acct) { |
| 7052 | db_bind_mvt_account_id(stmt, db, chain_mvt->originating_acct); |
| 7053 | } else { |
| 7054 | db_bind_null(stmt); |
| 7055 | db_bind_null(stmt); |
| 7056 | } |
| 7057 | if (chain_mvt->output_count > 0) |
| 7058 | db_bind_int(stmt, chain_mvt->output_count); |
| 7059 | else |
| 7060 | db_bind_null(stmt); |
| 7061 | db_exec_prepared_v2(take(stmt)); |
no test coverage detected