query = """
        SELECT cp.parent_id, cp.name, cp.url, id as child_id FROM cat_parents as cp
         LEFT JOIN categories as c on cp.parent_id = c.parent_id
         WHERE id is null
        ; """
cur.execute(query)
cat=cur.fetchall()

def parse(url):
    try:
        response = requests.get(url).text
        response = BeautifulSoup(response, "html.parser")
        return response
    except Exception as err:
        print(f'ERROR: {err}')
        return ''


def crawl_sub_categories(category, save_db=False):
    name = category.name
    url = category.url
    sub_categories = []

    try:
        div_containers = parse(url).find_all(
            'div', attrs={"class": "list-group-item is-child"})
        for div in div_containers:
            sub_id = None
            sub_name = div.a.text
            sub_url = 'https://tiki.vn' + div.a.get('href')
            sub_parent_id = category.cat_id

            cat = Category(sub_id, sub_name, sub_url, sub_parent_id)
            if save_db:
                cat.save_into_db()
            if cat.cat_id is not None:
                sub_categories.append(cat)
    except Exception as err:
        print(f'ERROR: {err}')

    return sub_categories

# from app.py
@app.route('/', methods=['GET', 'POST'])
def index():
    form = SearchForm()
    if form.validate_on_submit():
        productsToShow = products.get_search_products(form.search.data)
    else:
        productsToShow = products.get_products()

# from product.py
def get_search_products(search):
    cursor.execute("SELECT * FROM products WHERE title LIKE  '%" +
                   str(search) + "%' LIMIT 9")
    products = cursor.fetchall()
    return products