A work-in-progress SQL parser written in TypeScript
Du kannst nicht mehr als 25 Themen auswählen Themen müssen mit entweder einem Buchstaben oder einer Ziffer beginnen. Sie können Bindestriche („-“) enthalten und bis zu 35 Zeichen lang sein.

lexer.test.ts 2.9KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293
  1. /* tslint:disable:no-unused-expression */
  2. import { expect } from "chai";
  3. import Error, { isError } from "../src/error";
  4. import Lexer from "../src/lexer";
  5. import Token, { TokenKind } from "../src/token";
  6. const scan = (source: string): Token[] | Error => {
  7. return new Lexer(source).scan();
  8. };
  9. describe("Lexer", () => {
  10. it("scans uppercase keywords", () => {
  11. const tokens = scan("SELECT FROM WHERE AS AND OR");
  12. expect(tokens).to.deep.equal([
  13. new Token(TokenKind.SELECT, null, 1),
  14. new Token(TokenKind.FROM, null, 1),
  15. new Token(TokenKind.WHERE, null, 1),
  16. new Token(TokenKind.AS, null, 1),
  17. new Token(TokenKind.AND, null, 1),
  18. new Token(TokenKind.OR, null, 1),
  19. new Token(TokenKind.EOF, null, 1),
  20. ]);
  21. });
  22. it("scans lowercase keywords", () => {
  23. const tokens = scan("select from where as and or");
  24. expect(tokens).to.deep.equal([
  25. new Token(TokenKind.SELECT, null, 1),
  26. new Token(TokenKind.FROM, null, 1),
  27. new Token(TokenKind.WHERE, null, 1),
  28. new Token(TokenKind.AS, null, 1),
  29. new Token(TokenKind.AND, null, 1),
  30. new Token(TokenKind.OR, null, 1),
  31. new Token(TokenKind.EOF, null, 1),
  32. ]);
  33. });
  34. it("scans symbols", () => {
  35. const tokens = scan("=,`;.+-*/()");
  36. expect(tokens).to.deep.equal([
  37. new Token(TokenKind.EQUALS, null, 1),
  38. new Token(TokenKind.COMMA, null, 1),
  39. new Token(TokenKind.BACKTICK, null, 1),
  40. new Token(TokenKind.SEMICOLON, null, 1),
  41. new Token(TokenKind.DOT, null, 1),
  42. new Token(TokenKind.PLUS, null, 1),
  43. new Token(TokenKind.MINUS, null, 1),
  44. new Token(TokenKind.STAR, null, 1),
  45. new Token(TokenKind.SLASH, null, 1),
  46. new Token(TokenKind.LPAREN, null, 1),
  47. new Token(TokenKind.RPAREN, null, 1),
  48. new Token(TokenKind.EOF, null, 1),
  49. ]);
  50. });
  51. it("scans identifiers", () => {
  52. const tokens = scan("ident ident_ifier Ident");
  53. expect(tokens).to.deep.equal([
  54. new Token(TokenKind.IDENTIFIER, "ident", 1),
  55. new Token(TokenKind.IDENTIFIER, "ident_ifier", 1),
  56. new Token(TokenKind.IDENTIFIER, "Ident", 1),
  57. new Token(TokenKind.EOF, null, 1),
  58. ]);
  59. });
  60. it("scans numbers", () => {
  61. const tokens = scan("1 123.45 .123");
  62. expect(tokens).to.deep.equal([
  63. new Token(TokenKind.NUMBER, "1", 1),
  64. new Token(TokenKind.NUMBER, "123.45", 1),
  65. new Token(TokenKind.NUMBER, ".123", 1),
  66. new Token(TokenKind.EOF, null, 1),
  67. ]);
  68. });
  69. it("keeps track of line numbers", () => {
  70. const tokens = scan("foo\nbar");
  71. expect(tokens).to.deep.equal([
  72. new Token(TokenKind.IDENTIFIER, "foo", 1),
  73. new Token(TokenKind.IDENTIFIER, "bar", 2),
  74. new Token(TokenKind.EOF, null, 2),
  75. ]);
  76. });
  77. it("returns an error for an unrecognized character", () => {
  78. const error = scan("~");
  79. expect(isError(error)).to.be.ok;
  80. if (isError(error)) {
  81. expect(error.message).to.equal("Unrecognized character ~");
  82. }
  83. });
  84. });