if __name__ == '__main__':
    workbook = xlrd.open_workbook('Server_PaypalInfo.xlsx')
    sheet = workbook.sheet_by_index(0)
    Hostname = sheet.cell_value(1, 2)
    DbUsername = sheet.cell_value(1, 3)
    DBPassword = sheet.cell_value(1, 4)
    Databasename = sheet.cell_value(1, 5)
    PreviousOrdersLink = []
    driver = webdriver.Chrome('chromedriver.exe')
    driver.maximize_window()
    print('\t\t\t------------------------------')
    print('\t\t\t  Connecting to the Database  ')
    print('\t\t\t------------------------------')
    Connection = pymysql.connect(host=str(Hostname), user=str(DbUsername), passwd=str(DBPassword),
                                 db=str(Databasename))
    Cursor = Connection.cursor()
    # This Query Will Execute at once then it will be run everytime fro getting new orders
    Cursor.execute("SELECT id FROM orders")
    for L in Cursor.fetchall():
        PreviousOrdersLink.append(L[0])
    pass
    # Now Run Query After Every Seconds to collect the new orders and SKip the Previous Orders
    BotLife = True
    while BotLife is not False:
        print('\t\t\t  Checking New ORDERS...  ')
        Connection = pymysql.connect(host=str(Hostname), user=str(DbUsername), passwd=str(DBPassword),
                                     db=str(Databasename))
        Cursor = Connection.cursor()
        NewOrdersLinks = []
        NewOrderQuantity = []
        NewOrdersGender = []
        NewOrdersCountry = []
        NewOrdersId = []
        try:
            Cursor.execute("SELECT id FROM orders")
            for L in Cursor.fetchall():
                if L[0] not in PreviousOrdersLink:
                    Cursor.execute("SELECT id,link,quantity,text_1,text_2,package_id,status FROM orders where id=%s",
                                   (str(L[0])))

                    for i, l, q, g, c, p, s in Cursor.fetchall():
                        if int(p) == 266 and s.__contains__('PENDING'):
                            NewOrdersLinks.append(l)
                            NewOrderQuantity.append(q)
                            NewOrdersGender.append(g)
                            NewOrdersCountry.append(c)
                            NewOrdersId.append(i)
                            PreviousOrdersLink.append(i)
                        pass
                    pass
                pass
            pass
            if len(NewOrdersLinks) > 0:
                MakeOrdersStrom(NewOrdersLinks, NewOrderQuantity, NewOrdersCountry, NewOrdersGender, NewOrdersId)
            pass
        except Exception as E:
            BotLife = False
            print(E)
        pass
        time.sleep(random.randint(3, 5))
        cls()
    pass
    pass