def test_CasJobs_getNumpyArrayFromQuery(self): #CasJobs.getNumpyArrayFromQuery array = CasJobs.getNumpyArrayFromQuery(queryString=CasJobs_TestQuery, context=CasJobs_TestDatabase) newArray = pandas.read_csv(StringIO(CasJobs_TestTableCSV), index_col=None).as_matrix() self.assertEqual(array.all(), newArray.all())
os.remove(CasJobs_TestFitsFile) # In[ ]: #get a Pandas dataframe containing the results of a query df = CasJobs.getPandasDataFrameFromQuery(queryString=CasJobs_TestQuery, context=CasJobs_TestDatabase) print(df) # In[ ]: # get numpy array containing the results of a query array = CasJobs.getNumpyArrayFromQuery(queryString=CasJobs_TestQuery, context=CasJobs_TestDatabase) print(array) # In[ ]: #uploads a Pandas dataframe into a Database table df = pandas.read_csv(StringIO(CasJobs_TestTableCSV), index_col=None) result = CasJobs.uploadPandasDataFrameToTable(dataFrame=df, tableName=CasJobs_TestTableName2, context="MyDB") table = CasJobs.executeQuery(sql="select * from " + CasJobs_TestTableName2, context="MyDB", format="pandas") print(result) print(table) # In[ ]: