Method create

src/utils/database/sqlite.py:188–307

(cls)

    @classmethod
    async def create(cls):
        cls.client = await aiosqlite.connect("database.db")
        cls.documents = []
        cls.vector_db = HyperDB(cls.documents, key="embedding_text")
        try:
            if isfile("vectors.pickle.gz"):
                cls.vector_db.load("vectors.pickle.gz")
        except:
            cls.documents = []
            cls.vector_db = HyperDB(cls.documents, key="embedding_text")
            pass

        await cls.client.execute(
            """
        CREATE TABLE IF NOT EXISTS worlds (
            id TEXT PRIMARY KEY,
            name TEXT
        )
        """
        )
        await cls.client.execute(
            """
        CREATE TABLE IF NOT EXISTS locations (
            id TEXT PRIMARY KEY,
            name TEXT,
            world_id TEXT,
            available_tools TEXT,
            description TEXT,
            channel_id TEXT,
            allowed_agent_ids TEXT,
            FOREIGN KEY (world_id) REFERENCES worlds (id)
        )
        """
        )
        await cls.client.execute(
            """
        CREATE TABLE IF NOT EXISTS agents (
            id TEXT PRIMARY KEY,
            full_name TEXT,
            private_bio TEXT,
            public_bio TEXT,
            authorized_tools TEXT,
            directives TEXT,
            last_checked_events TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            ordered_plan_ids TEXT,
            location_id TEXT,
            discord_bot_token TEXT,
            world_id TEXT,
            FOREIGN KEY (world_id) REFERENCES worlds (id),
            FOREIGN KEY (location_id) REFERENCES locations (id)
        )
        """
        )
        await cls.client.execute(
            """
        CREATE TABLE IF NOT EXISTS plans (
            id TEXT PRIMARY KEY,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,