How to completely remove an agent from the database so they start from scratch, without deleting the whole database?

[LinuxIsCool]

I tried running the following query in dbeaver:

BEGIN TRANSACTION;
DELETE FROM accounts WHERE id = '17b30f8a-9fe5-0be2-b375-cd4c125a11e5';
DELETE FROM knowledge WHERE agentId = '17b30f8a-9fe5-0be2-b375-cd4c125a11e5';
DELETE FROM memories WHERE agentId = '17b30f8a-9fe5-0be2-b375-cd4c125a11e5';
DELETE FROM cache WHERE agentId = '17b30f8a-9fe5-0be2-b375-cd4c125a11e5';
DELETE FROM relationships WHERE userA = '17b30f8a-9fe5-0be2-b375-cd4c125a11e5' OR userB = '17b30f8a-9fe5-0be2-b375-cd4c125a11e5';
COMMIT;

select * from accounts where id = '17b30f8a-9fe5-0be2-b375-cd4c125a11e5';

But my agent is still there in the accounts table!

[naiveai-dev]

I think you violate referential integrity of Database.
Aren't you getting any error message from it?
I tried your query and it got an error as follows :

Error: FOREIGN KEY constraint failed Query: 

This is due to participants table points to the id from accounts(id).
If an id in the accounts table is referenced in the participants table, attempting to delete it directly will not be allowed due to referential integrity constraints. The quick solution is to first delete the corresponding entries in the participants table before deleting the related record in the accounts table."

BEGIN TRANSACTION;
DELETE FROM participants WHERE userId = '17b30f8a-9fe5-0be2-b375-cd4c125a11e5';
DELETE FROM accounts WHERE id = '17b30f8a-9fe5-0be2-b375-cd4c125a11e5';
DELETE FROM knowledge WHERE agentId = '17b30f8a-9fe5-0be2-b375-cd4c125a11e5';
DELETE FROM memories WHERE agentId = '17b30f8a-9fe5-0be2-b375-cd4c125a11e5';
DELETE FROM cache WHERE agentId = '17b30f8a-9fe5-0be2-b375-cd4c125a11e5';
DELETE FROM relationships WHERE userA = '17b30f8a-9fe5-0be2-b375-cd4c125a11e5' OR userB = '17b30f8a-9fe5-0be2-b375-cd4c125a11e5';
COMMIT;

select * from accounts where id = '17b30f8a-9fe5-0be2-b375-cd4c125a11e5';

ps.
Is knowledge table is in eliza os 0.1.7? or only in the recent version?
I am using sqlite and I can't see any table named as knowledge

[LinuxIsCool]

Yeah the knowledge table was added here: #1620
I'm running 0.1.8.

Thanks for the help! I did end up restarting the whole db because I was impatient, and also I was a little worried I might have messed something up, so just started fresh. But in the future I can't be blowing away my whole db all the time so I will probably come back to this in the future when I need to reset a particular agent.