matrix-art

commit 9d8ae18bd7f22f9a0e45e784634ec9c3accd0cfa
parent 3ff9f1211fef65bef18c87bb63954de4ab6c1fde
Author: MTRNord <mtrnord1@gmail.com>
Date:   Wed, 26 Jan 2022 17:46:30 +0100

Fix db instances

Diffstat:
M
pages/api/directory.tsx
 | 
23
++++++++---------------

1 file changed, 8 insertions(+), 15 deletions(-)
diff --git a/pages/api/directory.tsx b/pages/api/directory.tsx
@@ -14,14 +14,15 @@ const cors = initMiddleware(
     })
 );
 
+const DB_PATH = path.join(process.cwd(), "matrix-art-db/db.sqlite");
+const db = new Sequelize({
+    dialect: 'sqlite',
+    storage: DB_PATH
+});
+db.addModels([User]);
+
 export const get_data = async () => {
-    console.log(path.join(process.cwd(), "matrix-art-db/db.sqlite"));
-    console.log(path.resolve(path.join(process.cwd(), "matrix-art-db/db.sqlite")));
-    const db = new Sequelize({
-        dialect: 'sqlite',
-        storage: path.join(process.cwd(), "matrix-art-db/db.sqlite")
-    });
-    db.addModels([User]);
+
     if (process.env.PLAYWRIGHT === '1') {
         console.log("Running in tests!");
         return [
@@ -41,11 +42,6 @@ export default async function handler(req: NextApiRequest, res: NextApiResponse)
     // Run cors
     await cors(req, res);
 
-    const db = new Sequelize({
-        dialect: 'sqlite',
-        storage: path.join(process.cwd(), "matrix-art-db.sqlite")
-    });
-    db.addModels([User]);
     try {
         await db.authenticate();
         console.log('Connection has been established successfully.');
@@ -109,7 +105,4 @@ export default async function handler(req: NextApiRequest, res: NextApiResponse)
     } else {
         res.status(405).json({});
     }
-
-
-    await db.close();
 }
 \ No newline at end of file