本文整理汇总了Java中com.taobao.tddl.group.jdbc.TGroupDataSource.setDbGroupKey方法的典型用法代码示例。如果您正苦于以下问题:Java TGroupDataSource.setDbGroupKey方法的具体用法?Java TGroupDataSource.setDbGroupKey怎么用?Java TGroupDataSource.setDbGroupKey使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类com.taobao.tddl.group.jdbc.TGroupDataSource
的用法示例。
在下文中一共展示了TGroupDataSource.setDbGroupKey方法的11个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: setUp
import com.taobao.tddl.group.jdbc.TGroupDataSource; //导入方法依赖的package包/类
@Before
public void setUp() throws Exception {
s1 = new TGroupDataSource();
s1.setAppName("TDDLSEQUENCE");
s1.setDbGroupKey("TDDL_SEQUENCE_GROUP0");
s1.init();
s2 = new TGroupDataSource();
s2.setAppName("TDDLSEQUENCE");
s2.setDbGroupKey("TDDL_SEQUENCE_GROUP1");
s2.init();
dao = new GroupSequenceDao();
// 设置adjust为true,这样不必关心怎么样去设置有规律的值。单元化部署必须设置这个值为true,切换的时候自动更新
dao.setAdjust(true);
dao.setAppName("TDDLSEQUENCE");
List<String> dbGroups = new ArrayList<String>();
dbGroups.add("TDDL_SEQUENCE_GROUP0");
dbGroups.add("TDDL_SEQUENCE_GROUP1");
dao.setDbGroupKeys(dbGroups);
dao.setDscount(2);
dao.setInnerStep(1000);
dao.init();
updateNormalTable(0);
updateTestTable(testStart);
GroupSequence s = new GroupSequence();
s.setName("ladygaga");
s.setSequenceDao(dao);
s.init();
sequence = s;
}
示例2: TGroupDataSource
import com.taobao.tddl.group.jdbc.TGroupDataSource; //导入方法依赖的package包/类
@Test
public void 三个数据库_测试db1可读写_db2与db3只能读_atom() throws Exception {
TGroupDataSource ds = new TGroupDataSource();
ds.setDbGroupKey(GROUP0);
ds.setAppName(APPNAME);
MockServer.setConfigInfo(ds.getFullDbGroupKey(), DSKEY0 + ":r10w" + "," + DSKEY1 + ":r20" + "," + DSKEY2
+ ":r30");
ds.init();
testCrud(ds);
}
示例3: getJT
import com.taobao.tddl.group.jdbc.TGroupDataSource; //导入方法依赖的package包/类
protected static JdbcTemplate getJT(String dbGroupKey) {
tds = new TGroupDataSource();
tds.setAppName(APPNAME);
tds.setDbGroupKey(dbGroupKey);
try {
tds.init();
} catch (TddlException e) {
Assert.fail();
}
return new JdbcTemplate(tds);
}
示例4: setUpBeforeClass
import com.taobao.tddl.group.jdbc.TGroupDataSource; //导入方法依赖的package包/类
@BeforeClass
public static void setUpBeforeClass() throws Exception {
tgds = new TGroupDataSource();
tgds.setDbGroupKey("dbKey0");
List<DataSourceWrapper> dataSourceWrappers = new ArrayList<DataSourceWrapper>();
DataSourceWrapper dsw1 = new DataSourceWrapper("db1", "rw", db1, DBType.MYSQL);
DataSourceWrapper dsw2 = new DataSourceWrapper("db2", "r", db2, DBType.MYSQL);
dataSourceWrappers.add(dsw1);
dataSourceWrappers.add(dsw2);
tgds.init(dataSourceWrappers);
}
示例5: TGroupDataSource
import com.taobao.tddl.group.jdbc.TGroupDataSource; //导入方法依赖的package包/类
@Test
public void 单个数据库_atom() throws Exception {
TGroupDataSource ds = new TGroupDataSource();
ds.setDbGroupKey(GROUP0);
ds.setAppName(APPNAME);
MockServer.setConfigInfo(ds.getFullDbGroupKey(), DSKEY1 + ":rw");
ds.init();
testCrud(ds);
}
示例6: DataSourceWrapper
import com.taobao.tddl.group.jdbc.TGroupDataSource; //导入方法依赖的package包/类
@Test
public void 测试DataSourceWrapper() throws Exception {
List<DataSourceWrapper> dataSourceWrappers = new ArrayList<DataSourceWrapper>();
dataSourceWrappers.add(new DataSourceWrapper(DSKEY1, "rw", getMySQLDataSource(1), DBType.MYSQL));
dataSourceWrappers.add(new DataSourceWrapper(DSKEY2, "r", getMySQLDataSource(2), DBType.MYSQL));
TGroupDataSource ds = new TGroupDataSource();
ds.setDbGroupKey(GROUP0);
ds.init(dataSourceWrappers);
testCrud(ds);
}
示例7: getJT
import com.taobao.tddl.group.jdbc.TGroupDataSource; //导入方法依赖的package包/类
protected static JdbcTemplate getJT(String dbGroupKey) {
tds = new TGroupDataSource();
tds.setAppName(APPNAME);
tds.setDbGroupKey(dbGroupKey);
tds.init();
return new JdbcTemplate(tds);
}
示例8: setUp
import com.taobao.tddl.group.jdbc.TGroupDataSource; //导入方法依赖的package包/类
@Before
public void setUp() throws Exception {
s1 = new TGroupDataSource();
s1.setAppName("TDDLSEQUENCE");
s1.setDbGroupKey("TDDL_SEQUENCE_GROUP0");
s1.init();
s2 = new TGroupDataSource();
s2.setAppName("TDDLSEQUENCE");
s2.setDbGroupKey("TDDL_SEQUENCE_GROUP1");
s2.init();
dao = new UnitGroupSequenceDao();
// 设置adjust为true,这样不必关心怎么样去设置有规律的值。单元化部署必须设置这个值为true,切换的时候自动更新
dao.setAdjust(true);
dao.setAppName("TDDLSEQUENCE");
List<String> dbGroups = new ArrayList<String>();
dbGroups.add("TDDL_SEQUENCE_GROUP0");
dbGroups.add("TDDL_SEQUENCE_GROUP1");
dao.setDbGroupKeys(dbGroups);
dao.setDscount(2);
dao.setInnerStep(1000);
// 设定切换时候的零时表
dao.setSwitchTempTable("sequence_temp");
// 测试时先将主sequence表值设置下,具体使用时可能是应用最大的sequence id
this.updateNormalTable(0);
testUnits = new HashSet<String>();
testUnits.add("UNIT_CM3");
testUnits.add("UNIT_XINGYI");
testUnits.add("UNIT_DONGGUAN");
testUnits.add("UNIT_CM9");
currentUnit = "UNIT_CM9";
// 设置测试参数
RouterTestHelper.setTestData(testUnits, currentUnit, false);
dao.init();
// 有个名字叫ladygaga的sequence,自动初始化值
GroupSequence s = new GroupSequence();
s.setName("ladygaga");
s.setSequenceDao(dao);
s.init();
sequence = s;
}
示例9: setUp
import com.taobao.tddl.group.jdbc.TGroupDataSource; //导入方法依赖的package包/类
@Before
public void setUp() throws Exception {
s1 = new TGroupDataSource();
s1.setAppName("TDDLSEQUENCE");
s1.setDbGroupKey("TDDL_SEQUENCE_GROUP0");
s1.init();
s2 = new TGroupDataSource();
s2.setAppName("TDDLSEQUENCE");
s2.setDbGroupKey("TDDL_SEQUENCE_GROUP1");
s2.init();
dao = new UnitGroupSequenceDao();
// 设置adjust为true,这样不必关心怎么样去设置有规律的值。单元化部署必须设置这个值为true,切换的时候自动更新
dao.setAdjust(true);
dao.setAppName("TDDLSEQUENCE");
List<String> dbGroups = new ArrayList<String>();
dbGroups.add("TDDL_SEQUENCE_GROUP0");
dbGroups.add("TDDL_SEQUENCE_GROUP1");
dao.setDbGroupKeys(dbGroups);
dao.setDscount(2);
dao.setInnerStep(1000);
// 设定切换时候的零时表
dao.setSwitchTempTable("sequence_temp");
// 测试时先将主sequence表值设置下,具体使用时可能是应用最大的sequence id
this.updateNormalTable(0);
this.updateTestTable(testStart);
testUnits = new HashSet<String>();
testUnits.add("UNIT_CM3");
testUnits.add("UNIT_XINGYI");
testUnits.add("UNIT_DONGGUAN");
testUnits.add("UNIT_CM9");
currentUnit = "UNIT_CM9";
// 设置测试参数
RouterTestHelper.setTestData(testUnits, currentUnit, false);
dao.init();
// 有个名字叫ladygaga的sequence,自动初始化值
GroupSequence s = new GroupSequence();
s.setName("ladygaga");
s.setSequenceDao(dao);
s.init();
sequence = s;
}
示例10: main
import com.taobao.tddl.group.jdbc.TGroupDataSource; //导入方法依赖的package包/类
public static void main(String[] args) throws TddlException, SQLException {
TGroupDataSource ds = new TGroupDataSource();
ds.setDbGroupKey("CBU_WORKOPERATIONS1_TEST_GROUP");
ds.setAppName("CBU_WORKOPERATIONS_TEST_APP");
// ds.setRuleFile("rule.xml");
//
// Map cp = new HashMap();
// cp.put("ALLOW_TEMPORARY_TABLE", "True");
// cp.put(ConnectionProperties.TEMP_TABLE_DIR, ".\\temp\\");
// cp.put(ConnectionProperties.TEMP_TABLE_CUT_ROWS, false);
// cp.put(ConnectionProperties.TEMP_TABLE_MAX_ROWS, 100);
// ds.setConnectionProperties(cp);
ds.init();
System.out.println("init done");
long start = System.currentTimeMillis();
Connection conn = ds.getConnection();
PreparedStatement ps = conn.prepareStatement("SELECT a.custId, a.id,b.adgroupid, SUM(c.cost) / SUM(c.click) AS ppc,c.thedate, c.memberid, c.campaignid, c.productlineid, c.adgroupid, SUM(c.impression), SUM(c.cost), SUM(c.click), SUM(c.click) / SUM(c.impression) AS ctr, b.title, a.onlinestate, a.reason FROM Lunaadgroup a join lunaadgroupinfo b on a.id=b.adgroupid LEFT JOIN rpt_solar_adgroup_ob c ON a.id = c.adgroupid where a.custid='1102000884' and b.custid='1102000884' GROUP BY c.thedate, c.memberid, c.campaignid, c.productlineid, c.adgroupid HAVING ppc > 1 ORDER BY ppc DESC");
ResultSet rs = ps.executeQuery();
while (rs.next()) {
StringBuilder sb = new StringBuilder();
int count = rs.getMetaData().getColumnCount();
for (int i = 1; i <= count; i++) {
String key = rs.getMetaData().getColumnLabel(i);
Object val = rs.getObject(i);
sb.append("[" + rs.getMetaData().getTableName(i) + "." + key + "->" + val + "]");
}
System.out.println(sb.toString());
}
rs.close();
ps.close();
conn.close();
System.out.println("done " + (System.currentTimeMillis() - start));
}
示例11: main
import com.taobao.tddl.group.jdbc.TGroupDataSource; //导入方法依赖的package包/类
public static void main(String[] args) throws TddlException, SQLException {
TGroupDataSource ds = new TGroupDataSource();
// init a datasource with dynamic config on diamond
ds.setAppName("wap");
ds.setDbGroupKey("wap_group");
ds.init();
System.out.println("init done");
Connection conn = ds.getConnection();
// insert a record
// conn.prepareStatement("replace into sample_table (id,name,address) values (1,'sun','hz')").executeUpdate();
// System.out.println("insert done");
// select all records
PreparedStatement ps = conn.prepareStatement("/*+TDDL({\"type\":\"direct\",\"realtabs\":[traa],\"dbid\":\"tddl5_sample_group\",\"vtab\":\"sample_table\"})*/ SELECT * from sample_table");
ResultSet rs = ps.executeQuery();
while (rs.next()) {
StringBuilder sb = new StringBuilder();
int count = rs.getMetaData().getColumnCount();
for (int i = 1; i <= count; i++) {
String key = rs.getMetaData().getColumnLabel(i);
Object val = rs.getObject(i);
sb.append("[" + rs.getMetaData().getTableName(i) + "." + key + "->" + val + "]");
}
System.out.println(sb.toString());
}
rs.close();
ps.close();
conn.close();
System.out.println("query done");
}