parse sql table explaination about blockparser HOT 2 CLOSED

Hi rushramia,

The sending address is not in the raw structure of the blockchain, the blockchain works with inputs and outputs, not addresses.

I'm too new to this so can't help more than this.
Were you successful in finding the answer to this?

I think you need to look for the previous transaction and I'm not sure the sql dump includes all the info you need for that.

Let me know if you have a better solution.

from blockparser.

You are correct, the sending address is not printed as part of the input.

For this, you need to find the output which the input is connected to and
read the sending address from there.

In other words, you need to execute a DB query to get that out: the SQL
dump produced by my parser is pretty much a 1 to 1 dump of how the
blockchain data structure is organized.

Alternatively, you could add code to cb/sql.cpp (in method edge) to print
the sending address (it is actually fetched internally, but not printed b/c
that'd be redundant information in the DB).

    - Znort.

On Thursday, February 20, 2014 7:02 AM, rushramia [email protected] wrote:

Hello @znort987, I ran the blockparser sql command (which ran successfully) and currently importing the data into mysql via the .bash script. Everything seems to be working fine so far. Great job!
However, I have a question about the SQL data structure. I noticed it dumps all the data into blocks, transactions, inputs and outputs tables in the db. I see that a block contains many transactions and the transactions contain many inputs and outputs. I also see that the input is related to an output (via it's outputID) column and I see that that the output contains a destAddress and value (which I assume is the wallet address and btc value being received by that address?). However I can't find where the sending address is specified. Is there something I'm missing or is this information not available? Please let me know if you can help clairfy. Thanks!
—
Reply to this email directly or view it on GitHub.

from blockparser.