You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ibatis.apache.org by gb...@apache.org on 2005/03/02 20:45:54 UTC
svn commit: r155947 - in
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test:
Maps/Access/OleDb/LineItem.xml Maps/Access/OleDb/ResultClass.xml ReadMe.txt
bin/Debug/IBatisNet.DataMapper.Test.dll.config
bin/Debug/SqlMap_Access_OleDb.config bin/Debug/dao_Access_OleDb.config
Author: gbayon
Date: Wed Mar 2 11:45:52 2005
New Revision: 155947
URL: http://svn.apache.org/viewcvs?view=rev&rev=155947
Log:
- Updated MS Access Nunit test
Modified:
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/LineItem.xml
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/ResultClass.xml
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/ReadMe.txt
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/IBatisNet.DataMapper.Test.dll.config
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/SqlMap_Access_OleDb.config
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/dao_Access_OleDb.config
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/LineItem.xml
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/LineItem.xml?view=diff&r1=155946&r2=155947
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/LineItem.xml (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/LineItem.xml Wed Mar 2 11:45:52 2005
@@ -171,7 +171,7 @@
-->
<delete id="DeleteWithComments" >
<!-- Delete LineItems -->
- delete from LineItems where Order_ID = 10
+ delete from LineItems where Order_ID = 10;
<!-- Delete LineItems -->
delete from LineItems where Order_ID = 9
</delete>
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/ResultClass.xml
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/ResultClass.xml?view=diff&r1=155946&r2=155947
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/ResultClass.xml (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/ResultClass.xml Wed Mar 2 11:45:52 2005
@@ -11,7 +11,7 @@
<statement id="GetBoolean"
parameterClass="Int"
resultClass="bool" >
- select 1 from Orders where Order_ID = #value#
+ select CBool('True') from Orders where Order_ID = #value#
</statement>
<!--
@@ -21,7 +21,7 @@
<statement id="GetByte"
parameterClass="Int"
resultClass="byte" >
- select 155 from Orders where Order_ID = #value#
+ select CByte(155) from Orders where Order_ID = #value#
</statement>
<statement id="GetChar"
@@ -37,7 +37,7 @@
<statement id="GetDate"
parameterClass="Int"
resultClass="date" >
- select '2003-02-15 8:15:00' from Orders where Order_ID = #value#
+ select Order_Date from Orders where Order_ID = #value#
</statement>
<statement id="GetDecimal"
@@ -52,7 +52,7 @@
<statement id="GetDouble"
parameterClass="Int"
resultClass="double" >
- select 99.5 from Orders where Order_ID= #value#
+ select CDbl(99.5) from Orders where Order_ID= #value#
</statement>
<!--
@@ -62,7 +62,7 @@
<statement id="GetGuid"
parameterClass="Int"
resultClass="guid" >
- select 'CD5ABF17-4BBC-4C86-92F1-257735414CF4' from Orders where Order_ID = #value#
+ select CONVERT(UNIQUEIDENTIFIER, 'CD5ABF17-4BBC-4C86-92F1-257735414CF4') from Orders where Order_ID = #value#
</statement>
<statement id="GetInt16"
@@ -89,7 +89,7 @@
<statement id="GetSingle"
parameterClass="Int"
resultClass="float" >
- select 92233.5 from Orders where Order_ID = #value#
+ select CSng(92233.5) from Orders where Order_ID = #value#
</statement>
<statement id="GetString"
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/ReadMe.txt
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/ReadMe.txt?view=diff&r1=155946&r2=155947
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/ReadMe.txt (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/ReadMe.txt Wed Mar 2 11:45:52 2005
@@ -1,14 +1,16 @@
To pass tests for MS Sql Server
------------------------------
-1/ Create the database with the script 'scripts\MSSQL\DBCreation.sql'
+1/ Create the database with the script 'scripts\(database name)\DBCreation.sql'
2/ In 'bin/IBatisNet.Test.dll.config' :
- set the database to MSSQL,
+ set the database value to the name of database server : MSSQL,Oracle, Acces, MySql
set the providerType key to a provider :
- 'SqlClient' to run test via native .Net provider for Sql Server.
- - 'Oledb' to run test via Oledb provider for Sql Server.
- - 'Odbc' to run test via Odbc provider for Sql Server.
+ - 'ByteFx' to run test via native .Net provider for MySql.
+ - 'OracleClient' to run test via native .Net provider for Oracle.
+ - 'Oledb' to run test via Oledb provider. (Access)
+ - 'Odbc' to run test via Odbc provider.
3/ With the help of the DataBase-Template.config
create a file named DataBase.config with your own value for datasource.
(WARNInG : don't included it in the solution and don't commit it in SVN)
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/IBatisNet.DataMapper.Test.dll.config
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/IBatisNet.DataMapper.Test.dll.config?view=diff&r1=155946&r2=155947
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/IBatisNet.DataMapper.Test.dll.config (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/IBatisNet.DataMapper.Test.dll.config Wed Mar 2 11:45:52 2005
@@ -9,15 +9,16 @@
<!-- <add key="log4net.Internal.Debug" value="true"/> -->
<!-- To test MySql set value="MySql" -->
- <!-- To test Oracle set value="Oracle" -->
+ <!-- To test Oracle set value="Oracle" -->
+ <!-- To test Access set value="Access" -->
<!-- To test MS Sql Server set value="MSSQL" -->
- <add key="database" value="MSSQL"/>
+ <add key="database" value="Access"/>
<!-- To test MS SqlServer via SqlClient value="SqlClient" -->
<!-- To test Oracle via OracleClient value="OracleClient" -->
<!-- To test MySql via ByteFx value="ByteFx" -->
<!-- To test via OleDb provider (any database) value="OleDb" -->
<!-- To test via Odbc provider (any database) value="Odbc" -->
- <add key="providerType" value="SqlClient"/>
+ <add key="providerType" value="OleDb"/>
</appSettings>
<!-- This section contains the log4net configuration settings -->
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/SqlMap_Access_OleDb.config
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/SqlMap_Access_OleDb.config?view=diff&r1=155946&r2=155947
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/SqlMap_Access_OleDb.config (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/SqlMap_Access_OleDb.config Wed Mar 2 11:45:52 2005
@@ -12,7 +12,7 @@
<!-- ==== OleDb configuration ========= -->
<database>
<provider name="OleDb1.1"/>
- <dataSource name="iBatisNetOLEDB" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.mdb;User Id=admin;Password=;"/>
+ <dataSource name="iBatisNetOLEDB" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\IBatisNet.mdb;User Id=admin;Password=;"/>
</database>
<alias>
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/dao_Access_OleDb.config
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/dao_Access_OleDb.config?view=diff&r1=155946&r2=155947
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/dao_Access_OleDb.config (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/dao_Access_OleDb.config Wed Mar 2 11:45:52 2005
@@ -15,7 +15,7 @@
<!-- ==== OleDb configuration ========= -->
<database>
<provider name="OleDb1.1"/>
- <dataSource name="iBatisNet" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.mdb;User Id=admin;Password=;"/>
+ <dataSource name="iBatisNet" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\IBatisNet.mdb;User Id=admin;Password=;"/>
</database>
<daoFactory>