-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathBNF.txt
executable file
·85 lines (44 loc) · 3.7 KB
/
BNF.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
<Command> ::= <CommandType> ";"
<CommandType> ::= <Use> | <Create> | <Drop> | <Alter> | <Insert> | <Select> | <Update> | <Delete> | <Join>
<Use> ::= "USE " [DatabaseName]
<Create> ::= <CreateDatabase> | <CreateTable>
<CreateDatabase> ::= "CREATE " "DATABASE " [DatabaseName]
<CreateTable> ::= "CREATE " "TABLE " [TableName] | "CREATE " "TABLE " [TableName] "(" <AttributeList> ")"
<Drop> ::= "DROP " "DATABASE " [DatabaseName] | "DROP " "TABLE " [TableName]
<Alter> ::= "ALTER " "TABLE " [TableName] " " <AlterationType> " " [AttributeName]
<Insert> ::= "INSERT " "INTO " [TableName] " VALUES" "(" <ValueList> ")"
<Select> ::= "SELECT " <WildAttribList> " FROM " [TableName] | "SELECT " <WildAttribList> " FROM " [TableName] " WHERE " <Condition>
<Update> ::= "UPDATE " [TableName] " SET " <NameValueList> " WHERE " <Condition>
<Delete> ::= "DELETE " "FROM " [TableName] " WHERE " <Condition>
<Join> ::= "JOIN " [TableName] " AND " [TableName] " ON " [AttributeName] " AND " [AttributeName]
[Digit] ::= "0" | "1" | "2" | "3" | "4" | "5" | "6" | "7" | "8" | "9"
[Uppercase] ::= "A" | "B" | "C" | "D" | "E" | "F" | "G" | "H" | "I" | "J" | "K" | "L" | "M" | "N" | "O" | "P" | "Q" | "R" | "S" | "T" | "U" | "V" | "W" | "X" | "Y" | "Z"
[Lowercase] ::= "a" | "b" | "c" | "d" | "e" | "f" | "g" | "h" | "i" | "j" | "k" | "l" | "m" | "n" | "o" | "p" | "q" | "r" | "s" | "t" | "u" | "v" | "w" | "x" | "y" | "z"
[Letter] ::= [Uppercase] | [Lowercase]
[PlainText] ::= [Letter] | [Digit] | [PlainText] [Letter] | [PlainText] [Digit]
[Symbol] ::= "!" | "#" | "$" | "%" | "&" | "(" | ")" | "*" | "+" | "," | "-" | "." | "/" | ":" | ";" | ">" | "=" | "<" | "?" | "@" | "[" | "\" | "]" | "^" | "_" | "`" | "{" | "}" | "~"
[Space] ::= " "
<NameValueList> ::= <NameValuePair> | <NameValuePair> "," <NameValueList>
<NameValuePair> ::= [AttributeName] "=" [Value]
<AlterationType> ::= "ADD" | "DROP"
<ValueList> ::= [Value] | [Value] "," <ValueList>
[DigitSequence] ::= [Digit] | [Digit] [DigitSequence]
[IntegerLiteral] ::= [DigitSequence] | "-" [DigitSequence] | "+" [DigitSequence]
[FloatLiteral] ::= [DigitSequence] "." [DigitSequence] | "-" [DigitSequence] "." [DigitSequence] | "+" [DigitSequence] "." [DigitSequence]
[BooleanLiteral] ::= "TRUE" | "FALSE"
[CharLiteral] ::= [Space] | [Letter] | [Symbol] | [Digit]
[StringLiteral] ::= "" | [CharLiteral] | [StringLiteral] [CharLiteral]
[Value] ::= "'" [StringLiteral] "'" | [BooleanLiteral] | [FloatLiteral] | [IntegerLiteral] | "NULL"
[TableName] ::= [PlainText]
[AttributeName] ::= [PlainText]
[DatabaseName] ::= [PlainText]
<WildAttribList> ::= <AttributeList> | "*"
<AttributeList> ::= [AttributeName] | [AttributeName] "," <AttributeList>
<Condition> ::= "(" <Condition> <BoolOperator> <Condition> ")" | <Condition> <BoolOperator> <Condition> | "(" [AttributeName] <Comparator> [Value] ")" | [AttributeName] <Comparator> [Value]
<BoolOperator> ::= "AND" | "OR"
<Comparator> ::= "==" | ">" | "<" | ">=" | "<=" | "!=" | " LIKE "
Note:
<name> denotes a rule which may contain arbitrary additional whitespace within the symbol, where as [name] indicates a rule that cannot contain additional whitespace.
For rules where additional whitespace is permitted, this can only occur before/after/between tokens and NOT _inside_ the tokens themselves...
For example, the following is valid: CREATE DATABASE marks;
Whereas the following is not valid: CRE ATE DATA BASE marks;