def clear_database():
print("deleting all links:", db.delete_all_links())
print("deleting all page data:", db.delete_all_page_data())
print("getting all images:", db.delete_all_images())
print("deleting all pages:", db.delete_all_pages())
print("deleting all sites:", db.delete_all_sites())
print("getting all sites:", db.get_all_sites())
print("getting all pages:", db.get_all_pages())
print("getting all images:", db.get_all_images())
print("getting all page data:", db.get_all_page_data())
print("getting_all_links:", db.get_all_links())
page1 = db.insert_page(site[0], PAGE_TYPE_CODES[0], "test.com/index.html", "html_content", "300", "040521")
print("inserted page:", page1)
page2 = db.insert_page(site[0], PAGE_TYPE_CODES[0], "test1.com/index.html", "html_content2", "303", "040522")
print("inserted page:", page2)
'''Insert image'''
image = db.insert_image(page1[0], "slika.jpg", "image/jpg", "asd", "040521")
print("inserted image:", image)
'''Insert page_data'''
page_data = db.insert_page_data(page2[0], DATA_TYPES[0], "asd")
print("page_data_id:", page_data)
'''Insert link'''
link = db.insert_link(page1[0], page2[0])
print("inserted link:", link)
print("getting all sites:", db.get_all_sites())
print("getting all pages:", db.get_all_pages())
print("getting all images:", db.get_all_images())
print("getting all page data:", db.get_all_page_data())
print("getting_all_links:", db.get_all_links())
print("deleting all links:", db.delete_all_links())
print("deleting all page data:", db.delete_all_page_data())
print("getting all images:", db.delete_all_images())
print("deleting all pages:", db.delete_all_pages())
print("deleting all sites:", db.delete_all_sites())