Changeset 6794 for branches/GeneralizedQAP

Timestamp:

09/17/11 18:31:34 (13 years ago)

Author:

abeham

Message:

#1619

• Updated Hello (test) service, tested db publishing

Location:

branches/GeneralizedQAP/HeuristicLab.Services.Hello/3.3

Files:

• HelloModel.Designer.cs (added)
• HelloModel.edmx (added)
• HelloService.svc.cs (modified) (2 diffs)
• HeuristicLab.Services.Hello-3.3.csproj (modified) (4 diffs)
• IHelloService.cs (modified) (2 diffs)
• SQLScripts (added)
• SQLScripts/CreateDatabase.sql (added)
• Web.Release.config (modified) (1 diff)
• Web.config (modified) (1 diff)

branches/GeneralizedQAP/HeuristicLab.Services.Hello/3.3/HelloService.svc.cs

@@ -20 +20 @@
 #endregion
 
+
+using System;
 namespace HeuristicLab.Services.Hello {
   public class HelloService : IHelloService {
@@ -25 +27 @@
       return "Hello";
     }
+
+    public string Say(string phrase) {
+      using (HelloEntities context = new HelloEntities()) {
+        Saying s = context.Sayings.CreateObject();
+        s.message = phrase.Length > 256 ? phrase.Substring(0, 256) : phrase;
+        s.date = DateTime.Now;
+        context.Sayings.AddObject(s);
+        context.SaveChanges();
+      }
+      return phrase;
+    }
   }
 }

branches/GeneralizedQAP/HeuristicLab.Services.Hello/3.3/HeuristicLab.Services.Hello-3.3.csproj

@@ -31 +31 @@
     <ErrorReport>prompt</ErrorReport>
     <WarningLevel>4</WarningLevel>
+    <PublishDatabaseSettings>
+      <Objects>
+        <ObjectGroup Name="HelloEntities-Deployment" Order="1" Enabled="True">
+          <Destination Path="Data Source=SERVICES%3bInitial Catalog=HelloDatabase%3bIntegrated Security=True" />
+          <Object Type="dbFullSql" Enabled="False">
+            <PreSource Path="Data Source=LOCALHOST\SQLEXPRESS%3bInitial Catalog=HelloDatabase%3bIntegrated Security=True" ScriptSchema="True" ScriptData="False" CopyAllFullTextCatalogs="False" />
+            <Source Path="obj\Release\AutoScripts\HelloEntities-Deployment_SchemaOnly.sql" Transacted="True" />
+          </Object>
+          <Object Type="dbFullSql" xmlns="" Enabled="False">
+            <Source Path="SQLScripts\CreateDatabase.sql" Transacted="False" />
+          </Object>
+        </ObjectGroup>
+      </Objects>
+    </PublishDatabaseSettings>
   </PropertyGroup>
   <ItemGroup>
     <Reference Include="Microsoft.CSharp" />
+    <Reference Include="System.Data.Entity" />
+    <Reference Include="System.Security" />
     <Reference Include="System.Web.DynamicData" />
     <Reference Include="System.Web.Entity" />
@@ -54 +70 @@
   <ItemGroup>
     <Content Include="HelloService.svc" />
+    <Content Include="SQLScripts\CreateDatabase.sql" />
     <Content Include="Web.config" />
     <Content Include="Web.Debug.config">
@@ -63 +80 @@
   </ItemGroup>
   <ItemGroup>
+    <Compile Include="HelloModel.Designer.cs">
+      <AutoGen>True</AutoGen>
+      <DesignTime>True</DesignTime>
+      <DependentUpon>HelloModel.edmx</DependentUpon>
+    </Compile>
     <Compile Include="HelloService.svc.cs">
       <DependentUpon>HelloService.svc</DependentUpon>
@@ -71 +93 @@
   <ItemGroup>
     <Folder Include="App_Data\" />
+  </ItemGroup>
+  <ItemGroup>
+    <EntityDeploy Include="HelloModel.edmx">
+      <Generator>EntityModelCodeGenerator</Generator>
+      <LastGenOutput>HelloModel.Designer.cs</LastGenOutput>
+    </EntityDeploy>
   </ItemGroup>
   <Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" />

branches/GeneralizedQAP/HeuristicLab.Services.Hello/3.3/IHelloService.cs

@@ -21 +21 @@
 
 using System.ServiceModel;
