Skip to content

Instantly share code, notes, and snippets.

View voidnerd's full-sized avatar
:octocat:
Debugging

Ndifreke Friday voidnerd

:octocat:
Debugging
108 followers · 86 following
View GitHub Profile
@voidnerd
voidnerd / 20190417131115_test-setup.ts
Created October 22, 2021 18:48 — forked from jukkatupamaki/20190417131115_test-setup.ts
How to use Knex.js in a TypeScript project
import { Knex } from 'knex'
export async function up(knex: Knex): Promise<any> {
await knex.schema.createTable('test_setup', (table: Knex.TableBuilder) => {
table.integer('foobar');
});
}
export async function down(knex: Knex): Promise<any> {
await knex.schema.dropTable('test_setup');
@voidnerd
voidnerd / hook.json
Created February 4, 2020 11:03 — forked from Afaara/hook.json
{
"event": "charge.success",
"data": {
"id": 84,
"domain": "test",
"status": "success",
"reference": "9cfbae6e-bbf3-5b41-8aef-d72c1a17650g",
"amount": 50000,
"message": null,
"gateway_response": "Approved",
@voidnerd
voidnerd / no-try-catch-async-await.js
Created April 22, 2019 12:46 — forked from DavidWells/no-try-catch-async-await.js
Nicer try/catch for async await.
/* Helper buddy for removing async/await try/catch litter 🗑 */
function O_o(promise) {
return promise.then(data => {
if (data instanceof Error) return [data]
return [null, data]
}).catch(err => [err])
}
/* Look ma, no try/catch */
async function usageExample(params) {
@voidnerd
voidnerd / html5-video-streamer.js
Created October 2, 2018 16:22 — forked from paolorossi/html5-video-streamer.js
Node.js HTML5 video streamer
/*
* Inspired by: http://stackoverflow.com/questions/4360060/video-streaming-with-html-5-via-node-js
*/
var http = require('http'),
fs = require('fs'),
util = require('util');
http.createServer(function (req, res) {
var path = 'video.mp4';
@voidnerd
voidnerd / build-tree.php
Created September 17, 2018 13:52 — forked from vyspiansky/build-tree.php
PHP: convert object / array to tree structure
<?php
/*
* Source: http://goo.gl/p2GybZ
*/
// for object
function buildTree($items) {
$childs = array();
foreach($items as $item)
@voidnerd
voidnerd / closure_table.md
Created September 14, 2018 16:25
Persistent tree structure using closure table in MySQL

Using closure tables to manage hierarchical relations in MySQL

Create DB tables

Create a table to represent tree nodes.

CREATE TABLE `tree_node` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `data_body` text,

node_deleted datetime DEFAULT NULL,