[geeklog-cvs] Geeklog-2.x/sql NamedQueries.xml,1.12,1.13

[Tony Bibbs]

Update of /cvsroot/geeklog2/Geeklog-2.x/sql
In directory qs1489.pair.com:/tmp/cvs-serv80766/sql

Modified Files:
	NamedQueries.xml 
Log Message:
""

Index: NamedQueries.xml
===================================================================
RCS file: /cvsroot/geeklog2/Geeklog-2.x/sql/NamedQueries.xml,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** NamedQueries.xml	29 Jun 2007 16:42:36 -0000	1.12
--- NamedQueries.xml	23 Jul 2007 13:57:45 -0000	1.13
***************
*** 6,9 ****
--- 6,15 ----
          <sql>SELECT * FROM gl2_list_item WHERE enabled = 1 and group_name = ?</sql>
      </model-query>
+     
+     <model-query name="getSecurityGroup"
+         description="Gets all security groups" paging="false" type="Gl2Group">
+ 		<sql>SELECT * FROM gl2_group ORDER BY group_name</sql>
+     </model-query>
+     
      <model-query name="getAllListItemsByGroup"
          description="Retrieves all list item entries for the specified group." paging="false" type="Gl2ListItem">
***************
*** 11,18 ****
--- 17,32 ----
          <sql>SELECT * FROM gl2_list_item WHERE group_name = ?</sql>
      </model-query>
+     
      <model-query name="getAllPlugins"
          description="Gets all plugins installed" paging="false" type="Gl2Plugin">
          <sql>SELECT * FROM gl2_plugin</sql>
      </model-query>
+     
+     <model-query name="getDefaultACLById"
+     	description="Description needed" paging="false" type="Gl2DefaultAcl">
+     	<input name="plugin_id" type="integer" description="Description needed"/>
+     	<sql>SELECT * FROM gl2_default_acl WHERE plugin_id = ?</sql>
+     </model-query>
+     
      <model-query name="getEnabledPlugins"
          description="Gets all plugins installed" paging="false" type="Gl2Plugin">
***************
*** 29,32 ****
--- 43,58 ----
          <input name="list_type" type="string" description="list type"/>
          <sql>SELECT * FROM gl2_group_assignment WHERE assigned_group_id IN (?)</sql>
+     </model-query>
+     
+     <model-query name="getPluginByName"
+         description="Gets a plugin by name given" paging="false" type="Gl2Plugin">
+         <input name="list_type" type="string" description="list type"/>
+         <sql>SELECT * FROM gl2_plugin WHERE logical_name = ?</sql>
+     </model-query>
+     
+     <model-query name="getActionsByName"
+         description="Gets all actions for a given name" paging="false" type="Gl2Action">
+         <input name="list_type" type="string" description="list type"/>
+         <sql>SELECT * FROM gl2_action WHERE action_name IN (?)</sql>
      </model-query>