def add_new_user(self, message):
pay = Payments()
chat_id = message.chat.id
username = message.from_user.username if message.from_user.username is not None else 'None'
firstname = message.from_user.first_name if message.from_user.first_name is not None else 'None'
lastname = message.from_user.last_name if message.from_user.last_name is not None else 'None'
btc_addr = pay.generate_address(chat_id, 'btc')['addr']
ltc_addr = pay.generate_address(chat_id, 'ltc')['addr']
btc_addr_balance = 0
ltc_addr_balance = 0
btc_addr_info = 'None'
ltc_addr_info = 'None'
last_check_receipt = 0
payment_date = 0
last_notification = 0
referrer = message.text.split(' ')[-1]
comments = 'free'
lang = 'eng'
with sqlite3.connect(self.dbname) as conn:
c = conn.cursor()
columns = [
'chat_id',
'username',
'firstname',
'lastname',
'btc_addr',
'btc_addr_balance',
'btc_addr_info',
'ltc_addr',
'ltc_addr_balance',
'ltc_addr_info',
'last_check_receipt',
'payment_date',
'last_notification',
'referrer',
'comments',
'lang',
]
stmt = 'INSERT INTO users ({}) VALUES ({});'.format(
', '.join(columns), ('?, ' * len(columns))[:-2])
args = [
(chat_id),
(username),
(firstname),
(lastname),
(btc_addr),
(btc_addr_balance),
(btc_addr_info),
(ltc_addr),
(ltc_addr_balance),
(ltc_addr_info),
(last_check_receipt),
(payment_date),
(last_notification),
(referrer),
(comments),
(lang),
]
c.execute(stmt, args)
conn.commit()
