github.com/voedger/voedger@v0.0.0-20240520144910-273e84102129/pkg/appdefcompat/sql/sys.old.vsql (about)

     1  -- noinspection SqlNoDataSourceInspectionForFile
     2  
     3  -- Copyright (c) 2020-present unTill Pro, Ltd.
     4  
     5  -- note: this schema is for tests only. Voedger sys package uses copy of this schema
     6  IMPORT SCHEMA 'pkg1' AS pkg1;
     7  IMPORT SCHEMA 'pkg2' AS pkg2;
     8  
     9  APPLICATION TEST(
    10  	USE pkg1;
    11  	USE pkg2;
    12  );
    13  
    14  ABSTRACT TABLE CRecord();
    15  ABSTRACT TABLE WRecord();
    16  ABSTRACT TABLE ORecord();
    17  
    18  ABSTRACT TABLE CDoc INHERITS CRecord();
    19  ABSTRACT TABLE ODoc INHERITS ORecord();
    20  ABSTRACT TABLE WDoc INHERITS WRecord();
    21  
    22  ABSTRACT TABLE Singleton INHERITS CDoc();
    23  
    24  ABSTRACT WORKSPACE Workspace (
    25  );
    26  
    27  WORKSPACE SomeWorkspace(
    28      USE TABLE pkg1.*;
    29      USE TABLE pkg2.*;
    30      TYPE CreateLoginParams(
    31          Login                       varchar,
    32          AppName                     varchar,
    33          SubjectKind                 int32,
    34          WSKindInitializationData    varchar(1024),
    35          ProfileCluster              int32,
    36          ProfileToken                int32,
    37          myfield1 ref(pkg1.MyTable1),
    38          myfield2 ref(pkg2.MyTable1)
    39      );
    40      TYPE CreateLoginUnloggedParams(
    41          Email varchar,
    42          Password varchar
    43      );
    44      TABLE OneMoreTable INHERITS CDoc(
    45          A varchar,
    46          B varchar,
    47          C int32,
    48          UNIQUE (B, A)
    49      );
    50      TABLE SomeTable INHERITS CDoc( -- NodeRemoved: removed in new.vsql
    51          A varchar,
    52          B varchar
    53      );
    54      TABLE AnotherOneTable INHERITS CDoc(
    55          A varchar,
    56          B varchar,
    57          C varchar,
    58          UNIQUE (A, B)
    59      );
    60      TYPE SomeType(
    61          A varchar,
    62          B int
    63      );
    64      TYPE SomeType2(
    65          A varchar,
    66          B int,
    67          C int,
    68          D int
    69      );
    70      VIEW SomeView(
    71          A int,
    72          B int,
    73          D int,
    74          E int,
    75          PRIMARY KEY ((A), B)
    76      ) AS RESULT OF Proj1;
    77      TABLE O_Doc INHERITS ODoc (
    78          Fld1 int32
    79      );
    80      EXTENSION ENGINE BUILTIN (
    81          PROJECTOR Proj1 AFTER EXECUTE ON (Orders) INTENTS (View(SomeView));
    82          COMMAND Orders();
    83          COMMAND CreateLogin(CreateLoginParams, UNLOGGED CreateLoginUnloggedParams) RETURNS void;
    84          COMMAND SomeCommand(SomeType, UNLOGGED SomeType) RETURNS SomeType;
    85          QUERY SomeQuery(SomeType) RETURNS SomeType;
    86          COMMAND CmdODoc(O_Doc);
    87      )
    88  );
    89  
    90  ALTERABLE WORKSPACE Profile(
    91      TABLE ProfileTable INHERITS CDoc(-- NodeRemoved: removed in new.vsql
    92          A varchar
    93      );
    94  );
    95  
    96  EXTENSION ENGINE BUILTIN (
    97  
    98      STORAGE Record(
    99          GET         SCOPE(COMMANDS, QUERIES, PROJECTORS),
   100          GETBATCH    SCOPE(COMMANDS, QUERIES, PROJECTORS),
   101          INSERT      SCOPE(COMMANDS),
   102          UPDATE      SCOPE(COMMANDS)
   103      ) ENTITY RECORD; -- used to validate projector state/intents declaration
   104  
   105  
   106      STORAGE View(
   107          GET         SCOPE(COMMANDS, QUERIES, PROJECTORS),
   108          GETBATCH    SCOPE(COMMANDS, QUERIES, PROJECTORS),
   109          READ        SCOPE(QUERIES, PROJECTORS),
   110          INSERT      SCOPE(PROJECTORS),
   111          UPDATE      SCOPE(PROJECTORS)
   112      ) ENTITY VIEW;
   113  
   114      STORAGE WLog(
   115          GET     SCOPE(COMMANDS, QUERIES, PROJECTORS),
   116          READ    SCOPE(QUERIES, PROJECTORS)
   117      );
   118  
   119      STORAGE PLog(
   120          GET     SCOPE(COMMANDS, QUERIES, PROJECTORS),
   121          READ    SCOPE(QUERIES, PROJECTORS)
   122      );
   123  
   124      STORAGE AppSecret(
   125          GET SCOPE(COMMANDS, QUERIES, PROJECTORS)
   126      );
   127  
   128      STORAGE Subject(
   129          GET SCOPE(COMMANDS, QUERIES)
   130      );
   131  
   132      STORAGE Http (
   133          READ SCOPE(QUERIES, PROJECTORS)
   134      );
   135  
   136      STORAGE SendMail(
   137          INSERT SCOPE(PROJECTORS)
   138      );
   139  
   140      STORAGE CmdResult(
   141          INSERT SCOPE(COMMANDS)
   142      );
   143  
   144  )