pmgreen

#!/usr/bin/env python
#-*- coding: utf-8 -*-
"""
Just get a csv report from the db that's populated by checky_urls.py
from 20150903
pmg
"""
import csv
import sqlite3 as lite

pmgreen

/* Relates to Ex Libris' Voyager ILS. Used in Toad for Oracle Freeware and SQL Developer (not MS Access) */
SELECT * FROM (
SELECT b.BIB_ID, m.MFHD_ID, m.LOCATION_ID, ROW_NUMBER()
OVER (
PARTITION BY m.LOCATION_ID ORDER BY m.LOCATION_ID
) SampleCount FROM BIB_TEXT b LEFT JOIN BIB_MFHD bm ON b.BIB_ID = bm.BIB_ID
LEFT JOIN MFHD_MASTER m ON bm.MFHD_ID = m.MFHD_ID
WHERE m.LOCATION_ID IN 
(
'1', '6', '7'