Ecoer Logo
VOTING POWER100.00%
DOWNVOTE POWER100.00%
RESOURCE CREDITS100.00%
REPUTATION PROGRESS0.00%
Net Worth
0.037USD
STEEM
0.000STEEM
SBD
0.000SBD
Effective Power
5.007SP
├── Own SP
0.636SP
└── Incoming Deleg
+4.371SP

Detailed Balance

STEEM
balance
0.000STEEM
market_balance
0.000STEEM
savings_balance
0.000STEEM
reward_steem_balance
0.000STEEM
STEEM POWER
Own SP
0.636SP
Delegated Out
0.000SP
Delegation In
4.371SP
Effective Power
5.007SP
Reward SP (pending)
0.000SP
SBD
sbd_balance
0.000SBD
sbd_conversions
0.000SBD
sbd_market_balance
0.000SBD
savings_sbd_balance
0.000SBD
reward_sbd_balance
0.000SBD
{
  "balance": "0.000 STEEM",
  "savings_balance": "0.000 STEEM",
  "reward_steem_balance": "0.000 STEEM",
  "vesting_shares": "1034.923033 VESTS",
  "delegated_vesting_shares": "0.000000 VESTS",
  "received_vesting_shares": "7108.736773 VESTS",
  "sbd_balance": "0.000 SBD",
  "savings_sbd_balance": "0.000 SBD",
  "reward_sbd_balance": "0.000 SBD",
  "conversions": []
}

Account Info

namehetdev
id211591
rank1,450,332
reputation18135913
created2017-06-21T22:57:24
recovery_accountsteem
proxyNone
post_count1
comment_count0
lifetime_vote_count0
witnesses_voted_for0
last_post2017-06-22T04:02:30
last_root_post2017-06-22T04:02:30
last_vote_time2017-06-22T04:02:30
proxied_vsf_votes0, 0, 0, 0
can_vote1
voting_power0
delayed_votes0
balance0.000 STEEM
savings_balance0.000 STEEM
sbd_balance0.000 SBD
savings_sbd_balance0.000 SBD
vesting_shares1034.923033 VESTS
delegated_vesting_shares0.000000 VESTS
received_vesting_shares7108.736773 VESTS
reward_vesting_balance0.000000 VESTS
vesting_balance0.000 STEEM
vesting_withdraw_rate0.000000 VESTS
next_vesting_withdrawal1969-12-31T23:59:59
withdrawn0
to_withdraw0
withdraw_routes0
savings_withdraw_requests0
last_account_recovery1970-01-01T00:00:00
reset_accountnull
last_owner_update1970-01-01T00:00:00
last_account_update1970-01-01T00:00:00
minedNo
sbd_seconds0
sbd_last_interest_payment1970-01-01T00:00:00
savings_sbd_last_interest_payment1970-01-01T00:00:00
{
  "active": {
    "account_auths": [],
    "key_auths": [
      [
        "STM67UAuiNBnvGhquFpthPG2XJokLopm9pMmr6x6WocqMqMhtuuhb",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "balance": "0.000 STEEM",
  "can_vote": true,
  "comment_count": 0,
  "created": "2017-06-21T22:57:24",
  "curation_rewards": 0,
  "delegated_vesting_shares": "0.000000 VESTS",
  "downvote_manabar": {
    "current_mana": 2035914951,
    "last_update_time": 1779066420
  },
  "guest_bloggers": [],
  "id": 211591,
  "json_metadata": "",
  "last_account_recovery": "1970-01-01T00:00:00",
  "last_account_update": "1970-01-01T00:00:00",
  "last_owner_update": "1970-01-01T00:00:00",
  "last_post": "2017-06-22T04:02:30",
  "last_root_post": "2017-06-22T04:02:30",
  "last_vote_time": "2017-06-22T04:02:30",
  "lifetime_vote_count": 0,
  "market_history": [],
  "memo_key": "STM5PEPj2XdMtHUYW8WVQFqk4s5ZxdM6dUdGNA5UmEZtPtAsHT8eC",
  "mined": false,
  "name": "hetdev",
  "next_vesting_withdrawal": "1969-12-31T23:59:59",
  "other_history": [],
  "owner": {
    "account_auths": [],
    "key_auths": [
      [
        "STM7TLZpLSC9fvThLGtJxGGnH8TneTZtX9ryvvf5bW77kYdc897e6",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "pending_claimed_accounts": 0,
  "post_bandwidth": 0,
  "post_count": 1,
  "post_history": [],
  "posting": {
    "account_auths": [],
    "key_auths": [
      [
        "STM5yN6K6K4aa3knAGRSE52q8trkWVET44ZnRuUsqe9Yk65xRvvue",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "posting_json_metadata": "",
  "posting_rewards": 0,
  "proxied_vsf_votes": [
    0,
    0,
    0,
    0
  ],
  "proxy": "",
  "received_vesting_shares": "7108.736773 VESTS",
  "recovery_account": "steem",
  "reputation": 18135913,
  "reset_account": "null",
  "reward_sbd_balance": "0.000 SBD",
  "reward_steem_balance": "0.000 STEEM",
  "reward_vesting_balance": "0.000000 VESTS",
  "reward_vesting_steem": "0.000 STEEM",
  "savings_balance": "0.000 STEEM",
  "savings_sbd_balance": "0.000 SBD",
  "savings_sbd_last_interest_payment": "1970-01-01T00:00:00",
  "savings_sbd_seconds": "0",
  "savings_sbd_seconds_last_update": "1970-01-01T00:00:00",
  "savings_withdraw_requests": 0,
  "sbd_balance": "0.000 SBD",
  "sbd_last_interest_payment": "1970-01-01T00:00:00",
  "sbd_seconds": "0",
  "sbd_seconds_last_update": "1970-01-01T00:00:00",
  "tags_usage": [],
  "to_withdraw": 0,
  "transfer_history": [],
  "vesting_balance": "0.000 STEEM",
  "vesting_shares": "1034.923033 VESTS",
  "vesting_withdraw_rate": "0.000000 VESTS",
  "vote_history": [],
  "voting_manabar": {
    "current_mana": "8143659806",
    "last_update_time": 1779066420
  },
  "voting_power": 0,
  "withdraw_routes": 0,
  "withdrawn": 0,
  "witness_votes": [],
  "witnesses_voted_for": 0,
  "rank": 1450332
}

Withdraw Routes

IncomingOutgoing
Empty
Empty
{
  "incoming": [],
  "outgoing": []
}
From Date
To Date
steemdelegated 4.371 SP to @hetdev
2026/05/18 01:07:00
delegateehetdev
delegatorsteem
vesting shares7108.736773 VESTS
Transaction InfoBlock #106144480/Trx 0a340593f643043928dfe9481a803df10e0022f2
View Raw JSON Data
{
  "block": 106144480,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "7108.736773 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-05-18T01:07:00",
  "trx_id": "0a340593f643043928dfe9481a803df10e0022f2",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 2.703 SP to @hetdev
2026/05/12 07:20:45
delegateehetdev
delegatorsteem
vesting shares4396.526368 VESTS
Transaction InfoBlock #105979908/Trx c244d561e4e8bfa8cf646d648beb1848ed6fc2dd
View Raw JSON Data
{
  "block": 105979908,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "4396.526368 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-05-12T07:20:45",
  "trx_id": "c244d561e4e8bfa8cf646d648beb1848ed6fc2dd",
  "trx_in_block": 3,
  "virtual_op": 0
}
steemdelegated 4.379 SP to @hetdev
2026/04/26 00:26:27
delegateehetdev
delegatorsteem
vesting shares7121.252529 VESTS
Transaction InfoBlock #105512106/Trx c2580cc603adcb1a0936fd348ae8d32c4aadefc9
View Raw JSON Data
{
  "block": 105512106,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "7121.252529 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-04-26T00:26:27",
  "trx_id": "c2580cc603adcb1a0936fd348ae8d32c4aadefc9",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 2.729 SP to @hetdev
2026/01/23 10:07:09
delegateehetdev
delegatorsteem
vesting shares4438.073187 VESTS
Transaction InfoBlock #102854589/Trx 100c922bad74502dac18adeed4b242c218f60596
View Raw JSON Data
{
  "block": 102854589,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "4438.073187 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-01-23T10:07:09",
  "trx_id": "100c922bad74502dac18adeed4b242c218f60596",
  "trx_in_block": 1,
  "virtual_op": 0
}
steemdelegated 2.830 SP to @hetdev
2024/12/17 05:25:09
delegateehetdev
delegatorsteem
vesting shares4602.292384 VESTS
Transaction InfoBlock #91300968/Trx 098fa1cb39292abc7ff33eb604645548fbafa4fa
View Raw JSON Data
{
  "block": 91300968,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "4602.292384 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2024-12-17T05:25:09",
  "trx_id": "098fa1cb39292abc7ff33eb604645548fbafa4fa",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 2.934 SP to @hetdev
2023/11/13 21:07:33
delegateehetdev
delegatorsteem
vesting shares4771.425916 VESTS
Transaction InfoBlock #79855159/Trx 0ff0ce23ef0972f8c217167f12fa48224c9d2ea2
View Raw JSON Data
{
  "block": 79855159,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "4771.425916 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2023-11-13T21:07:33",
  "trx_id": "0ff0ce23ef0972f8c217167f12fa48224c9d2ea2",
  "trx_in_block": 4,
  "virtual_op": 0
}
steemdelegated 4.740 SP to @hetdev
2023/09/21 22:50:51
delegateehetdev
delegatorsteem
vesting shares7708.704702 VESTS
Transaction InfoBlock #78349046/Trx d07c22208f9d9122747edf3cb4c3c7f9e1e99be7
View Raw JSON Data
{
  "block": 78349046,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "7708.704702 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2023-09-21T22:50:51",
  "trx_id": "d07c22208f9d9122747edf3cb4c3c7f9e1e99be7",
  "trx_in_block": 1,
  "virtual_op": 0
}
steemdelegated 4.876 SP to @hetdev
2022/11/03 12:30:36
delegateehetdev
delegatorsteem
vesting shares7930.386140 VESTS
Transaction InfoBlock #69114225/Trx 753f2d9163201df4cd73306f91f74ad5874e3ff5
View Raw JSON Data
{
  "block": 69114225,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "7930.386140 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2022-11-03T12:30:36",
  "trx_id": "753f2d9163201df4cd73306f91f74ad5874e3ff5",
  "trx_in_block": 2,
  "virtual_op": 0
}
steemdelegated 5.012 SP to @hetdev
2022/01/17 11:42:30
delegateehetdev
delegatorsteem
vesting shares8150.919371 VESTS
Transaction InfoBlock #60810312/Trx 754db2c387ba7bf291c505882367b37f88424881
View Raw JSON Data
{
  "block": 60810312,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "8150.919371 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2022-01-17T11:42:30",
  "trx_id": "754db2c387ba7bf291c505882367b37f88424881",
  "trx_in_block": 22,
  "virtual_op": 0
}
steemdelegated 5.125 SP to @hetdev
2021/06/14 01:35:39
delegateehetdev
delegatorsteem
vesting shares8334.688029 VESTS
Transaction InfoBlock #54608655/Trx 2ac8c39f5995e536f558fb85b0928314b55708ff
View Raw JSON Data
{
  "block": 54608655,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "8334.688029 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-06-14T01:35:39",
  "trx_id": "2ac8c39f5995e536f558fb85b0928314b55708ff",
  "trx_in_block": 2,
  "virtual_op": 0
}
steemdelegated 5.240 SP to @hetdev
2020/12/11 11:53:09
delegateehetdev
delegatorsteem
vesting shares8522.110003 VESTS
Transaction InfoBlock #49356076/Trx d258c6260f73a441fde5b200eeb4dfc1ec25d56c
View Raw JSON Data
{
  "block": 49356076,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "8522.110003 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-12-11T11:53:09",
  "trx_id": "d258c6260f73a441fde5b200eeb4dfc1ec25d56c",
  "trx_in_block": 2,
  "virtual_op": 0
}
steemdelegated 1.176 SP to @hetdev
2020/12/06 05:30:18
delegateehetdev
delegatorsteem
vesting shares1912.543513 VESTS
Transaction InfoBlock #49207638/Trx 2f5dc7087019019251b83e18edac935973c1c8f1
View Raw JSON Data
{
  "block": 49207638,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "1912.543513 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-12-06T05:30:18",
  "trx_id": "2f5dc7087019019251b83e18edac935973c1c8f1",
  "trx_in_block": 1,
  "virtual_op": 0
}
steemdelegated 5.244 SP to @hetdev
2020/12/05 15:31:06
delegateehetdev
delegatorsteem
vesting shares8528.317857 VESTS
Transaction InfoBlock #49191171/Trx 53e254de749712c2e0c0cece8be7f6d53c99d372
View Raw JSON Data
{
  "block": 49191171,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "8528.317857 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-12-05T15:31:06",
  "trx_id": "53e254de749712c2e0c0cece8be7f6d53c99d372",
  "trx_in_block": 6,
  "virtual_op": 0
}
steemdelegated 1.181 SP to @hetdev
2020/11/02 17:12:15
delegateehetdev
delegatorsteem
vesting shares1920.017158 VESTS
Transaction InfoBlock #48259644/Trx 77d3b21dca3b9847bf35390fb0905d3cc8bf8cfb
View Raw JSON Data
{
  "block": 48259644,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "1920.017158 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-11-02T17:12:15",
  "trx_id": "77d3b21dca3b9847bf35390fb0905d3cc8bf8cfb",
  "trx_in_block": 6,
  "virtual_op": 0
}
steemdelegated 5.369 SP to @hetdev
2020/05/09 06:28:21
delegateehetdev
delegatorsteem
vesting shares8731.123216 VESTS
Transaction InfoBlock #43217896/Trx bd295cbecbaa68fb7defa81185666f890c213a56
View Raw JSON Data
{
  "block": 43217896,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "8731.123216 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-05-09T06:28:21",
  "trx_id": "bd295cbecbaa68fb7defa81185666f890c213a56",
  "trx_in_block": 13,
  "virtual_op": 0
}
steemdelegated 1.201 SP to @hetdev
2020/05/08 10:11:36
delegateehetdev
delegatorsteem
vesting shares1953.311140 VESTS
Transaction InfoBlock #43194130/Trx f04e019bee122c2e8ae1b32c0e855f7b8743ae54
View Raw JSON Data
{
  "block": 43194130,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "1953.311140 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-05-08T10:11:36",
  "trx_id": "f04e019bee122c2e8ae1b32c0e855f7b8743ae54",
  "trx_in_block": 21,
  "virtual_op": 0
}
steemdelegated 5.377 SP to @hetdev
2020/04/16 00:23:15
delegateehetdev
delegatorsteem
vesting shares8744.010664 VESTS
Transaction InfoBlock #42565779/Trx 4d7a9bece3b9225abb4e4cf6ebf96b5a7cb7bce6
View Raw JSON Data
{
  "block": 42565779,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "8744.010664 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-04-16T00:23:15",
  "trx_id": "4d7a9bece3b9225abb4e4cf6ebf96b5a7cb7bce6",
  "trx_in_block": 20,
  "virtual_op": 0
}
2019/06/22 00:17:42
authorsteemitboard
bodyCongratulations @hetdev! You received a personal award! <table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@hetdev/birthday2.png</td><td>Happy Birthday! - You are on the Steem blockchain for 2 years!</td></tr></table> <sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@hetdev) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=hetdev)_</sub> **Do not miss the last post from @steemitboard:** <table><tr><td><a href="https://steemit.com/steemitboard/@steemitboard/the-steem-community-has-lost-an-epic-member-farewell-woflhart"><img src="https://steemitimages.com/64x128/https://cdn.steemitimages.com/DQmQWnM36SWCPGn98nY83M1ArgweMz5fnovQEp2E4FiDdug/Wolfhart_header.png"></a></td><td><a href="https://steemit.com/steemitboard/@steemitboard/the-steem-community-has-lost-an-epic-member-farewell-woflhart">The Steem community has lost an epic member! Farewell @woflhart!</a></td></tr><tr><td><a href="https://steemit.com/steemtoolbar/@steemitboard/steemtoolbar-update-display-bug-fixed"><img src="https://steemitimages.com/64x128/http://i.cubeupload.com/7CiQEO.png"></a></td><td><a href="https://steemit.com/steemtoolbar/@steemitboard/steemtoolbar-update-display-bug-fixed">SteemitBoard - Witness Update</a></td></tr><tr><td><a href="https://steemit.com/steem/@steemitboard/do-not-miss-the-coming-rocky-mountain-steem-meetup-and-get-a-new-community-badge"><img src="https://steemitimages.com/64x128/https://cdn.steemitimages.com/DQmUphCGZFWgt6bJ1XTtunV7esnwy6bxnGqcLcHAV3NEqnQ/meetup-rocky-mountain.png"></a></td><td><a href="https://steemit.com/steem/@steemitboard/do-not-miss-the-coming-rocky-mountain-steem-meetup-and-get-a-new-community-badge">Do not miss the coming Rocky Mountain Steem Meetup and get a new community badge!</a></td></tr></table> ###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!
json metadata{"image":["https://steemitboard.com/img/notify.png"]}
parent authorhetdev
parent permlinkgenerate-a-html-with-the-ebay-categories-tree-by-terminal-and-save-it-in-a-sqlite-db
permlinksteemitboard-notify-hetdev-20190622t001742000z
title
Transaction InfoBlock #34007383/Trx 4b434b0fc0f58fa1e81cdac5bc8c04322d399812
View Raw JSON Data
{
  "block": 34007383,
  "op": [
    "comment",
    {
      "author": "steemitboard",
      "body": "Congratulations @hetdev! You received a personal award!\n\n<table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@hetdev/birthday2.png</td><td>Happy Birthday! - You are on the Steem blockchain for 2 years!</td></tr></table>\n\n<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@hetdev) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=hetdev)_</sub>\n\n\n**Do not miss the last post from @steemitboard:**\n<table><tr><td><a href=\"https://steemit.com/steemitboard/@steemitboard/the-steem-community-has-lost-an-epic-member-farewell-woflhart\"><img src=\"https://steemitimages.com/64x128/https://cdn.steemitimages.com/DQmQWnM36SWCPGn98nY83M1ArgweMz5fnovQEp2E4FiDdug/Wolfhart_header.png\"></a></td><td><a href=\"https://steemit.com/steemitboard/@steemitboard/the-steem-community-has-lost-an-epic-member-farewell-woflhart\">The Steem community has lost an epic member! Farewell @woflhart!</a></td></tr><tr><td><a href=\"https://steemit.com/steemtoolbar/@steemitboard/steemtoolbar-update-display-bug-fixed\"><img src=\"https://steemitimages.com/64x128/http://i.cubeupload.com/7CiQEO.png\"></a></td><td><a href=\"https://steemit.com/steemtoolbar/@steemitboard/steemtoolbar-update-display-bug-fixed\">SteemitBoard - Witness Update</a></td></tr><tr><td><a href=\"https://steemit.com/steem/@steemitboard/do-not-miss-the-coming-rocky-mountain-steem-meetup-and-get-a-new-community-badge\"><img src=\"https://steemitimages.com/64x128/https://cdn.steemitimages.com/DQmUphCGZFWgt6bJ1XTtunV7esnwy6bxnGqcLcHAV3NEqnQ/meetup-rocky-mountain.png\"></a></td><td><a href=\"https://steemit.com/steem/@steemitboard/do-not-miss-the-coming-rocky-mountain-steem-meetup-and-get-a-new-community-badge\">Do not miss the coming Rocky Mountain Steem Meetup and get a new community badge!</a></td></tr></table>\n\n###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}",
      "parent_author": "hetdev",
      "parent_permlink": "generate-a-html-with-the-ebay-categories-tree-by-terminal-and-save-it-in-a-sqlite-db",
      "permlink": "steemitboard-notify-hetdev-20190622t001742000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-06-22T00:17:42",
  "trx_id": "4b434b0fc0f58fa1e81cdac5bc8c04322d399812",
  "trx_in_block": 16,
  "virtual_op": 0
}
steemdelegated 5.497 SP to @hetdev
2019/05/12 17:28:15
delegateehetdev
delegatorsteem
vesting shares8939.627477 VESTS
Transaction InfoBlock #32848568/Trx e200ba6849359a2a180162a200017c2e34a6685e
View Raw JSON Data
{
  "block": 32848568,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "8939.627477 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-05-12T17:28:15",
  "trx_id": "e200ba6849359a2a180162a200017c2e34a6685e",
  "trx_in_block": 20,
  "virtual_op": 0
}
steemdelegated 5.620 SP to @hetdev
2018/05/16 20:20:24
delegateehetdev
delegatorsteem
vesting shares9139.275875 VESTS
Transaction InfoBlock #22489909/Trx 9c8f3ba833fd700f9ca889db863229c7ad5f59ee
View Raw JSON Data
{
  "block": 22489909,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "9139.275875 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-16T20:20:24",
  "trx_id": "9c8f3ba833fd700f9ca889db863229c7ad5f59ee",
  "trx_in_block": 13,
  "virtual_op": 0
}
steemdelegated 18.256 SP to @hetdev
2018/01/09 06:39:15
delegateehetdev
delegatorsteem
vesting shares29690.266259 VESTS
Transaction InfoBlock #18819584/Trx 095998b55a8659c6ba8d97a44407434e4288b1ed
View Raw JSON Data
{
  "block": 18819584,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "29690.266259 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-09T06:39:15",
  "trx_id": "095998b55a8659c6ba8d97a44407434e4288b1ed",
  "trx_in_block": 20,
  "virtual_op": 0
}
steemdelegated 18.410 SP to @hetdev
2017/08/04 05:18:24
delegateehetdev
delegatorsteem
vesting shares29941.076967 VESTS
Transaction InfoBlock #14271445/Trx 83eee6b4319ada8e41a9ed604b9acc310ff92a5e
View Raw JSON Data
{
  "block": 14271445,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "hetdev",
      "delegator": "steem",
      "vesting_shares": "29941.076967 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-08-04T05:18:24",
  "trx_id": "83eee6b4319ada8e41a9ed604b9acc310ff92a5e",
  "trx_in_block": 4,
  "virtual_op": 0
}
2017/06/22 04:02:30
authorhetdev
permlinkgenerate-a-html-with-the-ebay-categories-tree-by-terminal-and-save-it-in-a-sqlite-db
voterhetdev
weight10000 (100.00%)
Transaction InfoBlock #13033172/Trx 434fe4ceb0ed73c8ea97cca70fac2f16b912e3a7
View Raw JSON Data
{
  "block": 13033172,
  "op": [
    "vote",
    {
      "author": "hetdev",
      "permlink": "generate-a-html-with-the-ebay-categories-tree-by-terminal-and-save-it-in-a-sqlite-db",
      "voter": "hetdev",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-06-22T04:02:30",
  "trx_id": "434fe4ceb0ed73c8ea97cca70fac2f16b912e3a7",
  "trx_in_block": 0,
  "virtual_op": 0
}
2017/06/22 04:02:30
authorhetdev
body<html> <p><img src="https://cdn-images-1.medium.com/max/800/1*jRAP_sWe-KSSrbQff-i8eA.png" width="551" height="902"/></p> <p>At the end we’re going to generate a&nbsp;.html file that would look like the image above.First of all we’re going to create the categories.sh script to control de terminal commands.<br> The script will manage two terminal commands</p> <ul> <li>— build</li> <li>— render [categoryID]</li> </ul> <p><br></p> <pre><code>#!/bin/sh</code></pre> <pre><code>if [ $# -eq 0 ]<br> then<br> echo “Please insert — rebuild or— render [categoryId]”<br> else<br> if [ $1 = “ — rebuild” ]; <br> &nbsp;then exec python db.py<br> elif [ $1 = “ — render” ]; <br> &nbsp;then exec python html.py $2<br> fi<br> fi</code></pre> <p>Then we create two python scripts, one to manage the the database CRUD actions and the rest query, and the other to render the&nbsp;.html file.The first one is called db.py, and is going to search for a db file called “categories_ht.db” if the file exists, the script will delete it, then create a new db file called “categories_ht.db”.</p> <pre><code>#!/usr/bin/python<br> # -*- coding: utf-8 -*-<br> __author__ = ‘hetdev’</code></pre> <pre><code>import sqlite3<br> import os<br> import requests<br> import xml.etree.ElementTree as ET</code></pre> <pre><code>def delete_database():<br> filelist = [ f for f in os.listdir(“.”) if f == ‘categories_ht.db’ ]<br> for f in filelist:<br> os.remove(f)</code></pre> <pre><code>def create_database():<br> conn = sqlite3.connect(‘categories_ht.db’)<br> c = conn.cursor()<br> c.execute(‘’’CREATE TABLE categories<br> (id integer primary key, categoryName text, categoryLevel integer, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bestOfferEnabled integer,<br> categoryParentID integer)’’’)</code></pre> <pre><code>conn.commit()<br> conn.close()</code></pre> <p>Make the REST api request, and save the data into the db.</p> <pre><code>def get_categories():<br> request_headers = {<br> ‘X-EBAY-API-CALL-NAME’: ‘GetCategories’,<br> ‘X-EBAY-API-APP-NAME’: ‘EchoBay62–5538–466c-b43b-662768d6841’,<br> ‘X-EBAY-API-CERT-NAME’: ‘00dd08ab-2082–4e3c-9518–5f4298f296db’,<br> ‘X-EBAY-API-DEV-NAME’: ‘16a26b1b-26cf-442d-906d-597b60c41c19’,<br> ‘X-EBAY-API-SITEID’: 0,<br> ‘X-EBAY-API-COMPATIBILITY-LEVEL’: 861<br> }<br> data_xml = ‘’’&lt;?xml version=”1.0" encoding=”utf-8"?&gt;<br> &lt;GetCategoriesRequest xmlns=”urn:ebay:apis:eBLBaseComponents”&gt;<br> &lt;CategorySiteID&gt;0&lt;/CategorySiteID&gt;<br> &lt;ViewAllNodes&gt;True&lt;/ViewAllNodes&gt;<br> &lt;DetailLevel&gt;ReturnAll&lt;/DetailLevel&gt;<br> &lt;RequesterCredentials&gt;<br> &lt;eBayAuthToken&gt;AgAAAA**AQAAAA**aAAAAA**y6rfVg**nY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6wFk4GhAJeHqQydj6x9nY+seQ**PbwDAA**AAMAAA**8OlM6fqJvNyuqK22AdBhw6/Ef9NR5TFA4TbCh2Kj5aZa+cRwuCmml6OFQ9bPWMiCn6fRqiKYjZW4SnihoRtnJhcq9UQL7sgWd7S7rV6k2LMAvUdPWbIadFnxroUnbDpAfCxx+MKKVo4Ez6ENlhtYFVhuVXYRWZ644UVGuTz3JMFdS97ZvTQiZI6oKkRPJM7uYs3+t2VvTzuaI63zMrtIZtsHO2H+qxrqChDL4eGr1K6ugJ1tSYztrmhf2vdtd01QID2CbVrEI/NJOypCs8nTXKEcvMtEsaUmU6ZdlmhTWnfHa45UAWHlEC/sG86r7Y/g72DEhl1SOrRLnng9CnTTT0274q9aJDwgoxK1u6TyP1qoKsa8FrCzIFdevT3FZ2d59PCk6jdKgKEyYiP8EmeNOK82QDOLverS7AhUrJB/fhMMurYy9mQpl0wyz5P8SVbtRb5r8ae3VXM2Sy2+7iSXwjwTyYDkS/ZeBMAEjXslMptIVMUi7pKqUMZofp2nClqrYOJ7k9SHCO3tCG6eckKznOdznSlcizf8/gHNg8AX9i4Dxx6s+L7HebrYptYM565446z7W3hD6fwuzXMONL0q0jffaJvF+buKFVTN/pPXhO/idD310Im5z1NGmb8/suCD6h0jOEGbSl8VRcQ/vNil2ddojHRmKTZr425Rc1JZhAfka4Yem8PmJrVE64C+4PbGXpusrEMK0z5fDpxcAfBw1B+zug42MZuFlO/1xvKEkwopwHlBq4S02sHuiZpfte23&lt;/eBayAuthToken&gt;<br> &lt;/RequesterCredentials&gt;<br> &lt;/GetCategoriesRequest&gt;’’’</code></pre> <pre><code>r =requests.post(‘<a href="https://api.sandbox.ebay.com/ws/api.dll%27">https://api.sandbox.ebay.com/ws/api.dll'</a>, headers=request_headers, data=data_xml)</code></pre> <pre><code>root = ET.fromstring(r.text.encode(‘utf-8’))<br> categories = root.find(‘{urn:ebay:apis:eBLBaseComponents}CategoryArray’)</code></pre> <pre><code>conn = sqlite3.connect(‘categories_ht.db’)<br> c = conn.cursor()<br> categories_array_sql = []<br> for child in categories:<br> id = int(child.find(‘{urn:ebay:apis:eBLBaseComponents}CategoryID’).text)<br> categoryName = child.find(‘{urn:ebay:apis:eBLBaseComponents}CategoryName’).text<br> categoryLevel = int(child.find(‘{urn:ebay:apis:eBLBaseComponents}CategoryLevel’).text)</code></pre> <pre><code>bestOfferEnabled = 0<br> try:<br> if child.find(‘{urn:ebay:apis:eBLBaseComponents}BestOfferEnabled’).text == ‘true’:<br> bestOfferEnabled = 1<br> except Exception as e:<br> pass</code></pre> <pre><code>categoryParentID = int(child.find(‘{urn:ebay:apis:eBLBaseComponents}CategoryParentID’).text)<br> if categoryParentID == id:<br> categoryParentID = -1</code></pre> <pre><code>category = (id, categoryName, categoryLevel, bestOfferEnabled, categoryParentID)<br> categories_array_sql.append(category)</code></pre> <pre><code>c.executemany(‘INSERT INTO categories VALUES (?,?,?,?,?)’, categories_array_sql)</code></pre> <pre><code>conn.commit()<br> conn.close()</code></pre> <p>At then we call the previous methods.</p> <pre><code>try:<br> delete_database()<br> create_database()<br> get_categories()<br> except Exception as e:<br> print e<br> delete_database()<br> print (‘Error creating the db or getting the data’)</code></pre> <p>The other python script is called html.py, this script will search for the category information and the data of their sons, then render it in a html file.The methods to get the category data and the method to get the sons category data.</p> <pre><code>#!/usr/bin/python<br> # -*- coding: utf-8 -*-<br> __author__ = ‘hetdev’</code></pre> <pre><code>import sqlite3<br> import sys</code></pre> <pre><code>def getCategory(categoryId):<br> conn = sqlite3.connect(‘categories_ht.db’)<br> c = conn.cursor()<br> category = None<br> c.execute(“SELECT * FROM categories WHERE id = “ + categoryId)<br> category = c.fetchone()<br> conn.commit()<br> conn.close()</code></pre> <pre><code>return category</code></pre> <pre><code>def getCategorySons(categoryId):<br> conn = sqlite3.connect(‘categories_ht.db’)<br> c = conn.cursor()<br> categories = None<br> c.execute(“SELECT * FROM categories WHERE categoryParentID = “ + str(categoryId))<br> categories = c.fetchall()<br> conn.commit()<br> conn.close()</code></pre> <pre><code>return categories</code></pre> <p>The method to add the list and the list items.</p> <pre><code>def render_category_list(f, category):<br> list_header = “&lt;ul&gt;”<br> f.write(list_header)</code></pre> <pre><code>name = category[1]<br> list_item = “&lt;li&gt;” + name.encode(‘utf-8’) + “&lt;/li&gt;”<br> f.write(list_item)</code></pre> <pre><code>categoryId = category[0]<br> sons = getCategorySons(categoryId)<br> if len(sons)&gt;0:<br> for son in sons:<br> render_category_list(f,son)</code></pre> <pre><code>list_footer = “&lt;/ul&gt;”<br> f.write(list_footer)</code></pre> <p>Method to create the html file.</p> <pre><code>def start():<br> categoryId = sys.argv[1]<br> category = getCategory(categoryId)<br> if category is None:<br> print ‘No category with ID:’ + categoryId<br> else:<br> html_file_name = categoryId + ‘.html’<br> f = open( html_file_name,’w’)</code></pre> <pre><code>header = “””&lt;!DOCTYPE html&gt;<br> &lt;head&gt;<br> &lt;meta charset=”utf-8"&gt;<br> &lt;link rel=”stylesheet” type=”text/css” href=”<a href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css">https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css</a>"&gt;<br> &lt;link href=”<a href="http://fonts.googleapis.com/css?family=Open+Sans">http://fonts.googleapis.com/css?family=Open+Sans</a>" rel=”stylesheet” type=”text/css”&gt;<br> &lt;/head&gt;<br> &lt;body&gt;<br> &lt;h2&gt;Ebay Categories List&lt;/h2&gt;”””<br> f.write(header)</code></pre> <pre><code>render_category_list(f, category)</code></pre> <pre><code>footer = “””&lt;/body&gt;<br> &lt;/html&gt;”””<br> f.write(footer)<br> f.close()<br> print html_file_name</code></pre> <p>At the we call the previous method</p> <pre><code>try:<br> start()<br> except Exception as e:<br> # print e<br> print (‘Error creating the html file’)</code></pre> <p>Finally we can run in the terminal the commands below.</p> <pre><code>./categories.sh &nbsp;--rebuild<br> ./categories.sh &nbsp;--render 1</code></pre> <p>The product is a html with the category list.Link to download de files:&nbsp;</p> <p><a href="https://mega.nz/#F!bIkSBDDI!kFewaVf4HLIrQvX_ZSjhSA">https://mega.nz/#F!bIkSBDDI!kFewaVf4HLIrQvX_ZSjhSA</a></p> <p>&nbsp;As always thanks for reading!&nbsp;</p> </html>
json metadata{"tags":["python","ebay","sqlite","developer","tutorial"],"image":["https://cdn-images-1.medium.com/max/800/1*jRAP_sWe-KSSrbQff-i8eA.png"],"links":["https://api.sandbox.ebay.com/ws/api.dll%27","https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css","http://fonts.googleapis.com/css?family=Open+Sans","https://mega.nz/#F!bIkSBDDI!kFewaVf4HLIrQvX_ZSjhSA"],"app":"steemit/0.1","format":"html"}
parent author
parent permlinkpython
permlinkgenerate-a-html-with-the-ebay-categories-tree-by-terminal-and-save-it-in-a-sqlite-db
titleGenerate a .html with the Ebay Categories Tree by terminal and save it in a sqlite DB
Transaction InfoBlock #13033172/Trx 434fe4ceb0ed73c8ea97cca70fac2f16b912e3a7
View Raw JSON Data
{
  "block": 13033172,
  "op": [
    "comment",
    {
      "author": "hetdev",
      "body": "<html>\n<p><img src=\"https://cdn-images-1.medium.com/max/800/1*jRAP_sWe-KSSrbQff-i8eA.png\" width=\"551\" height=\"902\"/></p>\n<p>At the end we’re going to generate a&nbsp;.html file that would look like the image above.First of all we’re going to create the categories.sh script to control de terminal commands.<br>\nThe script will manage two terminal commands</p>\n<ul>\n  <li>— build</li>\n  <li>— render [categoryID]</li>\n</ul>\n<p><br></p>\n<pre><code>#!/bin/sh</code></pre>\n<pre><code>if [ $# -eq 0 ]<br>\n then<br>\n echo “Please insert — rebuild or— render [categoryId]”<br>\nelse<br>\n if [ $1 = “ — rebuild” ]; <br>\n &nbsp;then exec python db.py<br>\n elif [ $1 = “ — render” ]; <br>\n &nbsp;then exec python html.py $2<br>\n fi<br>\nfi</code></pre>\n<p>Then we create two python scripts, one to manage the the database CRUD actions and the rest query, and the other to render the&nbsp;.html file.The first one is called db.py, and is going to search for a db file called “categories_ht.db” if the file exists, the script will delete it, then create a new db file called “categories_ht.db”.</p>\n<pre><code>#!/usr/bin/python<br>\n# -*- coding: utf-8 -*-<br>\n__author__ = ‘hetdev’</code></pre>\n<pre><code>import sqlite3<br>\nimport os<br>\nimport requests<br>\nimport xml.etree.ElementTree as ET</code></pre>\n<pre><code>def delete_database():<br>\n filelist = [ f for f in os.listdir(“.”) if f == ‘categories_ht.db’ ]<br>\n for f in filelist:<br>\n os.remove(f)</code></pre>\n<pre><code>def create_database():<br>\n conn = sqlite3.connect(‘categories_ht.db’)<br>\n c = conn.cursor()<br>\n c.execute(‘’’CREATE TABLE categories<br>\n (id integer primary key, categoryName text, categoryLevel integer, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bestOfferEnabled integer,<br>\n categoryParentID integer)’’’)</code></pre>\n<pre><code>conn.commit()<br>\nconn.close()</code></pre>\n<p>Make the REST api request, and save the data into the db.</p>\n<pre><code>def get_categories():<br>\n request_headers = {<br>\n ‘X-EBAY-API-CALL-NAME’: ‘GetCategories’,<br>\n ‘X-EBAY-API-APP-NAME’: ‘EchoBay62–5538–466c-b43b-662768d6841’,<br>\n ‘X-EBAY-API-CERT-NAME’: ‘00dd08ab-2082–4e3c-9518–5f4298f296db’,<br>\n ‘X-EBAY-API-DEV-NAME’: ‘16a26b1b-26cf-442d-906d-597b60c41c19’,<br>\n ‘X-EBAY-API-SITEID’: 0,<br>\n ‘X-EBAY-API-COMPATIBILITY-LEVEL’: 861<br>\n }<br>\n data_xml = ‘’’&lt;?xml version=”1.0\" encoding=”utf-8\"?&gt;<br>\n &lt;GetCategoriesRequest xmlns=”urn:ebay:apis:eBLBaseComponents”&gt;<br>\n &lt;CategorySiteID&gt;0&lt;/CategorySiteID&gt;<br>\n &lt;ViewAllNodes&gt;True&lt;/ViewAllNodes&gt;<br>\n &lt;DetailLevel&gt;ReturnAll&lt;/DetailLevel&gt;<br>\n &lt;RequesterCredentials&gt;<br>\n &lt;eBayAuthToken&gt;AgAAAA**AQAAAA**aAAAAA**y6rfVg**nY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6wFk4GhAJeHqQydj6x9nY+seQ**PbwDAA**AAMAAA**8OlM6fqJvNyuqK22AdBhw6/Ef9NR5TFA4TbCh2Kj5aZa+cRwuCmml6OFQ9bPWMiCn6fRqiKYjZW4SnihoRtnJhcq9UQL7sgWd7S7rV6k2LMAvUdPWbIadFnxroUnbDpAfCxx+MKKVo4Ez6ENlhtYFVhuVXYRWZ644UVGuTz3JMFdS97ZvTQiZI6oKkRPJM7uYs3+t2VvTzuaI63zMrtIZtsHO2H+qxrqChDL4eGr1K6ugJ1tSYztrmhf2vdtd01QID2CbVrEI/NJOypCs8nTXKEcvMtEsaUmU6ZdlmhTWnfHa45UAWHlEC/sG86r7Y/g72DEhl1SOrRLnng9CnTTT0274q9aJDwgoxK1u6TyP1qoKsa8FrCzIFdevT3FZ2d59PCk6jdKgKEyYiP8EmeNOK82QDOLverS7AhUrJB/fhMMurYy9mQpl0wyz5P8SVbtRb5r8ae3VXM2Sy2+7iSXwjwTyYDkS/ZeBMAEjXslMptIVMUi7pKqUMZofp2nClqrYOJ7k9SHCO3tCG6eckKznOdznSlcizf8/gHNg8AX9i4Dxx6s+L7HebrYptYM565446z7W3hD6fwuzXMONL0q0jffaJvF+buKFVTN/pPXhO/idD310Im5z1NGmb8/suCD6h0jOEGbSl8VRcQ/vNil2ddojHRmKTZr425Rc1JZhAfka4Yem8PmJrVE64C+4PbGXpusrEMK0z5fDpxcAfBw1B+zug42MZuFlO/1xvKEkwopwHlBq4S02sHuiZpfte23&lt;/eBayAuthToken&gt;<br>\n &lt;/RequesterCredentials&gt;<br>\n &lt;/GetCategoriesRequest&gt;’’’</code></pre>\n<pre><code>r =requests.post(‘<a href=\"https://api.sandbox.ebay.com/ws/api.dll%27\">https://api.sandbox.ebay.com/ws/api.dll'</a>, headers=request_headers, data=data_xml)</code></pre>\n<pre><code>root = ET.fromstring(r.text.encode(‘utf-8’))<br>\n categories = root.find(‘{urn:ebay:apis:eBLBaseComponents}CategoryArray’)</code></pre>\n<pre><code>conn = sqlite3.connect(‘categories_ht.db’)<br>\n c = conn.cursor()<br>\n categories_array_sql = []<br>\n for child in categories:<br>\n id = int(child.find(‘{urn:ebay:apis:eBLBaseComponents}CategoryID’).text)<br>\n categoryName = child.find(‘{urn:ebay:apis:eBLBaseComponents}CategoryName’).text<br>\n categoryLevel = int(child.find(‘{urn:ebay:apis:eBLBaseComponents}CategoryLevel’).text)</code></pre>\n<pre><code>bestOfferEnabled = 0<br>\n try:<br>\n if child.find(‘{urn:ebay:apis:eBLBaseComponents}BestOfferEnabled’).text == ‘true’:<br>\n bestOfferEnabled = 1<br>\n except Exception as e:<br>\n pass</code></pre>\n<pre><code>categoryParentID = int(child.find(‘{urn:ebay:apis:eBLBaseComponents}CategoryParentID’).text)<br>\n if categoryParentID == id:<br>\n categoryParentID = -1</code></pre>\n<pre><code>category = (id, categoryName, categoryLevel, bestOfferEnabled, categoryParentID)<br>\n categories_array_sql.append(category)</code></pre>\n<pre><code>c.executemany(‘INSERT INTO categories VALUES (?,?,?,?,?)’, categories_array_sql)</code></pre>\n<pre><code>conn.commit()<br>\nconn.close()</code></pre>\n<p>At then we call the previous methods.</p>\n<pre><code>try:<br>\n delete_database()<br>\n create_database()<br>\n get_categories()<br>\nexcept Exception as e:<br>\n print e<br>\n delete_database()<br>\n print (‘Error creating the db or getting the data’)</code></pre>\n<p>The other python script is called html.py, this script will search for the category information and the data of their sons, then render it in a html file.The methods to get the category data and the method to get the sons category data.</p>\n<pre><code>#!/usr/bin/python<br>\n# -*- coding: utf-8 -*-<br>\n__author__ = ‘hetdev’</code></pre>\n<pre><code>import sqlite3<br>\nimport sys</code></pre>\n<pre><code>def getCategory(categoryId):<br>\n conn = sqlite3.connect(‘categories_ht.db’)<br>\n c = conn.cursor()<br>\n category = None<br>\n c.execute(“SELECT * FROM categories WHERE id = “ + categoryId)<br>\n category = c.fetchone()<br>\n conn.commit()<br>\n conn.close()</code></pre>\n<pre><code>return category</code></pre>\n<pre><code>def getCategorySons(categoryId):<br>\n conn = sqlite3.connect(‘categories_ht.db’)<br>\n c = conn.cursor()<br>\n categories = None<br>\n c.execute(“SELECT * FROM categories WHERE categoryParentID = “ + str(categoryId))<br>\n categories = c.fetchall()<br>\n conn.commit()<br>\n conn.close()</code></pre>\n<pre><code>return categories</code></pre>\n<p>The method to add the list and the list items.</p>\n<pre><code>def render_category_list(f, category):<br>\n list_header = “&lt;ul&gt;”<br>\n f.write(list_header)</code></pre>\n<pre><code>name = category[1]<br>\n list_item = “&lt;li&gt;” + name.encode(‘utf-8’) + “&lt;/li&gt;”<br>\n f.write(list_item)</code></pre>\n<pre><code>categoryId = category[0]<br>\n sons = getCategorySons(categoryId)<br>\n if len(sons)&gt;0:<br>\n for son in sons:<br>\n render_category_list(f,son)</code></pre>\n<pre><code>list_footer = “&lt;/ul&gt;”<br>\n f.write(list_footer)</code></pre>\n<p>Method to create the html file.</p>\n<pre><code>def start():<br>\n categoryId = sys.argv[1]<br>\n category = getCategory(categoryId)<br>\n if category is None:<br>\n print ‘No category with ID:’ + categoryId<br>\n else:<br>\n html_file_name = categoryId + ‘.html’<br>\n f = open( html_file_name,’w’)</code></pre>\n<pre><code>header = “””&lt;!DOCTYPE html&gt;<br>\n &lt;head&gt;<br>\n &lt;meta charset=”utf-8\"&gt;<br>\n &lt;link rel=”stylesheet” type=”text/css” href=”<a href=\"https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css\">https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css</a>\"&gt;<br>\n &lt;link href=”<a href=\"http://fonts.googleapis.com/css?family=Open+Sans\">http://fonts.googleapis.com/css?family=Open+Sans</a>\" rel=”stylesheet” type=”text/css”&gt;<br>\n &lt;/head&gt;<br>\n &lt;body&gt;<br>\n &lt;h2&gt;Ebay Categories List&lt;/h2&gt;”””<br>\n f.write(header)</code></pre>\n<pre><code>render_category_list(f, category)</code></pre>\n<pre><code>footer = “””&lt;/body&gt;<br>\n &lt;/html&gt;”””<br>\n f.write(footer)<br>\n f.close()<br>\n print html_file_name</code></pre>\n<p>At the we call the previous method</p>\n<pre><code>try:<br>\n start()<br>\nexcept Exception as e:<br>\n # print e<br>\n print (‘Error creating the html file’)</code></pre>\n<p>Finally we can run in the terminal the commands below.</p>\n<pre><code>./categories.sh &nbsp;--rebuild<br>\n./categories.sh &nbsp;--render 1</code></pre>\n<p>The product is a html with the category list.Link to download de files:&nbsp;</p>\n<p><a href=\"https://mega.nz/#F!bIkSBDDI!kFewaVf4HLIrQvX_ZSjhSA\">https://mega.nz/#F!bIkSBDDI!kFewaVf4HLIrQvX_ZSjhSA</a></p>\n<p>&nbsp;As always thanks for reading!&nbsp;</p>\n</html>",
      "json_metadata": "{\"tags\":[\"python\",\"ebay\",\"sqlite\",\"developer\",\"tutorial\"],\"image\":[\"https://cdn-images-1.medium.com/max/800/1*jRAP_sWe-KSSrbQff-i8eA.png\"],\"links\":[\"https://api.sandbox.ebay.com/ws/api.dll%27\",\"https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css\",\"http://fonts.googleapis.com/css?family=Open+Sans\",\"https://mega.nz/#F!bIkSBDDI!kFewaVf4HLIrQvX_ZSjhSA\"],\"app\":\"steemit/0.1\",\"format\":\"html\"}",
      "parent_author": "",
      "parent_permlink": "python",
      "permlink": "generate-a-html-with-the-ebay-categories-tree-by-terminal-and-save-it-in-a-sqlite-db",
      "title": "Generate a .html with the Ebay Categories Tree by terminal and save it in a sqlite DB"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-06-22T04:02:30",
  "trx_id": "434fe4ceb0ed73c8ea97cca70fac2f16b912e3a7",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemcreated a new account: @hetdev
2017/06/21 22:57:24
active{"account_auths":[],"key_auths":[["STM67UAuiNBnvGhquFpthPG2XJokLopm9pMmr6x6WocqMqMhtuuhb",1]],"weight_threshold":1}
creatorsteem
delegation57000.000000 VESTS
extensions[]
fee0.500 STEEM
json metadata
memo keySTM5PEPj2XdMtHUYW8WVQFqk4s5ZxdM6dUdGNA5UmEZtPtAsHT8eC
new account namehetdev
owner{"account_auths":[],"key_auths":[["STM7TLZpLSC9fvThLGtJxGGnH8TneTZtX9ryvvf5bW77kYdc897e6",1]],"weight_threshold":1}
posting{"account_auths":[],"key_auths":[["STM5yN6K6K4aa3knAGRSE52q8trkWVET44ZnRuUsqe9Yk65xRvvue",1]],"weight_threshold":1}
Transaction InfoBlock #13027071/Trx d05f28e42ff0ae5b13808bf08752d63a0064849b
View Raw JSON Data
{
  "block": 13027071,
  "op": [
    "account_create_with_delegation",
    {
      "active": {
        "account_auths": [],
        "key_auths": [
          [
            "STM67UAuiNBnvGhquFpthPG2XJokLopm9pMmr6x6WocqMqMhtuuhb",
            1
          ]
        ],
        "weight_threshold": 1
      },
      "creator": "steem",
      "delegation": "57000.000000 VESTS",
      "extensions": [],
      "fee": "0.500 STEEM",
      "json_metadata": "",
      "memo_key": "STM5PEPj2XdMtHUYW8WVQFqk4s5ZxdM6dUdGNA5UmEZtPtAsHT8eC",
      "new_account_name": "hetdev",
      "owner": {
        "account_auths": [],
        "key_auths": [
          [
            "STM7TLZpLSC9fvThLGtJxGGnH8TneTZtX9ryvvf5bW77kYdc897e6",
            1
          ]
        ],
        "weight_threshold": 1
      },
      "posting": {
        "account_auths": [],
        "key_auths": [
          [
            "STM5yN6K6K4aa3knAGRSE52q8trkWVET44ZnRuUsqe9Yk65xRvvue",
            1
          ]
        ],
        "weight_threshold": 1
      }
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-06-21T22:57:24",
  "trx_id": "d05f28e42ff0ae5b13808bf08752d63a0064849b",
  "trx_in_block": 13,
  "virtual_op": 0
}

Account Metadata

POSTING JSON METADATA
None
JSON METADATA
None
{
  "posting_json_metadata": {},
  "json_metadata": {}
}

Auth Keys

Owner
Single Signature
Public Keys
STM7TLZpLSC9fvThLGtJxGGnH8TneTZtX9ryvvf5bW77kYdc897e61/1
Active
Single Signature
Public Keys
STM67UAuiNBnvGhquFpthPG2XJokLopm9pMmr6x6WocqMqMhtuuhb1/1
Posting
Single Signature
Public Keys
STM5yN6K6K4aa3knAGRSE52q8trkWVET44ZnRuUsqe9Yk65xRvvue1/1
Memo
STM5PEPj2XdMtHUYW8WVQFqk4s5ZxdM6dUdGNA5UmEZtPtAsHT8eC
{
  "owner": {
    "account_auths": [],
    "key_auths": [
      [
        "STM7TLZpLSC9fvThLGtJxGGnH8TneTZtX9ryvvf5bW77kYdc897e6",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "active": {
    "account_auths": [],
    "key_auths": [
      [
        "STM67UAuiNBnvGhquFpthPG2XJokLopm9pMmr6x6WocqMqMhtuuhb",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "posting": {
    "account_auths": [],
    "key_auths": [
      [
        "STM5yN6K6K4aa3knAGRSE52q8trkWVET44ZnRuUsqe9Yk65xRvvue",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "memo": "STM5PEPj2XdMtHUYW8WVQFqk4s5ZxdM6dUdGNA5UmEZtPtAsHT8eC"
}

Witness Votes

0 / 30
No active witness votes.
[]