def test_gitcoin_metadata(database):
db = DBLedgerActions(database, database.msg_aggregator)
db.set_gitcoin_grant_metadata(
grant_id=1,
name='foo',
created_on=1,
)
result = db.get_gitcoin_grant_metadata(1)
assert result == {
1: GitcoinGrantMetadata(grant_id=1, name='foo', created_on=1)
}
# change existing grant metadata
db.set_gitcoin_grant_metadata(
grant_id=1,
name='newfoo',
created_on=2,
)
result = db.get_gitcoin_grant_metadata(1)
assert result == {
1: GitcoinGrantMetadata(grant_id=1, name='newfoo', created_on=2)
}
# add 2nd grant and check we can get both back
db.set_gitcoin_grant_metadata(
grant_id=2,
name='boo',
created_on=3,
)
result = db.get_gitcoin_grant_metadata(2)
assert result == {
2: GitcoinGrantMetadata(grant_id=2, name='boo', created_on=3)
}
assert db.get_gitcoin_grant_metadata() == {
1: GitcoinGrantMetadata(grant_id=1, name='newfoo', created_on=2),
2: GitcoinGrantMetadata(grant_id=2, name='boo', created_on=3),
}
def test_delete_grant_events(rotkehlchen_api_server):
rotki = rotkehlchen_api_server.rest_api.rotkehlchen
# Get and save data of 3 different grants in the DB
id1 = 149
metadata1 = GitcoinGrantMetadata(
grant_id=id1,
name='Rotki - The portfolio tracker and accounting tool that protects your privacy',
created_on=1571694841,
)
json_data = {
'from_timestamp': 1622162468, # 28/05/2021
'to_timestamp': 1622246400, # 29/05/2021
'grant_id': id1,
}
response = requests.post(api_url_for(
rotkehlchen_api_server,
'gitcoineventsresource',
), json=json_data)
assert_proper_response(response)
id2 = 184
metadata2 = GitcoinGrantMetadata(
grant_id=id2,
name='TrueBlocks',
created_on=1575424305,
)
json_data = {
'from_timestamp': 1622162468, # 28/05/2021
'to_timestamp': 1622246400, # 29/05/2021
'grant_id': id2,
}
response = requests.post(api_url_for(
rotkehlchen_api_server,
'gitcoineventsresource',
), json=json_data)
assert_proper_response(response)
id3 = 223
metadata3 = GitcoinGrantMetadata(
grant_id=id3,
name='Ethereum Magicians',
created_on=1578054753,
)
json_data = {
'from_timestamp': 1622162468, # 28/05/2021
'to_timestamp': 1622246400, # 29/05/2021
'grant_id': id3,
}
response = requests.post(api_url_for(
rotkehlchen_api_server,
'gitcoineventsresource',
), json=json_data)
assert_proper_response(response)
# make sure events are saved
db = rotki.data.db
ledgerdb = DBLedgerActions(db, db.msg_aggregator)
actions = ledgerdb.get_ledger_actions(
filter_query=LedgerActionsFilterQuery.make(location=Location.GITCOIN),
has_premium=True,
)
assert len(actions) == 5
assert len([x for x in actions if x.extra_data.grant_id == id1]) == 3
assert len([x for x in actions if x.extra_data.grant_id == id2]) == 1
assert len([x for x in actions if x.extra_data.grant_id == id3]) == 1
# make sure db ranges were written
queryrange = db.get_used_query_range(f'{GITCOIN_GRANTS_PREFIX}_{id1}')
assert queryrange == (1622162468, 1622246400)
queryrange = db.get_used_query_range(f'{GITCOIN_GRANTS_PREFIX}_{id2}')
assert queryrange == (1622162468, 1622246400)
queryrange = db.get_used_query_range(f'{GITCOIN_GRANTS_PREFIX}_{id3}')
assert queryrange == (1622162468, 1622246400)
# make sure grant metadata were written
assert ledgerdb.get_gitcoin_grant_metadata() == {
id1: metadata1,
id2: metadata2,
id3: metadata3,
}
# delete 1 grant's data
response = requests.delete(api_url_for(
rotkehlchen_api_server,
'gitcoineventsresource',
), json={'grant_id': id2})
assert_proper_response(response)
# check that they got deleted but rest is fine
actions = ledgerdb.get_ledger_actions(
filter_query=LedgerActionsFilterQuery.make(location=Location.GITCOIN),
has_premium=True,
)
assert len(actions) == 4
assert len([x for x in actions if x.extra_data.grant_id == id1]) == 3
assert len([x for x in actions if x.extra_data.grant_id == id2]) == 0
assert len([x for x in actions if x.extra_data.grant_id == id3]) == 1
# make sure db ranges were written
queryrange = db.get_used_query_range(f'{GITCOIN_GRANTS_PREFIX}_{id1}')
assert queryrange == (1622162468, 1622246400)
assert db.get_used_query_range(f'{GITCOIN_GRANTS_PREFIX}_{id2}') is None
queryrange = db.get_used_query_range(f'{GITCOIN_GRANTS_PREFIX}_{id3}')
assert queryrange == (1622162468, 1622246400)
# make sure grant metadata were written
assert ledgerdb.get_gitcoin_grant_metadata() == {id1: metadata1, id3: metadata3}
# delete all remaining grant data
response = requests.delete(api_url_for(
rotkehlchen_api_server,
'gitcoineventsresource',
))
assert_proper_response(response)
# check that they got deleted but rest is fine
actions = ledgerdb.get_ledger_actions(
filter_query=LedgerActionsFilterQuery.make(location=Location.GITCOIN),
has_premium=True,
)
assert len(actions) == 0
# make sure db ranges were written
assert db.get_used_query_range(f'{GITCOIN_GRANTS_PREFIX}_{id1}') is None
assert db.get_used_query_range(f'{GITCOIN_GRANTS_PREFIX}_{id2}') is None
assert db.get_used_query_range(f'{GITCOIN_GRANTS_PREFIX}_{id3}') is None
# make sure grant metadata were written
assert ledgerdb.get_gitcoin_grant_metadata() == {}
class GitcoinAPI():
def __init__(self, db: DBHandler) -> None:
self.db = db
self.db_ledger = DBLedgerActions(self.db, self.db.msg_aggregator)
self.session = requests.session()
self.clr_payouts: Optional[List[Dict[str, Any]]] = None
def _single_grant_api_query(self, query_str: str) -> Dict[str, Any]:
backoff = 1
backoff_limit = 33
while backoff < backoff_limit:
log.debug(f'Querying gitcoin: {query_str}')
try:
response = self.session.get(query_str,
timeout=DEFAULT_TIMEOUT_TUPLE)
except requests.exceptions.RequestException as e:
if 'Max retries exceeded with url' in str(e):
log.debug(
f'Got max retries exceeded from gitcoin. Will '
f'backoff for {backoff} seconds.', )
gevent.sleep(backoff)
backoff = backoff * 2
if backoff >= backoff_limit:
raise RemoteError(
'Getting gitcoin error even '
'after we incrementally backed off', ) from e
continue
raise RemoteError(
f'Gitcoin API request failed due to {str(e)}') from e
if response.status_code != 200:
raise RemoteError(
f'Gitcoin API request {response.url} failed '
f'with HTTP status code {response.status_code} and text '
f'{response.text}', )
try:
json_ret = jsonloads_dict(response.text)
except JSONDecodeError as e:
raise RemoteError(
f'Gitcoin API request {response.url} returned invalid '
f'JSON response: {response.text}', ) from e
if 'error' in json_ret:
raise RemoteError(
f'Gitcoin API request {response.url} returned an error: {json_ret["error"]}',
)
break # success
return json_ret
def get_history_from_db(
self,
grant_id: Optional[int],
from_ts: Optional[Timestamp] = None,
to_ts: Optional[Timestamp] = None,
) -> Dict[int, Dict[str, Any]]:
grantid_to_metadata = self.db_ledger.get_gitcoin_grant_metadata(
grant_id)
grantid_to_events = defaultdict(list)
events = self.db_ledger.get_gitcoin_grant_events(
grant_id=grant_id,
from_ts=from_ts,
to_ts=to_ts,
)
for event in events:
grantid_to_events[event.extra_data.grant_id].append(
event.serialize_for_gitcoin()) # type: ignore # noqa: E501
result = {}
for grantid, serialized_events in grantid_to_events.items():
metadata = grantid_to_metadata.get(grantid)
result[grantid] = {
'events': serialized_events,
'name': metadata.name if metadata else None,
'created_on': metadata.created_on if metadata else None,
}
return result
def query_grant_history(
self,
grant_id: Optional[int],
from_ts: Optional[Timestamp] = None,
to_ts: Optional[Timestamp] = None,
only_cache: bool = False,
) -> Dict[int, Dict[str, Any]]:
"""May raise:
- RemotError if there is an error querying the gitcoin API
- InputError if only_cache is False and grant_id is missing
"""
if only_cache:
return self.get_history_from_db(
grant_id=grant_id,
from_ts=from_ts,
to_ts=to_ts,
)
if grant_id is None:
raise InputError(
'Attempted to query gitcoin events from the api without specifying a grant id',
)
entry_name = f'{GITCOIN_GRANTS_PREFIX}_{grant_id}'
dbranges = DBQueryRanges(self.db)
from_timestamp = GITCOIN_START_TS if from_ts is None else from_ts
to_timestamp = ts_now() if to_ts is None else to_ts
ranges = dbranges.get_location_query_ranges(
location_string=entry_name,
start_ts=from_timestamp,
end_ts=to_timestamp,
)
grant_created_on: Optional[Timestamp] = None
for period_range in ranges:
actions, grant_created_on = self.query_grant_history_period(
grant_id=grant_id,
grant_created_on=grant_created_on,
from_timestamp=period_range[0],
to_timestamp=period_range[1],
)
self.db_ledger.add_ledger_actions(actions)
dbranges.update_used_query_range(
location_string=entry_name,
start_ts=from_timestamp,
end_ts=to_timestamp,
ranges_to_query=ranges,
)
return self.get_history_from_db(
grant_id=grant_id,
from_ts=from_ts,
to_ts=to_ts,
)
def query_grant_history_period(
self,
grant_id: int,
grant_created_on: Optional[Timestamp],
from_timestamp: Timestamp,
to_timestamp: Timestamp,
) -> Tuple[List[LedgerAction], Optional[Timestamp]]:
transactions: List[Dict[str, Any]] = []
if grant_created_on is None:
query_str = (
f'https://gitcoin.co/api/v0.1/grants/contributions_rec_report/'
f'?id={grant_id}&from_timestamp=2017-09-25&to_timestamp=2017-09-25'
)
result = self._single_grant_api_query(query_str)
try:
grant_created_on = deserialize_timestamp_from_date(
date=result['metadata']['created_on'],
formatstr='%Y-%m-%dT%H:%M:%S',
location='Gitcoin API',
skip_milliseconds=True,
)
from_timestamp = max(grant_created_on, from_timestamp)
grant_name = result['metadata']['grant_name']
self.db_ledger.set_gitcoin_grant_metadata(
grant_id=grant_id,
name=grant_name,
created_on=grant_created_on,
)
except (DeserializationError, KeyError) as e:
msg = str(e)
if isinstance(e, KeyError):
msg = f'Missing key entry for {msg}.'
log.error(
f'Unexpected data encountered during deserialization of gitcoin api '
f'query: {result}. Error was: {msg}', )
# continue with the given from_timestamp
step_to_timestamp = min(from_timestamp + MONTH_IN_SECONDS,
to_timestamp)
while from_timestamp != step_to_timestamp:
transactions.extend(
self.query_grant_history_period30d(
grant_id=grant_id,
from_ts=from_timestamp,
to_ts=Timestamp(step_to_timestamp),
), )
from_timestamp = Timestamp(step_to_timestamp)
step_to_timestamp = min(step_to_timestamp + MONTH_IN_SECONDS,
to_timestamp)
# Check if any of the clr_payouts are in the range
if self.clr_payouts:
for payout in self.clr_payouts:
timestamp = deserialize_timestamp_from_date(
date=payout['timestamp'],
formatstr='%Y-%m-%dT%H:%M:%S',
location='Gitcoin API',
skip_milliseconds=True,
)
if from_timestamp <= timestamp <= to_timestamp:
round_num = payout.pop('round')
payout['clr_round'] = round_num
transactions.append(payout)
actions = []
for transaction in transactions:
try:
action = _deserialize_transaction(grant_id=grant_id,
rawtx=transaction)
except (DeserializationError, KeyError) as e:
msg = str(e)
if isinstance(e, KeyError):
msg = f'Missing key entry for {msg}.'
self.db.msg_aggregator.add_error(
'Unexpected data encountered during deserialization of a gitcoin '
'api query. Check logs for details.', )
log.error(
f'Unexpected data encountered during deserialization of gitcoin api '
f'query: {transaction}. Error was: {msg}', )
continue
except UnknownAsset as e:
self.db.msg_aggregator.add_warning(
f'Found unknown asset {str(e)} in a gitcoin api event transaction. '
'Ignoring it.', )
continue
except ZeroGitcoinAmount:
log.warning(
f'Found gitcoin event with 0 amount for grant {grant_id}. Ignoring'
)
continue
actions.append(action)
return actions, grant_created_on
def query_grant_history_period30d(
self,
grant_id: int,
from_ts: Timestamp,
to_ts: Timestamp,
) -> List[Dict[str, Any]]:
transactions = []
from_date = timestamp_to_date(from_ts, formatstr='%Y-%m-%d')
to_date = timestamp_to_date(to_ts, formatstr='%Y-%m-%d')
page = 1
while True:
query_str = (
f'https://gitcoin.co/api/v0.1/grants/contributions_rec_report/'
f'?id={grant_id}&from_timestamp={from_date}&to_timestamp={to_date}'
f'&page={page}&format=json')
result = self._single_grant_api_query(query_str)
transactions.extend(result['transactions'])
if self.clr_payouts is None:
self.clr_payouts = result.get('clr_payouts', [])
if result['metadata']['has_next'] is False:
break
# else next page
page += 1
return transactions