@@ -48,7 +48,6 @@ Get details for the `terraform.tfvars` file:
4848~ /.ssh/id_rsa.pub
4949 ```
5050
51- Refresh the Riot Developer API key, only valid for 24 hours.
5251
5352Edit the values with `vim` or `nano` with your tenancy, compartment, ssh public key and Riot API key:
5453```
@@ -85,79 +84,4 @@ All checks should indicate `OK`. If any `FAIL`, review the setup and make sure `
8584
8685```
8786./stop.sh
88- ```
89-
90-
91- ## AJSON export/import
92-
93- Create Bucket.
94-
95- ```
96- BEGIN
97- DBMS_CLOUD.CREATE_CREDENTIAL(
98- credential_name => 'LOL_BUCKET_CREDENTIALS',
99- username => 'user1@example.com ',
100- password => 'password'
101- );
102- END;
103- /
104- ```
105-
106- Match:
107- ```
108- BEGIN
109- DBMS_CLOUD.EXPORT_DATA(
110- credential_name => 'LOL_BUCKET_CREDENTIALS',
111- file_uri_list => 'https://objectstorage.eu-frankfurt-1.oraclecloud.com/n/namespace-string/b/lolbackup/o/match_export ',
112- query => 'SELECT * FROM match',
113- format => JSON_OBJECT('type' value 'csv', 'delimiter' value '|', 'compression' value 'gzip'));
114- END;
115- /
116- ```
117-
118- Match Detail:
119- ```
120- BEGIN
121- DBMS_CLOUD.EXPORT_DATA(
122- credential_name => 'LOL_BUCKET_CREDENTIALS',
123- file_uri_list => 'https://objectstorage.eu-frankfurt-1.oraclecloud.com/n/namespace-string/b/lolbackup/o/match_detail_export ',
124- query => 'SELECT * FROM match_detail',
125- format => JSON_OBJECT('type' value 'csv', 'delimiter' value '|', 'compression' value 'gzip'));
126- END;
127- /
128- ```
129-
130- Summoner:
131- ```
132- BEGIN
133- DBMS_CLOUD.EXPORT_DATA(
134- credential_name => 'LOL_BUCKET_CREDENTIALS',
135- file_uri_list => 'https://objectstorage.eu-frankfurt-1.oraclecloud.com/n/namespace-string/b/lolbackup/o/summoner_export ',
136- query => 'SELECT * FROM summoner',
137- format => JSON_OBJECT('type' value 'csv', 'delimiter' value '|', 'compression' value 'gzip'));
138- END;
139- /
140- ```
141-
142- Predictor Live Client:
143- ```
144- BEGIN
145- DBMS_CLOUD.EXPORT_DATA(
146- credential_name => 'LOL_BUCKET_CREDENTIALS',
147- file_uri_list => 'https://objectstorage.eu-frankfurt-1.oraclecloud.com/n/namespace-string/b/lolbackup/o/predictor_liveclient_export ',
148- query => 'SELECT * FROM predictor_liveclient',
149- format => JSON_OBJECT('type' value 'csv', 'delimiter' value '|', 'compression' value 'gzip'));
150- END;
151- /
152- ```
153-
154- > Update Credentials?
155- > ```
156- > BEGIN
157- > DBMS_CLOUD.UPDATE_CREDENTIAL(
158- > credential_name => 'LOL_BUCKET_CREDENTIALS',
159- > attribute => 'PASSWORD',
160- > value => 'password');
161- > END;
162- > /
163- > ```
87+ ```
0 commit comments