Skip to content

Commit f751f18

Browse files
dmelnikovdmelnikov
committed
Update providers: MS SQL, RavenDB, MongoDB
Add providers: Oracle, MySQL, PostgreSQL
1 parent 2343d15 commit f751f18

60 files changed

Lines changed: 5602 additions & 44 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎Provider for MS SQL Server/DbSchemePersistenceProvider.cs‎

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -46,23 +46,23 @@ public SchemeDefinition<XElement> GetProcessSchemeBySchemeId(Guid schemeId)
4646
if (processScheme == null || string.IsNullOrEmpty(processScheme.Scheme))
4747
throw new SchemeNotFoundException();
4848

49-
return new SchemeDefinition<XElement>(schemeId, XElement.Parse(processScheme.Scheme), processScheme.IsObsolete, processScheme.DefiningParameters);
49+
return new SchemeDefinition<XElement>(schemeId, processScheme.SchemeCode, XElement.Parse(processScheme.Scheme), processScheme.IsObsolete, processScheme.DefiningParameters);
5050
}
5151

52-
public SchemeDefinition<XElement> GetProcessSchemeWithParameters(string SchemeCode, IDictionary<string, object> parameters)
52+
public SchemeDefinition<XElement> GetProcessSchemeWithParameters(string schemeCode, IDictionary<string, object> parameters)
5353
{
54-
return GetProcessSchemeWithParameters(SchemeCode, parameters, false);
54+
return GetProcessSchemeWithParameters(schemeCode, parameters, false);
5555
}
5656

