quietlight/skraak.app - Change QPZE42LFURFXW6QNTVXY6AF7DZI7KTOLHMNSJHLFCRZMNMGQ6EVQC

added webhook route, not sure its working correctly. Also removed icon from index.html

Created by AEj8dahVWy718uSSFPe9VSRJ5qX5G8pC2zvFzJJ8yzBd on June 1, 2025

QPZE42LFURFXW6QNTVXY6AF7DZI7KTOLHMNSJHLFCRZMNMGQ6EVQC

Dependencies

In channels

main

Change contents

Replacement in tsconfig.json at line 4 [3.239147]

B:BD[3.239183] → [3.239183:239303]

    { "path": "./tsconfig.app.json" },
    { "path": "./tsconfig.node.json" },
    { "path": "./tsconfig.worker.json" }

[3.239183]

[4.8549]

    {
      "path": "./tsconfig.app.json"
    },
    {
      "path": "./tsconfig.node.json"
    },
    {
      "path": "./tsconfig.worker.json"
    }

Replacement in tsconfig.json at line 20 [3.239147]

B:BD[4.8665] → [4.8665:8797]

      "@/*": ["./src/*"],
      "@react/*": ["./src/react-app/*"],
      "@worker/*": ["./src/worker/*"],
      "@db/*": ["./db/*"]

[4.8665]

[4.8797]

      "@/*": [
        "./src/*"
      ],
      "@react/*": [
        "./src/react-app/*"
      ],
      "@worker/*": [
        "./src/worker/*"
      ],
      "@db/*": [
        "./db/*"
      ]

Replacement in tsconfig.json at line 34 [3.239147]
∅:D[4.8807] → [3.239397:239399]
B:BD[3.239397] → [3.239397:239399]
```
}
```
[4.8807]
```
}
```
Insertion in src/worker/index.ts at line 28 [3.240196]
[5.144789]
[4.9403]
```
import webhookRoute from "./routes/W7YwJjZbQqB6z40Va6vio";
```
Insertion in src/worker/index.ts at line 59 [3.240196]
[5.145114]
[6.14474]
```
app.route("/api", webhookRoute);
```
Insertion in package.json at line 12 [3.254306]
[4.17078]
[4.17078]
```
    "@types/luxon": "^3.6.2",
```
Insertion in package.json at line 19 [3.254306]
[4.17198]
[7.53]
```
    "luxon": "^3.6.1",
```
Insertion in package-lock.json at line 17 [3.255732]
[4.17671]
[4.17671]
```
        "@types/luxon": "^3.6.2",
```
Insertion in package-lock.json at line 24 [3.255732]
[4.17807]
[7.79]
```
        "luxon": "^3.6.1",
```

Insertion in package-lock.json at line 4263 [3.255732]

[8.142709]

    "node_modules/@types/luxon": {
      "version": "3.6.2",
      "resolved": "https://registry.npmjs.org/@types/luxon/-/luxon-3.6.2.tgz",
      "integrity": "sha512-R/BdP7OxEMc44l2Ex5lSXHoIXTB2JLNa3y2QISIbr58U/YcsffyQrYW//hZSdrfxrjRZj3GcUoxMPGdO8gSYuw==",
      "license": "MIT"
    },

Insertion in package-lock.json at line 7186 [3.255732]

[4.42048]

[9.27094]

    "node_modules/luxon": {
      "version": "3.6.1",
      "resolved": "https://registry.npmjs.org/luxon/-/luxon-3.6.1.tgz",
      "integrity": "sha512-tJLxrKJhO2ukZ5z0gyjY1zPh3Rh88Ej9P7jNrZiHMUXHae1yvI2imgOZtL1TO8TW6biMMKfTtAOoEJANgtWBMQ==",
      "license": "MIT",
      "engines": {
        "node": ">=12"
      }
    },

Replacement in index.html at line 5 [3.434551]

B:BD[3.434623] → [3.434623:434685]

    <link rel="icon" type="image/svg+xml" href="/vite.svg" />

[3.434623]

[3.434685]

    <!-- <link rel="icon" type="image/svg+xml" href="/vite.svg" /> -->

Replacement in db/schema.sql at line 399 [8.70506]

∅:D[2.7856] → [8.89415:89583]

B:BD[8.89415] → [8.89415:89583]

-- Permission for a domain can be: Read, Manage, Delete
-- ??not able to delete an access grant, can only modify
-- ??this way we maintain some semblance of an history

[2.7856]

[8.89583]

-- Permission for a domain can be: Read, Upload, Download, Edit, Delete

Deletion in db/schema.sql at line 401 [8.70506]
B:BD[8.89641] → [8.89641:89678]
```
-- role grants will then still exist
```

Deletion in db/schema.sql at line 408 [8.70506]

B:BD[8.90630] → [8.90630:90866]

-- integrate Kinde authentication system to retrieve user roles and IDs.  The Kinde token should contain information about the user's role.  The application then uses the `user_id` from the token when querying the `access_grant` table.

Insertion in db/migrations.sql at line 748 [8.94401]

[2.7860]

-- Fix permissions, grants only apply to me now, runs on all currrent rows
BEGIN;
UPDATE access_grant
SET user_id = 'kp_8663c3b3d4654734874b17d846bbe52d';
COMMIT;
SELECT NOW();
-- 2025-05-31 23:37:00.715196+00
-- add cdecary@protonmail id as USER
INSERT INTO user_role (
    user_id,
    role,
    created_at,
    created_by,
    last_modified,
    modified_by
) VALUES
('kp_f51827365ac74df1a51692ea21b9de38', 'USER', '2025-05-31T22:43:24.665+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', '2025-05-31T22:43:24.665+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d');
SELECT NOW();
-- 2025-05-31 23:38:04.050806+00 
 
