Sep Dehpour seperman

## full_upsert.py
def upsert(session, model, rows):
    table = model.__table__
    stmt = postgresql.insert(table)
    primary_keys = [key.name for key in inspect(table).primary_key]
    update_dict = {c.name: c for c in stmt.excluded if not c.primary_key}

    if not update_dict:
        raise ValueError("insert_or_update resulted in an empty update_dict")

    stmt = stmt.on_conflict_do_update(index_elements=primary_keys,

## sha1sum.html
<html>
    <!-- You may need to download them from https://github.com/brix/crypto-js/tree/release-3.1.2/build -->
    <script src="rollups/sha1.js"></script>
    <script src='components/lib-typedarrays-min.js'></script>
    <body>
    <script>
        function sha1sum() {
            var oFile = document.getElementById('uploadFile').files[0];
            var sha1 = CryptoJS.algo.SHA1.create();
            var read = 0;

## p4merge install
# p4merge for 64 bit
wget http://www.perforce.com/downloads/perforce/r13.4/bin.linux26x86_64/p4v.tgz

# p4merge for 32 bit
# wget http://www.perforce.com/downloads/perforce/r13.4/bin.linux26x86/p4v.tgz

tar zxvf p4v.tgz
sudo cp -r p4v-* /usr/local/p4v/
sudo ln -s /usr/local/p4v/bin/p4merge /usr/local/bin/p4merge

## nginx.conf
# to generate your dhparam.pem file, run in the terminal
openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048
	def upsert(session, model, rows):
	table = model.__table__
	stmt = postgresql.insert(table)
	primary_keys = [key.name for key in inspect(table).primary_key]
	update_dict = {c.name: c for c in stmt.excluded if not c.primary_key}

	if not update_dict:
	raise ValueError("insert_or_update resulted in an empty update_dict")

	stmt = stmt.on_conflict_do_update(index_elements=primary_keys,
	<html>
	<!-- You may need to download them from https://github.com/brix/crypto-js/tree/release-3.1.2/build -->
	<script src="rollups/sha1.js"></script>
	<script src='components/lib-typedarrays-min.js'></script>
	<body>
	<script>
	function sha1sum() {
	var oFile = document.getElementById('uploadFile').files[0];
	var sha1 = CryptoJS.algo.SHA1.create();
	var read = 0;
	# p4merge for 64 bit
	wget http://www.perforce.com/downloads/perforce/r13.4/bin.linux26x86_64/p4v.tgz

	# p4merge for 32 bit
	# wget http://www.perforce.com/downloads/perforce/r13.4/bin.linux26x86/p4v.tgz

	tar zxvf p4v.tgz
	sudo cp -r p4v-* /usr/local/p4v/
	sudo ln -s /usr/local/p4v/bin/p4merge /usr/local/bin/p4merge
	# to generate your dhparam.pem file, run in the terminal
	openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048