def test_CasJobs_writeFitsFileFromQuery(self): #CasJobs.getFitsFileFromQuery try: result = CasJobs.writeFitsFileFromQuery( fileName=CasJobs_TestFitsFile, queryString=CasJobs_TestQuery, context="MyDB") self.assertEqual(result, True) self.assertEqual(os.path.isfile(CasJobs_TestFitsFile), True) finally: try: os.remove(CasJobs_TestFitsFile) except: pass
# In[ ]: #cancel a job jobId = CasJobs.submitJob(sql=CasJobs_TestQuery, context=CasJobs_TestDatabase) jobDescription = CasJobs.cancelJob(jobId=jobId) print(jobId) print(jobDescription) # In[ ]: #execute a query and write a local Fits file containing the query results: result = CasJobs.writeFitsFileFromQuery(fileName=CasJobs_TestFitsFile, queryString=CasJobs_TestQuery, context="MyDB") print(result) # In[ ]: #delete local FITS file just created: os.remove(CasJobs_TestFitsFile) # In[ ]: #get a Pandas dataframe containing the results of a query df = CasJobs.getPandasDataFrameFromQuery(queryString=CasJobs_TestQuery, context=CasJobs_TestDatabase)