First of all deletes_in_ten_seconds()
isn't ever called in your code, so the query isn't ever going to run.
Secondly, yes, you have to ask the database to delete your rows when it needs to happen, so you're going to need to schedule this (every so often) somehow. There are many ways to do it: from threads inside your python app to using functionality provided by the database.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…