Г
def get_score_table(self, chat_id):Результатом будет "Имя 5"
result = []
players = self.cursor.execute('SELECT * FROM scores WHERE chat_id = ? ORDER BY score DESC', (chat_id,)).fetchmany(10)
for player in players:
player_first_name = self.get_player_first_name(player[1])
player_score = player[2]
result.append([player_first_name, player_score])
return result
@dp.message_handler(commands=['score'])
async def get_score(message: Message):
player_id = message.from_user.id
score = g.get_score(chat_id=message.chat.id, player_id=player_id)
await message.answer(
text=f'{(g.get_player_first_name(player_id))}'
f'\nОчков в этом чате: {score}'
)
Мне нужно добавить строку
player_last_name = self.get_player_last_name
Чтобы было "Имя фамилия 5". Не совсем понимаю как склеить две строки здесь - text=f'{(g.get_player_first_name(player_id))}'
первый фрагмент вероятно будет таким:
def get_score_table(self, chat_id):
result = []
players = self.cursor.execute('SELECT * FROM scores WHERE chat_id = ? ORDER BY score DESC', (chat_id,)).fetchmany(10)
for player in players:
player_first_name = self.get_player_first_name(player[1])
player_last_name = self.get_player_last_name(player[2])
player_score = player[3]
result.append([player_first_name, player_last_name, player_score])
return result
