### Menu System Script Examples

Source: https://github.com/callmechewy/ourlibrary/blob/main/Scripts/Common/README-Quick.md

Examples of how scripts can be integrated into a menu system, categorized by ease of use and required user input. Includes scripts that can be run directly, those needing simple prompts, and those requiring careful confirmation.

```Shell
✅ BackupProject.py
✅ ListFilesByDate.py  
✅ ListNewPy.py
✅ SimpleTree.py
✅ VerifyIgnore.py
✅ CodebaseSum.py
✅ GitHubAutoUpdate.py
✅ GitHubUpdateSite.py

📝 FindText.py → "Search for what?"
📝 MarkdownToText.py → "Input dir?" "Output dir?"
📝 GitHubInitialCommit.py → "Repo name?"

⚠️ UpdateFiles.py → "Are you sure? This moves files!"
⚠️ SQLiteToMySQL_*.py → "Database path?"
```

--------------------------------

### GitHub Script Setup Requirements

Source: https://github.com/callmechewy/ourlibrary/blob/main/Scripts/Common/GitHub/README.md

Instructions for setting up the necessary tools and dependencies to run the GitHub scripts. This includes installing the GitHub CLI for authentication or using a personal access token, and installing Python libraries like PyGithub and Requests.

```bash
# Install GitHub CLI (recommended)
gh auth login

# Or set up API token
export GITHUB_TOKEN="your_token_here"

# Python dependencies
pip install pygithub requests
```

--------------------------------

### Firebase Functions Setup and Deployment

Source: https://github.com/callmechewy/ourlibrary/blob/main/README.md

Installs dependencies for Firebase Functions, logs into Firebase, sets the project, and deploys the functions.

```bash
cd functions
npm install
firebase login
firebase use our-library-d7b60
firebase deploy --only functions
```

--------------------------------

### Ensure Test Environment Setup

Source: https://github.com/callmechewy/ourlibrary/blob/main/Claude/CLAUDE.md

Creates a user test environment to facilitate testing before making changes.

```python
python Scripts/CreateUserTestEnvironment.py
```

--------------------------------

### GitHub Configuration File Example

Source: https://github.com/callmechewy/ourlibrary/blob/main/Scripts/Common/GitHub/README.md

An example JSON file (`github_config.json`) for configuring the GitHub scripts. It specifies user details, repositories to manage, the default branch, and the auto-synchronization interval.

```json
{
    "username": "your_github_username",
    "repositories": {
        "CSM": "https://github.com/HerbBowers/CSM.git",
        "GitUp": "https://github.com/HerbBowers/GitUp.git"
    },
    "default_branch": "main",
    "auto_sync_interval": 300
}
```

--------------------------------

### Configuration File Structure

Source: https://github.com/callmechewy/ourlibrary/blob/main/Scripts/Common/README.md

Provides an example structure for configuration files used within the project, including placeholders for GitHub and database configurations.

```bash
# Example config structure
scripts/config/
├── github_config.example.json
├── database_config.example.json
└── deployment_config.example.json
```

--------------------------------

### System Maintenance Scripts

Source: https://github.com/callmechewy/ourlibrary/blob/main/Scripts/Common/README-Quick.md

Scripts for maintaining and documenting the project codebase. Includes full project backups, temporary backups, and generating documentation snapshots.

```Python
BackupProject.py - Full project backup to Desktop (respects .gitignore)
BackupTemp.py - Quick backup of specific directories
CodebaseSum.py - Generate complete project documentation snapshot
```

--------------------------------

### Firebase Authentication Setup

Source: https://github.com/callmechewy/ourlibrary/blob/main/index.html

Initializes Firebase with project configuration and exposes authentication functions globally. Supports email/password and Google sign-in.

