Establishes the initial database schema using Drizzle ORM, replacing the prior placeholder. This migration introduces core entities like users, spaces, pages, access tokens, and their permissions, complete with relationships and constraints. Updates the authentication flow by securing the sign-in endpoint with JWT validation and extracting user details directly from the token via a new custom parameter decorator, improving user context handling. Integrates a new `Page` module, laying the groundwork for future page management capabilities.
71 lines
2.0 KiB
TypeScript
71 lines
2.0 KiB
TypeScript
import { relations } from "drizzle-orm/relations";
|
|
import { users, spaces, pages, accesstokens, tokenpermissions } from "./schema";
|
|
|
|
export const spacesRelations = relations(spaces, ({one, many}) => ({
|
|
user: one(users, {
|
|
fields: [spaces.createdByUserId],
|
|
references: [users.userId]
|
|
}),
|
|
pages: many(pages),
|
|
tokenpermissions: many(tokenpermissions),
|
|
}));
|
|
|
|
export const usersRelations = relations(users, ({many}) => ({
|
|
spaces: many(spaces),
|
|
pages_createdByUserId: many(pages, {
|
|
relationName: "pages_createdByUserId_users_userId"
|
|
}),
|
|
pages_updatedByUserId: many(pages, {
|
|
relationName: "pages_updatedByUserId_users_userId"
|
|
}),
|
|
accesstokens: many(accesstokens),
|
|
}));
|
|
|
|
export const pagesRelations = relations(pages, ({one, many}) => ({
|
|
space: one(spaces, {
|
|
fields: [pages.spaceId],
|
|
references: [spaces.spaceId]
|
|
}),
|
|
page: one(pages, {
|
|
fields: [pages.parentPageId],
|
|
references: [pages.pageId],
|
|
relationName: "pages_parentPageId_pages_pageId"
|
|
}),
|
|
pages: many(pages, {
|
|
relationName: "pages_parentPageId_pages_pageId"
|
|
}),
|
|
user_createdByUserId: one(users, {
|
|
fields: [pages.createdByUserId],
|
|
references: [users.userId],
|
|
relationName: "pages_createdByUserId_users_userId"
|
|
}),
|
|
user_updatedByUserId: one(users, {
|
|
fields: [pages.updatedByUserId],
|
|
references: [users.userId],
|
|
relationName: "pages_updatedByUserId_users_userId"
|
|
}),
|
|
tokenpermissions: many(tokenpermissions),
|
|
}));
|
|
|
|
export const accesstokensRelations = relations(accesstokens, ({one, many}) => ({
|
|
user: one(users, {
|
|
fields: [accesstokens.createdByUserId],
|
|
references: [users.userId]
|
|
}),
|
|
tokenpermissions: many(tokenpermissions),
|
|
}));
|
|
|
|
export const tokenpermissionsRelations = relations(tokenpermissions, ({one}) => ({
|
|
accesstoken: one(accesstokens, {
|
|
fields: [tokenpermissions.tokenId],
|
|
references: [accesstokens.tokenId]
|
|
}),
|
|
space: one(spaces, {
|
|
fields: [tokenpermissions.spaceId],
|
|
references: [spaces.spaceId]
|
|
}),
|
|
page: one(pages, {
|
|
fields: [tokenpermissions.pageId],
|
|
references: [pages.pageId]
|
|
}),
|
|
})); |