Python CasJobs.uploadCSVDataToTable Examples

Example #1

File: UnitTests.py Project: walterwsmf/SciScript-Python

    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

Example #2

File: Examples_SciScript-Python.py Project: parthadeka/SciScript-Python

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[ ]: