Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
# -*- coding: utf-8 -*-
import SQLPandasTools as cut
import unittest
import pickle
class Testapi(unittest.TestCase):
def testSqlToGeoPandas(self):
with open("./pickle/fetchall.pickle", "rb") as pickleFile:
sqlResult = pickle.load(pickleFile)
stationList = cut.sqlToGeoPandas(sqlResult)
self.assertEqual(stationList['2012'].dtype, 'float64')
self.assertEqual(stationList['1992'].dtype, 'float64')
def testDetermineAnnualMean(self):
with open("./pickle/fetchall.pickle", "rb") as pickleFile:
sqlResult = pickle.load(pickleFile)
stationList = cut.sqlToGeoPandas(sqlResult)
annualMean = cut.determineAnnualMean(stationList)
self.assertEqual(annualMean["2000"].dtype, "float64")
self.assertTrue(annualMean["2000"]>=2)
self.assertEqual(annualMean["1992"].dtype, "float64")
self.assertTrue(annualMean["1992"]>=2)
def testDetermineAnnualMeanWithList(self):
with open("./pickle/fetchall.pickle", "rb") as pickleFile:
stationList = pickle.load(pickleFile)
annualMean = cut.determineAnnualMean(stationList)
self.assertEqual(annualMean["2000"].dtype, "float64")
self.assertTrue(annualMean["2000"]>=2)
self.assertEqual(annualMean["1992"].dtype, "float64")
self.assertTrue(annualMean["1992"]>=2)
if __name__ == '__main__':
unittest.main()