Python + SQLite database

Job ID: 33966531

Budget: $30 – $250 USD

Hi,
I have a small project in which I want to save data to a SQLite database. You should provide a python function to create this database and insert entries into the table.

The database should store transactions of the following format:
# transactions = [{
# 'txHash': '0xc0dccb5459cb157179b76d0fb8076b9ddec4e6452458323c382741099b2dc378',
# 'gasLimit': 73394,
# 'gasPrice': 13000000000,
# 'from': '0x3f0547d56c5aEFF209d9526e78213a56295076fa',
# 'to': '0x05cDe89cCfa0adA8C88D5A23caaa79Ef129E7883',
# 'value': 9400000000000000000,
# 'blockNumber': 10000027,
# 'blockTime': 1588602666
# }]

The index of the table should be txHash above.

Requirements:
* Create SQLite table and database through Python with the columns for a transaction mentioned above
* Create a Python function to add one entry and entries in batches of a list
* Create a Python function that returns a transaction based on the txHash
* Create a Python function that returns 100 transaction after a specific blockTime or blockNumber (ascending)

Happy bidding. Budget is 80 USD. Please start your bid with ~ TX so I know you are not a bot ;)