🦖

Semenov Artur meanother

🦖

data engineer

meanother / execute_statistics.py

Created August 26, 2024 15:27

Сборка статистики по использованию сети

meanother / index.js

Created July 26, 2024 07:22

New index.js with fix create new users

	const wgService = require("./wgService");
	const express = require("express");
	const bodyParser = require("body-parser");
	const cors = require('cors');
	const config = require("./config");
	const asyncHandler = require('express-async-handler');
	const fs = require('fs');
	const path = require("path");
	const archiver = require('archiver');

meanother / export_wg.py

Created July 24, 2024 20:58

Сбор данных по пользователям wg0

meanother / gist:75410675f817653aeb92ff4a62a6f6d4

Created January 19, 2024 13:42

systemctl table

	#!/root/env/bin/python

	import subprocess
	from prettytable import PrettyTable


	services = [
	"wg-quick@wg0",
	"wg-bot",
	"wg-slave",

meanother / check_10.sql

Created October 14, 2021 19:26

meanother / check_9.sql

Created October 14, 2021 19:25

	create trigger banki_hist_insert_trigger after insert on home.dt_banki_responses
	for each row execute procedure home.banki_hist_insert();

meanother / check_8.sql

Created October 14, 2021 19:24

	CREATE OR REPLACE FUNCTION home.banki_hist_insert()
	RETURNS trigger
	LANGUAGE plpgsql AS
	$function$
	BEGIN
	INSERT INTO home.dth_banki_responses
	(id, link, ... action, valid_from)
	VALUES
	(NEW.id, NEW.link, ... 'I', current_timestamp);
	RETURN NEW;

meanother / check_7.sql

Created October 14, 2021 19:24

	create table if not exists home.dth_banki_responses (
	id int,
	link varchar(255) not null,
	...
	action char(1) not null,
	valid_from timestamptz not null
	);

meanother / check_6.sql

Created October 14, 2021 19:23

	select
	round(
	avg(date_part('day', bank_answer_date-create_dt)::int), 1
	) as "Среднее время ответа в днях"
	, round(
	median(date_part('day', bank_answer_date-create_dt)::int), 1
	) as "Медианное время ответа в днях"
	from
	home.dt_banki_responses
	where

meanother / check_5.sql

Created October 14, 2021 19:23

	select
	substr(create_dt::varchar,1,7) as month
	, round(avg(coalesce(score, 0)), 1) as "Среднее"
	, trunc(median(coalesce(score, 0))) as "Медиана"
	, count(*) as "Общее кол-во"
	, sum(case when score = 1 then 1 else 0 end) as "Оценка 1"
	, sum(case when score = 2 then 1 else 0 end) as "Оценка 2"
	, sum(case when score = 3 then 1 else 0 end) as "Оценка 3"
	, sum(case when score = 4 then 1 else 0 end) as "Оценка 4"
	, sum(case when score = 5 then 1 else 0 end) as "Оценка 5"