Dalet 5.1e - Get Titles in Class

gistfile1.txt

import sys
import pypyodbc 
import json
import io
import time

SybaseConnectionString = 'DSN=DSN_NAME;UID=USERNAME;Pwd=PASSWORD;'
dbConn = pypyodbc.connect(SybaseConnectionString)
cur = dbConn.cursor()

def Dalet51_getTitlesInClass(classId):
	classSearchQuery = '''SELECT titles.title_id, titles.title, soundfiles.soundfile_name, dab_rds.value
	FROM titles_in_class, titles, soundfiles, dab_rds
	WHERE titles_in_class.class_id = ?
	AND titles_in_class.title_id = titles.title_id
	AND titles.soundfile_id = soundfiles.soundfile_id
	AND titles.title_id *= dab_rds.title_id
	AND dab_rds.dabrds_no = 2
	ORDER BY titles.title_id DESC'''

	cur.execute(classSearchQuery, [classId])
	
	titles = dict()
	count = 0;
	
	for d in cur:
		titles[count] = dict()
		titles[count]['title_id'] = d[0]
		titles[count]['title'] = d[1]
		titles[count]['soundfile'] = d[2]
		titles[count]['outputName'] = d[3]
		count = count + 1
		
	return titles
		
if __name__ == "__main__":
	print Dalet51_getTitlesInClass(1124)