def test_CasJobs_uploadPandasDataFrameToTable_uploadCSVDataToTable(self): try: 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") result2 = CasJobs.executeQuery(sql="DROP TABLE " + CasJobs_TestTableName2, context="MyDB", format="csv") self.assertEqual(result, True) self.assertItemsEqual(table, df) result = CasJobs.uploadCSVDataToTable( csvData=CasJobs_TestTableCSV, tableName=CasJobs_TestTableName2, context="MyDB") df2 = CasJobs.executeQuery(sql="select * from " + CasJobs_TestTableName2, context="MyDB", format="pandas") result2 = CasJobs.executeQuery(sql="DROP TABLE " + CasJobs_TestTableName2, context="MyDB", format="csv") self.assertEqual(result, True) self.assertItemsEqual(df, df2) finally: try: csv = CasJobs.executeQuery(sql="DROP TABLE " + CasJobs_TestTableName2, context="MyDB", format="csv") except: pass
print(table) # In[ ]: # drop or delete table just created: result2 = CasJobs.executeQuery(sql="DROP TABLE " + CasJobs_TestTableName2, context=CasJobs_TestDatabase, format="pandas") print(result2) # In[ ]: #upload csv data string into a database table: result3 = CasJobs.uploadCSVDataToTable(csvData=CasJobs_TestTableCSV, tableName=CasJobs_TestTableName2, context="MyDB") df2 = CasJobs.executeQuery(sql="select * from " + CasJobs_TestTableName2, context="MyDB", format="pandas") print(result3) print(df2) # In[ ]: # drop or delete table just created: result4 = CasJobs.executeQuery(sql="DROP TABLE " + CasJobs_TestTableName2, context="MyDB", format="pandas") print(result4) # In[ ]: