SqlDatabase/Examples/ConfigurationFile/SqlDatabase.dll.config at master · max-ieremenko/SqlDatabase · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <configSections>
    <section name="sqlDatabase"
             type="SqlDatabase.Configuration.AppConfiguration, SqlDatabase"/>
  </configSections>

  <sqlDatabase>

    <!-- default class and method name of assembly scripts -->
    <assemblyScript className="SqlDatabaseScript"
                    methodName="Execute" />

    <!--  global variables, by default the list is empty -->
    <variables>
      <add name="GlobalVariable1"
           value="value1" />
      <add name="GlobalVariable2"
           value="value 2" />
    </variables>

    <!--
      mssql configuration:
      - default scripts to read and update database version
      - few predefined variables, applicable only for mssql, by defult is empty
    -->
    <mssql getCurrentVersion="SELECT value from sys.fn_listextendedproperty('version', default, default, default, default, default, default)"
           setCurrentVersion="EXEC sys.sp_updateextendedproperty @name=N'version', @value=N'{{TargetVersion}}'">
      <variables>
        <add name="MsSqlVariable1"
             value="value1" />
        <add name="MsSqllVariable2"
             value="value 2" />
      </variables>
    </mssql>

    <!--
      pgsql configuration:
      - default scripts to read and update database version
      - few predefined variables, applicable only for pgsql, by defult is empty
      -->
    <pgsql getCurrentVersion="SELECT version FROM public.version WHERE module_name = 'database'"
           setCurrentVersion="UPDATE public.version SET version='{{TargetVersion}}' WHERE module_name = 'database'">
      <variables>
        <add name="PgSqlVariable1"
             value="value1" />
        <add name="PgSqllVariable2"
             value="value 2" />
      </variables>
    </pgsql>

    <!--
      mysql configuration:
      - default scripts to read and update database version
      - few predefined variables, applicable only for mysql, by defult is empty
      -->
    <mysql getCurrentVersion="SELECT version FROM version WHERE module_name = 'database'"
           setCurrentVersion="UPDATE version SET version='{{TargetVersion}}' WHERE module_name = 'database'">
      <variables>
        <add name="MySqlVariable1"
             value="value1" />
        <add name="MySqlVariable2"
             value="value 2" />
      </variables>
    </pgsql>
  </sqlDatabase>
</configuration>