View 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, |
View 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; |
View 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 |
View nginx.conf
# to generate your dhparam.pem file, run in the terminal | |
openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048 |