def lto_db_media_id_exists(domain, id, config):
media_id_exists_for_domain_qry = 'exists(/tape/tar/'+domain+'[@id="'+id+'"])'
xquery_result = ltoUtil.exec_url_xquery(config, ltoUtil.get_lto_url(config)+'/data', media_id_exists_for_domain_qry)
if ltoUtil.get_parsed_xquery_value(xquery_result) == ['true']:
return True
else:
return False
def db_device_code_exists(config, device_code):
device_exists_qry = 'exists(//deviceCode[@id="'+device_code+'"])'
xquery_result = ltoUtil.exec_url_xquery(config, ltoUtil.get_transcript_url(config)+'/reference', device_exists_qry)
if ltoUtil.get_parsed_xquery_value(xquery_result) == ['true']:
return True
else:
return False
def db_session_id_exists(config, session_id):
session_exists_qry = 'exists(/session[@id="'+session_id+'"])'
xquery_result = ltoUtil.exec_url_xquery(config, ltoUtil.get_transcript_url(config)+'/data', session_exists_qry)
if ltoUtil.get_parsed_xquery_value(xquery_result) == ['true']:
return True
else:
return False
def db_media_id_exists(domain, id, config):
media_id_exists_for_domain_qry = 'exists(/session//mediaMetadata//'+domain+'[@id="'+id+'"])'
xquery_result = ltoUtil.exec_url_xquery(config, ltoUtil.get_transcript_url(config)+'/data', media_id_exists_for_domain_qry)
if ltoUtil.get_parsed_xquery_value(xquery_result) == ['true']:
return True
else:
return False
def session_device_check(config, session_id, device_code):
if not ltoUtil.valid_chars(session_id):
print 'Invalid characters used in session id.'
print ltoUtil.get_script_name()+' script terminated.'
sys.exit(2)
if not ltoUtil.valid_chars(device_code):
print 'Invalid characters used in device_code.'
print ltoUtil.get_script_name()+' script terminated.'
sys.exit(2)
media_exists_for_session_device_qry = 'exists(/session[@id="'+session_id+'"]//device[@code="'+device_code+'"]/*)'
if not db_session_id_exists(config, session_id):
print 'session id: '+session_id+' does not yet exist.'
print ltoUtil.get_script_name()+' script terminated.'
sys.exit(2)
if not db_device_code_exists(config, device_code):
print 'device code: '+device_code+' does not exist.'
print ltoUtil.get_script_name()+' script terminated.'
sys.exit(2)
xquery_result = ltoUtil.exec_url_xquery(config, ltoUtil.get_transcript_url(config)+'/data', media_exists_for_session_device_qry)
if ltoUtil.get_parsed_xquery_value(xquery_result) == ['true']:
print 'At least one media item has already been associated with session: '+session_id+' and device: '+device_code
print
print 'To see the associated media items for this session open the following link in your browser:'
print 'http://'+ltoUtil.get_host_port(config)+ltoUtil.get_transcript_url(config)+'/data?_query=/session[@id="'+session_id+'"]//mediaMetadata'
print
cont = raw_input('Are you sure you want to continue? [y/n]: ')
if cont == 'y':
return
else:
print ltoUtil.get_script_name()+' script terminated.'
sys.exit(2)
def get_media_ids(config, session_ids, domain):
list = []
for s in session_ids:
if ltoTarUtil.db_session_id_exists(config, s):
media_ids_qry = '/session[@id="'+s+'"]//'+domain+'/xs:string(@id)'
xquery_result = ltoUtil.exec_url_xquery(config, ltoUtil.get_transcript_url(config)+'/data', media_ids_qry)
list.extend(ltoUtil.get_parsed_xquery_value(xquery_result))
else:
print s+' is not a recognised session id.'
print ltoUtil.get_script_name()+' script terminated.'
sys.exit(2)
return list