[COMMON][MUSIC] Uses new tpls for repos / images

[oom.git] / kubernetes / common / music / components / music-cassandra / resources / cql / extra / check.cql

diff --git a/kubernetes/common/music/components/music-cassandra/resources/cql/extra/check.cql b/kubernetes/common/music/components/music-cassandra/resources/cql/extra/check.cql
new file mode 100644 (file)
index 0000000..a516be8
--- /dev/null
+++ b/kubernetes/common/music/components/music-cassandra/resources/cql/extra/check.cql
@@ -0,0 +1,23 @@
+CREATE KEYSPACE testks
+    WITH REPLICATION = {
+        'class' : '{{.Values.cql.keyspace.replicationClass}}',
+        'replication_factor': {{.Values.cql.keyspace.replicationFactor}}
+    }
+    AND DURABLE_WRITES = true;
+
+CREATE TABLE testks.keyspace_master_table (
+    uuid uuid,
+    keyspace_name text,
+    application_name text,
+    is_api boolean,
+    password text,
+    username text,
+    is_aaf boolean,
+    PRIMARY KEY (uuid)
+);
+
+DESCRIBE KEYSPACES;
+DESCRIBE keyspace testks;
+SELECT * FROM system_auth.roles;
+DROP keyspace testks;
+