-- give Read access to my data to cdecary@protonmail.com, I mutated this a little later to give access to anyone with USER role
INSERT INTO access_grant (
    id,
    dataset_id,
    role,
    permission,
    user_id,
    created_at,
    created_by,
    last_modified,
    modified_by,
    active
) VALUES
('_eRX3OwbE_gc', 'Yx0oNUDmP5ch', 'USER', 'READ', 'kp_f51827365ac74df1a51692ea21b9de38', '2025-05-31T22:43:24.665+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', '2025-05-31T22:43:24.665+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', true),
('n4BK5BlprYTT', 'gljgxDbfasva', 'USER', 'READ', 'kp_f51827365ac74df1a51692ea21b9de38', '2025-05-31T22:43:24.665+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', '2025-05-31T22:43:24.665+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', true);
SELECT NOW();
-- 2025-05-31 23:39:29.390785+00 
-- Insert 2 datasets for Inge
INSERT INTO dataset (
    id,
    name,
    public,
    description,
    created_by,
    created_at,
    last_modified,
    modified_by,
    owner,
    active,
    type
) VALUES
('la-JpAf2nLKG', 'Manu o Kahurangi', FALSE, 'Inge Bolt''s Kahurangi Kiwi Survey',  'kp_8663c3b3d4654734874b17d846bbe52d', '2025-06-01T17:46:18.229+00:00', '2025-06-01T17:46:18.229+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', 'kp_a54e280f0e914e10b06e88e894055689', TRUE, 'organise'),
('QZ0tlUrX4Nyi', 'Friends of Cobb', FALSE, 'Friends of Cobb',  'kp_8663c3b3d4654734874b17d846bbe52d', '2025-06-01T17:46:18.229+00:00', '2025-06-01T17:46:18.229+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', 'kp_a54e280f0e914e10b06e88e894055689', TRUE, 'organise');
SELECT NOW();
-- 2025-06-01 18:25:47.688359+00

Insertion in db/migrations.sql at line 806 [8.94401]

[2.7861]

-- Give Inge ADMIN role
INSERT INTO user_role (
    user_id,
    role,
    created_at,
    created_by,
    last_modified,
    modified_by
) VALUES
('kp_a54e280f0e914e10b06e88e894055689', 'ADMIN', '2025-06-01T17:46:18.229+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', '2025-06-01T17:46:18.229+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d');
SELECT NOW();
-- 2025-06-01 18:26:31.482392+00
-- Give Inge full permissions for her datasets
INSERT INTO access_grant (
    id,
    dataset_id,
    role,
    permission,
    user_id,
    created_at,
    created_by,
    last_modified,
    modified_by,
    active
) VALUES
('Cmpye4WPU0Cu', 'la-JpAf2nLKG', 'ADMIN', 'READ', 'kp_a54e280f0e914e10b06e88e894055689', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', true),
('y72kxAuL4t8V', 'la-JpAf2nLKG', 'ADMIN', 'UPLOAD', 'kp_a54e280f0e914e10b06e88e894055689', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', true),
('K_vEeuFzu1Qb', 'la-JpAf2nLKG', 'ADMIN', 'DOWNLOAD', 'kp_a54e280f0e914e10b06e88e894055689', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', true),
('15XbhaLpwdy_', 'la-JpAf2nLKG', 'ADMIN', 'EDIT', 'kp_a54e280f0e914e10b06e88e894055689', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', true),
('PhLrc-xlNYKz', 'la-JpAf2nLKG', 'ADMIN', 'DELETE', 'kp_a54e280f0e914e10b06e88e894055689', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', true),
('mLW-Pex1wE-3', 'QZ0tlUrX4Nyi', 'ADMIN', 'READ', 'kp_a54e280f0e914e10b06e88e894055689', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', true),
('X03iZV0RL8Mh', 'QZ0tlUrX4Nyi', 'ADMIN', 'UPLOAD', 'kp_a54e280f0e914e10b06e88e894055689', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', true),
('CNXvRs_ZVHpc', 'QZ0tlUrX4Nyi', 'ADMIN', 'DOWNLOAD', 'kp_a54e280f0e914e10b06e88e894055689', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', true),
('9a1HUFYQJQKl', 'QZ0tlUrX4Nyi', 'ADMIN', 'EDIT', 'kp_a54e280f0e914e10b06e88e894055689', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', true),
('EMLbmivpmIBw', 'QZ0tlUrX4Nyi', 'ADMIN', 'DELETE', 'kp_a54e280f0e914e10b06e88e894055689', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', '2025-06-01T18:15:36.855+00:00', 'kp_8663c3b3d4654734874b17d846bbe52d', true);
SELECT NOW();
-- 2025-06-01 18:27:15.703338+00
-- Give anyone with USER role access to my 2 datasets, Pomona and 24/7
BEGIN;
UPDATE access_grant
SET user_id = NULL
WHERE id IN ('_eRX3OwbE_gc', 'n4BK5BlprYTT');
COMMIT;
SELECT NOW();
-- 2025-06-01 21:55:26.214979+00

added webhook route, not sure its working correctly. Also removed icon from index.html

Dependencies

In channels

Change contents

Replacement in tsconfig.json at line 4 [3.239147]

Replacement in tsconfig.json at line 20 [3.239147]

Replacement in tsconfig.json at line 34 [3.239147]

Insertion in src/worker/index.ts at line 28 [3.240196]

Insertion in src/worker/index.ts at line 59 [3.240196]

Insertion in package.json at line 12 [3.254306]

Insertion in package.json at line 19 [3.254306]

Insertion in package-lock.json at line 17 [3.255732]

Insertion in package-lock.json at line 24 [3.255732]