57-
public SchemeDefinition<XElement> GetProcessSchemeWithParameters(string SchemeCode, IDictionary<string,object> parameters, bool ignoreObsolete)
57+
public SchemeDefinition<XElement> GetProcessSchemeWithParameters(string schemeCode, IDictionary<string,object> parameters, bool ignoreObsolete)
5858
{
5959
IEnumerable<WorkflowProcessScheme> processSchemes;
6060
var definingParameters = SerializeParameters(parameters);
6161
var hash = HashHelper.GenerateStringHash(definingParameters);
6262

6363
using (var context = CreateContext())
6464
{
65-
processSchemes = context.WorkflowProcessSchemes.Where(pss => pss.SchemeCode == SchemeCode && pss.DefiningParametersHash == hash && (!ignoreObsolete || !pss.IsObsolete)).ToList();
65+
processSchemes = context.WorkflowProcessSchemes.Where(pss => pss.SchemeCode == schemeCode && pss.DefiningParametersHash == hash && (!ignoreObsolete || !pss.IsObsolete)).ToList();
6666
}
6767

6868
if (processSchemes.Count() < 1)
@@ -71,12 +71,12 @@ public SchemeDefinition<XElement> GetProcessSchemeWithParameters(string SchemeCo
7171
if (processSchemes.Count() == 1)
7272
{
7373
var scheme = processSchemes.First();
74-
return new SchemeDefinition<XElement>(scheme.Id, XElement.Parse(scheme.Scheme),scheme.IsObsolete);
74+
return new SchemeDefinition<XElement>(scheme.Id, schemeCode, XElement.Parse(scheme.Scheme), scheme.IsObsolete);
7575
}
7676

7777
foreach (var processScheme in processSchemes.Where(processScheme => processScheme.DefiningParameters == definingParameters))
7878
{
79-
return new SchemeDefinition<XElement>(processScheme.Id, XElement.Parse(processScheme.Scheme), processScheme.IsObsolete);
79+
return new SchemeDefinition<XElement>(processScheme.Id, schemeCode, XElement.Parse(processScheme.Scheme), processScheme.IsObsolete);
8080
}
8181

8282
throw new SchemeNotFoundException();

‎Provider for MS SQL Server/OptimaJet.Workflow.DbPersistence.csproj‎

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -25,10 +25,12 @@
2525
<PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
2626
<DebugType>pdbonly</DebugType>
2727
<Optimize>true</Optimize>
28-
<OutputPath>bin\Release\</OutputPath>
28+
<OutputPath>..\DLL\</OutputPath>
2929
<DefineConstants>TRACE</DefineConstants>
3030
<ErrorReport>prompt</ErrorReport>
3131
<WarningLevel>4</WarningLevel>
32+
<DocumentationFile>
33+
</DocumentationFile>
3234
</PropertyGroup>
3335
<PropertyGroup>
3436
<SignAssembly>true</SignAssembly>
@@ -93,6 +95,7 @@
9395
</None>
9496
</ItemGroup>
9597
<ItemGroup>
98+
<Content Include="Scripts\update_1_4_to_1_4_3.sql" />
9699
<Content Include="Scripts\update_1_3_to_1_4.sql" />
97100
<Content Include="Scripts\CreatePersistenceObjects.sql" />
98101
<Content Include="Scripts\CreatePersistenceObjectsForAzureSQL.sql" />

‎Provider for MS SQL Server/Properties/AssemblyInfo.cs‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -32,5 +32,5 @@
3232
// You can specify all the values or you can default the Build and Revision Numbers
3333
// by using the '*' as shown below:
3434
// [assembly: AssemblyVersion("1.0.*")]
35-
[assembly: AssemblyVersion("1.4.1.3")]
36-
[assembly: AssemblyFileVersion("1.4.1.3")]
35+
[assembly: AssemblyVersion("1.4.3.0")]
36+
[assembly: AssemblyFileVersion("1.4.3.0")]

‎Provider for MS SQL Server/Properties/Settings.settings‎

Lines changed: 0 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -10,13 +10,5 @@
1010
&lt;/SerializableConnectionString&gt;</DesignTimeValue>
1111
<Value Profile="(Default)">Data Source=(local)\SQL2012;Initial Catalog=SampleWorkflowEngineNET;Integrated Security=True;User ID=sa</Value>
1212
</Setting>
13-
<Setting Name="SampleWorkflowEngineNETConnectionString" Type="(Connection string)" Scope="Application">
14-
<DesignTimeValue Profile="(Default)">&lt;?xml version="1.0" encoding="utf-16"?&gt;
15-
&lt;SerializableConnectionString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;
16-
&lt;ConnectionString&gt;Data Source=(local)\SQL2012;Initial Catalog=SampleWorkflowEngineNET;Integrated Security=True;User ID=sa;Password=1&lt;/ConnectionString&gt;
17-
&lt;ProviderName&gt;System.Data.SqlClient&lt;/ProviderName&gt;
18-
&lt;/SerializableConnectionString&gt;</DesignTimeValue>
19-
<Value Profile="(Default)">Data Source=(local)\SQL2012;Initial Catalog=SampleWorkflowEngineNET;Integrated Security=True;User ID=sa;Password=1</Value>
20-
</Setting>
2113
</Settings>
2214
</SettingsFile>

‎Provider for MS SQL Server/Scripts/CreatePersistenceObjects.sql‎

Lines changed: 6 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,9 @@
11
/*
22
Company: OptimaJet
3-
Project: WorkflowEngine.NET 1.4
3+
Project: WorkflowEngine.NET Provider for MSSQL
4+
Version: 1.4.3
45
File: CreatePersistenceObjects.sql
6+
57
*/
68

79

@@ -29,7 +31,7 @@ IF NOT EXISTS (SELECT 1 FROM [INFORMATION_SCHEMA].[TABLES] WHERE [TABLE_NAME] =
2931
BEGIN
3032
CREATE TABLE [WorkflowProcessInstance](
3133
[Id] [uniqueidentifier] NOT NULL,
32-
[StateName] [nvarchar](max) NOT NULL,
34+
[StateName] [nvarchar](max) NULL,
3335
[ActivityName] [nvarchar](max) NOT NULL,
3436
[SchemeId] [uniqueidentifier] NULL,
3537
[PreviousState] [nvarchar](max) NULL,
@@ -69,8 +71,8 @@ BEGIN
6971
CREATE TABLE [WorkflowProcessTransitionHistory](
7072
[Id] [uniqueidentifier] NOT NULL,
7173
[ProcessId] [uniqueidentifier] NOT NULL,
72-
[ExecutorIdentityId] [nvarchar](max) NOT NULL,
73-
[ActorIdentityId] [nvarchar](max) NOT NULL,
74+
[ExecutorIdentityId] [nvarchar](max) NULL,
75+
[ActorIdentityId] [nvarchar](max) NULL,
7476
[FromActivityName] [nvarchar](max) NOT NULL,
7577
[ToActivityName] [nvarchar](max) NOT NULL,
7678
[ToStateName] [nvarchar](max) NULL,

‎Provider for MS SQL Server/Scripts/CreatePersistenceObjectsForAzureSQL.sql‎

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,7 @@
11
/*
22
Company: OptimaJet
3-
Project: WorkflowEngine.NET 1.4 For Azure
3+
Project: WorkflowEngine.NET Provider for Azure
4+
Version: 1.4.3
45
File: CreatePersistenceObjectsForAzure.sql
56
*/
67

‎Provider for MS SQL Server/Scripts/DropPersistenceObjects.sql‎

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,7 @@
11
/*
22
Company: OptimaJet
3-
Project: WorkflowEngine.NET 1.3
3+
Project: WorkflowEngine.NET Provider for MSSQL
4+
Version: 1.4.3
45
File: DropPersistenceObjects.sql
56
*/
67

‎Provider for MS SQL Server/Scripts/update_1_4_to_1_4_3.sql‎

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,4 @@
1+
ALTER TABLE WorkflowProcessInstance ALTER COLUMN StateName nvarchar(max) NULL
2+
ALTER TABLE WorkflowProcessTransitionHistory ALTER COLUMN ExecutorIdentityId nvarchar(max) NULL
3+
ALTER TABLE WorkflowProcessTransitionHistory ALTER COLUMN ActorIdentityId nvarchar(max) NULL
4+
ALTER TABLE WorkflowProcessTransitionHistory ALTER COLUMN FromStateName nvarchar(max) NULL

‎Provider for MS SQL Server/WorkflowPersistenceModel.dbml‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<?xml version="1.0" encoding="utf-8"?><Database Name="SampleWorkflowEngineNET" Class="WorkflowPersistenceModelDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
2-
<Connection Mode="AppSettings" ConnectionString="Data Source=(local)\SQL2012;Initial Catalog=SampleWorkflowEngineNET;Integrated Security=True;User ID=sa" SettingsObjectName="OptimaJet.Workflow.DbPersistence.Properties.Settings" SettingsPropertyName="SampleWorkflowEngineNETConnectionString" Provider="System.Data.SqlClient" />
2+
<Connection Mode="AppSettings" ConnectionString="Data Source=(local)\SQL2012;Initial Catalog=SampleWorkflowEngineNET;Integrated Security=True;User ID=sa" SettingsObjectName="OptimaJet.Workflow.DbPersistence.Properties.Settings" SettingsPropertyName="SampleWorkflowEngineNETConnectionString1" Provider="System.Data.SqlClient" />
33
<Table Name="dbo.WorkflowProcessInstancePersistence" Member="WorkflowProcessInstancePersistences">
44
<Type Name="WorkflowProcessInstancePersistence">
55
<Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
@@ -34,7 +34,7 @@
3434
<Table Name="dbo.WorkflowProcessInstance" Member="WorkflowProcessInstances">
3535
<Type Name="WorkflowProcessInstance">
3636
<Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
37-
<Column Name="StateName" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
37+
<Column Name="StateName" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="true" />
3838
<Column Name="ActivityName" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
3939
<Column Name="SchemeId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
4040
<Column Name="PreviousState" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
@@ -65,8 +65,8 @@
6565
<Type Name="WorkflowProcessTransitionHistory">
6666
<Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
6767
<Column Name="ProcessId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
68-
<Column Name="ExecutorIdentityId" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
69-
<Column Name="ActorIdentityId" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
68+
<Column Name="ExecutorIdentityId" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="true" />
69+
<Column Name="ActorIdentityId" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="true" />
7070
<Column Name="FromActivityName" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
7171
<Column Name="ToActivityName" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
7272
<Column Name="ToStateName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />

‎Provider for MS SQL Server/WorkflowPersistenceModel.designer.cs‎

Lines changed: 3 additions & 3 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

0 commit comments

Comments
 (0)