Skip to content

Instantly share code, notes, and snippets.

View rayvoelker's full-sized avatar

Ray Voelker rayvoelker

22 followers · 16 following
View GitHub Profile
@rayvoelker
rayvoelker / locCallClass.html
Created September 5, 2016 19:10
javascript class for parsing, comparing and sorting library of congress call numbers
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>locCallClass test sorting of call numbers</title>
<script type="text/javascript" src="./locCallClass.js"></script>
</head>
<body style="font-family:monospace;">
@rayvoelker
rayvoelker / duplicate_control_tags.sql
Created September 21, 2016 14:11
SELECT
-- put your url prefix here
'http://flyers.udayton.edu/record=' || id2reckey(record_id) || 'a' AS link,
id2reckey(record_id) || 'a' as bib_record_num,
index_entry as control_number
FROM
sierra_view.phrase_entry
WHERE
@rayvoelker
rayvoelker / duplicate_non-repeating_tags.sql
Created September 21, 2016 15:26
SELECT
'b' || r.record_num || 'a' as bib_record_num,
v.marc_tag,
count(*) as count
FROM
sierra_view.record_metadata as r
JOIN
sierra_view.varfield as v
@rayvoelker
rayvoelker / barcode_to_record_nums.sql
Created September 23, 2016 15:59
SELECT
e.index_entry as barcode,
'i' || i.record_num || 'a' AS item_record_num,
i.record_num as item_num,
'b' || b.record_num || 'a' as bib_record_num,
b.record_num as bib_num,
i.creation_date_gmt as item_creation_date,
i.deletion_date_gmt as item_deletion_date,
b.creation_date_gmt as bib_creation_date,
@rayvoelker
rayvoelker / match_isbn_to_volume.sql
Last active October 11, 2016 15:04
SELECT
r.record_num as bib_num,
s.content as marc_020,
v.field_content as vol
FROM
sierra_view.record_metadata as r
-- if we want to get best_title, we can select p.best_title and uncomment below
-- JOIN
@rayvoelker
rayvoelker / get_patron_data_from_email.sql
Created October 17, 2016 17:46
SELECT
'p' || r.record_num || 'a' as patron_record_num,
v.field_content,
b.index_entry as barcode,
n.index_entry as patron_name_norm
FROM
sierra_view.record_metadata as r
JOIN
@rayvoelker
rayvoelker / get_patrons_with_no_email.sql
Created October 19, 2016 14:38
-- get patron's with no e-mail info
-- (some of which have some odd things going on in the barcode field)
SELECT
'p' || r.record_num || 'a' AS patron,
b.index_entry as barcode,
r.creation_date_gmt as creation_date,
r.record_last_updated_gmt as record_last_updated,
r.previous_last_updated_gmt as previous_last_updated,
v.field_content as patron_email
@rayvoelker
rayvoelker / get_patron_records_by_last_updated_date.sql
Last active October 25, 2016 15:00
SELECT
'p' || r.record_num || 'a' as patron_record_num
-- ,*
FROM
sierra_view.record_metadata as r
WHERE
r.record_type_code = 'p'
AND r.campus_code = ''
@rayvoelker
rayvoelker / get_call_numbers_and_norms.sql
Created October 25, 2016 20:04
SELECT
e.record_id, e.index_entry, v.field_content
FROM
sierra_view.phrase_entry as e
JOIN
sierra_view.varfield as v
ON
(v.record_id = e.record_id) AND (v.varfield_type_code = 'c')
@rayvoelker
rayvoelker / rifftrax_sync.md
Last active February 26, 2023 09:47

How To Sync Your Movie to the Professional Jokes By Professional Comedy Professionals (AKA RiffTrax)

Intro

This guide started off as a sort of checklist for myself to try to refine, and speed up the process. I'm sure that there are a good number of things that can be improved upon, but in my opinion, the steps below produce pretty consistently good results. Hopefully this will help