```javascript
import { initializeApp } from "https://www.gstatic.com/firebasejs/9.6.1/firebase-app.js";
import { getAuth, createUserWithEmailAndPassword, sendEmailVerification, signInWithEmailAndPassword, GoogleAuthProvider, signInWithPopup, signInWithCredential } from "https://www.gstatic.com/firebasejs/9.6.1/firebase-auth.js";

// Firebase SDKs configured for OurLibrary authentication system
// Your web app's Firebase configuration - Our Library Project
const firebaseConfig = {
  apiKey: "AIzaSyAsG8hleX4WRKCLcIJdWkcNptWNMGdNjzk",
  authDomain: "our-library-d7b60.firebaseapp.com",
  projectId: "our-library-d7b60",
  storageBucket: "our-library-d7b60.firebasestorage.app",
  messagingSenderId: "71206584632",
  appId: "1:71206584632:web:61a21f2d08b9e318dfc1cd",
  measurementId: "G-XL47Q42LB8"
};

// Initialize Firebase
const app = initializeApp(firebaseConfig);
const auth = getAuth(app);

// Export Firebase functions to global scope
window.signInWithCredential = signInWithCredential;
window.createUserWithEmailAndPassword = createUserWithEmailAndPassword;
window.sendEmailVerification = sendEmailVerification;
window.signInWithEmailAndPassword = signInWithEmailAndPassword;
window.GoogleAuthProvider = GoogleAuthProvider;
window.signInWithPopup = signInWithPopup;
```

--------------------------------

### Configuration File Header Example (package.json)

Source: https://github.com/callmechewy/ourlibrary/blob/main/Docs/Standards/Archive/Design Standard v2.0.md

Example of metadata included in a configuration file (like package.json) to adhere to project header standards, including file specifics and requirements.

```json
{
  "_comment": "File: package.json",
  "_path": "package.json",
  "_standard": "AIDEV-PascalCase-2.0",
  "_ecosystem_requirement": "npm requires exact filename 'package.json'",
  "_created": "2025-07-07",
  "_lastModified": "2025-07-07 09:06PM",
  "_description": "npm package configuration"
}
```

--------------------------------

### Running Scripts in OurLibrary

Source: https://github.com/callmechewy/ourlibrary/blob/main/Scripts/README.md

Provides examples of how to execute both project-specific scripts and common utilities from the Scripts directory.

```bash
# Run shared GitHub utility
python Scripts/Common/GitHub/GitHubInitialCommit.py

# Run project-specific script  
python Scripts/my_custom_tool.py
```

--------------------------------

### Python Path Handling Examples

Source: https://github.com/callmechewy/ourlibrary/blob/main/Docs/Standards/Archive/Design Standard v2.2.md

Examples demonstrating correct and incorrect path formats for project files and templates, emphasizing the use of project-relative paths and template variables.

```Python
# Correct project-relative path
Path: Project_BaseFiles/Scripts/ScriptMenu.py   # ✅ Correct
# Incorrect absolute path
Path: ~/Desktop/Project_BaseFiles/Scripts/ScriptMenu.py  # ❌ Wrong
```

```Python
# Templates should use placeholder for project name
Path: {% raw %}{{project_name}}{% endraw %}/README.md               # ✅ Template
Path: Project_BaseFiles/templates/README_template.md  # ✅ Template source
```

--------------------------------

### CSM Integration Example

Source: https://github.com/callmechewy/ourlibrary/blob/main/Scripts/Common/GitHub/README.md

An example demonstrating how to integrate GitHub operations with CSM project context, specifically for committing changes with session information.

```python
# Commit with CSM session context
python GitHubAutoUpdate.py --commit-with-session --session-id CSM_20250716_123000
```

--------------------------------

### Deployment Script

Source: https://github.com/callmechewy/ourlibrary/blob/main/Scripts/Common/README-Quick.md

A powerful and potentially dangerous script for deploying files based on header paths. Requires careful confirmation before execution.

```Python
UpdateFiles.py - Deploy files based on header paths ⚠️ POWERFUL/DANGEROUS
```

--------------------------------

### SQL Data Access Example

Source: https://github.com/callmechewy/ourlibrary/blob/main/Docs/Standards/Archive/Design Standard v1.9.md

Demonstrates raw SQL usage with parameterized queries, adhering to PascalCase naming conventions for all database elements. This example shows a typical query for retrieving book titles and categories.

```SQL
-- Good: Full PascalCase compliance
SELECT B.BookTitle, C.CategoryName, B.Rating
FROM Books B
    INNER JOIN Categories C ON B.CategoryID = C.CategoryID
WHERE B.CreatedDate >= @StartDate
    AND C.CategoryName LIKE @CategoryFilter
ORDER BY B.BookTitle;
```

--------------------------------

### BackToTheFuture.sh Usage

Source: https://github.com/callmechewy/ourlibrary/blob/main/Scripts/Common/GitHub/README.md

