@start_router.message(Form.tg)
async def add_tg(message: types.Message, state: FSMContext):
user_id = message.from_user.id
username = message.from_user.username
usertg = message.text.strip()
async with aiosqlite.connect('base.db') as db:
await db.execute('''
INSERT INTO user (id, username, user_tg)
VALUES(?, ?, ?)
ON CONFLICT(id) DO UPDATE SET
username=?, user_tg=?
''', (user_id, username, usertg, username, usertg))
await db.commit()
await message.answer(text="Введите имя")
await state.set_state(Form.name)
@start_router.message(Form.name)
async def add_name(message: types.Message):
user_id = message.from_user.id
name = message.text.strip()
async with aiosqlite.connect('base.db') as db:
await db.execute('''
UPDATE user
SET name = ?
WHERE id = ?
''', (name, user_id))
await db.commit()
await message.answer("Готово")
ну и таблица скорее всего вот так должна создаваться у вас:
CREATE TABLE IF NOT EXISTS user (
id INTEGER PRIMARY KEY,
username TEXT,
user_tg TEXT,
name TEXT
);