Skip to content

Instantly share code, notes, and snippets.

View stasgm's full-sized avatar
:octocat:
coding...

Stanislau Shliakhtsich stasgm

:octocat:
coding...
View GitHub Profile
@stasgm
stasgm / gist:a663070dd0b9256857908d48a5d74b5f
Created January 18, 2020 10:33
Determine Firebird architecture?
execute block returns( fb_arch varchar(50) )
as
declare a_connect_with_usr varchar(31) default 'SYSDBA';
declare a_connect_with_pwd varchar(31) default 'masterkey';
declare cur_server_pid int;
declare ext_server_pid int;
declare att_protocol varchar(255);
declare v_test_sttm varchar(255);
declare v_fetches_beg bigint;
declare v_fetches_end bigint;
@stasgm
stasgm / gist:e3f1ce2e4862be57c3ff698037e27922
Last active November 28, 2019 08:19
VSCode Jest Test debug config
{
"type": "node",
"request": "launch",
"name": "Jest Test",
"program": "${workspaceFolder}\\node_modules\\jest\\bin\\jest",
"args": ["--runInBand", "--config=${workspaceFolder}\\jest.config.js"],
"console": "integratedTerminal",
"internalConsoleOptions": "neverOpen"
},
1) открыть окно командной строки в режиме админа
2) yarn global add ndb
3) заходим в папку gdmn-back
4) yarn rebuild
5) ndb node ./dist/src/index.js
запустится отладчик, где можно открывать исходники, ставить точки останова и т.п.
если надо поставить точку останова ДО запуска бэка, то запускаем отладчик так
@stasgm
stasgm / gist:e297a1dddadb68b0dbb33cef51bf12d5
Created June 10, 2019 11:20
VBS first and last day of the month
FirstDayCM = DateSerial(year(date), Month(date), 1) ' Первый день текущего месяца
LastDayCM = DateAdd("m", 1, FirstDayCM) - 1 ' Последний день текущего месяца
###create a new repository on the command line
echo "# html-test" >> README.md
git init
git add README.md
git commit -m "first commit"
git remote add origin https://github.com/stasgm/html-test.git
git push -u origin master
###push an existing repository from the command line
@stasgm
stasgm / SQL Remains
Last active January 19, 2018 20:55
SQL. Get remains on a specified date
SELECT
g.name goodname,
v.name valname,
con.name depname,
sum(m.balance)
FROM
( SELECT
M.CARDKEY,
M.CONTACTKEY,
M.BALANCE
@stasgm
stasgm / Firebird SQL
Last active March 1, 2019 07:20
Calculates the first day of the month for given period
select DATEADD(month, 1, DATEADD(DAY, -EXTRACT(DAY FROM CURRENT_DATE) + 1, CURRENT_DATE)) from rdb$database
@stasgm
stasgm / gist:29b0dc83b2746929f87a3763751b4368
Created May 4, 2016 17:02
Firebird SQL - First/last day of month
select
current_date - EXTRACT(DAY FROM current_date) + 1 FirstDay,
current_date - EXTRACT(DAY FROM current_date) + 32 - EXTRACT(DAY FROM current_date - EXTRACT(DAY FROM current_date) + 32) LastDay
from
rdb$database
Set objWsNet = CreateObject("WScript.Network")
strComputer = objWsNet.ComputerName
Set objWsNet = Nothing
Set objGroup = GetObject("WinNT://" & strComputer & "/Administrators")
For Each objUser In objGroup.Members
If StrComp(objUser.Class, "user", vbTextCompare) = 0 Then strList = strList & objUser.Name & vbNewLine
Next
MsgBox strList
@stasgm
stasgm / json.vbs
Last active August 29, 2015 14:13 — forked from atifaziz/json.vbs
'==========================================================================
' JSON Encoder for VBScript
' Copyright (c) 2013 Atif Aziz. All rights reserved.
'
' Licensed under the Apache License, Version 2.0 (the "License");
' you may not use this file except in compliance with the License.
' You may obtain a copy of the License at
'
' http://www.apache.org/licenses/LICENSE-2.0
'