find or create codes

2 files changed, 6 insertions, 5 deletions

diff --git a/db/models/codes.js b/db/models/codes.js
index 9d967d11..66a8f7e0 100644
--- a/db/models/codes.js
+++ b/db/models/codes.js
@@ -2,11 +2,11 @@ const { DataTypes } = require('sequelize');
 
 const attributes = {
   code: {
-    type: DataTypes.STRING(64),
+    type: DataTypes.STRING(255),
     allowNull: false,
     defaultValue: null,
     primaryKey: true,
-    autoIncrement: true,
+    autoIncrement: false,
     comment: null,
     field: "code"
   },
diff --git a/routes/lnurl.js b/routes/lnurl.js
index 44eb0fb9..7da1d768 100644
--- a/routes/lnurl.js
+++ b/routes/lnurl.js
@@ -65,13 +65,14 @@ app.post(
   ah(async (req, res, next) => {
     try {
       const { encoded } = req.body.lnurl;
-      const code = await db.Code.create({
-        code: "lnurl:" + encoded.substr(-32),
+      const code = await db.Code.findOrCreate({ where: {
+        code: `lnurl:${encoded.substr(-32)}`,
         text: encoded,
-      });
+      }});
 
       res.send(code);
     } catch (e) {
+      l.error(e.errors);
       res.status(500).send(e.message);
     }
   })