DB: Referencing to own table column

[wpinfusion]

Creating a table where one column referenced to another column is possible, but it generates type errors in your IDE.

For example:

const post = defineTable({
    columns: {
        id: column.text({ primaryKey: true, autoIncrement: true }),
        parentPostId: column.text({ optional: true, references: () => post.columns.id }),
    },
});

The use-case here is to allow parent/child relationships in posts (for example).

The solution (by Fryuni) is to import the type:

import type { TextColumnInput } from "@astrojs/db/types";

And then use that in the table schema:

const post = defineTable({
    columns: {
        id: column.text({ primaryKey: true, autoIncrement: true }),
        parentPostId: column.text({ optional: true, references: (): TextColumnInput => post.columns.id }),
    },
});

[ArmandPhilippot]

We're closing stale and outdated discussion to keep only the discussions still relevant to the current project version and/or the current docs state.

I haven't follow everything that happened to @astrojs/db but isn't this fixed by https://docs.astro.build/en/guides/integrations-guide/db/#foreignkeys ? So, I'm closing this.

If you think this is a mistake and that this discussion should remain open, please feel free to ping me, I'll take a second look at it.

Thank your for your contribution!