rename_replica.py 2.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. # Copyright Materialize, Inc. and contributors. All rights reserved.
  2. #
  3. # Use of this software is governed by the Business Source License
  4. # included in the LICENSE file at the root of this repository.
  5. #
  6. # As of the Change Date specified in that file, in accordance with
  7. # the Business Source License, use of this software will be governed
  8. # by the Apache License, Version 2.0.
  9. from textwrap import dedent
  10. from materialize.checks.actions import Testdrive
  11. from materialize.checks.checks import Check
  12. class RenameReplica(Check):
  13. def manipulate(self) -> list[Testdrive]:
  14. return [
  15. Testdrive(dedent(s))
  16. for s in [
  17. """
  18. > CREATE TABLE rename_replica_table (f1 INTEGER);
  19. > INSERT INTO rename_replica_table VALUES (1);
  20. > CREATE CLUSTER rename_replica REPLICAS ();
  21. > SET cluster=rename_replica
  22. > CREATE DEFAULT INDEX ON rename_replica_table;
  23. > CREATE MATERIALIZED VIEW rename_replica_view AS SELECT COUNT(f1) FROM rename_replica_table;
  24. > INSERT INTO rename_replica_table VALUES (2);
  25. > CREATE CLUSTER REPLICA rename_replica.replica1 SIZE '2-2';
  26. > INSERT INTO rename_replica_table VALUES (3);
  27. > CREATE CLUSTER REPLICA rename_replica.replica2 SIZE '2-2';
  28. > INSERT INTO rename_replica_table VALUES (4);
  29. > ALTER CLUSTER REPLICA rename_replica.replica1 RENAME TO replica_new1
  30. """,
  31. """
  32. > INSERT INTO rename_replica_table VALUES (5);
  33. > ALTER CLUSTER REPLICA rename_replica.replica2 RENAME TO replica_new2;
  34. > INSERT INTO rename_replica_table VALUES (6);
  35. """,
  36. ]
  37. ]
  38. def validate(self) -> Testdrive:
  39. return Testdrive(
  40. dedent(
  41. """
  42. > SET cluster=rename_replica
  43. > SELECT * FROM rename_replica_table;
  44. 1
  45. 2
  46. 3
  47. 4
  48. 5
  49. 6
  50. > SELECT * FROM rename_replica_view;
  51. 6
  52. """
  53. )
  54. )