Octavian Nita octavian-nita

Meandering through code since MM

octavian-nita / create-db.my.sql

Last active August 29, 2015 14:01

Create MySQL database and user and grant rights (precedes many tool installations like WordPress, Koken, etc.)

	CREATE DATABASE IF NOT EXISTS kabuki DEFAULT CHARACTER SET = 'utf8' DEFAULT COLLATE 'utf8_general_ci';

	GRANT USAGE ON . TO 'koken'@'localhost' IDENTIFIED BY 'Midori1981';

	GRANT ALL PRIVILEGES ON kabuki.* TO 'koken'@'localhost';

	FLUSH PRIVILEGES;

octavian-nita / fisher-yates.sql

Created August 6, 2014 08:59

The Fisher-Yates shuffle in PL/SQL

octavian-nita / spell-number.sql

Created August 6, 2014 09:05

Spelling numbers in PL/SQL

	CREATE OR REPLACE FUNCTION spell_number(p_number IN NUMBER)
	RETURN VARCHAR2 AS
	TYPE myarray IS TABLE OF VARCHAR2(255);

	l_str myarray := myarray(
	'',
	' thousand ',
	' million ',
	' billion ',
	' trillion ',

octavian-nita / backup.groovy

Last active March 31, 2018 00:07

Back up a directory to your email (+ nice utility to detect the code base of a class)

	#!/usr/bin/env groovy

	import javax.activation.*
	import javax.mail.*
	import javax.mail.internet.*

	@Grapes ([
	@Grab (group = 'javax.activation', module = 'activation', version = '1.1.1'),
	@Grab (group = 'javax.mail', module = 'mail', version = '1.4.5')
	])

octavian-nita / index.xhtml

Created August 6, 2014 09:38

XHTML 1.0 strict template [deprecated]

	<?xml version="1.0" encoding="UTF-8"?>
	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
	<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">

	<head>

	<meta http-equiv="content-type" content="text/html; charset=utf-8" />
	<title>An XHTML 1.0 Strict document</title>

	<style type="text/css">

octavian-nita / index4.html

Last active August 29, 2015 14:04

HTML 4.01 strict template [deprecated]

	<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
	<html>

	<head>
	<meta http-equiv="content-type" content="text/html; charset=utf-8" />
	<title>An HTML 4.01 Strict document</title>
	</head>

	<body>
	<p>... The document content goes here ...</p>

octavian-nita / NoCacheServlet.java

Last active April 5, 2017 15:02

Disable browser caching for servlet response; http://stackoverflow.com/questions/49547/making-sure-a-web-page-is-not-cached-across-all-browsers

	// ...

	response.setContentType("text/plain");
	response.setCharacterEncoding("UTF-8");
	response.setContentLength(tx.length());

	response.setStatus(HttpStatus.OK.value());

	response.setHeader("Access-Control-Allow-Origin", "*");

octavian-nita / header.php

Created August 6, 2014 09:48

HTML-enabled site description in WordPress

	<!-- header.php -->
	<!-- h2 class="site-description"><?php bloginfo( 'description' ); ?></h2 -->
	<h2 class="site-description"><?php echo html_entity_decode(get_bloginfo('description')); ?></h2>

octavian-nita / Logging.java

Created August 6, 2014 09:50

java.util.logging basic setup

	private static final Logger LOG = Logger.getLogger(MyClass.class.getName());

	static {
	Logger rootLogger = Logger.getLogger("");
	rootLogger.setLevel(Level.INFO);
	rootLogger.addHandler(new ConsoleHandler());

	Handler fileHandler; // set up a file handler as well...
	try {
	fileHandler = new FileHandler("file.log"); // a file in the current working directory

octavian-nita / visible-ip.js

Created August 22, 2014 09:48

Callback on getting the current visible IP address in Node.js, using basic proxy authorization

	'use strict';

	var ip;

	function visibleIp(callback) {

	if (ip \|\| (ip = process.env['VISIBLE_IP'])) {
	return process.nextTick(function() { callback(null, ip); });
	}