v-vashchenko’s gists

v-vashchenko / gist:2b27fc4ccf7dea5600c1dfbbbc927b09

Last active April 12, 2019 16:36

////ssh config


	cd ~/.ssh

	Host netvest-dev
	User ubuntu
	HostName
	IdentitiesOnly yes
	IdentityFile ~/.ssh/WeezLabsDev.pem

v-vashchenko / gist:3d6e02da98a579e8adc608fa75680874

Last active May 21, 2019 09:28

Postgresql dump load

	//load
	psql -d db_name < file_name.sql
	//upload
	pg_dump -U user_name -W -C db_name -t table_name > file_name.sql

v-vashchenko / gist:56ffb6c2643057f7443bde4cf05c25c0

Created April 25, 2019 12:57

escape listner react

	document.removeEventListener("keydown", this.handleEscapeButton, false);

	handleEscapeButton = (event) => {
	if (event.keyCode === 27) {
	this.setState({ openFilter: false });
	}
	};

v-vashchenko / sequelize order by related table

Created May 13, 2019 07:04

v-vashchenko / gist:f80cc6939222dfa60d48d0f6b871b552

Last active May 22, 2019 11:56

Node request logger

	const logRequestStart = (req, res, next) => {
	console.log('\x1b[33m%s\x1b[0m', `${req.method} ${req.originalUrl}`)

	res.on('finish', () => {
	console.log(`${res.statusCode} ${res.statusMessage}; ${res.get('Content-Length') \|\| 0}b sent`)
	})

	next()
	}

v-vashchenko / gist:bcd928548389698103f17715d7cea32e

Created May 28, 2019 15:22

custom textInput filter JS


	//custom textInput filter.

	function setInputFilter(textbox, inputFilter) {
	["input", "keydown", "keyup", "mousedown", "mouseup", "select", "contextmenu", "drop"].forEach(function (event) {
	textbox.addEventListener(event, function () {
	if (inputFilter(this.value)) {
	this.oldValue = this.value;
	this.oldSelectionStart = this.selectionStart;
	this.oldSelectionEnd = this.selectionEnd;

v-vashchenko / gist:e9324fd0e83e6f39f7630defe6f6d77b

Created May 30, 2019 08:36

React immutable initialState

	const getInitialModalState = () => ({
	projects: {},
	modalCreate: false,
	modalAskForDelete: false,
	currentId: 0,
	currentDescription: '',
	currentStart: defaultDate,
	currentEnd: defaultDate,
	currentDate: defaultDate,
	currentTitle: 'Добавить переработку',

v-vashchenko / gist:feb781e79b4bd696a8f3dd86e7f5857c

Last active June 3, 2019 10:03

Migration extend enum postgres SEQUELIZE

	'use strict';

	module.exports = {
	up: (queryInterface, Sequelize) => {
	return queryInterface.changeColumn(
	'table',
	'column',
	{
	type: Sequelize.TEXT,
	}

v-vashchenko / regex float number

Created July 5, 2019 07:42


	const pattern = /^\d{0,4}(\.\d{0,4})?$/;
	console.log('@@@MATCH', pattern.test(text));

v-vashchenko / Common-Currency.json

Created July 5, 2019 07:54 — forked from ksafranski/Common-Currency.json

Common Currency Codes in JSON

	order: [
	['createdAt', 'DESC'],//collumn
	[db.specialization, 'id', 'ASC']//related table
	],