From 2fbc53d1f5d9e0a000717642d02558453bc610a8 Mon Sep 17 00:00:00 2001
From: wei <>
Date: Tue, 18 Jul 2006 23:39:13 +0000
Subject: Add more tests and business code for time-tracker

---
 .../protected/App_Data/mysql-sqlmap.xml            |  14 ++-
 demos/time-tracker/protected/App_Data/users.xml    | 133 ---------------------
 2 files changed, 10 insertions(+), 137 deletions(-)
 delete mode 100644 demos/time-tracker/protected/App_Data/users.xml

(limited to 'demos/time-tracker/protected/App_Data')

diff --git a/demos/time-tracker/protected/App_Data/mysql-sqlmap.xml b/demos/time-tracker/protected/App_Data/mysql-sqlmap.xml
index fe4ebedc..3f850955 100644
--- a/demos/time-tracker/protected/App_Data/mysql-sqlmap.xml
+++ b/demos/time-tracker/protected/App_Data/mysql-sqlmap.xml
@@ -1,8 +1,11 @@
 <?xml version="1.0" encoding="UTF-8" ?>
 <sqlMapConfig>
 	
-	<typeHandler type="TimeTrackerUser" 
-		callback="TimeTrackerUserTypeHandler"/>
+	<typeHandlers>
+		<typeHandler type="TimeTrackerUser" 
+			callback="TimeTrackerUserTypeHandler"/>
+		<typeHandler type="DateTime" callback="DateTimeMySQL" />
+	</typeHandlers>
 	
     <provider class="TAdodb">
         <datasource 
@@ -14,8 +17,11 @@
     </provider>
     
     <sqlMaps>
-        <sqlMap resource="users.xml"/>
-		<sqlMap resource="project.xml"/>
+        <sqlMap resource="mysql-maps/users.xml"/>
+		<sqlMap resource="mysql-maps/projects.xml"/>
+		<sqlMap resource="mysql-maps/category.xml" />
+		<sqlMap resource="mysql-maps/time-entry.xml" />
+		<sqlMap resource="mysql-maps/reports.xml" />
     </sqlMaps>
     
 </sqlMapConfig>
\ No newline at end of file
diff --git a/demos/time-tracker/protected/App_Data/users.xml b/demos/time-tracker/protected/App_Data/users.xml
deleted file mode 100644
index f4151c30..00000000
--- a/demos/time-tracker/protected/App_Data/users.xml
+++ /dev/null
@@ -1,133 +0,0 @@
-<?xml version="1.0" encoding="utf-8" ?>
-<sqlMap>
-
-<resultMap id="time-tracker-user" class="TimeTrackerUser" GroupBy="Name">
-	<result property="Name" column="Name" />
-	<result property="EmailAddress" column="EmailAddress" />
-	<result property="Roles" Type="array" resultMapping="user-roles-result" />
-</resultMap>
-
-<resultMap id="user-roles-result">
-	<result column="role" />
-</resultMap>
-
-<!--
-<select id="GetUserByName" parameterClass="string" resultMap="TimeTrackerUser">
-	SELECT 
-		users.Username as Name,
-		users.EmailAddress as EmailAddress,
-		user_roles.RoleType as role
-	FROM
-		users
-		LEFT JOIN user_roles ON users.Username = user_roles.UserID
-	WHERE
-		Username = #value#
-	AND 
-		Disabled = 0
-</select>
--->
-
-<select id="GetUserByName" parameterClass="string" resultMap="time-tracker-user">
-	SELECT 
-		users.Username as Name,
-		users.EmailAddress as EmailAddress,
-		user_roles.RoleType as role
-	FROM
-		users
-		LEFT JOIN user_roles ON users.Username = user_roles.UserID
-	WHERE
-		Username = #value#
-	AND 
-		Disabled = 0
-</select>
-    
-<select id="GetAllUsers" resultMap="time-tracker-user">
-	SELECT
-		users.Username as Name,
-		users.EmailAddress as EmailAddress,
-		user_roles.RoleType as role
-	FROM
-		users
-		LEFT JOIN user_roles ON users.Username = user_roles.UserID
-	WHERE
-		Disabled = 0
-</select>
-
-<select id="ValidateUser" resultClass="boolean">
-	SELECT 
-		count(Username)
-	FROM
-		users
-	WHERE
-		username = #username# AND password = #password#
-	AND
-		Disabled = 0
-</select>
-
-<insert id="AddNewUser" parameterClass="array">
-	INSERT INTO 
-		users (Username, Password, EmailAddress)
-	VALUES
-		(#user.Name#, #password#, #user.EmailAddress#)
-</insert>
-
-<update id="DeleteUserByName">
-	UPDATE users SET Disabled = 1  WHERE username = #value#
-</update>
-
-<insert id="RegisterAutoSignon" parameterClass="array">
-	INSERT INTO 
-		signon (SessionToken, Username, LastSignOnDate)
-	VALUES
-		(#token#, #username#, NOW())
-</insert>
-
-<select id="ValidateAutoSignon" resultMap="time-tracker-user">
-	SELECT
-		users.Username as Name,
-		users.EmailAddress as EmailAddress,
-		user_roles.RoleType as role
-	FROM
-		users LEFT JOIN user_roles ON users.Username = user_roles.UserID,
-		signon
-	WHERE
-		users.Username = signon.Username
-		AND signon.SessionToken = #value#
-		AND users.Disabled = 0
-</select>
-
-<update id="UpdateSignon">
-	UPDATE signon SET LastSignOnDate = NOW() 
-	WHERE SessionToken = #value#
-</update>
-
-<delete id="DeleteUserRoles" parameterClass="TimeTrackerUser">
-	DELETE FROM user_roles WHERE UserID = #Name#
-</delete>
-
-<update id="AddUserRole" parameterClass="array">
-	INSERT INTO user_roles (UserID, RoleType)
-	VALUES(#username#, #role#)
-</update>
-
-<update id="UpdateUserDetails" parameterClass="TimeTrackerUser">
-	UPDATE users 
-	SET EmailAddress = #EmailAddress#
-	WHERE Username = #Name#
-</update>
-
-<update id="UpdateUserDetailsAndPassword" parameterClass="array">
-	UPDATE users 
-	SET EmailAddress = #user.EmailAddress#, Password=#password#
-	WHERE Username = #user.Name#
-</update>
-
-<delete id="DeleteAutoSignon">
-	DELETE FROM signon WHERE Username = #value#
-</delete>
-
-<delete id="DeleteAllSignon">
-	DELETE FROM signon
-</delete>
-
-</sqlMap>
\ No newline at end of file
-- 
cgit v1.2.3