def test_SkyQuery_uploadTable_getTable_getTableInfo_listTableColumns_dropTable( self): try: result = SkyQuery.dropTable(tableName=SkyQuery_TestTableName, datasetName="MyDB") except: pass result = SkyQuery.uploadTable(uploadData=SkyQuery_TestTableCSV, tableName=SkyQuery_TestTableName, datasetName="MyDB", format="csv") self.assertEqual(result, True) table = SkyQuery.getTable(tableName=SkyQuery_TestTableName, datasetName="MyDB", top=10) self.assertEqual(SkyQuery_TestTableCSVdownloaded, table.to_csv(index=False)) info = SkyQuery.getTableInfo(tableName="webuser." + SkyQuery_TestTableName, datasetName="MyDB") columns = SkyQuery.listTableColumns(tableName="webuser." + SkyQuery_TestTableName, datasetName="MyDB") result = SkyQuery.dropTable(tableName=SkyQuery_TestTableName, datasetName="MyDB") self.assertEqual(result, True)
print(longJobsList) # In[ ]: #define csv table to be uploaded to into MyDB in SkyQuery SkyQuery_TestTableName = "TestTable_SciScript_R" SkyQuery_TestTableCSV = u"Column1,Column2\n4.5,5.5\n" # In[ ]: #uploading the csv table: result = SkyQuery.uploadTable(uploadData=SkyQuery_TestTableCSV, tableName=SkyQuery_TestTableName, datasetName="MyDB", format="csv") print(result) # In[ ]: #downloading table: table = SkyQuery.getTable(tableName=SkyQuery_TestTableName, datasetName="MyDB", top=10) print(table) # In[ ]: #list tables inside dataset