data-api-builder/src/Cli.Tests/Snapshots/EndToEndTests.TestAddingStoredProcedureWithRestMethodsAndGraphQLOperations.verified.txt at 27734bfa267779d772857a75faade9bb1b0e848c · Azure/data-api-builder · 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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
{
  DataSource: {
    DatabaseType: MSSQL,
    Options: {
      set-session-context: true
    }
  },
  Runtime: {
    Rest: {
      Enabled: true,
      Path: /api,
      RequestBodyStrict: true
    },
    GraphQL: {
      Enabled: true,
      Path: /graphql,
      AllowIntrospection: true
    },
    Mcp: {
      Enabled: true,
      Path: /mcp,
      DmlTools: {
        AllToolsEnabled: true,
        DescribeEntities: true,
        CreateRecord: true,
        ReadRecords: true,
        UpdateRecord: true,
        DeleteRecord: true,
        ExecuteEntity: true,
        UserProvidedAllTools: false,
        UserProvidedDescribeEntities: false,
        UserProvidedCreateRecord: false,
        UserProvidedReadRecords: false,
        UserProvidedUpdateRecord: false,
        UserProvidedDeleteRecord: false,
        UserProvidedExecuteEntity: false
      }
    },
    Host: {
      Cors: {
        AllowCredentials: false
      },
      Authentication: {
        Provider: StaticWebApps
      }
    }
  },
  Entities: [
    {
      MyEntity: {
        Source: {
          Object: s001.book,
          Type: stored-procedure,
          Parameters: [
            {
              Name: param1,
              Required: false,
              Default: 123
            },
            {
              Name: param2,
              Required: false,
              Default: hello
            },
            {
              Name: param3,
              Required: false,
              Default: True
            }
          ]
        },
        GraphQL: {
          Singular: MyEntity,
          Plural: MyEntities,
          Enabled: true,
          Operation: Query
        },
        Rest: {
          Methods: [
            Post,
            Put,
            Patch
          ],
          Enabled: true
        },
        Permissions: [
          {
            Role: anonymous,
            Actions: [
              {
                Action: Execute
              }
            ]
          }
        ]
      }
    }
  ]
}