Usage example for the `BackToTheFuture.sh` shell script, which is used for repository state management.

```bash
./BackToTheFuture.sh
```

--------------------------------

### Session Start Protocol - AI Compliance

Source: https://github.com/callmechewy/ourlibrary/blob/main/Docs/Standards/Archive/Design Standard v1.9.md

The required protocol for starting an AI session, confirming understanding and commitment to the design standard's requirements regarding timestamps and project specifications.

```Markdown
### SESSION START PROTOCOL
Every AI session MUST begin with:
```
"I acknowledge Design Standard v1.9 requirements:
✅ I will use ACTUAL CURRENT TIME in Last Modified headers
✅ I will update timestamps for EVERY file change  
✅ I will search project specs before coding
✅ I understand timestamp compliance is NOT OPTIONAL"
```
```

--------------------------------

### Firebase Authentication Setup and Initialization

Source: https://github.com/callmechewy/ourlibrary/blob/main/BowersWorld.com/index.html

Initializes the Firebase app and authentication service using provided configuration. Imports necessary Firebase SDK functions for authentication operations.

```JavaScript
import { initializeApp } from "https://www.gstatic.com/firebasejs/9.6.1/firebase-app.js";
import { getAuth, createUserWithEmailAndPassword, sendEmailVerification, signInWithEmailAndPassword, GoogleAuthProvider, signInWithPopup } from "https://www.gstatic.com/firebasejs/9.6.1/firebase-auth.js";

// Firebase SDKs configured for OurLibrary authentication system
// Your web app's Firebase configuration - Our Library Project
const firebaseConfig = {
  projectId: "our-library-d7b60",
  authDomain: "our-library-d7b60.firebaseapp.com",
  storageBucket: "our-library-d7b60.firebasestorage.app"
};

// Initialize Firebase
const app = initializeApp(firebaseConfig);
const auth = getAuth(app);
```

--------------------------------

### Testing Script

Source: https://github.com/callmechewy/ourlibrary/blob/main/Scripts/Common/README-Quick.md

A script for checking the health of the Anderson's Library web application.

```Python
WebAppDiagnostic.py - Check Anderson's Library web app health
```

--------------------------------

### File Organization and Search Scripts

Source: https://github.com/callmechewy/ourlibrary/blob/main/Scripts/Common/README.md

Provides examples of Python scripts used for organizing files by date, generating project directory trees, and searching for specific text content within files.

```Bash
# List files by date
python Scripts/FinderDisplay/ListFilesByDate.py

# Generate project tree
python Scripts/FinderDisplay/SimpleTree.py

# Search for specific content
python Scripts/FinderDisplay/FindText.py
```

--------------------------------

### Deployment Verification Questions

Source: https://github.com/callmechewy/ourlibrary/blob/main/Docs/Standards/Archive/Design Standard v2.1.md

A set of questions designed to verify file deployment and prevent header mismatches or path-related issues. These questions guide the AI in understanding the deployment context.

```APIDOC
DEPLOYMENT VERIFICATION QUESTIONS:
1. Where will this file actually be served from?
2. What routes/endpoints reference this file?
3. Do any automated systems depend on this path?
4. Are there existing files that need path updates?
5. What's the impact of this path on deployment?
```

--------------------------------

### Simulate User Startup Scenarios

Source: https://github.com/callmechewy/ourlibrary/blob/main/Claude/CLAUDE.md

Simulates user startup scenarios to check system behavior before making changes.

```python
python Scripts/SimulateUserStartup.py
```

--------------------------------

### API Test Example

Source: https://github.com/callmechewy/ourlibrary/blob/main/Docs/Standards/Archive/Design Standard v1.9.md

An example of testing a web API endpoint using FastAPI's TestClient. It asserts that the GET request to '/api/books' returns a 200 status code and includes a 'books' key in the JSON response.

```Python
def test_get_books():
    response = client.get("/api/books")
    assert response.status_code == 200
    assert "books" in response.json()
```

--------------------------------

### User Registrations Sheet Headers

Source: https://github.com/callmechewy/ourlibrary/blob/main/Claude/GOOGLE_SHEETS_SETUP.md

Headers for the 'User Registrations' Google Sheet. These should be pasted into the first row of the sheet to define the data columns.

```text
userId	email	name	authMethod	status	startTime	completionTime	location	consent	notes
```

