class DatabaseSetDao extends BaseDao {

    public List<DatabaseSetView> getAllDatabaseSetByProjectId(Long projectId) throws SQLException {
        String sql = "SELECT t1.id, t1.name, t1.db_type,t1.strategy_type, t1.strategy_source, t1.dynamic_strategy_id, t1.class_name, t1.group_id, t1.update_user_no, t1.update_time ,t3.group_name, t1.pattern " +
                "FROM databaseset t1 " +
                "inner join project_dbset_relation t2 on t2.dbset_id = t1.id " +
                "inner join dal_group t3 on t1.group_id = t3.id " +
                "where t2.project_id = " + projectId;
        if (projectId == null) {
            sql = "SELECT t1.id, t1.name, t1.db_type, t1.strategy_source, t1.dynamic_strategy_id, t1.class_name, t1.group_id, t1.update_user_no, t1.update_time FROM databaseset t1 order by t1.name";
        }
        return this.queryBySql(sql, DatabaseSetView.class);
    }

}