Skip to content

Instantly share code, notes, and snippets.

@nyg
nyg / fk_delete_recursive.sql
Last active August 25, 2017 08:01
Oracle: delete a row and all rows preventing it to be deleted because of "child record found" errors.
DECLARE
-- ORA-02292: integrity constraint (OWNER.FK) violated - child record found
ora_02292 EXCEPTION;
PRAGMA EXCEPTION_INIT(ora_02292, -2292);
l_foreign_key VARCHAR2(400);
PROCEDURE delete_row(pi_table IN VARCHAR2,
pi_column IN VARCHAR2,
pi_value IN VARCHAR2) IS
@nyg
nyg / iOSCreatePDF.swift
Last active April 2, 2024 11:09
iOS, Swift: Create a PDF file from an HTML string.
// Thanks to http://www.labs.saachitech.com/2012/10/23/pdf-generation-using-uiprintpagerenderer
// Note: including images in the HTML won't work, see here:
// https://github.com/nyg/HTMLWithImagesToPDF
import UIKit
// 1. Create a print formatter
let html = "<b>Hello <i>World!</i></b>"
let fmt = UIMarkupTextPrintFormatter(markupText: html)
@nyg
nyg / kraken-ledger.js
Created May 30, 2014 21:32
Get all entries of your Kraken.com ledger.
/* Querying your ledger through Kraken's API only return 50 results... */
var KrakenClient = require('kraken-api'); // https://github.com/nothingisdead/npm-kraken-api
var kraken = new KrakenClient('api_key', 'api_secret');
var ledger = [];
var offset = 0;
function getLedgerEntries (error, data) {