blob: 05792c5ba895a91822fb7b6e68e050e8c3f2d58f (
plain)
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
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
|
/**
* Copyright 2017-2020 ZTE Corporation.
* <p>
* 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
* <p>
* http://www.apache.org/licenses/LICENSE-2.0
* <p>
* 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.
*/
package org.onap.holmes.common.utils;
import io.dropwizard.db.DataSourceFactory;
import io.dropwizard.jdbi.DBIFactory;
import io.dropwizard.setup.Environment;
import org.jvnet.hk2.annotations.Service;
import org.skife.jdbi.v2.DBI;
import org.skife.jdbi.v2.Handle;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import javax.annotation.PostConstruct;
import javax.inject.Inject;
import javax.inject.Singleton;
@Singleton
@Service
public class DbDaoUtil {
private Logger log = LoggerFactory.getLogger(DbDaoUtil.class);
private DBI jdbi;
@Inject
private Environment environmentProvider;
@Inject
private DataSourceFactory dataSourceFactoryProvider;
private DBIFactory factory = new DBIFactory();
@PostConstruct
public synchronized void init() {
if (jdbi == null) {
jdbi = factory.build(environmentProvider, dataSourceFactoryProvider, "postgres");
}
}
public <K> K getDao(Class<K> clazz) {
try {
return jdbi.open(clazz);
} catch (Exception e) {
log.warn("get object instance of Dao error.", e);
}
return null;
}
public Handle getHandle() {
try {
return jdbi.open();
} catch (Exception e) {
log.warn("get object instance of Dao error.", e);
}
return null;
}
public void close(Object obj) {
if (obj != null) {
try {
jdbi.close(obj);
} catch (Exception e) {
log.warn("close jdbi connection error.", e);
}
}
}
public <T> T getJdbiDaoByOnDemand(Class<T> daoClazz) {
return jdbi.onDemand(daoClazz);
}
public <T> T getJdbiDaoByOpen(Class<T> daoClazz) {
return jdbi.open(daoClazz);
}
}
|