Skip to content

Instantly share code, notes, and snippets.

View bolubee101's full-sized avatar

Akinwande Akinboluwarin bolubee101

View GitHub Profile
@bolubee101
bolubee101 / migration.sql
Last active February 26, 2025 08:12
PostgreSQL Schema and Data Migration Script Using the dblink extension
DO $$
DECLARE
tbl RECORD;
col RECORD;
seq RECORD;
udt RECORD;
schema RECORD;
sql TEXT;
default_expr TEXT;
column_definitions TEXT;
@bolubee101
bolubee101 / standard.md
Last active October 13, 2021 08:16
Proposed standard for Search endpoint for Zuri. Implemented on goals plugin

The request is shaped as such, following the get request format that has been followed by the plugin

api/v1/search?search=searchparams&orgid=orgid&page=page&limit=limit

{
status,
message,
prev: 'link to previous search page',
@bolubee101
bolubee101 / standard.md
Created October 12, 2021 11:55
Proposed standard for Search endpoint for Zuri. Implemented on goals plugin

The request is shaped as such

api/v1/search?search=searchparams&orgid="orgid"

{
status
message
data:[]
@bolubee101
bolubee101 / nigeria-states-and-local-govts.json
Created July 24, 2020 00:29 — forked from mofesolapaul/nigeria-states-and-local-govts.json
Json array containing objects of each Nigerian state, and their local governments
[
{
"state": "Abia",
"lgas": [
"Aba North",
"Aba South",
"Arochukwu",
"Bende",
"Ikawuno",
"Ikwuano",