Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def _work(self):
- connection = database.get_connection()
- cursor = connection.cursor()
- sql = "SELECT * FROM profiles WHERE uid = %s"
- cursor.execute(sql, (self._from_id))
- if cursor.fetchall() != ():
- if self._check_have_work():
- t1 = time.time()
- sql = 'SELECT time_job FROM profiles WHERE uid = %s'
- cursor.execute(sql, (self._from_id))
- minute = 0
- time_job = 0
- for i in cursor:
- time_job += i['time_job']
- minute += int((t1 - i['time_job']) / 60)
- complete_minute = 15 - minute
- if (15 - minute) >= 15:
- sql = "SELECT job_id FROM profiles WHERE uid = %s"
- job_id = 0
- cursor.execute(sql, (self._from_id))
- for i in cursor:
- job_id += i['job_id']
- sql = "SELECT * FROM works WHERE id = %s"
- cursor.execute(sql, (job_id))
- min_earn = 0
- max_earn = 0
- for i in cursor:
- min_earn += i['min']
- max_earn += i['max']
- earn = random.randrange(min_earn, max_earn)
- self._add_balance(earn)
- sql = 'UPDATE profiles SET time_job = %s'
- cursor.execute(sql, (time.time()))
- connection.commit()
- connection.close()
- return f'Вы успешно заработали {earn} руб.'
- else:
- return f"Вы можете работать только через {complete_minute} минут"
- else:
- return 'Вы нигде не работаете'
- else:
- self._add_to_database()
- return '[☢] || Ваш профиль создан!\n'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement