void AccountFrame::storeDelete(LedgerDelta& delta, Database& db, LedgerKey const& key) { flushCachedEntry(key, db); std::string actIDStrKey = PubKeyUtils::toStrKey(key.account().accountID); { auto timer = db.getDeleteTimer("account"); auto prep = db.getPreparedStatement( "DELETE from accounts where accountid= :v1"); auto& st = prep.statement(); st.exchange(soci::use(actIDStrKey)); st.define_and_bind(); st.execute(true); } { auto timer = db.getDeleteTimer("signer"); auto prep = db.getPreparedStatement("DELETE from signers where accountid= :v1"); auto& st = prep.statement(); st.exchange(soci::use(actIDStrKey)); st.define_and_bind(); st.execute(true); } delta.deleteEntry(key); }
void OfferFrame::storeDelete(LedgerDelta& delta, Database& db, LedgerKey const& key) { auto timer = db.getDeleteTimer("offer"); db.getSession() << "DELETE FROM offers WHERE offerid=:s", use(key.offer().offerID); delta.deleteEntry(key); }
void OfferFrame::storeDelete(LedgerDelta& delta, Database& db, LedgerKey const& key) { auto timer = db.getDeleteTimer("offer"); auto prep = db.getPreparedStatement("DELETE FROM offers WHERE offerid=:s"); auto& st = prep.statement(); st.exchange(use(key.offer().offerID)); st.define_and_bind(); st.execute(true); delta.deleteEntry(key); }
void TrustFrame::storeDelete(LedgerDelta& delta, Database& db, LedgerKey const& key) { flushCachedEntry(key, db); std::string actIDStrKey, issuerStrKey, assetCode; getKeyFields(key, actIDStrKey, issuerStrKey, assetCode); auto timer = db.getDeleteTimer("trust"); db.getSession() << "DELETE FROM trustlines " "WHERE accountid=:v1 AND issuer=:v2 AND assetcode=:v3", use(actIDStrKey), use(issuerStrKey), use(assetCode); delta.deleteEntry(key); }
void AccountFrame::storeDelete(LedgerDelta& delta, Database& db, LedgerKey const& key) { flushCachedEntry(key, db); std::string actIDStrKey = PubKeyUtils::toStrKey(key.account().accountID); soci::session& session = db.getSession(); { auto timer = db.getDeleteTimer("account"); session << "DELETE from accounts where accountid= :v1", soci::use(actIDStrKey); } { auto timer = db.getDeleteTimer("signer"); session << "DELETE from signers where accountid= :v1", soci::use(actIDStrKey); } delta.deleteEntry(key); }