github.com/voedger/voedger@v0.0.0-20240520144910-273e84102129/pkg/iextengine/wazero/sql_example_syspkg/system.vsql (about)

     1  -- Copyright (c) 2020-present unTill Pro, Ltd.
     2  
     3  -- note: this schema is for tests only. Voedger sys package uses copy of this schema
     4  
     5  ABSTRACT TABLE CRecord();
     6  ABSTRACT TABLE WRecord();
     7  ABSTRACT TABLE ORecord();
     8  ABSTRACT TABLE CDoc INHERITS CRecord();
     9  ABSTRACT TABLE ODoc INHERITS ORecord();
    10  ABSTRACT TABLE WDoc INHERITS WRecord();
    11  ABSTRACT TABLE CSingleton INHERITS CDoc();
    12  ABSTRACT WORKSPACE Workspace(
    13  	EXTENSION ENGINE WASM(
    14          COMMAND NewWorkspace();
    15      );
    16  );
    17  ALTERABLE WORKSPACE Profile();
    18  
    19  TABLE WorkspaceDescriptor INHERITS CSingleton (
    20  	WSKind qname NOT NULL
    21  );
    22  
    23  TYPE Raw(
    24      Body   varchar(65535)
    25  );
    26  
    27  EXTENSION ENGINE BUILTIN (
    28  
    29      STORAGE Record(
    30          GET         SCOPE(COMMANDS, QUERIES, PROJECTORS),
    31          GETBATCH    SCOPE(COMMANDS, QUERIES, PROJECTORS),
    32          INSERT      SCOPE(COMMANDS),
    33          UPDATE      SCOPE(COMMANDS)
    34      ) ENTITY RECORD; -- used to validate projector state/intents declaration
    35  
    36  
    37      STORAGE View(
    38          GET         SCOPE(COMMANDS, QUERIES, PROJECTORS),
    39          GETBATCH    SCOPE(COMMANDS, QUERIES, PROJECTORS),
    40          READ        SCOPE(QUERIES, PROJECTORS),
    41          INSERT      SCOPE(PROJECTORS),
    42          UPDATE      SCOPE(PROJECTORS)
    43      ) ENTITY VIEW;
    44  
    45      STORAGE WLog(
    46          GET     SCOPE(COMMANDS, QUERIES, PROJECTORS),
    47          READ    SCOPE(QUERIES, PROJECTORS)
    48      );
    49  
    50      STORAGE PLog(
    51          GET     SCOPE(COMMANDS, QUERIES, PROJECTORS),
    52          READ    SCOPE(QUERIES, PROJECTORS)
    53      );
    54  
    55      STORAGE AppSecret(
    56          GET SCOPE(COMMANDS, QUERIES, PROJECTORS)
    57      );
    58  
    59      STORAGE Subject(
    60          GET SCOPE(COMMANDS, QUERIES)
    61      );
    62  
    63      STORAGE Http (
    64          READ SCOPE(QUERIES, PROJECTORS)
    65      );
    66  
    67      STORAGE SendMail(
    68          INSERT SCOPE(PROJECTORS)
    69      );
    70  
    71      STORAGE CmdResult(
    72          INSERT SCOPE(COMMANDS)
    73      );
    74  
    75      STORAGE Arg(
    76  		GET SCOPE(COMMANDS, QUERIES)
    77  	);
    78  )