Sagiv Ofek sagivo

👨‍💻

coding

Founder at LIBLAB (we're hiring!) Previously - Facebook, AWS

sagivo / bulk-upsert-from-temporary-table.sql

Created April 18, 2016 19:05 — forked from seanbehan/bulk-upsert-from-temporary-table.sql

Perform an "upsert" from CSV file using Postgres copy command #sql #psql

	create temporary table temp (symbol varchar(255), open decimal, high decimal, low decimal, close decimal, volume varchar(255), date date );

	create table if not exists stocks (id serial primary key, symbol varchar(255), open decimal, high decimal, low decimal, close decimal, volume varchar(255), date date, created_at timestamp, updated_at timestamp);

	copy temp (symbol, date, open, high, low, close, volume) from '/path/to/file.csv' with delimiter ',' csv header;

	delete from stocks using temp where stocks.date = temp.date and stocks.symbol = temp.symbol;

	insert into stocks (symbol, open, high, low, close, volume, date) select symbol, open, high, low, close, volume, date from temp;

sagivo / byte-sizetuts.md

Last active August 29, 2015 14:14 — forked from honkskillet/byte-sizetuts.md

byte-size tuts

by alexander white ©

sagivo / byte-sizetuts.md

Created January 29, 2015 16:00 — forked from honkskillet/byte-sizetuts.md

addByReference fix

by alexander white ©

sagivo / encrypt_decrypt.js

Created November 4, 2013 19:02 — forked from csanz/encrypt_decrypt.js

	function encrypt(text){
	var cipher = crypto.createCipher('aes-256-cbc','d6F3Efeq')
	var crypted = cipher.update(text,'utf8','hex')
	crypted += cipher.final('hex');
	return crypted;
	}

	function decrypt(text){
	var decipher = crypto.createDecipher('aes-256-cbc','d6F3Efeq')
	var dec = decipher.update(text,'hex','utf8')