Free cookie consent management tool by TermsFeed Policy Generator

Ignore:
Timestamp:
04/17/09 13:11:13 (15 years ago)
Author:
svonolfe
Message:

Updated PluginInfoAdapter, added ER model (#372)

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/sources/HeuristicLab.Hive.Server.ADODataAccess/3.2/dsHiveServer.xsd

    r1577 r1592  
    717717                <DeleteCommand>
    718718                  <DbCommand CommandType="Text" ModifiedByUser="false">
    719                     <CommandText>DELETE FROM [dbo].[PluginInfo] WHERE (([PluginId] = @Original_PluginId) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Version = 1 AND [Version] IS NULL) OR ([Version] = @Original_Version)) AND ((@IsNull_BuildDate = 1 AND [BuildDate] IS NULL) OR ([BuildDate] = @Original_BuildDate)))</CommandText>
     719                    <CommandText>DELETE FROM [PluginInfo] WHERE (([PluginId] = @Original_PluginId) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Version = 1 AND [Version] IS NULL) OR ([Version] = @Original_Version)) AND ((@IsNull_BuildDate = 1 AND [BuildDate] IS NULL) OR ([BuildDate] = @Original_BuildDate)))</CommandText>
    720720                    <Parameters>
    721721                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PluginId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PluginId" SourceColumnNullMapping="false" SourceVersion="Original" />
    … …  
    725725                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Version" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Version" SourceColumnNullMapping="false" SourceVersion="Original" />
    726726                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BuildDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuildDate" SourceColumnNullMapping="true" SourceVersion="Original" />
    727                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BuildDate" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BuildDate" SourceColumnNullMapping="false" SourceVersion="Original" />
     727                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_BuildDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="BuildDate" SourceColumnNullMapping="false" SourceVersion="Original" />
    728728                    </Parameters>
    729729                  </DbCommand>
    … …  
    731731                <InsertCommand>
    732732                  <DbCommand CommandType="Text" ModifiedByUser="false">
    733                     <CommandText>INSERT INTO [dbo].[PluginInfo] ([PluginId], [Name], [Version], [BuildDate]) VALUES (@PluginId, @Name, @Version, @BuildDate);
     733                    <CommandText>INSERT INTO [PluginInfo] ([PluginId], [Name], [Version], [BuildDate]) VALUES (@PluginId, @Name, @Version, @BuildDate);
    734734SELECT PluginId, Name, Version, BuildDate FROM PluginInfo WHERE (PluginId = @PluginId)</CommandText>
    735735                    <Parameters>
    … …  
    737737                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
    738738                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Version" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Version" SourceColumnNullMapping="false" SourceVersion="Current" />
    739                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BuildDate" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BuildDate" SourceColumnNullMapping="false" SourceVersion="Current" />
     739                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@BuildDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="BuildDate" SourceColumnNullMapping="false" SourceVersion="Current" />
    740740                    </Parameters>
    741741                  </DbCommand>
    … …  
    743743                <SelectCommand>
    744744                  <DbCommand CommandType="Text" ModifiedByUser="true">
    745                     <CommandText>SELECT PluginId, Name, Version, BuildDate FROM PluginInfo</CommandText>
     745                    <CommandText>SELECT * FROM PluginInfo</CommandText>
    746746                    <Parameters />
    747747                  </DbCommand>
    … …  
    749749                <UpdateCommand>
    750750                  <DbCommand CommandType="Text" ModifiedByUser="false">
    751                     <CommandText>UPDATE [dbo].[PluginInfo] SET [PluginId] = @PluginId, [Name] = @Name, [Version] = @Version, [BuildDate] = @BuildDate WHERE (([PluginId] = @Original_PluginId) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Version = 1 AND [Version] IS NULL) OR ([Version] = @Original_Version)) AND ((@IsNull_BuildDate = 1 AND [BuildDate] IS NULL) OR ([BuildDate] = @Original_BuildDate)));
     751                    <CommandText>UPDATE [PluginInfo] SET [PluginId] = @PluginId, [Name] = @Name, [Version] = @Version, [BuildDate] = @BuildDate WHERE (([PluginId] = @Original_PluginId) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Version = 1 AND [Version] IS NULL) OR ([Version] = @Original_Version)) AND ((@IsNull_BuildDate = 1 AND [BuildDate] IS NULL) OR ([BuildDate] = @Original_BuildDate)));
    752752SELECT PluginId, Name, Version, BuildDate FROM PluginInfo WHERE (PluginId = @PluginId)</CommandText>
    753753                    <Parameters>
    … …  
    755755                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
    756756                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Version" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Version" SourceColumnNullMapping="false" SourceVersion="Current" />
    757                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BuildDate" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BuildDate" SourceColumnNullMapping="false" SourceVersion="Current" />
     757                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@BuildDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="BuildDate" SourceColumnNullMapping="false" SourceVersion="Current" />
    758758                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PluginId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PluginId" SourceColumnNullMapping="false" SourceVersion="Original" />
    759759                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
    … …  
    762762                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Version" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Version" SourceColumnNullMapping="false" SourceVersion="Original" />
    763763                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BuildDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuildDate" SourceColumnNullMapping="true" SourceVersion="Original" />
    764                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BuildDate" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BuildDate" SourceColumnNullMapping="false" SourceVersion="Original" />
     764                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_BuildDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="BuildDate" SourceColumnNullMapping="false" SourceVersion="Original" />
    765765                    </Parameters>
    766766                  </DbCommand>
    … …  
    778778                <SelectCommand>
    779779                  <DbCommand CommandType="Text" ModifiedByUser="true">
    780                     <CommandText>SELECT * FROM PluginInfo WHERE (PluginId = @Id)</CommandText>
     780                    <CommandText>SELECT BuildDate, Name, PluginId, Version FROM PluginInfo WHERE (PluginId = @Id)</CommandText>
    781781                    <Parameters>
    782782                      <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="PluginId" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.PluginInfo" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="PluginId" SourceColumnNullMapping="false" SourceVersion="Current" />
    783783                    </Parameters>
     784                  </DbCommand>
     785                </SelectCommand>
     786              </DbSource>
     787              <DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.PluginInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByNameVersionBuilddate" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByNameVersionBuilddate" GeneratorSourceName="FillByNameVersionBuilddate" GetMethodModifier="Public" GetMethodName="GetDataByNameVersionBuilddate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByNameVersionBuilddate" UserSourceName="FillByNameVersionBuilddate">
     788                <SelectCommand>
     789                  <DbCommand CommandType="Text" ModifiedByUser="true">
     790                    <CommandText>SELECT BuildDate, Name, PluginId, Version FROM PluginInfo WHERE (Name = @Name) AND (Version = @Version) AND (BuildDate = @BuildDate)</CommandText>
     791                    <Parameters>
     792                      <Parameter AllowDbNull="true" AutogeneratedName="Name" ColumnName="Name" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.PluginInfo" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
     793                      <Parameter AllowDbNull="true" AutogeneratedName="Version" ColumnName="Version" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.PluginInfo" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Version" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Version" SourceColumnNullMapping="false" SourceVersion="Current" />
     794                      <Parameter AllowDbNull="true" AutogeneratedName="BuildDate" ColumnName="BuildDate" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.PluginInfo" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@BuildDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="BuildDate" SourceColumnNullMapping="false" SourceVersion="Current" />
     795                    </Parameters>
     796                  </DbCommand>
     797                </SelectCommand>
     798              </DbSource>
     799              <DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.PluginInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByOrphaned" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByOrphaned" GeneratorSourceName="FillByOrphaned" GetMethodModifier="Public" GetMethodName="GetDataByOrphaned" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByOrphaned" UserSourceName="FillByOrphaned">
     800                <SelectCommand>
     801                  <DbCommand CommandType="Text" ModifiedByUser="true">
     802                    <CommandText>SELECT BuildDate, Name, PluginId, Version FROM PluginInfo WHERE (NOT EXISTS (SELECT JobId, PluginId FROM RequiredPlugins WHERE (PluginId = PluginInfo.PluginId)))</CommandText>
     803                    <Parameters />
    784804                  </DbCommand>
    785805                </SelectCommand>
    … …  
    915935                </xs:simpleType>
    916936              </xs:element>
    917               <xs:element name="BuildDate" msprop:Generator_UserColumnName="BuildDate" msprop:Generator_ColumnVarNameInTable="columnBuildDate" msprop:Generator_ColumnPropNameInRow="BuildDate" msprop:Generator_ColumnPropNameInTable="BuildDateColumn" minOccurs="0">
    918                 <xs:simpleType>
    919                   <xs:restriction base="xs:string">
    920                     <xs:maxLength value="20" />
    921                   </xs:restriction>
    922                 </xs:simpleType>
    923               </xs:element>
     937              <xs:element name="BuildDate" msprop:Generator_UserColumnName="BuildDate" msprop:Generator_ColumnVarNameInTable="columnBuildDate" msprop:Generator_ColumnPropNameInRow="BuildDate" msprop:Generator_ColumnPropNameInTable="BuildDateColumn" type="xs:dateTime" minOccurs="0" />
    924938            </xs:sequence>
    925939          </xs:complexType>
Note: See TracChangeset for help on using the changeset viewer.