AccountExchGroupCapStrat

V8 Message Definiton

METADATA

Attribute	Value
Topic	5120-srse-gateway
MLink Token	ConfigGateway
Product	SRConfigGateway
accessType	SELECT,UPDATE,INSERT,DELETE
MLink Endpoint	MLink-Live

Table Definition

Field	Type	Key	Default Value	Comment
templateName	VARCHAR(32)	PRI	''
clientFirm	VARCHAR(16)	PRI	''
CapStrategyIDList	JSON		'JSON_ARRAY()'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
templateName	1
clientFirm	2

JSON Block (CapStrategyIDList)

Field	Type	Comment
exDest	enum - exDest	exchange
capStrategyID	enum - capStrategyID	client cap strategy ID if any

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRConfigGateway`.`MsgAccountExchGroupCapStrat` (
    `templateName` VARCHAR(32) NOT NULL DEFAULT '',
    `clientFirm` VARCHAR(16) NOT NULL DEFAULT '',
    `CapStrategyIDList` JSON NOT NULL DEFAULT JSON_ARRAY() CHECK(JSON_VALID(CapStrategyIDList)),
    PRIMARY KEY USING HASH (`templateName`,`clientFirm`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='';

SELECT TABLE EXAMPLE QUERY

SELECT
    `templateName`,
    `clientFirm`,
    `CapStrategyIDList`
FROM `SRConfigGateway`.`MsgAccountExchGroupCapStrat`
WHERE 
    /* Replace with a VARCHAR(32) */ 
    `templateName` = 'Example_templateName'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

UPDATE TABLE EXAMPLE QUERY

UPDATE `SRConfigGateway`.`MsgAccountExchGroupCapStrat` 
SET
    /* Replace with a JSON */
    `CapStrategyIDList` = '{"key": "value"}'
WHERE
    /* Replace with a VARCHAR(32) */ 
    `templateName` = 'Example_templateName'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

INSERT TABLE EXAMPLE QUERY

INSERT INTO `SRConfigGateway`.`MsgAccountExchGroupCapStrat`(
    /* Replace with a VARCHAR(32) */ 
    `templateName`,
    /* Replace with a VARCHAR(16) */ 
    `clientFirm`,
    /* Replace with a JSON */
    `CapStrategyIDList`
) 
VALUES(
    'Example_templateName',
    'Example_clientFirm',
    '{"key": "value"}'
);

DELETE TABLE EXAMPLE QUERY

DELETE FROM `SRConfigGateway`.`MsgAccountExchGroupCapStrat` 
WHERE
    /* Replace with a VARCHAR(32) */ 
    `templateName` = 'Example_templateName'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

Doc Columns Query

SELECT * FROM SRConfigGateway.doccolumns WHERE TABLE_NAME='AccountExchGroupCapStrat' ORDER BY ordinal_position ASC;