Skip to content

Instantly share code, notes, and snippets.

View steklopod's full-sized avatar
🎯
spot on

Dima Kaltovich steklopod

🎯
spot on
  • Berlin, Germany
View GitHub Profile
@steklopod
steklopod / Open_feb_auth.http
Last active November 29, 2019 12:45
[GIT] и [NPM] команды
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
@steklopod
steklopod / postgres.sql
Last active May 16, 2019 06:52
Примеры работы с POSTGRES (функции и их применение)
---------------------------------
-- Функции для создания писем --
---------------------------------
-------------------
-- MESSAGE GROUP --
-------------------
CREATE OR REPLACE FUNCTION create_close_message_group(external_id_p text, inn_p text)
RETURNS bigint AS
$group_id$
package ru.openbank.marketplace.back.service.credit;
import org.apache.commons.configuration.Configuration;
import org.junit.Before;
import org.junit.Ignore;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.mockito.Mock;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
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;
@steklopod
steklopod / kill_iddle.sql
Last active February 13, 2019 13:44
Kill SQL process
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');
@steklopod
steklopod / Clone_schema_postgres.sql
Created February 13, 2019 09:38
Clone schema postgres
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
@steklopod
steklopod / build.gradle.kts
Created January 9, 2019 08:21
Maven publishing
plugins {
maven
`maven-publish`
}
publishing {
val repositoryUrl: String by project
val repositoryUser: String by project
@steklopod
steklopod / PaymentOrderService.kt
Created December 25, 2018 13:59
Generic Kotlin Service
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"
@steklopod
steklopod / ibm_mq_qith_docker.txt
Last active December 13, 2018 10:18
DOCKER заметки
В 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)
@steklopod
steklopod / ExceptionHandlers.kt
Created November 24, 2018 18:24
ExceptionHandlers
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