Python ORDER BY Random with Seed in Sqlite3

sqlite_seeded_random.py

import sqlite3
import random


def seeded_random_collation(string1, string2):
    return random.randint(-1, 1)


try:
    con = sqlite3.connect("db.sqlite")
except sqlite3.Error as e:
    print(e)
else:
    con.create_collation("seeded_random", seeded_random_collation)
    cur = con.cursor()
    random.seed("YOUR SEED HERE")
    cur.execute(
        "SELECT * FROM your_table ORDER BY CAST(id as TEXT) COLLATE seeded_random"
    )