Max Rogério max10rogerio

## example.ts
/**
 * global describe
 */

namespace Command {
  export type NotAsync = String
}

/**
 * Generic interface basead in design pattern: https://refactoring.guru/design-patterns/command

## command.sh
❯ cat database.dump | docker exec -i server_postgres_1 psql -U postgres -W postgres -p 5432 -h 127.0.0.1 -d database

## useQuery.ts
import { useLocation } from "react-router-dom";

/**
 * Get URL query params as object
 *
 * Example:
 *
 * ```tsx
 * type Query = {
 *  q: string

## basic-clean-example.ts
interface Api {
  post: <R = any, P = any>(params: P) => Promise<R>
}

/*
  A api espera user_login, user_password
  E response user_name, user_age, user_status
*/
type ApiResponse = {
  user_name: string

## postgres-sql-with-json-parameters.ts
// Example
// https://www.typescriptlang.org/play?#code/MYewdgziA2CmB0w4EMBOAKAlAKG6SALgATCqzIGwBKsAZrGWMLEQLxHpm0BcRYArgFsARg0y8IBVAEswAczYA+IgAMAOgBINAby4BfFXnCSSZCrAAKaZINiVUAaVgBPNhwDWLiVNlzxRSRl5JVVuHU9nA1x8EwIQAGUARQAZNwAeABUiWAAPSjAAEwgiEGEAK1hgYnZkMGdFdAgAR2hvILkAGiIAB2tbewheDP8AbUDfLtrnEYBdGZDtbCJlojhiLgBJQty3AEYllbW+WAB3eJa3ZugD5ZjiWDAfWGL2AHlyyoJ4B6eIdF7UDY7AwIDgViRjMQ0KgrIDBC8iLNcODaCAMHdEREugA3ZDQfiweYgWjZR4yZ6YIiLcHgjEAoH2NykciUWEMhhOZzoCJgmm3SFEMhyHbsMCnIg0OQAURy3X+fWBqC6AHI5MreXyMVwGA9mEyzJQaPRGMxOHQtgVcjgbjSxWcLqLTudoPAyN1oMhTULcl1tSbYNa+ctoWz4fBuvwIAALdC4-EBm3gzbbHIAalTNr0yJWZAI-FQYERdudk1QML6EBm2Cz2Fk9lonpYoeK1JWYCBbV8NrRltQvGVAEF4gBhZVEAA+RGVABEpSPlTboNJBNICLwBCIGNXcAB6HdECJ8IFEWREWjSVAmbogCCr6TgIyEHoV3a8ZtuVvLdu2fuCZA5ZUOm7VBe37IdRyA8ElxXNciF2AAGICaz3A8XCPWwT0LD0rxvO8HzpCsACY3wrD9gNAqdwMAxdl1XXgEMgtsOynP8AKQ6IBSuNxDHBCBYDgKoiETFYACpGL5bhoNXIghxPfIIAAfW6BglOQYUbVoVAQEEISgyIAhkGEOBdJWE4ox1Ey+TAbSWHYbhv1gciGCIYRXAcohuB7LcoNo4hJN87BDEfEwyAgfhoAIXY3DiJJkjSZsGiuLp6XhXYcC1Z5woIQjooSFJ4orRKWmSojr

## columns-to-annotations.sql
SELECT
	E'@Column({ name: \'' || column_name || E'\', type: \'' || data_type || E'\'})'
FROM
	INFORMATION_SCHEMA.COLUMNS
WHERE
	TABLE_NAME = 'yourtable'
	AND TABLE_SCHEMA = 'your schema if necessary';

## slugify.ts
// ref: https://gist.github.com/codeguy/6684588#gistcomment-3426313

export const slugify = (...args: (string | number)[]): string => {
    const value = args.join(' ')

    return value
        .normalize('NFD') // split an accented letter in the base letter and the acent
        .replace(/[\u0300-\u036f]/g, '') // remove all previously split accents
        .toLowerCase()
        .trim()

## template-literal-type.ts
interface Example {
    first_name: string,
    last_name: string,
    home_town: string,
}

type CamelizeString<T extends PropertyKey> = T extends string ? string extends T ? string :
    T extends `${infer F}_${infer R}` ? `${F}${Capitalize<CamelizeString<R>>}` : T : T;

type Camelize<T> = { [K in keyof T as CamelizeString<K>]: T[K] }

## clipboard.ts
// https://developer.mozilla.org/en-US/docs/Mozilla/Add-ons/WebExtensions/Interact_with_the_clipboard

/**
 * Interface CopyToClipboard params
 */
interface ICopyToClipboard {
  /** HTML reference identifier ```<div id="foo"></div>```  */
  target?: string;
  /** String value */
  value?: string;

## mimes.json
{
  "aac": "audio/aac",
  "abw": "application/x-abiword",
  "arc": "application/x-freearc",
  "avi": "video/x-msvideo",
  "azw": "application/vnd.amazon.ebook",
  "bin": "application/octet-stream",
  "bmp": "image/bmp",
  "bz": "application/x-bzip",
  "bz2": "application/x-bzip2",
	/**
	* global describe
	*/

	namespace Command {
	export type NotAsync = String
	}

	/**
	* Generic interface basead in design pattern: https://refactoring.guru/design-patterns/command
	import { useLocation } from "react-router-dom";

	/**
	* Get URL query params as object
	*
	* Example:
	*
	* ```tsx
	* type Query = {
	* q: string
	interface Api {
	post: <R = any, P = any>(params: P) => Promise<R>
	}

	/*
	A api espera user_login, user_password
	E response user_name, user_age, user_status
	*/
	type ApiResponse = {
	user_name: string
	SELECT
	E'@Column({ name: \'' \|\| column_name \|\| E'\', type: \'' \|\| data_type \|\| E'\'})'
	FROM
	INFORMATION_SCHEMA.COLUMNS
	WHERE
	TABLE_NAME = 'yourtable'
	AND TABLE_SCHEMA = 'your schema if necessary';
	// ref: https://gist.github.com/codeguy/6684588#gistcomment-3426313

	export const slugify = (...args: (string \| number)[]): string => {
	const value = args.join(' ')

	return value
	.normalize('NFD') // split an accented letter in the base letter and the acent
	.replace(/[\u0300-\u036f]/g, '') // remove all previously split accents
	.toLowerCase()
	.trim()
	interface Example {
	first_name: string,
	last_name: string,
	home_town: string,
	}

	type CamelizeString<T extends PropertyKey> = T extends string ? string extends T ? string :
	T extends `${infer F}_${infer R}` ? `${F}${Capitalize<CamelizeString<R>>}` : T : T;

	type Camelize<T> = { [K in keyof T as CamelizeString<K>]: T[K] }
	// https://developer.mozilla.org/en-US/docs/Mozilla/Add-ons/WebExtensions/Interact_with_the_clipboard

	/**
	* Interface CopyToClipboard params
	*/
	interface ICopyToClipboard {
	/** HTML reference identifier ```<div id="foo"></div>``` */
	target?: string;
	/** String value */
	value?: string;
	{
	"aac": "audio/aac",
	"abw": "application/x-abiword",
	"arc": "application/x-freearc",
	"avi": "video/x-msvideo",
	"azw": "application/vnd.amazon.ebook",
	"bin": "application/octet-stream",
	"bmp": "image/bmp",
	"bz": "application/x-bzip",
	"bz2": "application/x-bzip2",