def __init__(self, id, name=None, email=None, password=None):
self.id = id
self.name = name
self.email = email
self.password = password
self.created = datetime.datetime.now()
self.updated = self.created
self.money = MoneyPlayer(player_id=self.id)
self.counters = CountersPlayer(player_id=self.id)
self.achievements = PlayerAchievements(player_id=self.id)
def __init__(self, id, name=None, email=None, password=None):
self.id = id
self.name = name
self.email = email
self.password = password
self.created = datetime.datetime.now()
self.updated = self.created
self.money = MoneyPlayer(player_id=self.id)
self.counters = CountersPlayer(player_id=self.id)
self.achievements = PlayerAchievements(player_id=self.id)
class Player(object):
def __init__(self, id, name=None, email=None, password=None):
self.id = id
self.name = name
self.email = email
self.password = password
self.created = datetime.datetime.now()
self.updated = self.created
self.money = MoneyPlayer(player_id=self.id)
self.counters = CountersPlayer(player_id=self.id)
self.achievements = PlayerAchievements(player_id=self.id)
def as_dict(self):
d = {
'name_class': self.__class__.__name__,
'id': self.id,
'name': self.name,
'email': self.email,
'password': self.password,
'created': self.created,
'updated': self.updated
}
return d
def save_to_db(self):
cursor = db.connect.cursor()
sql_data = self.as_dict()
insert_query = 'insert into player (id, name, email, password, created, updated)' \
' values (%(id)s, %(name)s, %(email)s, %(password)s, %(created)s, %(updated)s)'
update_query = 'update player ' \
'set name=%(name)s, email=%(email)s, password=%(password)s, updated=%(updated)s ' \
'where id=%(id)s'
try:
cursor.execute(insert_query, sql_data)
except db.IntegrityError:
sql_data['updated'] = datetime.datetime.now()
cursor.execute(update_query, sql_data)
db.connect.commit()
def delete_from_db(self):
cursor = db.connect.cursor()
delete_query = 'delete from player where id=%(id)s'
sql_data = {
'id': self.id
}
try:
cursor.execute(delete_query, sql_data)
except:
print('error delete player')
def load_from_db(self, email):
load_query = 'select id, name, email, password, created, updated ' \
'from player' \
' where email=%(email)s'
sql_data = {
'email': email
}
cursor = db.connect.cursor()
try:
cursor.execute(load_query, sql_data)
db_row = cursor.fetchone()
self.id = db_row[0]
self.name = db_row[1]
self.email = db_row[2]
self.password = db_row[3]
self.created = db_row[4]
self.updated = db_row[5]
except TypeError:
print('error load player')
def save(self, file_object):
json.dump(self.as_dict(), file_object)
def load(self, file_object):
object_as_dict = json.load(file_object)
self.id = object_as_dict['id']
self.name = object_as_dict['name']
self.email = object_as_dict['email']
self.password = object_as_dict['password']
self.created = object_as_dict['created']
self.updated = object_as_dict['updated']
def get_money_player(self):
return self.money.load_from_db(self.id)
def delete_money_player(self):
self.money.delete_from_db()
def set_session(self):
self.session = GameSession(self.id)
def leave_the_game(self):
self.session.save_to_db()
self.money.save_to_db()
self.counters.save_to_db()
self.achievements.save_to_db()
def get_counters_player(self):
return self.counters.load_from_db(self.id)
def delete_counters_player(self):
self.counters.delete_from_db()
def get_achievements_player(self):
return self.achievements.load_from_db(self.id)
def delete_achievemets_player(self):
self.achievements.delete_from_db()
def __str__(self):
return '{}(id={}, name="{}", email="{}", password="******", created={}, updated={})'.format(
self.__class__.__name__,
self.id,
self.name,
self.email,
self.password,
self.created,
self.updated
)
class Player(object):
def __init__(self, id, name=None, email=None, password=None):
self.id = id
self.name = name
self.email = email
self.password = password
self.created = datetime.datetime.now()
self.updated = self.created
self.money = MoneyPlayer(player_id=self.id)
self.counters = CountersPlayer(player_id=self.id)
self.achievements = PlayerAchievements(player_id=self.id)
def as_dict(self):
d = {
'name_class': self.__class__.__name__,
'id': self.id,
'name': self.name,
'email': self.email,
'password': self.password,
'created': self.created,
'updated': self.updated
}
return d
def save_to_db(self):
cursor = db.connect.cursor()
sql_data = self.as_dict()
insert_query = 'insert into player (id, name, email, password, created, updated)' \
' values (%(id)s, %(name)s, %(email)s, %(password)s, %(created)s, %(updated)s)'
update_query = 'update player ' \
'set name=%(name)s, email=%(email)s, password=%(password)s, updated=%(updated)s ' \
'where id=%(id)s'
try:
cursor.execute(insert_query, sql_data)
except db.IntegrityError:
sql_data['updated'] = datetime.datetime.now()
cursor.execute(update_query, sql_data)
db.connect.commit()
def delete_from_db(self):
cursor = db.connect.cursor()
delete_query = 'delete from player where id=%(id)s'
sql_data = {'id': self.id}
try:
cursor.execute(delete_query, sql_data)
except:
print('error delete player')
def load_from_db(self, email):
load_query = 'select id, name, email, password, created, updated ' \
'from player' \
' where email=%(email)s'
sql_data = {'email': email}
cursor = db.connect.cursor()
try:
cursor.execute(load_query, sql_data)
db_row = cursor.fetchone()
self.id = db_row[0]
self.name = db_row[1]
self.email = db_row[2]
self.password = db_row[3]
self.created = db_row[4]
self.updated = db_row[5]
except TypeError:
print('error load player')
def save(self, file_object):
json.dump(self.as_dict(), file_object)
def load(self, file_object):
object_as_dict = json.load(file_object)
self.id = object_as_dict['id']
self.name = object_as_dict['name']
self.email = object_as_dict['email']
self.password = object_as_dict['password']
self.created = object_as_dict['created']
self.updated = object_as_dict['updated']
def get_money_player(self):
return self.money.load_from_db(self.id)
def delete_money_player(self):
self.money.delete_from_db()
def set_session(self):
self.session = GameSession(self.id)
def leave_the_game(self):
self.session.save_to_db()
self.money.save_to_db()
self.counters.save_to_db()
self.achievements.save_to_db()
def get_counters_player(self):
return self.counters.load_from_db(self.id)
def delete_counters_player(self):
self.counters.delete_from_db()
def get_achievements_player(self):
return self.achievements.load_from_db(self.id)
def delete_achievemets_player(self):
self.achievements.delete_from_db()
def __str__(self):
return '{}(id={}, name="{}", email="{}", password="******", created={}, updated={})'.format(
self.__class__.__name__, self.id, self.name, self.email,
self.password, self.created, self.updated)
player_vasya.save_to_db()
player_boris.save_to_db()
player_akakij.save_to_db()
player = Player(1)
player.load_from_db('*****@*****.**')
print(player)
print('player={}, money={}, counters={}'.format(player.name, player.get_money_player(), player.get_counters_player()))
counetrs_player_1 = CountersPlayer(1, 4030, 1212, 15)
counetrs_player_2 = CountersPlayer(2, 400, 12, 5)
counetrs_player_3 = CountersPlayer(3, 10000, 1222, 6)
counetrs_player_1.save_to_db()
counetrs_player_2.save_to_db()
counetrs_player_3.save_to_db()
achievements_player_1 = PlayerAchievements(1, 1)
achievements_player_2 = PlayerAchievements(2, 4)
achievements_player_3 = PlayerAchievements(3, 4)
achievements_player_1.save_to_db()
achievements_player_2.save_to_db()
achievements_player_3.save_to_db()
money_player_1 = MoneyPlayer(1)
money_player_2 = MoneyPlayer(2)
money_player_3 = MoneyPlayer(3)
money_player_1.save_to_db()
money_player_2.save_to_db()
money_player_3.save_to_db()
player1 = Player(1)