oojikoo’s gists

oojikoo / .env

Created December 7, 2022 04:47 — forked from degitgitagitya/.env

Next JS + Next Auth + Keycloak + AutoRefreshToken

oojikoo / convert-keys-to-camel-case

Created April 19, 2022 06:47 — forked from imbudhiraja/convert-keys-to-camel-case

Converting Object Keys from Snake Case, Kebab Case to Camel Case with JavaScript

	const mongoose = require('mongoose');

	const toCamel = (string) => string.replace(/([-_][a-z])/gi, ($1) => $1
	.toUpperCase()
	.replace('-', '')
	.replace('_', ''));

	const isObject = (args) => args === Object(args) && !Array.isArray(args) && typeof args !== 'function';

	const keysToCamel = (args) => {

oojikoo / nanoid.sql

Created March 30, 2022 02:39 — forked from prashant-shahi/nanoid.sql

Nano ID implementation in PostgreSQL - PL/pgSQL

	CREATE EXTENSION IF NOT EXISTS pgcrypto;

	CREATE OR REPLACE FUNCTION public.nanoid(size integer DEFAULT 21)
	RETURNS text
	LANGUAGE plpgsql
	STABLE
	AS $function$
	DECLARE
	id text := '';
	i int := 0;

oojikoo / page-info.ts

Created February 16, 2022 14:20 — forked from tumainimosha/page-info.ts

NestJS Graphql Cursor Based pagination

	import { ObjectType, Field } from "@nestjs/graphql";

	@ObjectType()
	export class PageInfo {

	@Field({ nullable: true })
	startCursor: string;

	@Field({ nullable: true })
	endCursor: string;

oojikoo / artifact-registry-cloud-run-demo.sh

Created February 14, 2022 22:37 — forked from pydevops/artifact-registry-cloud-run-demo.sh

Google Cloud Platform demo of Artifact Registry deployment and Cloud Run app

	#!/usr/bin/env bash

	export PROJECT_ID=$(gcloud config get-value project)
	export PROJECT_USER=$(gcloud config get-value core/account) # set current user
	export PROJECT_NUMBER=$(gcloud projects describe $PROJECT_ID --format="value(projectNumber)")
	export IDNS=${PROJECT_ID}.svc.id.goog # workflow identity domain

	export GCP_REGION="us-east1" # CHANGEME (OPT)
	export GCP_ZONE="us-east1-c" # CHANGEME (OPT)
	export NETWORK_NAME="default"

oojikoo / snowflake-id.sql

Created December 13, 2021 00:18 — forked from beginor/snowflake-id.sql

Twitter Snowflake ID for PostgreSQL

	CREATE SEQUENCE public.global_id_seq;
	ALTER SEQUENCE public.global_id_seq OWNER TO postgres;

	CREATE OR REPLACE FUNCTION public.id_generator()
	RETURNS bigint
	LANGUAGE 'plpgsql'
	AS $BODY$
	DECLARE
	our_epoch bigint := 1314220021721;
	seq_id bigint;

oojikoo / formikApollo.js

Created March 16, 2021 02:28 — forked from mwickett/formikApollo.js

Formik + Apollo

	import React from 'react'
	import { withRouter, Link } from 'react-router-dom'
	import { graphql, compose } from 'react-apollo'
	import { Formik } from 'formik'
	import Yup from 'yup'

	import FormWideError from '../elements/form/FormWideError'
	import TextInput from '../elements/form/TextInput'
	import Button from '../elements/form/Button'
	import { H2 } from '../elements/text/Headings'

oojikoo / index.ts

Created January 7, 2020 02:58 — forked from ikorolev93/index.ts

Running redux-saga in a web worker

	import {theSaga} from "somewhere";

	const ctx: Worker = self as any;
	const workerIO: RunSagaOptions<Action, undefined> = {
	subscribe: cb => {
	const listener = (ev: MessageEvent) => cb(ev.data);
	ctx.addEventListener("message", listener);
	return () => ctx.removeEventListener("message", listener);
	},
	dispatch: action => ctx.postMessage(action),

oojikoo / read-access.sql

Created July 19, 2018 08:35 — forked from oinopion/read-access.sql

How to create read only user in PostgreSQL

	-- Create a group
	CREATE ROLE readaccess;

	-- Grant access to existing tables
	GRANT USAGE ON SCHEMA public TO readaccess;
	GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;

	-- Grant access to future tables
	ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;

oojikoo / PrivateRoute.js

Created July 17, 2018 23:29

Conditional Route for react-router. tags: #react #react-router

	import React from 'react'
	import {
	Route,
	Redirect
	} from 'react-router-dom'

	class PrivateRoute extends React.Component {
	render() {
	const { component: Component, ...rest } = this.props

ryankim oojikoo