Skip to content

Instantly share code, notes, and snippets.

@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
@jeffgerhard
jeffgerhard / update.sh
Created April 16, 2019 19:59
git repo auto-updater
git checkout -- .
git clean -fd
git pull
@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)
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)
#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;}
#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;}
@jeffgerhard
jeffgerhard / delete599s.py
Last active August 2, 2017 20:02
delete 599 and 910 fields from mrc records via pymarc
# delete 599 and 910 fields from a current directory full of individual mrc files
# (python 3 script)
# pymarc: https://github.com/edsu/pymarc
# help found at https://gist.github.com/symac/0133cae8846c134e849c and https://gist.github.com/EG5h/0ac510047f39e0cf930a
import os
import glob
import pymarc
errorlist = ""
path = os.path.dirname(os.path.abspath(__file__)) + '\\'
@jeffgerhard
jeffgerhard / fd2002_nooverlap_curved.png
Last active April 26, 2017 20:29
images for fd project
fd2002_nooverlap_curved.png
@jeffgerhard
jeffgerhard / compare_and_replace.py
Last active March 30, 2017 14:05
compare two directories and optionally replace one's content (i.e., from a backup)
'''
compare two directories recursively and optionally
replace directories' contents with the other
use case: replacing files from an old backup for
a cloned hard drive that has unpredictably corrupt files
'''
import os
# cleans up the downloaded, bagged masters
# and moves to archival storage
#
# could combine this with the IA download script?
#
# leaves behind a log file with the id's to plug them into the Access db
import os
import shutil
from tkinter.filedialog import askdirectory