--------------------------------

### Incomplete Emails Sheet Headers

Source: https://github.com/callmechewy/ourlibrary/blob/main/Claude/GOOGLE_SHEETS_SETUP.md

Headers for the 'Incomplete Emails' Google Sheet. These should be pasted into the first row of the sheet to define the data columns for tracking incomplete email entries.

```text
email	timestamp	step	sessionId	userAgent	referrer	hostname
```

--------------------------------

### Session Analytics Sheet Headers

Source: https://github.com/callmechewy/ourlibrary/blob/main/Claude/GOOGLE_SHEETS_SETUP.md

Headers for the 'Session Analytics' Google Sheet. These should be pasted into the first row of the sheet to define the data columns for tracking user session activity.

```text
userId	email	action	details	sessionId	timestamp	userAgent	hostname
```

--------------------------------

### OurLibrary Development Commands

Source: https://github.com/callmechewy/ourlibrary/blob/main/Claude/CLAUDE.md

Provides essential commands for running, testing, and validating the OurLibrary application. Includes starting the web server, executing various test suites (unit, integration, API), validating architecture, and simulating user scenarios.

```Python
python StartOurLibrary.py
python RunStableMode.py
python -m pytest Tests/
python -m pytest Tests/ -m unit
python -m pytest Tests/ -m integration
python Scripts/ValidateRighteousArchitecture.py
python Scripts/TestWorkflows.py
python Scripts/CreateUserTestEnvironment.py
python Scripts/SimulateUserStartup.py
pytest Tests/test_startup.py
```

--------------------------------

### Migration Guide Markdown

Source: https://github.com/callmechewy/ourlibrary/blob/main/Docs/Standards/Archive/Design Standard v1.8.md

Markdown document detailing the migration guide for the project. Includes standard headers.

```markdown
# File: MigrationGuide.md
# Path: Docs/Architecture/MigrationGuide.md
# Standard: AIDEV-PascalCase-1.8
# Created: 2025-07-05
# Last Modified: 2025-07-05  05:31PM
```

--------------------------------

### Firebase Functions Deployment

Source: https://github.com/callmechewy/ourlibrary/blob/main/CLAUDE.md

Steps to set up, log in, select a Firebase project, and deploy Firebase Functions. Assumes the existence of a 'functions/' directory.

```bash
cd functions
npm install
firebase login
firebase use our-library-d7b60
firebase deploy --only functions
```

--------------------------------

### Required Casing Examples

Source: https://github.com/callmechewy/ourlibrary/blob/main/Docs/Standards/Archive/Design Standard v2.0.md

Examples of filenames and directory structures that have strict casing requirements due to tool or platform specifications.

```text
package.json          # npm REQUIRES this exact name
node_modules/         # npm REQUIRES this exact name
.gitignore           # Git REQUIRES dot + lowercase
robots.txt           # SEO crawlers EXPECT lowercase
sitemap.xml          # SEO crawlers EXPECT lowercase
index.html           # Web server convention (Linux case-sensitive)
manifest.json        # PWA specification requirement
tsconfig.json        # TypeScript REQUIRES this exact name
webpack.config.js    # Webpack REQUIRES this exact name
.env                 # Environment variable convention
src/                 # Frontend build tool convention
public/              # Static file serving convention
```

--------------------------------

### Clone Repository and Navigate

Source: https://github.com/callmechewy/ourlibrary/blob/main/README.md

Clones the OurLibrary repository from GitHub and navigates into the project directory.

```bash
git clone https://github.com/CallMeChewy/OurLibrary.git
cd OurLibrary
```

--------------------------------

### Session Recovery and System Testing Commands

Source: https://github.com/callmechewy/ourlibrary/blob/main/SESSION_RECOVERY_DOCUMENTATION.md

Commands to navigate the project directory, check the current git state, view recent commits, and test the live system. It also includes instructions for deploying Firebase functions.

```bash
cd /home/herb/Desktop/OurLibrary
git status
git log --oneline -5
python monitor-final-deployment.py
```

```bash
cd /home/herb/functions
firebase deploy --only functions
```

--------------------------------

### OurLibrary Project Structure

Source: https://github.com/callmechewy/ourlibrary/blob/main/PHASE1_FOUNDATION.md

Overview of the essential files and directories for OurLibrary Phase 1, including the main interface, authentication logic, configuration files, and test suites.

