Skip to content

Instantly share code, notes, and snippets.

View CanRau's full-sized avatar
🤓
coding

Can Rau CanRau

🤓
coding
View GitHub Profile
@CanRau
CanRau / Basics.md
Last active March 12, 2023 21:32
[SQLite Notes] #SQLite

insert multiple

INSERT INTO table1 (column1,column2 ,..)
VALUES 
   (value1,value2 ,...),
   (value1,value2 ,...),
    ...
   (value1,value2 ,...);
@CanRau
CanRau / 1_stripe-schema.md
Created February 16, 2023 01:25 — forked from FGRibreau/1_stripe-schema.md
Stripe database schema (extracted from their sigma product) as of 2019-10-09
jqn -r markdown-table 'map(x => "## " + x.name + "\n\n" + markdownTable(x.columns.map(y => [y.name, y.type]))  ) | join("\n\n")' < /tmp/stripe.json

accounts

id varchar
business_name varchar
business_url varchar

Keybase proof

I hereby claim:

  • I am canrau on github.
  • I am canrau (https://keybase.io/canrau) on keybase.
  • I have a public key ASDcjXYRMtWtmJKpTow9SS7FahCJbrnILp30C51yJrH_7Ao

To claim this, I am signing this object:

import { useEffect, useState } from "react";
// @NOTE: It's stringifying as I'm storing the result in a form field and then DB, but you can of course change that to your needs
// @NOTE: Also `getHighEntropyValues` might throw as mentioned in https://developer.mozilla.org/en-US/docs/Web/API/NavigatorUAData/getHighEntropyValues#exceptions
// @NOTE: so when it errors I'm returning the more "basic" `navigator?.userAgentData` with the error information, which might be unnecessary, but I'm curious 🤷🏻‍♂️
export const useUserAgentClientHints = () => {
const [userAgent, setUserAgent] = useState("");
useEffect(() => {
<?php
/* Batch delete all fields containing order_ in name */
foreach($fields->find("name%=order_") as $field) {
$fields->delete($field);
if (!$fields->get($field)) echo "<p>field {$field->name} was deleted.</p>";
}
/* list all templates and provide ability to delete unused ones */
if ($input->post->submit) {
@CanRau
CanRau / gtm-utm-remover.js
Last active April 22, 2019 04:11
Removes all query parameters from the url beginning with 'utm_', leaves anchors (#) and other query params alone
/**
* GTM utm_ remover
* License: MIT
* Author: @CanRau
* Version: 0.2.0
*
* Removes all query parameters from the url beginning with 'utm_'
* Leaves anchors (#) and other query params alone, so
* example.com/?session=SESSIONID&utm_source=instagram#content
* would become
@CanRau
CanRau / TextformatterBlogImages.module
Last active April 18, 2019 10:48
Please read https://processwire.com/talk/topic/13471-better-ckeditor-image-insertion-at-least-for-me/ I'm fixing some bugs right now and am rearranging the whole thing
<?php
/**
* Add to any textarea field from field settings
* or place the following code into any template file
*
* $modules->TextformatterBlogImages->formatValue($page, new Field(), $page->body);
* where $page->body is your textarea
*
* make sure to review path to simple_html_dom.php
*
@CanRau
CanRau / README.md
Created November 26, 2018 18:41 — forked from kentcdodds/README.md
Rendering a function with React

Rendering a function with React

No, this isn't about render props

I'm going to clean this up and publish it in my newsletter next week!

Context

So react-i18n (not the npm one... one we made at PayPal internally) has this

@CanRau
CanRau / wrapper.js
Created November 6, 2018 04:41 — forked from jimfb/wrapper.js
class MyWrapper {
return React.Children.only(this.props.children);
}
class MyLibraryComponent {
render() {
return <div><span><whatever><MyWrapper ref=...>{this.props.statelessComponentThatIWantToReference}</MyWrapper></whatever></span></div>;
}
@CanRau
CanRau / README.md
Created October 16, 2018 04:27 — forked from mw-ferretti/README.md
Paypal button on markdown github

###Steps:

<!-- Sample of code generated --> 
<form action="https://www.paypal.com/cgi-bin/webscr" method="post" target="_top">
<input type="hidden" name="cmd" value="_s-xclick">
<input type="hidden" name="hosted_button_id" value="RGQ8NSYPA59FL">
<input type="image" src="https://www.paypalobjects.com/en_US/i/btn/btn_donateCC_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src="https://www.paypalobjects.com/pt_BR/i/scr/pixel.gif" width="1" height="1">