Hannes Heine · c6ff0723 · c6ff0723 · c6ff0723 · a9817048 · a9817048
--- a/backend/src/schema/resolvers/helpers/generateInviteCode.js 0 → 100644
+++ b/backend/src/schema/resolvers/helpers/generateInviteCode.js 0 → 100644
+export default function generateInviteCode() {
+  // 6 random numbers in [ 0, 35 ] are 36 possible numbers (10 [0-9] + 26 [A-Z])
+  return Array.from({ length: 6 }, (n = Math.floor(Math.random() * 36)) => {
+    // n > 9: it is a letter (ASCII 65 is A) -> 10 + 55 = 65
+    // else: it is a number (ASCII 48 is 0) -> 0 + 48 = 48
+    return String.fromCharCode(n > 9 ? n + 55 : n + 48)
-    return String.fromCharCode(n > 9 ? n + 55 : n + 48)
+    // Shift ASCII Characters to numbers (48-57) or A-Z (65-90)
+    return String.fromCharCode(n > 9 ? n + 65 : n + 48)
--- a/backend/src/schema/resolvers/inviteCodes.spec.js 0 → 100644
+++ b/backend/src/schema/resolvers/inviteCodes.spec.js 0 → 100644
+
+    it('does not validate an invite code which expired in the past', async () => {
+      const lastWeek = new Date()
+      lastWeek.setDate(lastWeek.getDate() - 7)
+      const inviteCode = await Factory.build('inviteCode', {
+        expiresAt: lastWeek.toISOString(),
+      })
+      const code = inviteCode.get('code')
+      const result = await query({ query: isValidInviteCodeQuery, variables: { code } })
+      expect(result.data.isValidInviteCode).toBeFalsy()
+    })
+
+    it('does not validate an invite code which does not exits', async () => {
+      const result = await query({ query: isValidInviteCodeQuery, variables: { code: 'AAA' } })
+      expect(result.data.isValidInviteCode).toBeFalsy()
+    })
-    })
+    })
+    
+    it('does validate an invite code in lower caps' , async () => {
+    ...
+    }
--- a/backend/src/db/factories.js
+++ b/backend/src/db/factories.js
 }

 Factory.define('emailAddress')
- .attr(emailDefaults)
+ .attrs(emailDefaults)
--- a/backend/src/schema/resolvers/inviteCodes.js
+++ b/backend/src/schema/resolvers/inviteCodes.js
+   })
+   return parseInt(String(result.records[0].get('count'))) === 0
+ })
+}
+
+export default {
+ Query: {
+   MyInviteCodes: async (_parent, args, context, _resolveInfo) => {
+     const {
+       user: { id: userId },
+     } = context
+     const session = context.driver.session()
+     const readTxResultPromise = session.readTransaction(async (txc) => {
+       const result = await txc.run(
+         `MATCH (user:User {id: $userId})-[:GENERATED]->(ic:InviteCode)
+          RETURN properties(ic) AS inviteCodes`,
--- a/backend/src/schema/resolvers/inviteCodes.js
+++ b/backend/src/schema/resolvers/inviteCodes.js
+     } finally {
+       session.close()
+     }
+   },
+   isValidInviteCode: async (_parent, args, context, _resolveInfo) => {
+     const { code } = args
+     if (!code) return false
+     const session = context.driver.session()
+     const readTxResultPromise = session.readTransaction(async (txc) => {
+       const result = await txc.run(
+         `MATCH (ic:InviteCode { code: toUpper($code) })
+          RETURN
+          CASE
+          WHEN ic.expiresAt IS NULL THEN true
+          WHEN datetime(ic.expiresAt) >=  datetime() THEN true
+          ELSE false END AS result`,