def test_create_player_stat(self):
TestTime.set_app_time(datetime.datetime(2015, 8, 1))
DatabaseUtils.recreate_database(DatabaseUtils.get_db_connection())
conn = DatabaseUtils.get_db_connection()
player_data = {
'clan_id': 1,
'account_id': 777,
'account_name': 'test player',
'total_resources_earned': 1200,
'stronghold_skirmish_battles': 100,
'stronghold_defense_battles': 10,
'seven_day_resources_earned': 320,
'thirty_day_resources_earned': 320,
'last_update': AppTime.get_now(),
'thirty_day_defense_battles': 0,
'thirty_day_skirmish_battles': 0,
'clan_battles': 10,
'thirty_day_clan_battles': 5,
'all_battles': 100,
'thirty_day_all_battles': 50
}
controller = ClanController()
controller.create_player_stat(conn, player_data)
row = PlayerRepository.get_player(conn, player_data['clan_id'],
player_data['account_id'])
player_stat_dict = dict(zip(row.keys(), row))
expected = {
'clan_id': 1,
'account_id': 777,
'account_name': u'test player',
'total_resources_earned': 1200,
'stronghold_skirmish_battles': 100,
'thirty_day_skirmish_battles': 0,
'stronghold_defense_battles': 10,
'thirty_day_defense_battles': 0,
'seven_day_resources_earned': 320,
'thirty_day_resources_earned': 320,
'clan_battles': 10,
'thirty_day_clan_battles': 5,
'all_battles': 100,
'thirty_day_all_battles': 50,
'last_update': str(AppTime.get_now())
}
self.assertEqual(expected, player_stat_dict)
from_date = AppTime.get_now()
to_date = from_date - datetime.timedelta(days=30)
rows = PlayerRepository.get_player_stats(conn, player_data['clan_id'],
player_data['account_id'],
from_date, to_date)
self.assertEqual(1, len(rows))
player_stat_snapshot_dict = dict(zip(rows[0].keys(), rows[0]))
expected = {
'stronghold_defense_battles': 10,
'account_id': 777,
'stronghold_skirmish_battles': 100,
'clan_id': 1,
'total_resources_earned': 1200,
'created_date': str(AppTime.get_now())
}
self.assertEqual(expected, player_stat_snapshot_dict)
def test_create_player_stat(self):
TestTime.set_app_time(datetime.datetime(2015, 8, 1))
DatabaseUtils.recreate_database(DatabaseUtils.get_db_connection())
conn = DatabaseUtils.get_db_connection()
player_data = {'clan_id': 1,
'account_id': 777,
'account_name': 'test player',
'total_resources_earned': 1200,
'stronghold_skirmish_battles': 100,
'stronghold_defense_battles': 10,
'seven_day_resources_earned': 320,
'thirty_day_resources_earned': 320,
'last_update': AppTime.get_now(),
'thirty_day_defense_battles': 0,
'thirty_day_skirmish_battles': 0,
'clan_battles': 10,
'thirty_day_clan_battles': 5,
'all_battles': 100,
'thirty_day_all_battles': 50}
controller = ClanController()
controller.create_player_stat(conn, player_data)
row = PlayerRepository.get_player(conn, player_data['clan_id'], player_data['account_id'])
player_stat_dict = dict(zip(row.keys(), row))
expected = {'clan_id': 1,
'account_id': 777,
'account_name': u'test player',
'total_resources_earned': 1200,
'stronghold_skirmish_battles': 100,
'thirty_day_skirmish_battles': 0,
'stronghold_defense_battles': 10,
'thirty_day_defense_battles': 0,
'seven_day_resources_earned': 320,
'thirty_day_resources_earned': 320,
'clan_battles': 10,
'thirty_day_clan_battles': 5,
'all_battles': 100,
'thirty_day_all_battles': 50,
'last_update': str(AppTime.get_now())}
self.assertEqual(expected, player_stat_dict)
from_date = AppTime.get_now()
to_date = from_date - datetime.timedelta(days=30)
rows = PlayerRepository.get_player_stats(conn, player_data['clan_id'], player_data['account_id'], from_date,
to_date)
self.assertEqual(1, len(rows))
player_stat_snapshot_dict = dict(zip(rows[0].keys(), rows[0]))
expected = {'stronghold_defense_battles': 10,
'account_id': 777,
'stronghold_skirmish_battles': 100,
'clan_id': 1,
'total_resources_earned': 1200,
'created_date': str(AppTime.get_now())}
self.assertEqual(expected, player_stat_snapshot_dict)
