diff options
Diffstat (limited to 'app/frontend/sqlmap')
| -rw-r--r-- | app/frontend/sqlmap/config.xml | 9 | ||||
| -rw-r--r-- | app/frontend/sqlmap/events.xml | 11 |
2 files changed, 20 insertions, 0 deletions
diff --git a/app/frontend/sqlmap/config.xml b/app/frontend/sqlmap/config.xml new file mode 100644 index 0000000..101e1b7 --- /dev/null +++ b/app/frontend/sqlmap/config.xml @@ -0,0 +1,9 @@ +<?xml version="1.0" encoding="utf-8"?> +<sqlMapConfig> + <provider class="TAdodbProvider"> + <datasource ConnectionID="db" /> + </provider> + <sqlMaps> + <sqlMap name="events" resource="events.xml" /> + </sqlMaps> +</sqlMapConfig> diff --git a/app/frontend/sqlmap/events.xml b/app/frontend/sqlmap/events.xml new file mode 100644 index 0000000..030a773 --- /dev/null +++ b/app/frontend/sqlmap/events.xml @@ -0,0 +1,11 @@ +<?xml version="1.0" encoding="utf-8" ?> +<sqlMapConfig> + <select id="getEvents" resultClass="Entry"> + <![CDATA[ + SELECT * FROM entries + WHERE end_date >= #date_from# AND begin_date <= #date_to# + AND $calendar_clause$ + ORDER BY begin_date $order_clause$; + ]]> + </select> +</sqlMapConfig> |