Python FTSFile.tableDesc示例

示例#1

文件： FTSDB.py 项目： vingar/DIRAC

 def _getFTSFileProperties(self, ftsFileID, columnNames=None):
     """ select :columnNames: from FTSJobFile table  """
     columnNames = columnNames if columnNames else FTSFile.tableDesc(
     )["Fields"].keys()
     columnNames = ",".join(
         ['`%s`' % str(columnName) for columnName in columnNames])
     return "SELECT %s FROM `FTSFile` WHERE `FTSFileID` = %s;" % (
         columnNames, int(ftsFileID))

示例#2

文件： FTSDB.py 项目： DIRACGrid/DIRAC

 def _getFTSFileProperties( self, ftsFileID, columnNames = None ):
   """ select :columnNames: from FTSJobFile table  """
   columnNames = columnNames if columnNames else FTSFile.tableDesc()["Fields"].keys()
   columnNames = ",".join( [ '`%s`' % str( columnName ) for columnName in columnNames ] )
   return "SELECT %s FROM `FTSFile` WHERE `FTSFileID` = %s;" % ( columnNames, int( ftsFileID ) )