diff options
Diffstat (limited to 'apps/web/src/server')
| -rw-r--r-- | apps/web/src/server/auth.ts | 6 | ||||
| -rw-r--r-- | apps/web/src/server/db/index.ts | 7 | ||||
| -rw-r--r-- | apps/web/src/server/db/schema.ts | 15 | ||||
| -rw-r--r-- | apps/web/src/server/helpers.ts | 66 |
4 files changed, 47 insertions, 47 deletions
diff --git a/apps/web/src/server/auth.ts b/apps/web/src/server/auth.ts index c32efe55..95edcf35 100644 --- a/apps/web/src/server/auth.ts +++ b/apps/web/src/server/auth.ts @@ -1,7 +1,7 @@ import { env } from "@/env"; import NextAuth from "next-auth"; import Google from "next-auth/providers/google"; -import { DrizzleAdapter } from "@auth/drizzle-adapter" +import { DrizzleAdapter } from "@auth/drizzle-adapter"; import { db } from "./db"; export const { @@ -15,9 +15,9 @@ export const { ...session, user: { ...session.user, - id: user.id + id: user.id, }, - }) + }), }, adapter: DrizzleAdapter(db), providers: [ diff --git a/apps/web/src/server/db/index.ts b/apps/web/src/server/db/index.ts index 5aa87fc1..4d671bea 100644 --- a/apps/web/src/server/db/index.ts +++ b/apps/web/src/server/db/index.ts @@ -1,8 +1,5 @@ -import { drizzle } from 'drizzle-orm/d1'; +import { drizzle } from "drizzle-orm/d1"; import * as schema from "./schema"; -export const db = drizzle( - process.env.DATABASE, - { schema, logger: true } -); +export const db = drizzle(process.env.DATABASE, { schema, logger: true }); diff --git a/apps/web/src/server/db/schema.ts b/apps/web/src/server/db/schema.ts index a80eb7cf..e0ddbdbc 100644 --- a/apps/web/src/server/db/schema.ts +++ b/apps/web/src/server/db/schema.ts @@ -6,7 +6,7 @@ import { sqliteTableCreator, text, integer, - unique + unique, } from "drizzle-orm/sqlite-core"; export const createTable = sqliteTableCreator((name) => `${name}`); @@ -78,7 +78,6 @@ export const verificationTokens = createTable( }), ); - export const storedContent = createTable( "storedContent", { @@ -103,8 +102,12 @@ export const storedContent = createTable( export const contentToSpace = createTable( "contentToSpace", { - contentId: integer("contentId").notNull().references(() => storedContent.id), - spaceId: integer("spaceId").notNull().references(() => space.id), + contentId: integer("contentId") + .notNull() + .references(() => storedContent.id), + spaceId: integer("spaceId") + .notNull() + .references(() => space.id), }, (cts) => ({ compoundKey: primaryKey({ columns: [cts.contentId, cts.spaceId] }), @@ -115,7 +118,7 @@ export const space = createTable( "space", { id: integer("id").notNull().primaryKey({ autoIncrement: true }), - name: text('name').notNull().default('all'), + name: text("name").notNull().default("all"), user: text("user", { length: 255 }).references(() => users.id), }, (space) => ({ @@ -124,4 +127,4 @@ export const space = createTable( }), ); -export type StoredContent = Omit<typeof storedContent.$inferSelect, 'user'>
\ No newline at end of file +export type StoredContent = Omit<typeof storedContent.$inferSelect, "user">; diff --git a/apps/web/src/server/helpers.ts b/apps/web/src/server/helpers.ts index 1f6cf977..519e4b17 100644 --- a/apps/web/src/server/helpers.ts +++ b/apps/web/src/server/helpers.ts @@ -1,34 +1,34 @@ export async function getMetaData(url: string) { - const response = await fetch(url); - const html = await response.text(); - - // Extract the base URL - const baseUrl = new URL(url).origin; - - // Extract title - const titleMatch = html.match(/<title>(.*?)<\/title>/); - const title = titleMatch ? titleMatch[1] : 'Title not found'; - - // Extract meta description - const descriptionMatch = html.match( - /<meta name="description" content="(.*?)"\s*\/?>/, - ); - const description = descriptionMatch - ? descriptionMatch[1] - : 'Description not found'; - - // Extract Open Graph image - const imageMatch = html.match( - /<meta property="og:image" content="(.*?)"\s*\/?>/, - ); - const image = imageMatch ? imageMatch[1] : 'Image not found'; - - // Prepare the metadata object - const metadata = { - title, - description, - image, - baseUrl, - }; - return metadata; - }
\ No newline at end of file + const response = await fetch(url); + const html = await response.text(); + + // Extract the base URL + const baseUrl = new URL(url).origin; + + // Extract title + const titleMatch = html.match(/<title>(.*?)<\/title>/); + const title = titleMatch ? titleMatch[1] : "Title not found"; + + // Extract meta description + const descriptionMatch = html.match( + /<meta name="description" content="(.*?)"\s*\/?>/, + ); + const description = descriptionMatch + ? descriptionMatch[1] + : "Description not found"; + + // Extract Open Graph image + const imageMatch = html.match( + /<meta property="og:image" content="(.*?)"\s*\/?>/, + ); + const image = imageMatch ? imageMatch[1] : "Image not found"; + + // Prepare the metadata object + const metadata = { + title, + description, + image, + baseUrl, + }; + return metadata; +} |