Akinwande Akinboluwarin bolubee101
bolubee101
/ migration.sql
Last active
February 26, 2025 08:12
PostgreSQL Schema and Data Migration Script Using the dblink extension
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DO $$ | |
| DECLARE | |
| tbl RECORD; | |
| col RECORD; | |
| seq RECORD; | |
| udt RECORD; | |
| schema RECORD; | |
| sql TEXT; | |
| default_expr TEXT; | |
| column_definitions TEXT; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Convert string to number | |
| type ToNumber<S> = S extends `${infer N extends number}` ? N : never; | |
| // Creates an array with a particular length | |
| type ArrayWithLength< | |
| T extends number, | |
| A extends number[] = number[], | |
| > = A["length"] extends T ? A : ArrayWithLength<T, [...A, A["length"]]>; | |
| // Generates a union type with all the numbers from zero -> n |
davidekete
/ updateEnv.js
Last active
November 15, 2023 11:32
A script that watches your .env file and updates your .env.example file
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| const fs = require('fs'); | |
| const chokidar = require('chokidar'); | |
| const envFilePath = './.env'; | |
| const exampleFilePath = './.env.example'; | |
| /** | |
| * Reads the contents of the .env file and returns an array of variable names. | |
| * @returns A set of variable names from the .env file. | |
| */ |