@Test public void getMasterDatabaseSetEntryByDatabaseSetId() throws Exception { DatabaseSetEntry databasesetentry = databaseSetDao.getMasterDatabaseSetEntryByDatabaseSetId(180L); System.out.println("getMasterDatabaseSetEntryByDatabaseSetId :-------> " + databasesetentry); Assert.assertTrue(databasesetentry != null); }
public DatabaseSetEntry getMasterDatabaseSetEntryByDatabaseSetId(Long dbset_id) throws SQLException { String sql = "SELECT en.id, en.name, en.database_type, en.sharding, en.db_Id, en.dbset_id, en.update_user_no, en.update_time " + "FROM databasesetentry as en " + "WHERE en.database_type = 1 and en.dbset_id = ? limit 1"; List<DatabaseSetEntry> list = this.queryBySql(sql, DatabaseSetEntry.class, Parameter.integerOf(StringUtils.EMPTY, dbset_id)); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; }
DatabaseSetDao extends BaseDao { public DatabaseSetEntry getMasterDatabaseSetEntryByDatabaseSetId(Long dbset_id) throws SQLException { String sql = "SELECT en.id, en.name, en.database_type, en.sharding, en.db_Id, en.dbset_id, en.update_user_no, en.update_time " + "FROM databasesetentry as en " + "WHERE en.database_type = 1 and en.dbset_id = ? limit 1"; List<DatabaseSetEntry> list = this.queryBySql(sql, DatabaseSetEntry.class, Parameter.integerOf(StringUtils.EMPTY, dbset_id)); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; } }
DatabaseSetDao extends BaseDao { public DatabaseSetEntry getMasterDatabaseSetEntryByDatabaseSetId(Long dbset_id) throws SQLException { String sql = "SELECT en.id, en.name, en.database_type, en.sharding, en.db_Id, en.dbset_id, en.update_user_no, en.update_time " + "FROM databasesetentry as en " + "WHERE en.database_type = 1 and en.dbset_id = ? limit 1"; List<DatabaseSetEntry> list = this.queryBySql(sql, DatabaseSetEntry.class, Parameter.integerOf(StringUtils.EMPTY, dbset_id)); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; }  }
DatabaseSetDao extends BaseDao { public DatabaseSetEntry getMasterDatabaseSetEntryByDatabaseSetId(Long dbset_id) throws SQLException { String sql = "SELECT en.id, en.name, en.database_type, en.sharding, en.db_Id, en.dbset_id, en.update_user_no, en.update_time " + "FROM databasesetentry as en " + "WHERE en.database_type = 1 and en.dbset_id = ? limit 1"; List<DatabaseSetEntry> list = this.queryBySql(sql, DatabaseSetEntry.class, Parameter.integerOf(StringUtils.EMPTY, dbset_id)); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; }  Long insertDatabaseSet(DatabaseSet dbset); int updateDatabaseSet(DatabaseSet dbset); int deleteDatabaseSetById(Long dbsetId); int deleteDatabaseSetEntryByDbsetId(Long dbsetId); DatabaseSet getDatabaseSetById(Long id); DatabaseSet getDatabaseSetByName(String name); List<DatabaseSet> getAllDatabaseSetByName(String name); List<DatabaseSet> getAllDatabaseSetByNames(List<String> names); List<DatabaseSet> getAllDatabaseSetById(Long id); List<DatabaseSetView> getAllDatabaseSetByProjectId(Long projectId); List<DatabaseSet> getAllDatabaseSetByGroupId(Long groupId); DatabaseSetEntry getMasterDatabaseSetEntryByDatabaseSetId(Long dbset_id); Long getDbSetTotalCount(Paging<DatabaseSet> paging); List<DatabaseSetView> findDbSetPageList(Paging<DatabaseSet> paging); Long getDbSetTotalCountByAppid(Paging<DatabaseSet> paging); List<DatabaseSetView> findDbSetPageListByAppid(Paging<DatabaseSet> paging); }
DatabaseSetDao extends BaseDao { public DatabaseSetEntry getMasterDatabaseSetEntryByDatabaseSetId(Long dbset_id) throws SQLException { String sql = "SELECT en.id, en.name, en.database_type, en.sharding, en.db_Id, en.dbset_id, en.update_user_no, en.update_time " + "FROM databasesetentry as en " + "WHERE en.database_type = 1 and en.dbset_id = ? limit 1"; List<DatabaseSetEntry> list = this.queryBySql(sql, DatabaseSetEntry.class, Parameter.integerOf(StringUtils.EMPTY, dbset_id)); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; }  Long insertDatabaseSet(DatabaseSet dbset); int updateDatabaseSet(DatabaseSet dbset); int deleteDatabaseSetById(Long dbsetId); int deleteDatabaseSetEntryByDbsetId(Long dbsetId); DatabaseSet getDatabaseSetById(Long id); DatabaseSet getDatabaseSetByName(String name); List<DatabaseSet> getAllDatabaseSetByName(String name); List<DatabaseSet> getAllDatabaseSetByNames(List<String> names); List<DatabaseSet> getAllDatabaseSetById(Long id); List<DatabaseSetView> getAllDatabaseSetByProjectId(Long projectId); List<DatabaseSet> getAllDatabaseSetByGroupId(Long groupId); DatabaseSetEntry getMasterDatabaseSetEntryByDatabaseSetId(Long dbset_id); Long getDbSetTotalCount(Paging<DatabaseSet> paging); List<DatabaseSetView> findDbSetPageList(Paging<DatabaseSet> paging); Long getDbSetTotalCountByAppid(Paging<DatabaseSet> paging); List<DatabaseSetView> findDbSetPageListByAppid(Paging<DatabaseSet> paging);  }