Skip to content

Instantly share code, notes, and snippets.

View Mauzzz0's full-sized avatar
:octocat:

Ruslan Semak Mauzzz0

:octocat:
View GitHub Profile
@Mauzzz0
Mauzzz0 / node-mysql2-promise-query-stream.js
Created December 26, 2022 15:15 — forked from islishude/node-mysql2-promise-query-stream.js
node-mysql2 query stream with Promise
// https://github.com/sidorares/node-mysql2/issues/677
const mysql = require("mysql2/promise");
const stream = require("stream");
const dbconn = mysql.createPool({
connectionLimit: 10,
host: "127.0.0.1",
user: "user",
password: "password",
database: "database",
@Mauzzz0
Mauzzz0 / Dto.ts
Created August 9, 2022 14:06
NestJs Swagger Query Array Of Numbers
@ApiProperty({ type: [Number] })
@ArrayMinSize(2)
@ArrayMaxSize(2)
@Type(() => Number)
@IsArray()
@IsNumber({}, { each: true })
public entityIds: number[];
with whmcs as (select distinct datas.*
from temp_segment,
json_to_recordset(temp_segment.data::json)
as datas(user_id bigint,
service_id bigint,
tunnel character varying,
segment_sync_id character varying)
where segment_sync_id = '19fe2cf3-1967-4f27-be5a-3d3753b56ae2'),
swsdk as (select distinct datas.*
from temp_segment,
@Mauzzz0
Mauzzz0 / script.sh
Created January 28, 2022 09:31
download all repos in gitlab group
for repo in $(curl -s --header "PRIVATE-TOKEN: *PRIVATE_TOKEN_FROM_GITLAB*" https://*HOST*/api/v4/groups/*GROUPID* | jq ".projects[].ssh_url_to_repo" | tr -d '"'); do git clone $repo; done;
@Mauzzz0
Mauzzz0 / graph-response-graph-visualization.js
Last active October 14, 2021 12:54
postman-response-graph-visualization
//========For this response:
/*
{
"trackingId": "11111111-22222222-3333-4444-555555555555",
"status": "Ok",
"payload": {
"percentile": 6666666.77777777,
"history": [
{
"ts": "2021-10-08 00:00:00",
@Mauzzz0
Mauzzz0 / install-toolbox.sh
Created July 3, 2021 08:27 — forked from greeflas/install-toolbox.sh
JetBrains Toolbox installation script for Ubuntu - https://www.jetbrains.com/toolbox/app/
#!/bin/bash
set -e
if [ -d ~/.local/share/JetBrains/Toolbox ]; then
echo "JetBrains Toolbox is already installed!"
exit 0
fi
echo "Start installation..."
@Mauzzz0
Mauzzz0 / gist:9847ebf15974e37f131339eb1aabbc7e
Created December 7, 2020 22:41 — forked from shadowmint/gist:7004832
Kivy example using sqlalchemy to build a layout.
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import create_engine
from sqlalchemy import Column, Integer, String
from sqlalchemy.orm import sessionmaker
from sqlalchemy import ForeignKey
from sqlalchemy.orm import relationship, backref
from kivy.graphics import Rectangle
from kivy.uix.boxlayout import BoxLayout
from kivy.uix.label import Label
from kivy.uix.widget import Widget