#! /usr/bin/env python
# 
# This file is released under the BSD licence.

__author__ = 'Greig A Cowan, Samuel C Skipsey'
__date__ = 'April 2009'
__version = 0.2


'''List physical files in a space token'''


import sys
import os
from optparse import OptionParser
import string
import getpass
import MySQLdb
import gridpp_dpm

def main():
	parser = OptionParser(
		usage = 'usage: %prog')
	parser.add_option('--st', dest='st',default='',
			help='Specify a space token description')
 

	(options, args) = parser.parse_args()
   
	if len(args) > 1:
		parser.error("incorrect number of arguments")
	
	(c,cc,dpmdb) = gridpp_dpm.MySQLConnect(True)

	try:
		cc.execute('''
 select Cns_file_replica.sfn from Cns_file_replica join %(dpm_db)s.dpm_space_reserv on %(dpm_db)s.dpm_space_reserv.s_token = Cns_file_replica.setname where %(dpm_db)s.dpm_space_reserv.u_token="%(st)s"''' % {"st": options.st, "dpm_db":dpmdb})

		results = cc.fetchall()
	except MySQLdb.Error, e:
		print "Error %d: %s" % (e.args[0], e.args[1])
		sys.exit (1)
	cc.close()
	c.close()
	for line in results:
		print line[0].tostring()

if __name__ == '__main__':
	main()
 
