ylabel='Percent of Aussie Population', y2label='Percent of USA Population', xcol=1, ycolL=[2, 3, 4], showMarkerL=[ 0, ], lineStyleL=[ 1, ], lineThkL=[ 2, ], colorL=['r', 'g', 'b']) mySprSht.add_curve('Combo2_Plot', 'USA_Data', xcol=1, ycol2L=[2, 3, 4], showMarker2L=[ 0, ], lineThk2L=[ 2, ], color2L=['r', 'g', 'b']) mySprSht.setYrange(ymin=0, ymax=80, plot_sheetname=None) mySprSht.setY2range(ymin=0, ymax=80, plot_sheetname=None) mySprSht.save(filename='bmi_index.ods', launch=True)
class MyTest(unittest.TestCase): def setUp(self): unittest.TestCase.setUp(self) self.mySprSht = SpreadSheet() def tearDown(self): unittest.TestCase.tearDown(self) del (self.mySprSht) def test_should_always_pass_cleanly(self): """Should always pass cleanly.""" pass def test_myclass_existence(self): """Check that myclass exists""" result = self.mySprSht # See if the self.mySprSht object exists self.assertTrue(result) def test_save(self): """Check that save operates cleanly""" list_of_rows = ALT_DATA self.mySprSht.add_sheet('Alt_Data', list_of_rows) self.mySprSht.add_scatter( 'Alt_Plot', 'Alt_Data', title='Unittest Title', xlabel='Unittest X Axis', ylabel='Unittest Y Axis', y2label='Unittest Y2 Axis', xcol=1, ycolL=[2, 3, 4], ycol2L=None, showMarkerL=[1, 1, 1], showMarker2L=None, lineThkL=["0.1in", "0.01in"], lineStyleL=[1, 2, 3], colorL=None, #['cyan','GRaY','#69a'], #['#666666'], labelL=None, label2L=None) self.mySprSht.setXrange(-10000, 70000, plot_sheetname=None) self.mySprSht.setYrange(-100, 700) #self.mySprSht.add_scatter( 'Alt_Plot2', 'Alt_Data') #self.mySprSht.add_scatter( 'Alt_Plot3', 'Alt_Data') self.mySprSht.save(filename=os.path.join(here, 'alt')) def test_save_secondary_y(self): """Check that save operates for a second y axis""" list_of_rows = ALT_DATA_WIDE self.mySprSht.add_sheet('Alt_Data', list_of_rows) self.mySprSht.add_scatter( 'Alt_Plot', 'Alt_Data', title='Unittest Title', xlabel='Unittest X Axis', ylabel='Unittest Y Axis', y2label='Unittest Y2 Axis', xcol=1, ycolL=[2, 5, 6], ycol2L=[3, 4], lineThkL=[1, 2, 3], lineThk2L=[3.5, 1.5], lineStyle2L=[4, 5], showMarkerL=[1, 1, 1], showMarker2L=None, showLineL=[0, 1, 0], showLine2L=[1, 1], #colorL=['r','g','b'], excel_colors=False, color2L=['c','dc'], labelL=None, label2L=None) self.mySprSht.setY2range(50, 550) self.mySprSht.save(filename=os.path.join(here, 'alt_y2')) def test_logx_save(self): """Check that save operates cleanly""" list_of_rows = ALT_DATA self.mySprSht.add_sheet('Alt_Data', list_of_rows) self.mySprSht.add_scatter('Alt_Plot', 'Alt_Data', title='Unittest Title', xlabel='Unittest X Axis', ylabel='Unittest Y Axis', y2label='Unittest Y2 Axis', xcol=1, logx=True, ycolL=[3, 4], ycol2L=None, showMarkerL=[1, 1, 1], showMarker2L=None, colorL=None, labelL=None, label2L=None) self.mySprSht.save(filename=os.path.join(here, 'alt_logx')) def test_logy_save(self): """Check that save operates cleanly""" list_of_rows = ALT_DATA self.mySprSht.add_sheet('Alt_Data', list_of_rows) self.mySprSht.add_scatter('Alt_Plot', 'Alt_Data', title='Unittest Title', xlabel='Unittest X Axis', ylabel='Unittest Y Axis', y2label='Unittest Y2 Axis', xcol=1, logy=True, ycolL=[3, 4], ycol2L=None, showMarkerL=[1, 1, 1], showMarker2L=None, colorL=None, labelL=None, label2L=None) self.mySprSht.save(filename=os.path.join(here, 'alt_logy')) def test_log2y_save(self): """Check that save operates for a second y axis""" list_of_rows = ALT_DATA_WIDE self.mySprSht.add_sheet('Alt_Data', list_of_rows) self.mySprSht.add_scatter('Alt_Plot', 'Alt_Data', title='Unittest Title', xlabel='Unittest X Axis', ylabel='Unittest Y Axis', y2label='Unittest Y2 Axis', xcol=1, log2y=True, ycolL=[2, 5, 6], ycol2L=[3, 4], showMarkerL=[1, 1, 1], showMarker2L=None, colorL=None, labelL=None, label2L=None) self.mySprSht.save(filename=os.path.join(here, 'alt_log2y')) def test_all_log_save(self): """Check that save operates for a second y axis""" list_of_rows = ALT_DATA_WIDE self.mySprSht.add_sheet('Alt_Data', list_of_rows) self.mySprSht.add_scatter('Alt_Plot', 'Alt_Data', title='Unittest Title', xlabel='Unittest X Axis', ylabel='Unittest Y Axis', y2label='Unittest Y2 Axis', xcol=1, log2y=True, logx=True, logy=True, ycolL=[2, 5, 6], ycol2L=[3, 4], showMarkerL=[1, 1, 1], showMarker2L=None, colorL=None, labelL=None, label2L=None) self.mySprSht.save(filename=os.path.join(here, 'alt_all_log'))
mySprSht.add_curve('Combo_Plot', 'Aussie_Data', xcol=1, ycolL=[2,3,4], showMarkerL=[0,], lineStyleL=[1,], lineThkL=[2,], colorL=['r','g','b']) mySprSht.add_scatter( 'Combo2_Plot', 'Aussie_Data', title='Australian and USA BMI', xlabel='Year', ylabel='Percent of Aussie Population', y2label='Percent of USA Population', xcol=1, ycolL=[2,3,4], showMarkerL=[0,], lineStyleL=[1,], lineThkL=[2,], colorL=['r','g','b']) mySprSht.add_curve('Combo2_Plot', 'USA_Data', xcol=1, ycol2L=[2,3,4], showMarker2L=[0,], lineThk2L=[2,], color2L=['r','g','b']) mySprSht.setYrange( ymin=0, ymax=80, plot_sheetname=None) mySprSht.setY2range( ymin=0, ymax=80, plot_sheetname=None) mySprSht.save( filename='bmi_index.ods', launch=True )