Skip to content

A Python SQL syntax Checker with validation that converts into predefined code as a front-end for the Awinodb project by Geliana

License

Notifications You must be signed in to change notification settings

stevietelly/SQL-Validator

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Awino SQL Interpreter

Built for the project Awino DB Converts Single SQl Statements into Awino code Awino DB is targeted to be able to handle multiple databases using simple syntax A-SQL is targeted to be ISO/IEC 9075:2016 Compliant (For more info, check GRAMAR.MD File)

SQL statements follow a Two-step Process to achieve Awino code

  1. Parser

    Where the statements are tokenized into single tokens per every coma, space or parenthesis

  2. Lexer

    The tokens are converted into Singular Token-Types with primary and secondary value

Using the Program

To use the program please check USE.MD file

Awino Code

Awino code follows the Following Format:

[Token Type]:[Primary Value]:[Secondary Value] It is produced by the Token Class

Token Type

Token Types are Recognized SQL statements including some custom AwinoDB recognized syntax

Values

This refers to all variable types including all non-sql syntax, numbers, text inside "'`, and all tuples Values are categorized into two

  1. Primary Values
  2. Secondary Values

Primary Values

Primary values are all varchar, strings and numbers

Secondary Values

Everything inside a tuple Parentheseis

About

A Python SQL syntax Checker with validation that converts into predefined code as a front-end for the Awinodb project by Geliana

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages