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(table) # In[ ]: #list tables inside dataset tables = SkyQuery.listDatasetTables("MyDB") print(tables) # In[ ]: #get dataset table info: info = SkyQuery.getTableInfo(tableName="webuser." + SkyQuery_TestTableName, datasetName="MyDB") print(info) # In[ ]: #get dataset table columns info columns = SkyQuery.listTableColumns(tableName="webuser." + SkyQuery_TestTableName, datasetName="MyDB") print(columns) # In[ ]: #drop (or delete) table from dataset.