diff options
| author | mokhan <mokhan@da190166-9cfc-4ee1-ae03-434a172be219> | 2009-02-21 21:44:27 +0000 |
|---|---|---|
| committer | mokhan <mokhan@da190166-9cfc-4ee1-ae03-434a172be219> | 2009-02-21 21:44:27 +0000 |
| commit | 1dfdccb8118aeaa3cd844ac8de2a672c93312166 (patch) | |
| tree | 4b19e7f816ab1019f180a46b68572af4b66fe4bc /slips/src/test/Marina.Test/Integration/DataAccess/Utility | |
| parent | 42d66bcab8262c7b8b2452615df535e694a3ec1c (diff) | |
git-svn-id: http://svn.xp-dev.com/svn/mokhan-sait@2 da190166-9cfc-4ee1-ae03-434a172be219
Diffstat (limited to 'slips/src/test/Marina.Test/Integration/DataAccess/Utility')
4 files changed, 92 insertions, 0 deletions
diff --git a/slips/src/test/Marina.Test/Integration/DataAccess/Utility/BoatMother.cs b/slips/src/test/Marina.Test/Integration/DataAccess/Utility/BoatMother.cs new file mode 100644 index 0000000..cb8d7b3 --- /dev/null +++ b/slips/src/test/Marina.Test/Integration/DataAccess/Utility/BoatMother.cs @@ -0,0 +1,19 @@ +using Marina.DataAccess;
+using Marina.DataAccess.Builders;
+using Marina.DataAccess.Schemas;
+using Marina.Infrastructure.Container;
+
+namespace Marina.Test.Integration.DataAccess.Utility {
+ public static class BoatMother {
+ public static void AddBoatsFor( long customerId ) {
+ IInsertQueryBuilder builder = DatabaseInsert.Into( BoatTable.TableName )
+ .AddValue( BoatTable.RegistrationNumber, string.Empty )
+ .AddValue( BoatTable.Manufacturer, string.Empty )
+ .AddValue( BoatTable.ModelYear, string.Empty )
+ .AddValue( BoatTable.Length, string.Empty )
+ .AddValue( BoatTable.CustomerID, customerId.ToString( ) );
+
+ Resolve.DependencyFor< IDatabaseGateway >( ).Execute( builder.Build( ), builder.Build( ), builder.Build( ) );
+ }
+ }
+}
\ No newline at end of file diff --git a/slips/src/test/Marina.Test/Integration/DataAccess/Utility/CustomerMother.cs b/slips/src/test/Marina.Test/Integration/DataAccess/Utility/CustomerMother.cs new file mode 100644 index 0000000..923528a --- /dev/null +++ b/slips/src/test/Marina.Test/Integration/DataAccess/Utility/CustomerMother.cs @@ -0,0 +1,34 @@ +using Marina.DataAccess;
+using Marina.DataAccess.Builders;
+using Marina.DataAccess.Schemas;
+using Marina.Infrastructure.Container;
+
+namespace Marina.Test.Integration.DataAccess.Utility {
+ public static class CustomerMother {
+ public static long CreateCustomerRecord() {
+ IInsertQueryBuilder builder = DatabaseInsert.Into( CustomerTable.TableName )
+ .AddValue( CustomerTable.FirstName, string.Empty )
+ .AddValue( CustomerTable.LastName, string.Empty )
+ .AddValue( CustomerTable.Phone, string.Empty )
+ .AddValue( CustomerTable.City, string.Empty );
+ return Resolve.DependencyFor< IDatabaseGateway >( ).ExecuteScalar( builder.Build( ) );
+ }
+
+ public static long CreateCustomerRecordWith( string username ) {
+ IInsertQueryBuilder builder = DatabaseInsert.Into( CustomerTable.TableName )
+ .AddValue( CustomerTable.FirstName, string.Empty )
+ .AddValue( CustomerTable.LastName, string.Empty )
+ .AddValue( CustomerTable.Phone, string.Empty )
+ .AddValue( CustomerTable.City, string.Empty );
+ long customerId = Resolve.DependencyFor< IDatabaseGateway >( ).ExecuteScalar( builder.Build( ) );
+
+ IQuery insertToAuthTable = DatabaseInsert.Into( AuthorizationTable.TableName )
+ .AddValue( AuthorizationTable.UserName, username )
+ .AddValue( AuthorizationTable.Password, string.Empty )
+ .Build( );
+
+ Resolve.DependencyFor< IDatabaseGateway >( ).Execute( insertToAuthTable );
+ return customerId;
+ }
+ }
+}
\ No newline at end of file diff --git a/slips/src/test/Marina.Test/Integration/DataAccess/Utility/LeaseMother.cs b/slips/src/test/Marina.Test/Integration/DataAccess/Utility/LeaseMother.cs new file mode 100644 index 0000000..1c8b2ec --- /dev/null +++ b/slips/src/test/Marina.Test/Integration/DataAccess/Utility/LeaseMother.cs @@ -0,0 +1,21 @@ +using System;
+using Marina.DataAccess;
+using Marina.DataAccess.Builders;
+using Marina.DataAccess.Schemas;
+using Marina.Infrastructure.Container;
+
+namespace Marina.Test.Integration.DataAccess.Utility {
+ public static class LeaseMother {
+ public static void CreateLeaseFor( long customerId ) {
+ IQuery query = DatabaseInsert
+ .Into( LeaseTable.TableName )
+ .AddValue( LeaseTable.CustomerID, customerId )
+ .AddValue( LeaseTable.EndDate, DateTime.Now.AddDays( 1 ) )
+ .AddValue( LeaseTable.LeaseTypeID, 1 )
+ .AddValue( LeaseTable.SlipID, SlipMother.CreateSlip( ) )
+ .AddValue( LeaseTable.StartDate, DateTime.Now ).Build( );
+
+ Resolve.DependencyFor< IDatabaseGateway >( ).Execute( query );
+ }
+ }
+}
\ No newline at end of file diff --git a/slips/src/test/Marina.Test/Integration/DataAccess/Utility/SlipMother.cs b/slips/src/test/Marina.Test/Integration/DataAccess/Utility/SlipMother.cs new file mode 100644 index 0000000..51cbecb --- /dev/null +++ b/slips/src/test/Marina.Test/Integration/DataAccess/Utility/SlipMother.cs @@ -0,0 +1,18 @@ +using Marina.DataAccess;
+using Marina.DataAccess.Builders;
+using Marina.DataAccess.Schemas;
+using Marina.Infrastructure.Container;
+
+namespace Marina.Test.Integration.DataAccess.Utility {
+ public static class SlipMother {
+ public static long CreateSlip() {
+ IQuery query = DatabaseInsert
+ .Into( SlipTable.TableName )
+ .AddValue( SlipTable.DockID, 1 )
+ .AddValue( SlipTable.Length, 100 )
+ .AddValue( SlipTable.Width, 100 ).Build( );
+
+ return Resolve.DependencyFor< IDatabaseGateway >( ).ExecuteScalar( query );
+ }
+ }
+}
\ No newline at end of file |