<commit_before>var pg = require('pg');

pg.connect(process.env.DATABASE_URL, function(err, client) {
	if (err) {
		return;
	}

	client.query("CREATE TABLE IF NOT EXISTS subscriptions(email varchar(64), repourl varchar(64))");
	client.query("CREATE TABLE IF NOT EXISTS packages(name varchar(64), version varchar(16), updated DATE)");
	client.query("INSERT INTO subscriptions(email, repourl) values('<EMAIL>', 'https://github.com/seriema/npmalerts.git')");
});


// client.query("INSERT INTO emps(firstname, lastname) values($1, $2)", ['Ronald', 'McDonald']);
// client.query("INSERT INTO emps(firstname, lastname) values($1, $2)", ['Mayor', 'McCheese']);

CREATE TABLE IF NOT EXISTS subscriptions(email varchar(64), repourl varchar(64))
CREATE TABLE IF NOT EXISTS packages(name varchar(64), version varchar(16), updated DATE)

INSERT INTO subscriptions(email, repourl) values('<EMAIL>', 'https://github.com/seriema/npmalerts.git')<commit_msg>Update create_db.js although it's not really used<commit_after>var pg = require('pg');

pg.connect(process.env.DATABASE_URL, function(err, client) {
	if (err) {
		return;
	}

	client.query("CREATE TABLE IF NOT EXISTS subscriptions(email varchar(64), repourl varchar(64))");
	client.query("CREATE TABLE IF NOT EXISTS packages(name varchar(64), version varchar(16), updated DATE)");
	client.query("INSERT INTO subscriptions(email, repourl) values('<EMAIL>', 'https://github.com/seriema/npmalerts.git')");
});
{'fraction_non_alphanumeric': 0.165860400829302, 'fraction_numerical': 0.019350380096751902, 'mean_word_length': 6.702127659574468, 'pattern_counts': {'":': 0, '<': 6, '<?xml version=': 0, '>': 6, 'https://': 3, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6152696', 'n_tokens_mistral': 504, 'n_tokens_neox': 460, 'n_words': 117}