def create_views():
db = LocalSession()
queries = db.table_queries
queries = [
queries.create_view_notebooks.sql,
queries.create_view_desktops.sql,
]
for query in queries:
db.exec_query(query)
def drop_duplicates():
db = LocalSession()
queries = db.drop_duplicates_queries
queries = (
queries.drop_product_duplicates,
queries.drop_review_duplicates,
queries.drop_category_duplicates,
queries.drop_cpu_rating_duplicates,
queries.drop_gpu_rating_duplicates,
)
for query in queries:
db.exec_query(query.sql)
def drop_indexes():
db = LocalSession()
queries = db.drop_index_queries
queries = (
queries.drop_category_indexes,
queries.drop_product_indexes,
queries.drop_review_indexes,
queries.drop_specs_indexes,
queries.drop_cpu_rating_indexes,
queries.drop_gpu_rating_indexes,
)
for query in queries:
db.exec_query(query.sql)