```tree
OurLibrary/
├── index.html              ✅ Main application interface
├── auth-demo.html           ✅ Authentication system (primary)
├── README.md               ✅ Project overview
├── PHASE1_FOUNDATION.md    ✅ This documentation
├── JS/
│   └── OurLibraryGoogleAuth.js  ✅ Authentication logic
├── Config/
│   ├── oauth_security_config.json    ✅ OAuth configuration
│   └── google_credentials.json       ✅ Firebase credentials
├── Tests/                   ✅ Comprehensive test suite
└── Archive/
    └── Phase1_Development/  ✅ Archived development files
```

--------------------------------

### Session Start Protocol Confirmation

Source: https://github.com/callmechewy/ourlibrary/blob/main/Docs/Standards/Archive/Design Standard v1.8a.md

The required confirmation message AI assistants must provide at the start of every session to acknowledge understanding and commitment to Design Standard v1.9 requirements.

```APIDOC
Session Start Confirmation:
"I acknowledge Design Standard v1.9 requirements:
✅ I will use ACTUAL CURRENT TIME in Last Modified headers
✅ I will update timestamps for EVERY file change  
✅ I will search project specs before coding
✅ I understand timestamp compliance is NOT OPTIONAL"
```

--------------------------------

### JavaScript API Service Example

Source: https://github.com/callmechewy/ourlibrary/blob/main/Docs/Standards/Archive/Design Standard v1.9.md

An example of a JavaScript API service using modern ES6+ features to fetch data from a backend endpoint. Includes error handling for network requests.

```javascript
// Use modern ES6+ features\nconst ApiService = {\n    async GetBooks(params = {}) {\n        try {\n            const response = await fetch('/api/books', {\n                method: 'GET',\n                headers: {\n                    'Content-Type': 'application/json'\n                }\n            });\n            return await response.json();\n        } catch (error) {\n            console.error('API Error:', error);\n            throw error;\n        }\n    }\n};
```

--------------------------------

### Executing Utility Scripts

Source: https://github.com/callmechewy/ourlibrary/blob/main/Scripts/Common/README.md

Illustrates the standard method for running utility scripts from the project's root directory and how to access help or arguments for scripts.

```Bash
# Run from CSM root directory
python Scripts/[category]/[script_name].py

# Many scripts accept command line arguments
python Scripts/[category]/[script_name].py --help
```

--------------------------------

### OurLibrary Auth Demo Page Load and UI

Source: https://github.com/callmechewy/ourlibrary/blob/main/Claude/manual-test-checklist.md

Verifies the correct loading and initial UI state of the 'Secure Auth Demo' page. Checks for the page title, step indicator, and the presence of the registration form.

```APIDOC
Test Case: Auth Demo Page Load and UI

Steps:
1. Navigate to the Auth Demo page URL: https://callmechewy.github.io/OurLibrary/auth-demo.html
2. Confirm that the page title is "Secure Auth Demo".
3. Verify the presence and correct display of the step indicator (e.g., 1-2-3 circles).
4. Ensure the registration form is visible on the page.

Expected Outcome:
The Auth Demo page should load correctly with all specified UI elements present and in their initial state.
```

--------------------------------

### OurLibrary Authentication Documentation Files

Source: https://github.com/callmechewy/ourlibrary/blob/main/Claude/FINAL_PROGRESS_DOCUMENTATION.md

Markdown files created to document the authentication system's progress, issues, and next steps. Includes session summaries, issue analysis, and checklists.

```Markdown
# SESSION_DOCUMENTATION.md
## Issue Analysis: 'Wrong Email' Resolution and Google OAuth Blocked
```

```Markdown
# COMPLETE_SESSION_SUMMARY.md
## OurLibrary Authentication System Status: 89% Functional
```

```Markdown
# NEXT_SESSION_CHECKLIST.md
## Action Items for Next Session: Focus on Google OAuth Fix
```

```Markdown
# URGENT_GOOGLE_OAUTH_FIX.md
## Guide: Configuring Google OAuth Redirect URIs
```

```Markdown
# FINAL_PROGRESS_DOCUMENTATION.md
## OurLibrary Authentication: Session Progress Report
```

--------------------------------

### Real Violation Example: Header Mismatch

Source: https://github.com/callmechewy/ourlibrary/blob/main/Docs/Standards/Archive/Design Standard v2.1.md

