Skip to content

Instantly share code, notes, and snippets.

View bschulz87's full-sized avatar
๐Ÿ‰

Benjamin Schulz bschulz87

๐Ÿ‰
  • Germany, Berlin
View GitHub Profile
@bschulz87
bschulz87 / gist:74315bc555b502250200ee79a0ad3a7b
Created October 23, 2023 14:34
Simple case insensitive search replace wordpress meta values
SET @old = "Holzbraun";
SET @new = "wooden";
SET @meta_key = "color";
UPDATE wp_postmeta
SET meta_value = REPLACE(REPLACE(meta_value,@old,@new),LOWER(@old),@new)
WHERE LOWER(meta_value) LIKE LOWER(CONCAT('%',@old,'%')) AND meta_key = @meta_key;
SELECT meta_id, post_id, meta_key, meta_value
FROM wp_postmeta
@bschulz87
bschulz87 / stories.dart
Last active July 1, 2024 14:14
Storybook Riverpod Knob
extension on Iterable<(String, Override)> {
List<Option> toKnobOptions() => List<Option>.from(map((e) => Option(label: e.$1, value: e)));
}
final knobOverride = Story(
name: "Knob/Override",
builder: (context) {
final options = [
(
"Loading",
@MappableRecord()
typedef Shop = ({
String id,
String name,
DateTime createdAt,
String address,
});
final res = await Amplify.API
.query(
@bschulz87
bschulz87 / datastore-resolver.js
Created January 27, 2025 10:36
Webiny DataStore Resolver
import { util } from "@aws-appsync/utils";
/**
* Sends a POST request to create a new user
* @param {import('@aws-appsync/utils').Context<{input: {id: string; name:string}}>} ctx the context
* @returns the request
*/
export function request(ctx) {
return fetch("/graphql", {
method: "POST",
@bschulz87
bschulz87 / testing-graphql.sh
Created February 4, 2025 14:21 — forked from dabit3/testing-graphql.sh
GraphQL requests using CURL
# query
curl \
-X POST \
-H "x-api-key: xxx-xxxx" \
-H "Content-Type: application/json" \
-d '{ "query": "query { listUsers { name } }" }' \
https://app-id.appsync-api.us-east-1.amazonaws.com/graphql
# mutation with variables
curl \