[geeklog-cvs] Geeklog-2.x/plugins/content/sql NamedQueries.xml, NONE, 1.1

[Damien Hodgkin]

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

Added Files:
	NamedQueries.xml 
Log Message:
Second commit

--- NEW FILE: NamedQueries.xml ---
<?xml version="1.0" encoding="UTF-8"?>
<named_queries>    
    <model-query name="getContents"
        description="Gets all contents ordered by content_id" paging="false" type="Gl2Content">
        <sql>SELECT * FROM gl2_content ORDER BY content_id</sql>        
    </model-query>
    <model-query name="getContentsByKeyword" type="Gl2Content">
        <input name="content_author" type="string" description=""/>
        <input name="content_url" type="string" description=""/>
        <sql propelPeer="Gl2ContentPeer">SELECT * FROM gl2_content WHERE content_author LIKE ? OR content_url LIKE ? ORDER BY content_author</sql>
    </model-query>
    <model-query name="getContentById" type="Gl2Content">
        <input name="content_id" type="integer" description=""/>
        <sql>SELECT * FROM gl2_content WHERE content_id = ?</sql>
    </model-query>
    <model-query name="getContentByIdOrRewriteId" type="Gl2Content">
        <input name="content_id" type="integer" description="Description needed"/>
        <input name="rewrite_id" type="string" description="Description needed"/>
        <sql propelPeer="Gl2ContentPeer">SELECT gl2_content.* FROM gl2_content, gl2_item WHERE gl2_item.item_id = gl2_content.content_id AND ((gl2_content.content_id = ?) OR (gl2_item.rewrite_id = ?))</sql>
    </model-query>
    <model-query name="getContentByRewriteId" type="Gl2Content">
        <input name="rewrite_id" type="string" description="Description needed"/>
        <sql propelPeer="Gl2ContentPeer">SELECT gl2_content.* FROM gl2_content, gl2_item WHERE gl2_item.item_id = gl2_content.content_id AND gl2_item.rewrite_id = ?</sql>
    </model-query>
    <model-query name="getMaxContentId" type="Gl2Content">
        <sql propelPeer="Gl2ContentPeer">SELECT MAX(content_id) FROM gl2_content</sql>
    </model-query>    
    <model-query name="getListItemByKeyword"
        description="Retrieves all active list item entries for the specified group." paging="false" type="Gl2ListItem">
		<input name="group_name" type="string" description="group name"/>
		<input name="short_name" type="string" description="short name"/>
        <sql>SELECT * FROM gl2_list_item WHERE group_name = ? and short_name = ?</sql>
    </model-query>
    <model-query name="getListItemById"
        description="Retrieves all active list item entries for the specified group." paging="false" type="Gl2ListItem">
		<input name="list_item_id" type="string" description="group name"/>
        <sql>SELECT * FROM gl2_list_item WHERE list_item_id = ?</sql>
    </model-query>
    <model-query name="getPluginByName"
        description="Retrieve a plugin by it's name" paging="false" type="Gl2Plugin">
        <input name="plugin_name" type="string" description="plugin name"/>
        <sql>SELECT * FROM gl2_plugin WHERE logical_name = ?</sql>
    </model-query>
    <model-query name="getItemByUserId"
        description="Retrieve a plugin by it's name" paging="false" type="Gl2Plugin">
        <input name="user_id" type="string" description="user id"/>
        <input name="user_id2" type="string" description="user id"/>
        <sql>SELECT * FROM gl2_item, gl2_item_acl WHERE gl2_item.user_id = ? AND gl2_item_acl.user_id = ?</sql>
    </model-query>
</named_queries>