engine = create_engine("sqlite:///z00bot_base.db")
metadata=MetaData()
z00bot_base=Table("z00bot_base",metadata,
Column("player_id",INTEGER),
Column("chat_id",INTEGER),
Column("points",INTEGER),
Column("admin",TEXT),
Column("promo1",TEXT),
Column("name",TEXT))
select_query=select(z00bot_base).where(z00bot_base.columns.chat_id == айди_чата)
with engine.connect() as s:
rows= s.execute(select_query)
if rows == []:
insert_query= insert(z00bot_base).values(chat_id=айди_чата ,name = имя_игрока)
s.execute(insert_query)
s.commit()