to begin to do imports:
import sqlite3
from sqlite3 import Error
from time import sleep, ctime
calling all SQL statements to do this via the:
def post_sql_query(sql_query):
with sqlite3.connect('my.db') as connection:
cursor = connection.cursor()
try:
cursor.execute(sql_query)
except Error:
pass
result = cursor.fetchall()
return result
next you need to create a table in sqlite and as a primary key (that it is not the uniqueness defined) to make the id user:
def create_tables():
users_query = "'CREATE TABLE IF NOT EXISTS USERS
(user_id INTEGER PRIMARY KEY NOT NULL,
username TEXT
first_name TEXT,
last_name TEXT,
reg_date TEXT);"'
post_sql_query(users_query)
and the function of registering user:
def register_user(user, username, first_name, last_name):
user_check_query = f SELECT * FROM USERS WHERE user_id = {user};'
user_check_data = post_sql_query(user_check_query)
if not user_check_data:
insert_to_db_query = f INSERT INTO USERS (user_id, username, first_name, last_name, reg_date) VALUES ({user} "{username}", "{first_name}", "{last_name}", ctime());'
post_sql_query(insert_to_db_query )
and then call it from the handler:
create_tables() # calling the function to create the users table
@bot.message_handler(commands=['start'])
def start(message):
register_user(message.from_user.id, message.from_user.username
message.from_user.first_name, message.from_user.last_name)
bot.send_message(message.from_user.id Welcome f {message.from_user.first_name}' )
I think the principle is clear, you can continue with all your data to work and Yes the code myself but should work.
Enough detail?)
to properly wrap ctime - avery_Tremblay commented on April 19th 20 at 12:15