Skip to content

Instantly share code, notes, and snippets.

#toc h3 {margin: 16px 8px 16px 0px;}
#toc dt {margin: 3px; padding: 4px 0px; font-weight: normal;}
#toc dd {margin-top: 3px; margin-left: 16px; padding: 4px 0px;}
#toc dt a:link, #toc dd a:link {color: #333; text-decoration: none;}
#toc dt a:visited, #toc dd a:visited {color: #333; text-decoration: none;}
#toc dt a:active, #toc dd a:active {color: #679146;}
#toc dt a:hover, #toc dd a:hover {color: #679146;}
#toc h3 {margin: 16px 8px 16px 0px;}
#toc dt {margin: 3px; padding: 4px 0px; font-weight: normal;}
#toc dd {margin-top: 3px; margin-left: 16px; padding: 4px 0px;}
#toc dt a:link, #toc dd a:link {color: #333; text-decoration: none;}
#toc dt a:visited, #toc dd a:visited {color: #679146; text-decoration: none;}
#toc dt a:active, #toc dd a:active {color: #679146;}
#toc dt a:hover, #toc dd a:hover {color: #679146;}
CREATE DEFINER=`root`@`localhost` trigger processtrigger after INSERT ON digitization_process
for each row BEGIN
UPDATE item
SET
item.PhysicalState = (SELECT
NewPhysState
FROM
process_type p
WHERE
NEW.ProcessType = p.ProcessTypeID)
@jeffgerhard
jeffgerhard / md_render.py
Last active March 13, 2019 18:03
render markdown file (like README) in jupyter notebook
from markdown2 import markdown
from IPython.core.display import HTML
with open('README.md', 'r') as fh:
m = markdown(fh.read())
HTML(m)
@jeffgerhard
jeffgerhard / update.sh
Created April 16, 2019 19:59
git repo auto-updater
git checkout -- .
git clean -fd
git pull
@jeffgerhard
jeffgerhard / open_library_tsv_to_xml_for_alma.py
Last active July 31, 2019 11:51
Internet Archive / Open Library TSV file to XML for Alma import profile as portfolios
# -*- coding: utf-8 -*-
"""
Build XML file of all our books' data for lending
for the purposes of short-term management of our electronic lending
collection in Alma
"""
import os