PEATSA/WebApp/Data.py
def JobIDsInTable(dataTable, connection):

	'''Returns all the values of the JobID column from the given table in the database.'''

	cursor = connection.cursor()
	query = "SELECT JobID FROM %s" % (dataTable)
	cursor.execute(query)
	data = cursor.fetchall()
	cursor.close()
	
	if len(data) is not 0:
		return [element[0] for element in data]
	else:
		return None
Returns all the values of the JobID column from the given table in the database.
Returns all the values of the JobID column from the given table in the database.
Returns all the values of the JobID column from the given table in the database .
def JobIDsInTable(dataTable, connection):
	cursor = connection.cursor()
	query = "SELECT JobID FROM %s" % (dataTable)
	cursor.execute(query)
	data = cursor.fetchall()
	cursor.close()
	if len(data) is not 0:
		return [element[0] for element in data]
	else:
		return None
def JobIDsInTable ( dataTable , connection ) : cursor = connection . cursor ( ) query = "SELECT JobID FROM %s" % ( dataTable ) cursor . execute ( query ) data = cursor . fetchall ( ) cursor . close ( ) if len ( data ) is not 0 : return [ element [ 0 ] for element in data ] else : return None
Returns all the values of the JobID column from the given table in the database.
Returns all the values of the JobID column from the given table in the database .
'''Returns all the values of the JobID column from the given table in the database.'''
dataTable
connection