+using System.ServiceModel.Web;
 
 namespace HeuristicLab.Services.Hello {
@@ -26 +27 @@
   public interface IHelloService {
     [OperationContract]
+    [WebGet(UriTemplate = "SayHello")]
     string SayHello();
+
+    [OperationContract]
+    [WebGet(UriTemplate = "Say/{phrase}")]
+    string Say(string phrase);
   }
 }

branches/GeneralizedQAP/HeuristicLab.Services.Hello/3.3/Web.Release.config

@@ -8 +8 @@
     <compilation xdt:Transform="RemoveAttributes(debug)" />
   </system.web>
+  <connectionStrings>
+    <add xdt:Transform="Replace" name="HelloEntities" connectionString="metadata=res://*/HelloModel.csdl|res://*/HelloModel.ssdl|res://*/HelloModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=SERVICES;Initial Catalog=HelloDatabase;Integrated Security=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
+  </connectionStrings>
 
 </configuration>

branches/GeneralizedQAP/HeuristicLab.Services.Hello/3.3/Web.config

@@ -3 +3 @@
 
   <system.web>
-    <compilation debug="true" targetFramework="4.0" />
+    <compilation debug="true" targetFramework="4.0">
+      <assemblies>
+        <add assembly="System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
+      </assemblies>
+    </compilation>
   </system.web>
+  
   <system.serviceModel>
+    <bindings>
+      <webHttpBinding> <!-- separate bindings are necessary -->
+        <binding name="jsonBinding" />
+        <binding name="xmlBinding" />
+      </webHttpBinding>
+    </bindings>
+    
     <behaviors>
       <serviceBehaviors>
         <behavior>
-          <!-- To avoid disclosing metadata information, set the value below to false and remove the metadata endpoint above before deployment -->
-          <serviceMetadata httpGetEnabled="true"/>
-          <!-- To receive exception details in faults for debugging purposes, set the value below to true.  Set to false before deployment to avoid disclosing exception information -->
-          <serviceDebug includeExceptionDetailInFaults="false"/>
+          <serviceMetadata httpGetEnabled="true" />
+          <serviceDebug includeExceptionDetailInFaults="true" />
         </behavior>
       </serviceBehaviors>
+      
+      <endpointBehaviors>
+        <behavior name="xmlEndpoint">
+          <webHttp helpEnabled="true" defaultOutgoingResponseFormat="Xml" />
+        </behavior>
+        <behavior name="jsonEndpoint"> <!-- do not specify enableWebScript or UriTemplate will not work -->
+          <webHttp helpEnabled="true" defaultOutgoingResponseFormat="Json" />
+        </behavior>
+      </endpointBehaviors>
     </behaviors>
+    
+    <services>
+      <service name="HeuristicLab.Services.Hello.HelloService"> <!-- name needs to match the service entry in the .svc markup file -->
+        <!-- URL: HelloService.svc -->
+        <!-- URL: HelloService.svc?wsdl -->
+        <endpoint name="soap" address="" binding="basicHttpBinding" contract="HeuristicLab.Services.Hello.IHelloService" />
+        <endpoint name="mex" address="mex" binding="mexHttpBinding" contract="IMetadataExchange" />
+        <!-- URL: HelloService.svc/json/... -->
+        <!-- URL: HelloService.svc/json/help -->
+        <endpoint name="restJson" address="json" binding="webHttpBinding" bindingConfiguration="jsonBinding" contract="HeuristicLab.Services.Hello.IHelloService" behaviorConfiguration="jsonEndpoint" />
+        <!-- URL: HelloService.svc/xml/... -->
+        <!-- URL: HelloService.svc/xml/help -->
+        <endpoint name="restXml" address="xml" binding="webHttpBinding" bindingConfiguration="xmlBinding" contract="HeuristicLab.Services.Hello.IHelloService" behaviorConfiguration="xmlEndpoint" />
+      </service>
+    </services>
+    
     <serviceHostingEnvironment multipleSiteBindingsEnabled="true" />
   </system.serviceModel>
- <system.webServer>
-    <modules runAllManagedModulesForAllRequests="true"/>
+  
+  <system.webServer>
+    <modules runAllManagedModulesForAllRequests="true" />
   </system.webServer>
   
+  <connectionStrings>
+    <add name="HelloEntities" connectionString="metadata=res://*/HelloModel.csdl|res://*/HelloModel.ssdl|res://*/HelloModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=LOCALHOST\SQLEXPRESS;Initial Catalog=HelloDatabase;Integrated Security=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
+  </connectionStrings>
 </configuration>