This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--------------------------------- | |
-- Функции для создания писем -- | |
--------------------------------- | |
------------------- | |
-- MESSAGE GROUP -- | |
------------------- | |
CREATE OR REPLACE FUNCTION create_close_message_group(external_id_p text, inn_p text) | |
RETURNS bigint AS | |
$group_id$ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
GET http://localhost:11218/webapi-2.1/rko/ | |
Authorization: Bearer sso_1.0_dev_123 | |
http://localhost:11223/ | |
# Обновить зависимости в `package.json` | |
# npm install -g npm-check-updates | |
ncu -u | |
npm install | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import org.joda.time.DateTime; | |
import org.joda.time.DateTimeZone; | |
import org.joda.time.LocalDateTime; | |
import org.joda.time.format.DateTimeFormat; | |
import org.joda.time.format.DateTimeFormatter; | |
import javax.xml.datatype.DatatypeConfigurationException; | |
import javax.xml.datatype.DatatypeConstants; | |
import javax.xml.datatype.DatatypeFactory; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT * | |
FROM pg_stat_activity | |
WHERE state = 'active'; | |
SELECT pg_terminate_backend(pid) | |
FROM pg_stat_activity | |
WHERE datname = 'payhub' | |
AND pid <> pg_backend_pid() | |
AND state in ('active'); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE OR REPLACE FUNCTION clone_schema(source_schema text, dest_schema text) RETURNS void AS | |
$BODY$ | |
DECLARE | |
objeto text; | |
buffer text; | |
BEGIN | |
EXECUTE 'CREATE SCHEMA ' || dest_schema; | |
FOR objeto IN | |
SELECT TABLE_NAME::text FROM information_schema.TABLES WHERE table_schema = source_schema |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
plugins { | |
maven | |
`maven-publish` | |
} | |
publishing { | |
val repositoryUrl: String by project | |
val repositoryUser: String by project |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
abstract class PaymentOrderCommon<AnyChildOfOrderEsbRequest : OrderEsbRequest> { | |
private val esbSystemId = "ESB" | |
private val okStatusValue = "ok" | |
private val absTimeoutErrorCode = "450" | |
private val absTimeoutErrorMessage = "5NT не ответил по таймауту" | |
private val defaultEsbTimeOutErrorCode = "timeOut" | |
private val defaultEsbTimeOutErrorMessage = "Таймаут при обращении в ESB" | |
private val defaultEsbErrorCode = "error" | |
private val defaultEsbErrorMessage = "Ошибка при обращении в ESB" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import com.fasterxml.jackson.databind.DeserializationFeature | |
import com.fasterxml.jackson.databind.ObjectMapper | |
import com.fasterxml.jackson.module.kotlin.readValue | |
import org.junit.jupiter.api.Assertions.* | |
import org.junit.jupiter.api.BeforeAll | |
import org.junit.jupiter.api.Disabled | |
import org.junit.jupiter.api.Test | |
import org.junit.jupiter.api.TestInstance | |
import org.junit.jupiter.api.extension.ExtendWith |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package ru.gazprombank.omnichannel.clientservice.configuration | |
import com.fasterxml.jackson.core.JsonGenerator | |
import com.fasterxml.jackson.databind.JsonSerializer | |
import com.fasterxml.jackson.databind.SerializerProvider | |
import com.fasterxml.jackson.databind.annotation.JsonSerialize | |
import org.springframework.http.HttpStatus | |
import org.springframework.web.bind.annotation.ControllerAdvice | |
import org.springframework.web.bind.annotation.ExceptionHandler | |
import org.springframework.web.bind.annotation.ResponseBody |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
В PowerShell, запустив как админ (для IBM MQ): | |
Enable-WindowsOptionalFeature –Online -FeatureName Microsoft-Hyper-V –All -NoRestart | |
bcdedit /set hypervisorlaunchtype auto | |
ЗАПУСК очереди: | |
docker run -e LICENSE=accept -e MQ_QMGR_NAME=QM1 -p 1414:1414 -p 9443:9443 ibmcom/mq | |
ОСТАНОВИТЬ ВСЕ: | |
docker rm -f $(docker ps -a -q) |