Alexis Seigneurin aseigneurin

Data Engineer

aseigneurin / app.js

Created November 26, 2013 17:19

Read JSON from a REST API, turn that into SQL requests, execute the SQL request against a SQL Server DB.

	var fs = require('fs');
	var http = require('http');
	var nodemailer = require('nodemailer');

	var dbServer = '...';
	var dbName = '...';
	var dbUser = '...';
	var dbpassword = '...';
	var smtpHost = '...';
	var mailFrom = '...';

aseigneurin / git-split.sh

Last active December 28, 2015 16:48

	#!/bin/bash
	if [ "$#" -ne 4 ]; then
	echo "Usage: $0 SOURCE_REPO SOURCE_MODULE TARGET_REPO TARGET_MODULE" >&2
	echo "Example: $0 git@...:src_repo src_module git@...:target_repo target_module" >&2
	exit 1
	fi

	SOURCE_REPO=$1
	SOURCE_MODULE=$2
	TARGET_REPO=$3

aseigneurin / parse.js

Created November 18, 2013 09:53

Parse a JSON file and output a SQL script with Node.js.

	var fs = require('fs');

	var data = fs.readFileSync(process.argv[2], {
	encoding: 'ascii'
	});
	var json = JSON.parse(data);

	for (var list in json) {
	var devices = json[list];
	for (var i = 0; i < devices.length; i++) {