How stevietelly/sql-validator works
Main Components
a) Input/Output Layer:
• SQL Statement Input
• Awino Code Output
b) Core Processing Components:
• Parser Module
• Lexer Module
• File Handling System
• Error Handling System
Component Relationships
SQL Input → Parser → Lexer → Awino Code Output
Detailed Component Breakdown
a) Parser Component (Parser/Parser.py):
• Input as SQL statements
• Tokenization process (breaking by comma, space, parenthesis)
• To the Lexer component
b) Lexer Component (Lexer/Lexer.py):
• Token processing
• Token type classification
• Primary/secondary value extraction
• To the output generation
c) Support Systems:
• Error Handling (var/Errors.py)
• File Handling (var/FileHandling.py)
• Object Management (var/Objects.py)
Use the following visual elements:
• Rounded rectangles: Support modules
• Diamonds: Decision points/validation
• Blue: Core processing components
• Green: Input/Output
• Yellow: Support systems
• Red: Error handling
Labels
a) Process Labels:
• "SQL Statement Input"
• "Tokenization"
• "Token Type Classification"
• "Value Extraction"
• "Awino Code Generation"
b) Data Format Labels:
• "Raw SQL"
• "Tokens"
• "Classified Tokens"
• "Awino Code Format: [Token Type]:[Primary Value]:[Secondary Value]"
Additional Elements
• Token Types (reference TOKENS.MD)
• Primary vs Secondary Values
• Error handling paths
• File handling interactions