Skip to content

Instantly share code, notes, and snippets.

View wimleers's full-sized avatar
🦙

Wim Leers wimleers

🦙
273 followers · 121 following
View GitHub Profile
@wimleers
wimleers / sqlite-rewrite.sh
Created November 5, 2023 19:51
cp mqtt.db ebusd-from-mqtt.db
sqlite3 ebusd-from-mqtt.db "DROP TRIGGER mqtt_after_insert; DROP TRIGGER mqtt_after_update;ALTER TABLE mqtt DROP qos; ALTER TABLE mqtt DROP retain; ALTER TABLE mqtt DROP history_enable; ALTER TABLE mqtt DROP history_diffonly; UPDATE mqtt SET ts=datetime(ts, '-1 hour'); UPDATE mqtt_history SET ts=datetime(ts, '-1 hour');"
sqlite3 ebusd-from-mqtt.db < newtriggers.sql
@wimleers
wimleers / sadfasdfsadf
Created September 1, 2023 07:51
{
"data": [
{
"package": null,
"note": "sa;dlfkjasd;flkjasd f;lkasdjf a;sldkfj asd;flkjasdf",
"replaces": {
"name": "php"
},
"vetted": true
},
@wimleers
wimleers / sdfsdf.json
Last active September 1, 2023 07:49
{
"data": [
{
"package": null,
"note": "sa;dlfkjasd;flkjasd f;lkasdjf a;sldkfj asd;flkjasdf",
"replaces": {
"name": "php"
},
"vetted": true
},
@wimleers
wimleers / mastodon alias
Created May 28, 2023 08:14
$ http GET https://wimleers.com/.well-known/webfinger
HTTP/1.1 200 OK
Accept-Ranges: bytes
Age: 1172
Connection: keep-alive
Content-Length: 475
Content-Type: application/octet-stream
Date: Sun, 28 May 2023 08:05:52 GMT
ETag: "6473069d-1db"
Last-Modified: Sun, 28 May 2023 07:45:33 GMT
@wimleers
wimleers / ama-manual-cloud-deploy.md
Created June 10, 2020 15:24 — forked from balsama/ama-manual-cloud-deploy.md
Instructions to manually deploy Migrate Assistant to an Acquia Cloud environment

Manually deploy a newly created migrate project to Acquia Cloud

@TODO

Updated 10 June

  • Manually test again
  • Add instructions on scp-ing files directory too

Prerequisites

  1. Admin access to an Acquia Cloud hosting environment.
  2. A Drupal 7 site running locally
@wimleers
wimleers / state-of-jsonapi-2018-10.md
Last active October 25, 2018 08:43

Mateu, Gabe and I just released the first RC of JSON API 2, so time for an update!

It's been three months since the previous "state of JSON API" blog post, where we explained why JSON API didn't get into Drupal 8.6 core.

What happened since then? In a nutshell:

  • We're now much closer to getting JSON API into Drupal core!
  • JSON API 2.0-beta1, 2.0-beta2 and 2.0-rc1 were released
  • Those three releases span 84 fixed issues. (Not counting support requests.)
  • includes are now 3 times faster, 4xx responses are now cached!
@wimleers
wimleers / json 82 vs 83 work around.patch
Created September 27, 2017 13:53
modules/json82/json82.info.yml | 5 +++++
modules/json82/json82.services.yml | 5 +++++
modules/json82/src/Json82Encoder.php | 14 ++++++++++++++
modules/json82/src/Json82ServiceModifier.php | 28 ++++++++++++++++++++++++++++
4 files changed, 52 insertions(+)
diff --git a/modules/json82/json82.info.yml b/modules/json82/json82.info.yml
new file mode 100644
index 0000000..3eabde8
--- /dev/null
@wimleers
wimleers / dcon-vienna-api-first.md
Last active September 25, 2017 07:56 — forked from e0ipso/api-first-priorities.md
DrupalCon Vienna API-First Sprints
@wimleers
wimleers / ping.txt
Created May 15, 2017 16:57
$ ping google.com
PING google.com (216.58.211.110): 56 data bytes
64 bytes from 216.58.211.110: icmp_seq=0 ttl=53 time=19.736 ms
64 bytes from 216.58.211.110: icmp_seq=1 ttl=53 time=21.182 ms
64 bytes from 216.58.211.110: icmp_seq=2 ttl=53 time=91.430 ms
64 bytes from 216.58.211.110: icmp_seq=3 ttl=53 time=21.584 ms
Request timeout for icmp_seq 4
Request timeout for icmp_seq 5
Request timeout for icmp_seq 6
Request timeout for icmp_seq 7
@wimleers
wimleers / sphp.sh
Created October 17, 2016 11:37 — forked from w00fz/sphp.sh
PHP switcher
#!/bin/bash
# Check if command was ran as root.
if [[ $(id -u) -eq 0 ]]; then
echo "The command \"sphp\" should not be executed as root or via sudo directly."
echo "When a service requires root access, you will be prompted for a password as needed."
exit 1
fi
# Usage