You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ibatis.apache.org by ro...@apache.org on 2005/04/30 01:32:48 UTC
svn commit: r165362 - in
/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test:
Maps/MySql/ByteFx/ Scripts/MySql/
Author: roberto
Date: Fri Apr 29 16:32:47 2005
New Revision: 165362
URL: http://svn.apache.org/viewcvs?rev=165362&view=rev
Log:
~Updated C# DataMapper NUnit MySql maps and scripts
Modified:
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Account.xml
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Complex.xml
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/DynamicAccount.xml
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Order.xml
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Other.xml
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/ResultClass.xml
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/DataBase.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/account-init.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/account-procedure.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/category-init.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/category-procedure.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/documents-init.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/enumeration-init.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/line-item-init.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/order-init.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/other-init.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/swap-procedure.sql
incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/user-init.sql
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Account.xml
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Account.xml?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Account.xml (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Account.xml Fri Apr 29 16:32:47 2005
@@ -135,7 +135,16 @@
from Accounts
order by Account_ID
</select>
-
+
+ <select id="GetNoAccountWithCache"
+ parameterClass="Integer"
+ resultMap="account-hashtable-result"
+ cacheModel="account-cache">
+ select *
+ from Accounts
+ where Account_ID = #value#
+ </select>
+
<select id="GetAccountAsHashtable"
parameterClass="Integer"
resultMap="account-hashtable-result">
@@ -443,6 +452,31 @@
where Account_ID between #lowID# and #hightID#
</select>
+ <select id="SelectAccountJIRA29" parameterClass="map" resultClass="Account">
+ select
+ Account_ID as Id,
+ Account_FirstName as FirstName,
+ Account_LastName as LastName,
+ Account_Email as EmailAddress
+ from Accounts
+ where Account_FirstName = '##$AccountName$##'
+ </select>
+
+ <select id="SelectAccountJIRA29-2"
+ parameterClass="Hashtable"
+ resultClass="Account">
+ select
+ Account_ID as Id,
+ Account_FirstName as FirstName,
+ Account_LastName as LastName,
+ Account_Email as EmailAddress
+ from Accounts
+ where 1=1
+ <isNotEmpty prepend="AND" property="Foo">
+ (Account_FirstName = '##$Foo$##')
+ </isNotEmpty>
+ </select>
+
<!-- For procedure, the parameters of the parameterMap must in the same order
as for the procedure paramaters-->
<procedure id="InsertAccountViaStoreProcedure" parameterMap="insert-params">
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Complex.xml
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Complex.xml?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Complex.xml (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Complex.xml Fri Apr 29 16:32:47 2005
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="utf-8" ?>
-<sqlMap namespace="Category" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+<sqlMap namespace="Complex" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="SqlMap.xsd">
<statements>
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/DynamicAccount.xml
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/DynamicAccount.xml?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/DynamicAccount.xml (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/DynamicAccount.xml Fri Apr 29 16:32:47 2005
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="utf-8" ?>
-<sqlMap namespace="Category" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+<sqlMap namespace="Account" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="SqlMap.xsd">
<alias>
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Order.xml
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Order.xml?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Order.xml (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Order.xml Fri Apr 29 16:32:47 2005
@@ -282,8 +282,36 @@
parameterClass="Integer"
resultMap="order-with-dyn-favourite-line-item">
select * from Orders where Order_ID = #value#
- </select>
+ </select>
+ <select id="SelectOrderByDate"
+ parameterClass="Hashtable"
+ resultMap="lite-order-result-by-name">
+ select * from Orders where Order_Date = #Foo#
+ </select>
+
+ <select id="SelectOrderByDateDynamic"
+ parameterClass="Hashtable"
+ resultMap="lite-order-result-by-name">
+ select * from Orders
+ where 1=1
+ <isNotEmpty prepend="AND" property="Foo">
+ (Order_Date = '$Foo$')
+ </isNotEmpty>
+ </select>
+
+ <select id="GetAccountJIRA45"
+ parameterClass="int"
+ resultMap="Account.account-result">
+ select
+ Account_ID,
+ Account_FirstName,
+ Account_LastName,
+ Account_Email
+ from Accounts
+ where Account_ID = #value#
+ </select>
+
</statements>
<parameterMaps>
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Other.xml
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Other.xml?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Other.xml (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/Other.xml Fri Apr 29 16:32:47 2005
@@ -1,4 +1,4 @@
-<?xml version="1.0" encoding="utf-8"?>
+<?xml version="1.0" encoding="utf-8"?>
<sqlMap namespace="Other" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="SqlMap.xsd">
@@ -32,6 +32,25 @@
</isNotEqual>
</dynamic>
</statement>
+
+ <statement id="DynamicSelectByBool"
+ parameterClass="Other"
+ resultMap="other-result">
+ select
+ Other_Int,
+ Other_Long,
+ Other_Bit
+ from Others
+ Where Other_Bit = #Bool#
+ </statement>
+
+ <statement id="InsertBool"
+ parameterClass="Other">
+ Insert into Others
+ ( Other_Int, Other_Long, Other_Bit )
+ values
+ ( #Int#, #Long#, #Bool#)
+ </statement>
</statements>
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/ResultClass.xml
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/ResultClass.xml?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/ResultClass.xml (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MySql/ByteFx/ResultClass.xml Fri Apr 29 16:32:47 2005
@@ -1,6 +1,6 @@
-<?xml version="1.0" encoding="UTF-8" ?>
+<?xml version="1.0" encoding="UTF-8" ?>
-<sqlMap namespace="Order" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+<sqlMap namespace="ResultClass" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="SqlMap.xsd">
<statements>
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/DataBase.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/DataBase.sql?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/DataBase.sql (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/DataBase.sql Fri Apr 29 16:32:47 2005
@@ -1,14 +1,14 @@
use mysql;
-drop database iBatisNet;
-create database iBatisNet;
+drop database IBatisNet;
+create database IBatisNet;
drop database NHibernate;
create database NHibernate;
-grant all privileges on iBatisNet.* to IBatisNet@'%' identified by 'test';
-grant all privileges on iBatisNet.* to IBatisNet@localhost identified by 'test';
-grant all privileges on iBatisNet.* to IBatisNet@localhost.localdomain identified by 'test';
+grant all privileges on IBatisNet.* to IBatisNet@'%' identified by 'test';
+grant all privileges on IBatisNet.* to IBatisNet@localhost identified by 'test';
+grant all privileges on IBatisNet.* to IBatisNet@localhost.localdomain identified by 'test';
grant all privileges on NHibernate.* to NHibernate@'%' identified by 'test';
grant all privileges on NHibernate.* to NHibernate@localhost identified by 'test';
@@ -21,109 +21,110 @@
/* Date de création : 27/05/2004 20:51:40 */
/*==============================================================*/
-use iBatisNet;
+use IBatisNet;
-drop table if exists ACCOUNTS;
+drop table if exists Accounts;
-drop table if exists CATEGORIES;
+drop table if exists Categories;
-drop table if exists ENUMERATIONS;
+drop table if exists Enumerations;
-drop table if exists LINEITEMS;
+drop table if exists LineItems;
-drop table if exists ORDERS;
+drop table if exists Orders;
-drop table if exists OTHERS;
+drop table if exists Others;
-drop table if exists DOCUMENTS;
+drop table if exists Documents;
/*==============================================================*/
-/* Table : ACCOUNTS */
+/* Table : Accounts */
/*==============================================================*/
-create table ACCOUNTS
+create table Accounts
(
- ACCOUNT_ID int not null,
- ACCOUNT_FIRSTNAME varchar(32) not null,
- ACCOUNT_LASTNAME varchar(32) not null,
- ACCOUNT_EMAIL varchar(128),
- primary key (ACCOUNT_ID)
+ Account_Id int not null,
+ Account_FirstName varchar(32) not null,
+ Account_LastName varchar(32) not null,
+ Account_Email varchar(128),
+ primary key (Account_Id)
) TYPE=INNODB;
/*==============================================================*/
-/* Table : CATEGORIES */
+/* Table : Categories */
/*==============================================================*/
-create table CATEGORIES
+create table Categories
(
- CATEGORY_ID int not null AUTO_INCREMENT,
- CATEGORY_NAME varchar(32),
- CATEGORY_GUID varchar(36),
- primary key (CATEGORY_ID)
+ Category_Id int not null AUTO_INCREMENT,
+ Category_Name varchar(32),
+ Category_Guid varchar(36),
+ primary key (Category_Id)
) TYPE=INNODB;
/*==============================================================*/
-/* Table : ENUMERATIONS */
+/* Table : Enumerations */
/*==============================================================*/
-create table ENUMERATIONS
+create table Enumerations
(
- ENUM_ID int not null,
- ENUM_DAY int not null,
- ENUM_COLOR int not null,
- ENUM_MONTH int,
- primary key (ENUM_ID)
+ Enum_Id int not null,
+ Enum_Day int not null,
+ Enum_Color int not null,
+ Enum_Month int,
+ primary key (Enum_Id)
) TYPE=INNODB;
/*==============================================================*/
-/* Table : LINEITEMS */
+/* Table : LineItems */
/*==============================================================*/
-create table LINEITEMS
+create table LineItems
(
- LINEITEM_ID int not null,
- ORDER_ID int not null,
- LINEITEM_CODE varchar(32) not null,
- LINEITEM_QUANTITY int not null,
- LINEITEM_PRICE decimal(18,2),
- LINEITEM_PICTURE blob,
- primary key (ORDER_ID, LINEITEM_ID)
+ LineItem_Id int not null,
+ Order_Id int not null,
+ LineItem_Code varchar(32) not null,
+ LineItem_Quantity int not null,
+ LineItem_Price decimal(18,2),
+ LineItem_Picture blob,
+ primary key (Order_Id, LineItem_Id)
) TYPE=INNODB;
/*==============================================================*/
-/* Table : ORDERS */
+/* Table : Orders */
/*==============================================================*/
-create table ORDERS
+create table Orders
(
- ORDER_ID int not null,
- ACCOUNT_ID int not null,
- ORDER_DATE datetime,
- ORDER_CARDTYPE varchar(32),
- ORDER_CARDNUMBER varchar(32),
- ORDER_CARDEXPIRY varchar(32),
- ORDER_STREET varchar(32),
- ORDER_CITY varchar(32),
- ORDER_PROVINCE varchar(32),
- ORDER_POSTALCODE varchar(32),
- ORDER_FAVOURITELINEITEM int,
- primary key (ORDER_ID)
+ Order_Id int not null,
+ Account_Id int not null,
+ Order_Date datetime,
+ Order_CardType varchar(32),
+ Order_CardNumber varchar(32),
+ Order_CardExpiry varchar(32),
+ Order_Street varchar(32),
+ Order_City varchar(32),
+ Order_Province varchar(32),
+ Order_PostalCode varchar(32),
+ Order_FavouriteLineItem int,
+ primary key (Order_Id)
) TYPE=INNODB;
/*==============================================================*/
-/* Table : OTHERS */
+/* Table : Others */
/*==============================================================*/
-create table OTHERS
+create table Others
(
- OTHER_INT int,
- OTHER_LONG bigint
+ Other_Int int,
+ Other_Long bigint,
+ Other_Bit bit not null default 0
) TYPE=INNODB;
/*==============================================================*/
-/* Table : DOCUMENTS */
+/* Table : Documents */
/*==============================================================*/
-create table DOCUMENTS
+create table Documents
(
- DOCUMENT_ID int not null,
- DOCUMENT_TITLE varchar(32),
- DOCUMENT_TYPE varchar(32),
- DOCUMENT_PAGENUMBER int,
- DOCUMENT_CITY varchar(32),
+ Document_Id int not null,
+ Document_Title varchar(32),
+ Document_Type varchar(32),
+ Document_PageNumber int,
+ Document_City varchar(32),
primary key (DOCUMENT_ID)
) TYPE=INNODB;
@@ -131,17 +132,17 @@
use NHibernate;
-drop table if exists USERS;
+drop table if exists Users;
/*==============================================================*/
-/* Table : USERS */
+/* Table : Users */
/*==============================================================*/
-create table USERS
+create table Users
(
- LOGONID varchar(20) not null default '0',
- NAME varchar(40) default null,
- PASSWORD varchar(20) default null,
- EMAILADDRESS varchar(40) default null,
- LASTLOGON datetime default null,
- primary key (LOGONID)
+ LogonId varchar(20) not null default '0',
+ Name varchar(40) default null,
+ Password varchar(20) default null,
+ EmailAddress varchar(40) default null,
+ LastLogon datetime default null,
+ primary key (LogonId)
) TYPE=INNODB;
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/account-init.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/account-init.sql?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/account-init.sql (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/account-init.sql Fri Apr 29 16:32:47 2005
@@ -1,14 +1,14 @@
-use iBatisNet;
+use IBatisNet;
-drop table if exists ACCOUNTS;
+drop table if exists Accounts;
-create table ACCOUNTS
+create table Accounts
(
- ACCOUNT_ID int not null,
- ACCOUNT_FIRSTNAME varchar(32) not null,
- ACCOUNT_LASTNAME varchar(32) not null,
- ACCOUNT_EMAIL varchar(128),
- primary key (ACCOUNT_ID)
+ Account_Id int not null,
+ Account_FirstName varchar(32) not null,
+ Account_LastName varchar(32) not null,
+ Account_Email varchar(128),
+ primary key (Account_Id)
) TYPE=INNODB;
INSERT INTO Accounts VALUES(1,'Joe', 'Dalton', 'Joe.Dalton@somewhere.com');
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/account-procedure.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/account-procedure.sql?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/account-procedure.sql (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/account-procedure.sql Fri Apr 29 16:32:47 2005
@@ -1,2 +1,2 @@
-use iBatisNet;
\ No newline at end of file
+use IBatisNet;
\ No newline at end of file
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/category-init.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/category-init.sql?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/category-init.sql (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/category-init.sql Fri Apr 29 16:32:47 2005
@@ -1,12 +1,12 @@
-use iBatisNet;
+use IBatisNet;
-drop table if exists CATEGORIES;
+drop table if exists Categories;
-create table CATEGORIES
+create table Categories
(
- CATEGORY_ID int not null AUTO_INCREMENT,
- CATEGORY_NAME varchar(32),
- CATEGORY_GUID varchar(36),
- primary key (CATEGORY_ID)
+ Category_Id int not null AUTO_INCREMENT,
+ Category_Name varchar(32),
+ Category_Guid varchar(36),
+ primary key (Category_Id)
) TYPE=INNODB;
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/category-procedure.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/category-procedure.sql?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/category-procedure.sql (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/category-procedure.sql Fri Apr 29 16:32:47 2005
@@ -1,2 +1,2 @@
-use iBatisNet;
\ No newline at end of file
+use IBatisNet;
\ No newline at end of file
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/documents-init.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/documents-init.sql?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/documents-init.sql (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/documents-init.sql Fri Apr 29 16:32:47 2005
@@ -1,20 +1,20 @@
-use iBatisNet;
+use IBatisNet;
-drop table if exists DOCUMENTS;
+drop table if exists Documents;
-create table DOCUMENTS
+create table Documents
(
- DOCUMENT_ID int not null,
- DOCUMENT_TITLE varchar(32),
- DOCUMENT_TYPE varchar(32),
- DOCUMENT_PAGENUMBER int,
- DOCUMENT_CITY varchar(32),
+ Document_Id int not null,
+ Document_Title varchar(32),
+ Document_Type varchar(32),
+ Document_PageNumber int,
+ Document_City varchar(32),
primary key (DOCUMENT_ID)
) TYPE=INNODB;
-INSERT INTO DOCUMENTS VALUES (1, 'The World of Null-A', 'Book', 55, null);
-INSERT INTO DOCUMENTS VALUES (2, 'Le Progres de Lyon', 'Newspaper', null , 'Lyon');
-INSERT INTO DOCUMENTS VALUES (3, 'Lord of the Rings', 'Book', 3587, null);
-INSERT INTO DOCUMENTS VALUES (4, 'Le Canard enchaine', 'Tabloid', null , 'Paris');
-INSERT INTO DOCUMENTS VALUES (5, 'Le Monde', 'Broadsheet', null , 'Paris');
-INSERT INTO DOCUMENTS VALUES (6, 'Foundation', 'Monograph', 557, null);
+INSERT INTO Documents VALUES (1, 'The World of Null-A', 'Book', 55, null);
+INSERT INTO Documents VALUES (2, 'Le Progres de Lyon', 'Newspaper', null , 'Lyon');
+INSERT INTO Documents VALUES (3, 'Lord of the Rings', 'Book', 3587, null);
+INSERT INTO Documents VALUES (4, 'Le Canard enchaine', 'Tabloid', null , 'Paris');
+INSERT INTO Documents VALUES (5, 'Le Monde', 'Broadsheet', null , 'Paris');
+INSERT INTO Documents VALUES (6, 'Foundation', 'Monograph', 557, null);
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/enumeration-init.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/enumeration-init.sql?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/enumeration-init.sql (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/enumeration-init.sql Fri Apr 29 16:32:47 2005
@@ -1,15 +1,15 @@
-use iBatisNet;
+use IBatisNet;
-drop table if exists ENUMERATIONS;
+drop table if exists Enumerations;
-create table ENUMERATIONS
+create table Enumerations
(
- ENUM_ID int not null,
- ENUM_DAY int not null,
- ENUM_COLOR int not null,
- ENUM_MONTH int,
- primary key (ENUM_ID)
+ Enum_Id int not null,
+ Enum_Day int not null,
+ Enum_Color int not null,
+ Enum_Month int,
+ primary key (Enum_Id)
) TYPE=INNODB;
INSERT INTO Enumerations VALUES(1, 1, 1, 128);
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/line-item-init.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/line-item-init.sql?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/line-item-init.sql (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/line-item-init.sql Fri Apr 29 16:32:47 2005
@@ -1,17 +1,17 @@
-use iBatisNet;
+use IBatisNet;
-drop table if exists LINEITEMS;
+drop table if exists LineItems;
-create table LINEITEMS
+create table LineItems
(
- LINEITEM_ID int not null,
- ORDER_ID int not null,
- LINEITEM_CODE varchar(32) not null,
- LINEITEM_QUANTITY int not null,
- LINEITEM_PRICE decimal(18,2),
- LINEITEM_PICTURE blob,
- primary key (ORDER_ID, LINEITEM_ID)
+ LineItem_Id int not null,
+ Order_Id int not null,
+ LineItem_Code varchar(32) not null,
+ LineItem_Quantity int not null,
+ LineItem_Price decimal(18,2),
+ LineItem_Picture blob,
+ primary key (Order_Id, LineItem_Id)
) TYPE=INNODB;
INSERT INTO LineItems VALUES (1, 10, 'ESM-34', 1, 45.43, null);
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/order-init.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/order-init.sql?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/order-init.sql (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/order-init.sql Fri Apr 29 16:32:47 2005
@@ -1,19 +1,19 @@
-drop table if exists ORDERS;
+drop table if exists Orders;
-create table ORDERS
+create table Orders
(
- ORDER_ID int not null,
- ACCOUNT_ID int not null,
- ORDER_DATE datetime,
- ORDER_CARDTYPE varchar(32),
- ORDER_CARDNUMBER varchar(32),
- ORDER_CARDEXPIRY varchar(32),
- ORDER_STREET varchar(32),
- ORDER_CITY varchar(32),
- ORDER_PROVINCE varchar(32),
- ORDER_POSTALCODE varchar(32),
- ORDER_FAVOURITELINEITEM int,
- primary key (ORDER_ID)
+ Order_Id int not null,
+ Account_Id int not null,
+ Order_Date datetime,
+ Order_CardType varchar(32),
+ Order_CardNumber varchar(32),
+ Order_CardExpiry varchar(32),
+ Order_Street varchar(32),
+ Order_City varchar(32),
+ Order_Province varchar(32),
+ Order_PostalCode varchar(32),
+ Order_FavouriteLineItem int,
+ primary key (Order_Id)
) TYPE=INNODB;
INSERT INTO Orders VALUES (1, 1, '2003-02-15 8:15:00', 'VISA', '999999999999', '05/03', '11 This Street', 'Victoria', 'BC', 'C4B 4F4',2);
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/other-init.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/other-init.sql?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/other-init.sql (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/other-init.sql Fri Apr 29 16:32:47 2005
@@ -1,13 +1,14 @@
-use iBatisNet;
+use IBatisNet;
-drop table if exists OTHERS;
+drop table if exists Others;
-create table OTHERS
+create table Others
(
- OTHER_INT int,
- OTHER_LONG bigint
+ Other_Int int,
+ Other_Long bigint,
+ Other_Bit bit not null default 0
) TYPE=INNODB;
-INSERT INTO Others VALUES(1, 8888888);
-INSERT INTO Others VALUES(2, 9999999999);
\ No newline at end of file
+INSERT INTO Others VALUES(1, 8888888, 0);
+INSERT INTO Others VALUES(2, 9999999999, 1);
\ No newline at end of file
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/swap-procedure.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/swap-procedure.sql?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/swap-procedure.sql (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/swap-procedure.sql Fri Apr 29 16:32:47 2005
@@ -1,2 +1,2 @@
-use iBatisNet;
\ No newline at end of file
+use IBatisNet;
\ No newline at end of file
Modified: incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/user-init.sql
URL: http://svn.apache.org/viewcvs/incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/user-init.sql?rev=165362&r1=165361&r2=165362&view=diff
==============================================================================
--- incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/user-init.sql (original)
+++ incubator/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Scripts/MySql/user-init.sql Fri Apr 29 16:32:47 2005
@@ -1,14 +1,14 @@
use NHibernate;
-drop table if exists USERS;
+drop table if exists Users;
-create table USERS
+create table Users
(
- LOGONID varchar(20) not null default '0',
- NAME varchar(40) default null,
- PASSWORD varchar(20) default null,
- EMAILADDRESS varchar(40) default null,
- LASTLOGON datetime default null,
- primary key (LOGONID)
+ LogonId varchar(20) not null default '0',
+ Name varchar(40) default null,
+ Password varchar(20) default null,
+ EmailAddress varchar(40) default null,
+ LastLogon datetime default null,
+ primary key (LogonId)
) TYPE=INNODB;