Skip to content

Instantly share code, notes, and snippets.

View genakim's full-sized avatar

Gennadiy Kim genakim

  • Uzbekistan, Tashkent city
View GitHub Profile
@genakim
genakim / procedure.sql
Last active May 12, 2020 19:33
Пример процедуры на MySQL с использование цикла и условий
create
definer = root@`::1` procedure PublicIntoStatuses(IN dateFrom varchar(255), IN dateTo varchar(255),
IN comment varchar(20))
comment 'Процедура вставки в статусы общ. работ. Создает все недостающие статусы'
BEGIN
DECLARE vServiceLogId int;
DECLARE vServiceTypeId int;
DECLARE vServiceId int;
DECLARE vResult varchar(50);
DECLARE vPersonId int;
<template>
<ul :class="parentClass">
<li v-for="node in nodes" :class="childClass">
<a href="/">{{node.name}}</a>
<tree-item v-if="node.children.length" :nodes="node.children" :isSub="true"></tree-item>
</li>
</ul>
</template>
<script>
<template>
<tree-item :nodes="nodes"></tree-item>
</template>
<script>
export default {
props: ['items'],
data() {
return {
nodes: []
@genakim
genakim / SameParity.php
Created November 7, 2019 06:59
[Новый массив, состоящий из элементов, у которых такая же чётность, как и у первого элемента входного массива] #algorithm
<?php
function getSameParity($coll)
{
if (empty($coll)) {
return [];
}
$result = [];
$remainder = $coll[0] % 2;
@genakim
genakim / ContinuousSequence.php
Created November 7, 2019 06:20
[Последовательно возрастающие числа] #algorithm
<?php
function isContinuousSequence($coll)
{
// guard expression
if (count($coll) <= 1) {
return false;
}
// neutral element
$start = $coll[0];
@genakim
genakim / swap.php
Last active November 7, 2019 05:26
[Swap prev, next index by array center] #algorithm
<?php
function swap($coll, $center)
{
$prevIndex = $center - 1;
$nextIndex = $center + 1;
$isSwappable = array_key_exists($prevIndex, $coll) && array_key_exists($nextIndex, $coll);
if ($isSwappable) {
$temp = $coll[$prevIndex];
@genakim
genakim / reverse.php
Created November 7, 2019 05:07
[Реверс массива] #algorithm
<?php
function reverseArray($coll)
{
$size = count($coll);
$maxIndex = floor($size / 2);
for ($i = 0; $i < $maxIndex; $i++) {
$mirrorIndex = $size - $i - 1;
$temp = $coll[$i];
$coll[$i] = $coll[$mirrorIndex];
@genakim
genakim / GROUP_MAXIMUM.SQL
Created September 13, 2019 10:06 — forked from hackimov/GROUP_MAXIMUM.SQL
#SQL #MAXIMUM #WITHOUT_GROUP_BY #SPEED #QUERY
SELECT maintable.*
FROM TABLE_NAME maintable
LEFT OUTER JOIN TABLE_NAME temporarytable
ON maintable.GROUPING_BY_COLUMN = temporarytable.GROUPING_BY_COLUMN
AND maintable.COLUMN_WHERE_THE_MAXIMUM_IS_NEEDED < temporarytable.COLUMN_WHERE_THE_MAXIMUM_IS_NEEDED
WHERE temporarytable.COLUMN_WHERE_THE_MAXIMUM_IS_NEEDED IS NULL
ORDER BY PRIMARY_KEY_COLUMN DESC
LIMIT 50;
# Step 1 - install java 1.8
yum install java-1.8.0-openjdk.x86_64
# Step 2 - install jmeter 3.2
curl https://archive.apache.org/dist/jmeter/binaries/apache-jmeter-3.2.tgz > $HOME/apache-jmeter-3.2.tgz
tar -xvzf $HOME/apache-jmeter-3.2.tgz
ln -s $HOME/apache-jmeter-3.2 $HOME/jmeter
# Step 3 - add to your path in ~/.bashrc
export JMETER_HOME=$HOME/jmeter

Download Vagrant boxes manually

In this example, we're going to download the Midnight Sun box.

# The box URL is https://app.vagrantup.com/uwmidsun/boxes/box/versions/2.1.0
# In general, we just take the box URL, and then append the provider URL
# https://app.vagrantup.com/<organization name>/boxes/<box name>/versions/<version>/providers/<provider>.box
wget https://app.vagrantup.com/uwmidsun/boxes/box/versions/2.1.0/providers/virtualbox.box -O box-2.1.0.box