Github user necouchman commented on a diff in the pull request:
https://github.com/apache/incubator-guacamole-client/pull/198#discussion_r144607594
--- Diff:
extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlite/src/main/resources/org/apache/guacamole/auth/jdbc/connectiongroup/ConnectionGroupMapper.xml
---
@@ -0,0 +1,250 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
+ "http://mybatis.org/dtd/mybatis-3-mapper.dtd"; >
+
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one
+ or more contributor license agreements. See the NOTICE file
+ distributed with this work for additional information
+ regarding copyright ownership. The ASF licenses this file
+ to you 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.
+-->
+
+<mapper
namespace="org.apache.guacamole.auth.jdbc.connectiongroup.ConnectionGroupMapper"
>
+
+ <!-- Result mapper for connection objects -->
+ <resultMap id="ConnectionGroupResultMap"
type="org.apache.guacamole.auth.jdbc.connectiongroup.ConnectionGroupModel" >
+
+ <!-- Connection group properties -->
+ <id column="connection_group_id" property="objectID"
jdbcType="INTEGER"/>
+ <result column="connection_group_name" property="name"
jdbcType="VARCHAR"/>
+ <result column="parent_id"
property="parentIdentifier" jdbcType="INTEGER"/>
+ <result column="type" property="type"
jdbcType="VARCHAR"
+
javaType="org.apache.guacamole.net.auth.ConnectionGroup$Type"/>
+ <result column="max_connections"
property="maxConnections" jdbcType="INTEGER"/>
+ <result column="max_connections_per_user"
property="maxConnectionsPerUser" jdbcType="INTEGER"/>
+ <result column="enable_session_affinity"
property="sessionAffinityEnabled" jdbcType="BOOLEAN"/>
+
+ <!-- Child connection groups -->
+ <collection property="connectionGroupIdentifiers"
resultSet="childConnectionGroups" ofType="java.lang.String"
+ column="connection_group_id" foreignColumn="parent_id"
select="selectChildGroups"/>
+
+ <!-- Child connections -->
+ <collection property="connectionIdentifiers"
resultSet="childConnections" ofType="java.lang.String"
+ column="connection_group_id" foreignColumn="parent_id"
select="selectChildConnections"/>
+
+ </resultMap>
+
+ <!-- Result mapper for connection objects with read permission check
-->
--- End diff --
Ick.
---
