From 88da47b27a9584e800228b044e3adfd15adf2b18 Mon Sep 17 00:00:00 2001
From: Adam Soltys <asoltys@gmail.com>
Date: Fri, 7 Aug 2020 00:28:32 -0700
Subject: find or create codes

---
 db/models/codes.js | 4 ++--
 routes/lnurl.js    | 7 ++++---
 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);
     }
   })
-- 
cgit v1.2.3