#!/usr/bin/env python3 import pyodbc import os import json import getpass # --------------------------------------------------------- # CONFIGURATION # --------------------------------------------------------- SERVER = r"BRAVO\SQLEXPRESS01" DATABASE = "cresql" HTML_OUTPUT = r"C:\Temp\pcAmerica\HTML\tables.html" CONN_STR = ( "DRIVER={ODBC Driver 17 for SQL Server};" f"SERVER={SERVER};" f"DATABASE={DATABASE};" "Trusted_Connection=yes;" ) # --------------------------------------------------------- # GROUP → USERS # --------------------------------------------------------- GROUPS = { "Admin": ["michael", "susan", "david"], "Accounting": ["jane", "robert"], "IT": ["michael", "alex", "steve"], "Sales": ["linda", "john", "kevin"], "Support": ["nancy", "omar"] } # --------------------------------------------------------- # GROUP → TABLE PERMISSIONS # --------------------------------------------------------- GROUP_TABLE_ACCESS = { "Admin": "*", "Accounting": ["Invoices", "Payments", "Vendors"], "IT": ["Technology", "Servers", "Logs", "Users"], "Sales": ["Orders", "Customers", "Quotes"], "Support": ["Tickets", "Customers"] } # --------------------------------------------------------- # MAIN FUNCTION # --------------------------------------------------------- def generate_table_list_html(): logged_in_user = getpass.getuser().lower() # Determine user's group user_group = None for group, users in GROUPS.items(): if logged_in_user in [u.lower() for u in users]: user_group = group break if not user_group: user_group = "Support" # Connect to SQL Server conn = pyodbc.connect(CONN_STR) cursor = conn.cursor() cursor.execute(""" SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME; """) all_tables = [row.TABLE_NAME for row in cursor.fetchall()] # Filter tables based on group permissions if GROUP_TABLE_ACCESS.get(user_group) == "*": allowed_tables = all_tables else: allowed_tables = [ t for t in all_tables if t in GROUP_TABLE_ACCESS.get(user_group, []) ] # --------------------------------------------------------- # BUILD HTML (RAW F‑STRING) # --------------------------------------------------------- html = rf""" cresql Database Tables

cresql Database Overview

Database File Locations:
C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS01\MSSQL\DATA\cresql.mdf
C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS01\MSSQL\DATA\cresql_log.ldf

The cresql database is the primary SQL Server data store used by pcAmerica CRE (Cash Register Express). The MDF file contains all structured relational data for the POS system, including inventory, items, transactions, customers, employees, discounts, tax rules, and configuration metadata. The LDF file stores SQL Server’s transaction log, enabling rollback, crash recovery, and full ACID‑compliant write operations.

pcAmerica CRE is a Windows‑based retail and restaurant point‑of‑sale platform designed for high‑volume checkout environments. It uses SQL Server Express as its backend engine, with all POS terminals reading and writing directly to the cresql database. This makes the database the authoritative source of truth for all sales, inventory, and operational activity.

This page provides a structured view of the cresql database tables, including user‑specific notes, cross‑user annotations, and administrative grouping to support consultants, technicians, and analysts working with pcAmerica CRE.

Remote Script Access

The following endpoint provides direct access to the Python automation script used for generating this table‑analysis interface:
https://delacruz.belliniseven.ai/PY/getTableList.py

Technical Summary of getTableList.py

The getTableList.py script connects to the SQL Server instance hosting the cresql database and dynamically enumerates all base tables using INFORMATION_SCHEMA.TABLES. It applies group‑based access control to filter which tables are visible to the current Windows user, then generates a complete HTML interface that includes:

User‑selectable table ownership and grouping
Editable per‑user notes stored in browser localStorage
Auto‑generated AI‑style notes for all other users
Shared message fields for cross‑team communication
Dynamic user lists based on group membership
Client‑side rendering of read‑only vs editable notes

The script outputs a fully self‑contained HTML dashboard that requires no server‑side components beyond the initial SQL query. All user‑specific data (notes, messages, group selections) is stored locally in the browser, making the interface safe to use across multiple consultants without modifying the underlying database.

cresql Database Tables

Create New Entry

Table: User:

""" # --------------------------------------------------------- # TABLE ROWS # --------------------------------------------------------- for table in allowed_tables: if user_group == "Admin": group_cell = ( f"" ) else: group_cell = f"{user_group}" html += rf""" """ html += """

Table Name	Group	User	Editable Notes	Other Users' Notes	Messages
{table}	{group_cell}

""" # --------------------------------------------------------- # WRITE FILE # --------------------------------------------------------- os.makedirs(os.path.dirname(HTML_OUTPUT), exist_ok=True) with open(HTML_OUTPUT, "w", encoding="utf-8") as f: f.write(html) print(f"HTML file created: {HTML_OUTPUT}") print(f"Tables available to {logged_in_user} ({user_group}): {len(allowed_tables)}") if __name__ == "__main__": generate_table_list_html()