-- 1.1.init-application.sql

insert into TB_DEV_APPLICATION (ID, DELETED, ADD_ACCOUNT, NAME, DESCRIPTION, ENABLED, URL, ICON, SYSTEM_ID, ABILITY_COUNT, APPLICATION_IDENTIFICATION)
values ('0', 0, 'init', '示例', '示例', 1, '', '', '1', 0, '0');


select CONCAT(
  'INSERT INTO \`TB_DEV_APPLICATION\` (ID, DELETED, NAME, DESCRIPTION, URL, SYSTEM_ID, APPLICATION_IDENTIFICATION) VALUES',
  '(\'cas_server-', ID, '\',\'1\',\'',NAME, '\',\'',DESCRIPTION,'\',\'', IFNULL(INFORMATION_URL,''),'\',\'','1', '\',\'', APPLICATION_ID , '\');') as INSERT_SQL
from cas_server.TB_SERVICE
where DELETED = 0

union

select CONCAT(
  'INSERT INTO \`TB_DEV_APPLICATION\` (ID, DELETED, NAME, DESCRIPTION, URL, SYSTEM_ID, APPLICATION_IDENTIFICATION) VALUES ',
  '(\'message-',ID,'\',\'1\',\'',NAME,'\',\'', IFNULL(DESCRIPTION,''),'\',\'', IFNULL(URL,''),'\',\'','1','\',\'',APP_ID,'\');') as INSERT_SQL
from message.ACCESS_APP
where DELETED = 0 AND APP_ID IS NOT NULL


select CONCAT(
  'INSERT INTO \`TB_DEV_APPLICATION_ABILITY_USAGE\` (ID, COMPANY_ID, DELETED, APPLICATION_ID, ABILITY_ID, APPLY_TIME,ABILITY_SETTINGS) VALUES (',
  '\'cas_server-',ID,'cas','\',\'',' 1\', \'0','\',\'', ID,'\',\'', 'cas\', \'2020-12-22 15:32:43\',\'',
  '{"logoutType":"',IFNULL(LOGOUT_TYPE,''),'","applicationDomain":"',IFNULL(APPLICATION_DOMAIN,''),'","addTime":1608538919314,"description":"',IFNULL(DESCRIPTION,''),
  '","externalId":"',IFNULL(EXTERNAL_ID,''),'","informationUrl":"',IFNULL(INFORMATION_URL,''),'","enabled":true,"registeredServiceId":',IFNULL(REGISTERED_SERVICE_ID,''),
  ',"companyId":"1","responseType":"',RESPONSE_TYPE,'","deleted":false,"ssoEnabled":',IF(SSO_ENABLED = 1,'true','false'),',"idTokenEnabled":',IF(ID_TOKEN_ENABLED = 1,'true','false'),
  ',"jwtAsServiceTicket":',IF(JWT_AS_SERVICE_TICKET = 1,'true','false'),',"logoutUrl":"',IFNULL(LOGOUT_URL,''),'","name":"',NAME,
  '","id":"',ID,'","addAccount":"admin","applicationId":"',IFNULL(APPLICATION_ID,''),'","serviceId":"',IFNULL(SERVICE_ID,''),'","requireAllAttributes":',IFNULL(REQUIRE_ALL_ATTRIBUTES,'1'),
  '}',
  '\');'
) as INSERT_SQL
from cas_server.TB_SERVICE
where DELETED = '0'
;