public void IdentifiesTokenTypesInUpdateExpression() { const string QueryText = "UPDATE TestTable SET Id = 101 WHERE Id = 1"; const int ExpectedTokenCount = 10; Token[] result = Lexer.Lex(QueryText).ToArray(); Assert.Equal(ExpectedTokenCount, result.Length); Assert.Equal(TokenHelpers.Reserved("UPDATE"), result[0]); Assert.Equal(TokenHelpers.Id("TestTable"), result[1]); Assert.Equal(TokenHelpers.Reserved("SET"), result[2]); Assert.Equal(TokenHelpers.Id("Id"), result[3]); Assert.Equal(TokenHelpers.Reserved("="), result[4]); Assert.Equal(TokenHelpers.Int("101"), result[5]); Assert.Equal(TokenHelpers.Reserved("WHERE"), result[6]); Assert.Equal(TokenHelpers.Id("Id"), result[7]); Assert.Equal(TokenHelpers.Reserved("="), result[8]); Assert.Equal(TokenHelpers.Int("1"), result[9]); }
public void IdentifiesTokenTypesInInsertExpression() { const string QueryText = "INSERT INTO TestTable (Id) VALUES (1)"; const int ExpectedTokenCount = 10; Token[] result = Lexer.Lex(QueryText).ToArray(); Assert.Equal(ExpectedTokenCount, result.Length); Assert.Equal(TokenHelpers.Reserved("INSERT"), result[0]); Assert.Equal(TokenHelpers.Reserved("INTO"), result[1]); Assert.Equal(TokenHelpers.Id("TestTable"), result[2]); Assert.Equal(TokenHelpers.Reserved("("), result[3]); Assert.Equal(TokenHelpers.Id("Id"), result[4]); Assert.Equal(TokenHelpers.Reserved(")"), result[5]); Assert.Equal(TokenHelpers.Reserved("VALUES"), result[6]); Assert.Equal(TokenHelpers.Reserved("("), result[7]); Assert.Equal(TokenHelpers.Int("1"), result[8]); Assert.Equal(TokenHelpers.Reserved(")"), result[9]); }