An example illustrating a deployment violation where a file's header did not match its actual deployment location, leading to confusion and wasted time. It highlights the root cause and impact.

```APIDOC
REAL VIOLATION: desktop-library.html Header Mismatch
WHAT HAPPENED:
- File deployed to: WebPages/desktop-library.html
- Header claimed: WebPages/index.html  
- Root cause: AI assumed index.html without verifying deployment
- Impact: Confusion, time waste, deployment uncertainty

CORRECT APPROACH:
- AI asks: "Where will this file be deployed?"
- Human clarifies: "MainAPI.py serves /app from desktop-library.html"
- AI updates header to match deployment reality
- Path change announced with impact assessment
```

--------------------------------

### Core Utility Scripts Execution

Source: https://github.com/callmechewy/ourlibrary/blob/main/Scripts/Common/README.md

Demonstrates how to execute common utility scripts for project backup, GitHub operations, and file management using Python.

```Bash
# Project backup and maintenance
python Scripts/System/BackupProject.py
python Scripts/System/CodebaseSum.py

# GitHub operations
python Scripts/GitHub/GitHubAutoUpdate.py
python Scripts/GitHub/GitHubInitialCommit.py

# File operations and deployment
python Scripts/Deployment/UpdateFiles.py
python Scripts/Tools/VerifyIgnore.py
```

--------------------------------

### Run Full Test Suite

Source: https://github.com/callmechewy/ourlibrary/blob/main/Claude/CLAUDE.md

Executes the complete test suite after making changes to verify overall functionality.

```bash
python -m pytest Tests/
```

--------------------------------

### Authentication Flow Steps

Source: https://github.com/callmechewy/ourlibrary/blob/main/PHASE1_FOUNDATION.md

Outlines the sequence of operations in the authentication system, from user registration to session management.

```process
1. User Registration: Form validation and data collection
2. Email Verification: Custom SMTP verification codes
3. Firebase Account: Real Firebase account creation with UID
4. Login System: Email/password authentication
5. Session Management: Firebase Auth state management
```

--------------------------------

### Python Script Naming

Source: https://github.com/callmechewy/ourlibrary/blob/main/Docs/Standards/Archive/Design Standard v1.9.md

Examples of Python script naming conventions using PascalCase.

```Python
UpdateFiles.py
CreateThumbnails.py
BackupDatabase.py
```

--------------------------------

### GitHubInitialCommit.py Usage

Source: https://github.com/callmechewy/ourlibrary/blob/main/Scripts/Common/GitHub/README.md

Shows how to use the `GitHubInitialCommit.py` script for initializing new repositories and creating the initial commit. It supports creating a repository with a default structure or using a specified template.

```bash
# Initialize new repository
python GitHubInitialCommit.py --repo-name "NewProject"

# Initialize with custom template
python GitHubInitialCommit.py --repo-name "NewProject" --template python
```

--------------------------------

### Deployment Status and Performance

Source: https://github.com/callmechewy/ourlibrary/blob/main/PHASE1_FOUNDATION.md

Details on the current deployment status of OurLibrary and verified performance metrics.

```deployment
Frontend: Deployed on GitHub Pages (https://callmechewy.github.io/OurLibrary/)
Backend: Firebase Functions for SMTP verification
Database: Firebase Authentication user management
Domain: Ready for BowersWorld.com custom domain

Performance Verified:
✅ Page load time: < 3 seconds
✅ Registration flow: < 30 seconds end-to-end
✅ Firebase account creation: < 10 seconds
✅ Mobile responsive: Works on all screen sizes
```

--------------------------------

### Database Element Naming

Source: https://github.com/callmechewy/ourlibrary/blob/main/Docs/Standards/Archive/Design Standard v1.9.md

Examples of naming conventions for databases, tables, columns, indexes, and constraints.

```SQL
LibraryDatabase
UserProfiles
SystemLogs

Books
Categories
UserSessions
AuditLogs

BookTitle
CategoryName
CreatedDate
LastModified

IX_Books_Category
IX_Users_Email
IX_Logs_Date

PK_Books_ID
FK_Books_Category
UK_Users_Email
```

--------------------------------

### Example Session: Creating 3 Python Files

Source: https://github.com/callmechewy/ourlibrary/blob/main/Docs/Standards/Archive/Design Standard v1.8a.md

Illustrates a correct implementation scenario for creating three Python files sequentially, demonstrating the correct usage of progressive timestamps in the 'Last Modified' headers.

```Python
# File: DatabaseManager.py
# Path: Source/Core/DatabaseManager.py
# Standard: AIDEV-PascalCase-1.8
# Created: 2025-07-06
# Last Modified: 2025-07-06  03:15PM  ← Current time when created
```

```Python
# File: BookService.py
# Path: Source/Core/BookService.py
# Standard: AIDEV-PascalCase-1.8
# Created: 2025-07-06
# Last Modified: 2025-07-06  03:18PM  ← Progressive time
```

```Python
# File: MainWindow.py
# Path: Source/Interface/MainWindow.py
# Standard: AIDEV-PascalCase-1.8
# Created: 2025-07-06
```

--------------------------------

### Keyboard Navigation Indicators

Source: https://github.com/callmechewy/ourlibrary/blob/main/desktop-library-enhanced.html

Styles for hints that appear on screen to guide keyboard navigation. Includes positioning, transitions, and visibility states.

```css
/* Keyboard Navigation Indicators */
.keyboard-hint { position: fixed; bottom: 80px; right: 20px; background: rgba(0, 0, 0, 0.8); color: #ecf0f1; padding: 12px 16px; border-radius: 8px; font-size: 12px; z-index: 1000; opacity: 0; transform: translateY(20px); transition: all 0.3s ease; pointer-events: none; }
.keyboard-hint.visible { opacity: 1; transform: translateY(0); }
```

--------------------------------

### Python File and Directory Naming

Source: https://github.com/callmechewy/ourlibrary/blob/main/Docs/Standards/Archive/Design Standard v1.9.md

Examples of standard Python file and directory naming conventions using PascalCase.

```Python
BookService.py
DatabaseManager.py
FilterPanel.py
Source/
Assets/
Tests/
Scripts/
```

--------------------------------

### Database Migration Scripts

Source: https://github.com/callmechewy/ourlibrary/blob/main/Scripts/Common/README-Quick.md

Scripts for migrating data between SQLite and MySQL databases. Includes data dump export, generic porting, and a hardened version for production environments, all requiring database path and credential inputs.

```Python
SQLiteToMySQL_DataDump.py - Export SQLite to MySQL script
SQLiteToMySQL_GenericPort.py - Direct SQLite→MySQL migration
SQLiteToMySQL_GenericPort_Hardened.py - Production migration tool
```

--------------------------------

### Google Sheets Headers

Source: https://github.com/callmechewy/ourlibrary/blob/main/Claude/setup-google-sheets-integration.md

Defines the required headers for the three Google Sheets used for user registrations, incomplete emails, and session tracking.

```text
UserID | Email | Name | AuthMethod | Status | RegStartTime | RegCompleteTime | Location | Consent | Notes
Email | Timestamp | LastStep | SessionID | UserAgent | Referrer | Hostname
UserID | Email | Action | Details | SessionID | Timestamp | UserAgent | Hostname
```

--------------------------------

### Input Formatting and Initialization

Source: https://github.com/callmechewy/ourlibrary/blob/main/BowersWorld.com/auth-demo.html

Includes event listeners for input formatting and initial setup messages. The verification code input is automatically converted to uppercase and stripped of non-alphanumeric characters. Console logs indicate the readiness of the demo and highlight key features.

```javascript
// Auto-format verification code input
document.getElementById('verificationCode').addEventListener('input', function(e) {
  this.value = this.value.toUpperCase().replace(/[^A-Z0-9]/g, '');
});

// Initialize demo
console.log('🔐 Secure Authentication Demo Ready');
console.log('Features: Manual verification codes, No phishing risk, Firebase integration');
```

--------------------------------

### Update HTML Configuration

Source: https://github.com/callmechewy/ourlibrary/blob/main/Claude/setup-google-sheets-integration.md

Shows how to update the Google Sheets IDs within the auth-demo.html and index.html files to link to the created Google Sheets.

```javascript
userRegistrationsSheetId: 'YOUR_ACTUAL_SHEET_ID_1',
incompleteEmailsSheetId: 'YOUR_ACTUAL_SHEET_ID_2',
sessionTrackingSheetId: 'YOUR_ACTUAL_SHEET_ID_3'
```