1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
|
/*******************************************************************************
* ============LICENSE_START====================================================
* * org.onap.aaf
* * ===========================================================================
* * Copyright © 2017 AT&T Intellectual Property. All rights reserved.
* * ===========================================================================
* * Licensed under the Apache License, Version 2.0 (the "License");
* * you may not use this file except in compliance with the License.
* * You may obtain a copy of the License at
* *
* * http://www.apache.org/licenses/LICENSE-2.0
* *
* * Unless required by applicable law or agreed to in writing, software
* * distributed under the License is distributed on an "AS IS" BASIS,
* * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* * See the License for the specific language governing permissions and
* * limitations under the License.
* * ============LICENSE_END====================================================
* *
* * ECOMP is a trademark and service mark of AT&T Intellectual Property.
* *
******************************************************************************/
package org.onap.aaf.dao.aaf.test;
import org.onap.aaf.authz.env.AuthzEnv;
import com.datastax.driver.core.Cluster;
import com.datastax.driver.core.ResultSet;
import com.datastax.driver.core.Row;
import com.datastax.driver.core.Session;
public class NS_ChildUpdate {
public static void main(String[] args) {
if(args.length < 3 ) {
System.out.println("usage: NS_ChildUpdate machine mechid (encrypted)passwd");
} else {
try {
AuthzEnv env = new AuthzEnv();
env.setLog4JNames("log.properties","authz","authz","audit","init","trace");
Cluster cluster = Cluster.builder()
.addContactPoint(args[0])
.withCredentials(args[1],env.decrypt(args[2], false))
.build();
Session session = cluster.connect("authz");
try {
ResultSet result = session.execute("SELECT name,parent FROM ns");
int count = 0;
for(Row r : result.all()) {
++count;
String name = r.getString(0);
String parent = r.getString(1);
if(parent==null) {
int idx = name.lastIndexOf('.');
parent = idx>0?name.substring(0, idx):".";
System.out.println("UPDATE " + name + " to " + parent);
session.execute("UPDATE ns SET parent='" + parent + "' WHERE name='" + name + "';");
}
}
System.out.println("Processed " + count + " records");
} finally {
session.close();
cluster.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
|