Python CasJobs.getSchemaName Examples

Example #1

File: unittests.py Project: IoA-WideFieldSurveys/SciScript-Python

def testTurbulence():
    token=testTurbulenceToken()
    print("turbulence token = ",token)
    schemaName = CasJobs.getSchemaName(token)
    print("schemaname=",schemaName)

Example #2

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

 def test_CasJobs_getSchemaName(self):
     casJobsId = CasJobs.getSchemaName()
     self.assertNotEqual(casJobsId, "")

Example #3

File: unittests.py Project: IoA-WideFieldSurveys/SciScript-Python

def testCasJobsTables():
    schema= CasJobs.getSchemaName()
    print("schema=",schema)
    tables= CasJobs.getTables("MyDB")
    print(tables)

Example #4

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

#Defining databse context and query, and other variables

CasJobs_TestDatabase = "MyDB"
CasJobs_TestQuery = "select 4 as Column1, 5 as Column2 "
CasJobs_TestTableName1 = "MyNewtable1"
CasJobs_TestTableName2 = "MyNewtable2"
CasJobs_TestTableCSV = u"Column1,Column2\n4,5\n"
CasJobs_TestFitsFile = "SciScriptTestFile.fits"
CasJobs_TestCSVFile = "SciScriptTestFile.csv"


# In[ ]:

#get user schema info

casJobsId = CasJobs.getSchemaName()
print(casJobsId)


# In[ ]:

#get info about tables inside MyDB database context:

tables = CasJobs.getTables(context="MyDB")
print(tables)


# In[ ]:

#execute a quick SQL query: