locking_test.go 1.9 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  1. package parser
  2. import (
  3. "errors"
  4. "testing"
  5. "github.com/danfragoso/pizzasql-next/pkg/lexer"
  6. "github.com/danfragoso/pizzasql-next/pkg/pgerror"
  7. )
  8. func TestSelectLockingClauseParses(t *testing.T) {
  9. cases := []struct {
  10. sql string
  11. strength LockStrength
  12. wait LockWait
  13. }{
  14. {"SELECT * FROM t FOR UPDATE", LockUpdate, LockWaitBlock},
  15. {"SELECT * FROM t WHERE id = 1 FOR UPDATE NOWAIT", LockUpdate, LockWaitNoWait},
  16. {"SELECT * FROM t FOR SHARE", LockShare, LockWaitBlock},
  17. {"SELECT id FROM t ORDER BY id LIMIT 10 FOR UPDATE SKIP LOCKED", LockUpdate, LockWaitSkipLocked},
  18. {"SELECT * FROM t FOR UPDATE OF t SKIP LOCKED", 0, 0},
  19. }
  20. for i, tc := range cases {
  21. t.Run(tc.sql, func(t *testing.T) {
  22. stmt, err := New(lexer.New(tc.sql)).Parse()
  23. if i == 4 {
  24. if !errors.Is(err, pgerror.ErrFeatureNotSupported) {
  25. t.Fatalf("error = %v, want ErrFeatureNotSupported", err)
  26. }
  27. return
  28. }
  29. if err != nil {
  30. t.Fatal(err)
  31. }
  32. sel, ok := stmt.(*SelectStmt)
  33. if !ok || sel.Locking == nil {
  34. t.Fatalf("locking clause missing: %#v", stmt)
  35. }
  36. if sel.Locking.Strength != tc.strength || sel.Locking.Wait != tc.wait {
  37. t.Fatalf("locking = %#v, want %v/%v", sel.Locking, tc.strength, tc.wait)
  38. }
  39. })
  40. }
  41. }
  42. func TestSelectLockingUnsupportedForms(t *testing.T) {
  43. for _, sql := range []string{
  44. "SELECT * FROM t FOR NO KEY UPDATE",
  45. "SELECT * FROM t FOR KEY SHARE",
  46. "SELECT id FROM t UNION SELECT id FROM u FOR UPDATE",
  47. } {
  48. t.Run(sql, func(t *testing.T) {
  49. _, err := New(lexer.New(sql)).Parse()
  50. if !errors.Is(err, pgerror.ErrFeatureNotSupported) {
  51. t.Fatalf("error = %v, want ErrFeatureNotSupported", err)
  52. }
  53. })
  54. }
  55. }
  56. func TestSelectWithoutLockingClauseStillParses(t *testing.T) {
  57. for _, sql := range []string{
  58. "SELECT * FROM t",
  59. "SELECT * FROM t WHERE id = 1",
  60. "SELECT * FROM t ORDER BY id LIMIT 1",
  61. } {
  62. if _, err := New(lexer.New(sql)).Parse(); err != nil {
  63. t.Fatalf("%s: %v", sql, err)
  64. }
  65. }
  66. }