You are viewing a single comment's thread from:

RE: Introducing SteemData - A Database Layer for STEEM

in #steemdata • 9 years ago

@furion: what type is the amount field in the Operations / VirtualOperations table?
How would one search for transactions above a certain amount or transactions that were in SBD etc. Tried with NumberDecimal/Float and currency: "STEEM" but to no avail..

9 years ago in #steemdata by
$0.00
    Reply 2
    Sort:  
  • Trending
    • [-]
     9 years ago (edited)

    The amount fields in Operations/VirtualOperations are still strings unfortunately (todo: have native types everywhere for v2).

    So what you have to do is query all transactions for a time period, and then filter out the ones you need in your code.

    Python Example:

    from steem.amount import Amount

filter(Amount(x['amount']).currency == 'STEEM', lambda x: Amount(x['amount']).amount > 100, db_results)
    [-]
     9 years ago 

    I see, ok, Thanks man!

    $0.00
      Reply

      Coin Marketplace

      STEEM 0.09
      TRX 0.30
      JST 0.033
      BTC 111638.57
      ETH 3944.23
      USDT 1.00
      SBD 0.57