Hello.py

import streamlit as st  
from streamlit_qrcode_scanner import qrcode_scanner  
import pyodbc

st.write("Please Scan Barcode of Pallet")
qr_code = qrcode_scanner(key='qrcode_scanner')  

if qr_code:  
  st.write(qr_code)
  st.table({qr_code : "1"})


# Initialize connection.
# Uses st.cache_resource to only run once.
@st.cache_resource
def init_connection():
    return pyodbc.connect(
        "DRIVER={ODBC Driver 17 for SQL Server};SERVER="
        + st.secrets["server"]
        + ";DATABASE="
        + st.secrets["database"]
        + ";UID="
        + st.secrets["username"]
        + ";PWD="
        + st.secrets["password"]
    )

conn = init_connection()

# Perform query.
# Uses st.cache_data to only rerun when the query changes or after 10 min.
@st.cache_data(ttl=600)
def run_query(query):
    with conn.cursor() as cur:
        cur.execute(query)
        return cur.fetchall()
rows = run_query("SELECT * from and_cvs;")

# Print results.
for row in rows:
    st.write(f"{row[0]} has a :{row[1]}:")