class TestHubSpot(BaseTest):

    logger = LogGen.logGen()

    @pytest.mark.parametrize("username, password",
                             [("*****@*****.**", "admin123"),
                              ("*****@*****.**", "Calgary_88")])
    def test_login(self, username, password):
        self.logger.info(
            "***********Verify Data Parameterization | Screenshot Capture***************"
        )
        self.logger.info(
            "***********Verify Config Property| Log Generation***************")
        #self.driver.get("https://app.hubspot.com/login")
        self.driver.get(ReadConfig.baseUrl()
                        )  #Reading data from config file using config.ini file
        self.logger.info("***********Launching the URL***************")
        self.driver.implicitly_wait(10)
        self.driver.find_element(By.ID, 'username').send_keys(username)
        self.logger.info("***********Entering Username***************")
        time.sleep(1)
        self.driver.find_element(By.ID, 'password').send_keys(password)
        self.logger.info("***********Entering Password***************")
        time.sleep(1)
        self.driver.find_element(By.ID, 'loginBtn').click()
        self.logger.info("***********Clicking on Login Button***************")
        time.sleep(1)
        x = datetime.datetime.now()
        hms = x.strftime("%H_%M_%S")
        self.driver.save_screenshot("../../../Screenshots/test_login_" +
                                    str(hms) + ".png")
        self.logger.info("***********Generating Screenshot***************")
class TestHubSpot(BaseTest):

    logger = LogGen.logGen()
    #Excel File Path
    path = "TestData/LoginData.xlsx"

    #@pytest.mark.parametrize("username, password",
    #                        [
    #                             ("*****@*****.**","admin123"),
    #                            ("*****@*****.**","Calgary_88")
    #                       ])
    @pytest.mark.datadriven
    def test_login(self):
        self.logger.info("***********Verify Data Driven Excel | Screenshot Capture***************")
        self.logger.info("***********Verify Config Property| Log Generation***************")
        #self.driver.get("https://app.hubspot.com/login")
        self.driver.get(ReadConfig.baseUrl())  #Reading data from config file using config.ini file
        self.logger.info("***********Launching the URL***************")
        self.driver.implicitly_wait(10)


        #Get Data from Excel File
        self.rows = excelUtils.getRowCount(self.path,'Sheet1')
        self.columns = excelUtils.getColumnCount(self.path,'Sheet1')

        for row in range(2,self.rows+1):
            self.userName =excelUtils.readData(self.path,'Sheet1',row ,1)
            self.passWord = excelUtils.readData(self.path, 'Sheet1',row , 2)

        #Using Data read from Excel File
            time.sleep(2)
            self.driver.find_element(By.ID, 'username').clear()
            self.driver.find_element(By.ID,'username').send_keys(self.userName)
            self.logger.info("***********Entering Username***************")

            self.driver.find_element(By.ID, 'password').clear()
            time.sleep(1)
            self.driver.find_element(By.ID, 'password').send_keys(self.passWord)
            self.logger.info("***********Entering Password***************")
            time.sleep(1)
            self.driver.find_element(By.ID, 'loginBtn').click()
            self.logger.info("***********Clicking on Login Button***************")
            time.sleep(1)

            x = datetime.datetime.now()
            hms = x.strftime("%H_%M_%S")
            self.driver.save_screenshot("Screenshots/test_login_"+str(hms)+".png")
            self.logger.info("***********Generating Screenshot***************")