def setUp(cls):
        database.empty_database()
        athlete = Athlete(username='******', password='******', first_name='John', last_name='Doe', email='*****@*****.**', birth_date=None)
        database.session.add(athlete)
        database.session.commit()

        cherrypy.session['id'] = athlete.id
    def setUp(self):
        """Setup"""
        database.empty_database()
        # intialize the Athlete table with known values
        athlete = Athlete(
                "username",
                "password",
                "Test", 
                "Athlete", 
                "*****@*****.**", 
                datetime.strptime("20-12-2012", "%d-%m-%Y"), 
                "I'm a Test", 
                "test street", 
                "test avatar")
        database.session.add(athlete)

       
        database.session.commit()
        athlete = database.session.query(Athlete).first()

        newHealthRecord = Health(
            athlete.id, 
            datetime.strptime("21-12-2012", "%d-%m-%Y"), 
            100, 
            40, 
            "comment2")

        
        database.session.add(newHealthRecord)
        database.session.commit()

        self.test_athlete = athlete
        cherrypy.session['id'] = athlete.id
    def setUp(self):
	database.empty_database()
	    
	# intialize the Athlete table with known values
        database.session.add(
            Athlete(
                "username",
                "password",
                "Test", 
                "Athlete", 
                "*****@*****.**", 
                "1111-11-11", 
                "I'm a Test", 
                "test street", 
                "test avatar"))

        database.session.commit()
        self.test_athlete = Athlete.query.filter_by(first_name = "Test").first()
        
        # initialize the Activity table with known values
	for num in range(1, 4):
	
	    database.session.add(            
	        Activity(
	            self.test_athlete.id, 
	            "Run",
	            "1-1-1",                    
	            num * 10, 
	            num * 10, 
	            num * 10))
	
        database.session.commit()
    def setUp(self):
        database.empty_database()
        # intialize the Athlete table with known values
        athlete = Athlete(
                "username",
                "password",
                "Test", 
                "Athlete", 
                "*****@*****.**", 
                datetime.datetime.now(), 
                "I'm a Test", 
                "test street", 
                "test avatar")
        database.session.add(athlete)
        database.session.commit()

        self.test_athlete = athlete
        cherrypy.session['id'] = athlete.id

        # initialize the Activity table with known values
        for num in range(1, 4):

            database.session.add(            
                Activity(
                    self.test_athlete.id, 
                    "run",
                    datetime.date(num * 1000, num, num),                    
                    num * 10, 
                    num * 10, 
                    num * 10))

            database.session.add(            
                Activity(
                    self.test_athlete.id, 
                    "run",
                    datetime.date(num * 2000, num, num),                    
                    num * 10, 
                    num * 10, 
                    num * 10))

            database.session.add(
                Activity(
                    self.test_athlete.id, 
                    "run",
                    datetime.date(num * 3000, num, num),                    
                    num * 10, 
                    num * 10, 
                    num * 10))

        database.session.commit()
    def setUp(self):
        database.empty_database()
        session = database.session

        session.add(Athlete('john', 'password', 'John', 'Doe', '*****@*****.**'))
        session.commit()
        athlete_id = Athlete.query.first().id
        cherrypy.session['id'] = athlete_id

        session.add(Activity(athlete_id, "Bike", date(2013, 2, 8), 25, 50, 25))
        session.add(Activity(athlete_id, "Run", date(2013, 2, 9), 35, 20, 40))
        session.add(Activity(athlete_id, "Walk", date(2013, 2, 10), 72, 40, 10))
        session.add(Activity(athlete_id, "Walk", date(2013, 2, 11), 72, 40, 10))
        session.add(Activity(athlete_id, "Ak", date(2013, 2, 11), 65, 70, 52))

        session.commit()
    def test_update_datatable(self):
        #retrieves empty json from datatables method   
        database.empty_database()     
        the_json = self.activity.update_datatable()
        self.assertTrue(len(the_json['aaData']) == 0)


        self.setUp() 
        the_json = self.activity.update_datatable()
        self.assertTrue(len(the_json['aaData']) == 9)

        self.assertTrue(the_json['aaData'][0]['date']  == "1000-01-01")
        self.assertTrue(the_json['aaData'][0]['duration'] == 10)
        self.assertTrue(the_json['aaData'][0]['max_speed']    == 10)
        self.assertTrue(the_json['aaData'][0]['type']    == u'run')
        self.assertTrue(the_json['aaData'][0]['distance']    == 10)
    def setUp(self):
        database.empty_database()
        # intialize the Athlete table with known values
        athlete = Athlete(
                "username",
                "password",
                "Test", 
                "Athlete", 
                "*****@*****.**", 
                datetime.now(), 
                "I'm a Test", 
                "test street", 
                "test avatar")
        database.session.add(athlete)
        database.session.commit()

        cherrypy.session['id'] = athlete.id
	def setUp(self):
		database.empty_database()
 def setUp(self):
     database.empty_database()
     database.session.add(Athlete("username1", "password1", "test_first", "test_last", "*****@*****.**", datetime.now()))
     database.session.commit()
    def setUp(self):
        """
        This method is run before tests to provide setup
        """  
        stats_eng = StatisticsEngine() 

        database.empty_database()

        # intialize the Athlete table with known values
        athlete = Athlete(
                "username",
                "password",
                "Test", 
                "Athlete", 
                "*****@*****.**", 
                datetime.datetime.now(), 
                "I'm a Test", 
                "test street", 
                "test avatar")
        database.session.add(athlete)
        database.session.commit()

        self.test_athlete = athlete

        # initialize the Activity table with known values
        for num in range(1, 4):

            database.session.add(            
                Activity(
                    self.test_athlete.id, 
                    "run",
                    datetime.date(1111, num, num),                    
                    num * 10, 
                    num * 5, 
                    num * 10))

            database.session.add(            
                Activity(
                    self.test_athlete.id, 
                    "run",
                    datetime.date(2222, num, num),                    
                    num * 10, 
                    num * 5, 
                    num * 10))

            database.session.add(
                Activity(
                    self.test_athlete.id, 
                    "ride",
                    datetime.date(1111, num, num),                    
                    num * 10, 
                    num * 5, 
                    num * 10))

            database.session.add(
                Activity(
                    self.test_athlete.id, 
                    "ride",
                    datetime.date(2222, num, num),                    
                    num * 10, 
                    num * 5, 
                    num * 10))

        database.session.commit()