Spaces:
Runtime error
Runtime error
| import streamlit as st | |
| import os.path | |
| import sqlite3 | |
| # Custom imports | |
| from pages.utils import db_connect | |
| def app(): | |
| '''delete form_submit to run quiz maker on return to page''' | |
| if "form_submit" in st.session_state.keys(): | |
| del st.session_state.form_submit | |
| if "form_upload" in st.session_state.keys(): | |
| del st.session_state.form_upload | |
| st.markdown("## View Data") | |
| BASE_DIR = os.path.dirname(os.path.abspath(__file__)) | |
| DATABASE = os.path.join(BASE_DIR, 'quiz_maker.db') | |
| c, conn = db_connect(DATABASE) | |
| size_query = "SELECT page_count * page_size as size FROM pragma_page_count(), pragma_page_size()" | |
| c.execute(size_query) | |
| st.markdown(f'##### Database size: {int(c.fetchone()[0] / 1000)} KB') | |
| query = st.text_input("Query", placeholder="Type query here") | |
| if len(query) > 1: | |
| try: | |
| for idx, item in enumerate(c.execute(query)): | |
| st.write(f'{idx}: {item}') | |
| except Exception as e: | |
| st.write("Query failed. " + str(e).capitalize()) | |