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 / 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
@jeffgerhard
jeffgerhard / bagit_script_for_current_directory.bat
Created August 2, 2016 15:41
batch script to bag-in-place all the subdirectories of the current directory, and list the file ids
REM first make a list of the directories
for /d %%A in (*) do echo %%~A>>temp.txt
REM then send each directory to bagit to baginplace
forfiles /C "cmd /c if @isdir==TRUE cd /d C:\bagit-4.9.0\bin\ & bag baginplace @path --payloadmanifestalgorithm sha1 --tagmanifestalgorithm sha1 --version 0.97 --verbose & move /-y @path Z:\archival_master_files\books\general_collection"
REM oh and then edit the files list to drop the "master" part
REM this find/replace code via https://social.technet.microsoft.com/Forums/scriptcenter/en-US/57bd676c-e5c3-4829-bdbf-6addea238bf0/find-and-replace-string-in-a-file-using-batch-script?forum=ITCG
@echo off
set "textfile=temp.txt"
set "newfile=filelist.txt"
set Scr="%temp%\TempVBS.vbs"