PabloCastellano
/ With SAMPLE_APP=1
Created
May 12, 2020 17:36
Different SQL queries in openwisp-firmware-upgrader issue 53
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT "authtoken_token"."key", "authtoken_token"."user_id", "authtoken_token"."created", "openwisp_users_user"."password", "openwisp_users_user"."last_login", "openwisp_users_user"."is_superuser", "openwisp_users_user"."username", "openwisp_users_user"."first_name", "openwisp_users_user"."last_name", "openwisp_users_user"."is_staff", "openwisp_users_user"."is_active", "openwisp_users_user"."date_joined", "openwisp_users_user"."id", "openwisp_users_user"."email", "openwisp_users_user"."bio", "openwisp_users_user"."url", "openwisp_users_user"."company", "openwisp_users_user"."location", "openwisp_users_user"."phone_number" FROM "authtoken_token" INNER JOIN "openwisp_users_user" ON ("authtoken_token"."user_id" = "openwisp_users_user"."id") WHERE "authtoken_token"."key" = '30ce80ab05b3098e080f27768efc4ae6e19f4052' LIMIT 21 | |
| SELECT "openwisp_users_organization"."name", "openwisp_users_organization"."is_active", "openwisp_users_organization"."created", "openwisp_users_organization"."modified", "openwisp_users_organ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| From be14a14de0409ef2b3627c04dcbd25660103c455 Mon Sep 17 00:00:00 2001 | |
| From: Pablo Castellano <pablo@anche.no> | |
| Date: Mon, 25 May 2020 19:43:33 +0200 | |
| Subject: [PATCH 1/3] Last changes | |
| --- | |
| openwisp_monitoring/device/api/views.py | 9 ++++++--- | |
| openwisp_monitoring/monitoring/charts.py | 19 +++++++++++-------- | |
| 2 files changed, 17 insertions(+), 11 deletions(-) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| From be14a14de0409ef2b3627c04dcbd25660103c455 Mon Sep 17 00:00:00 2001 | |
| From: Pablo Castellano <pablo@anche.no> | |
| Date: Mon, 25 May 2020 19:43:33 +0200 | |
| Subject: [PATCH 1/3] Last changes | |
| --- | |
| openwisp_monitoring/device/api/views.py | 9 ++++++--- | |
| openwisp_monitoring/monitoring/charts.py | 19 +++++++++++-------- | |
| 2 files changed, 17 insertions(+), 11 deletions(-) |
PabloCastellano
/ network_device_status.json
Created
July 17, 2020 10:11
ubus calls in OpenWrt 19.07.3
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "br-lan": { | |
| "external": false, | |
| "present": true, | |
| "type": "bridge", | |
| "up": true, | |
| "carrier": true, | |
| "bridge-members": [ | |
| "eth0.1" | |
| ], |
PabloCastellano
/ sql.diff
Created
July 8, 2023 10:21
Differences between staging and production blobscan db schema
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --- staging.sql 2023-07-08 12:19:13.712663068 +0200 | |
| +++ production.sql 2023-07-08 12:20:09.848668875 +0200 | |
| @@ -41,9 +41,9 @@ | |
| id text NOT NULL, | |
| "versionedHash" text NOT NULL, | |
| commitment text NOT NULL, | |
| + size integer NOT NULL, | |
| "gsUri" text NOT NULL, | |
| - "swarmHash" text, | |
| - size integer NOT NULL |
OlderNewer