Skip to content

Instantly share code, notes, and snippets.

View EvgenJin's full-sized avatar

Evgen Jin EvgenJin

1 follower · 6 following
  • Ekaterinburg, Russia
View GitHub Profile
@EvgenJin
EvgenJin / LokiJS
Created September 10, 2018 11:39
var loki = require('lokijs'),
db = new loki('test.json');
// var users = db.addCollection('users');
// загрузить базу
db.loadDatabase({},()=>{
let users = db.getCollection('users')
// записать
function insert (name_str,val_str) {
users.insert({name:name_str, val:val_str})
@EvgenJin
EvgenJin / gist:d3f7baf00a34226efd605c66406248a8
Created March 27, 2019 13:44
PowerShell killer_process.ps1
Do {
# всего памяти
$os = Get-Ciminstance Win32_OperatingSystem
# свободная память / всего
$pctFree = [math]::Round(($os.FreePhysicalMemory/$os.TotalVisibleMemorySize)*100,2)
$free = [math]::Round($os.FreePhysicalMemory/1024/1024)
# массив
$ProcArray = @()
# получить процессы с группировкой
$Processes = get-process | Group-Object -Property ProcessName
@EvgenJin
EvgenJin / gist:2b5cdab5497049159759a0ffffd414f1
Created June 17, 2019 12:28
pl/sql cursor
create or replace package test_pkg is
cursor c_zaj(p#obj_id number ) is
select zaj.id
, zaj.id_cus
, zaj.sum_crd
, zaj.targ
from exp_zaj zaj
where zaj.id = p#obj_id;
@EvgenJin
EvgenJin / OpenStreetMaps
Created January 22, 2020 06:58
<html>
<head>
<title>Maps of objects</title>
<script src="data.js"></script>
</head>
<body>
<div id="mapdiv"></div>
<script src="http://www.openlayers.org/api/OpenLayers.js"></script>
<script>
@EvgenJin
EvgenJin / XmlToCsvGroovy
Last active June 3, 2020 10:39
def headerRow
def rowList = new ArrayList<ReportRow>();
def dataXml = new XmlSlurper().parse("./employee.xml");
def sb = new StringBuffer();
def getKeyValue(obj, type) {
def String res
if (type == "key") {
res = obj.getProperties().findAll{name,value -> name != 'class'}.sort{(it.key.toString() =~ /\d+/)[0].toInteger()}.collect{it.key}.join(',')
}
@EvgenJin
EvgenJin / csvToXlsx.groovy
Last active June 3, 2020 23:17 — forked from VadimKirilchuk/csvToXlsx.groovy
Convert CSV to XLSX (Streaming)
@Grab("org.apache.poi:poi:3.16")
@Grab("org.apache.poi:poi-ooxml:3.16")
import org.apache.poi.xssf.usermodel.*;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.streaming.*;
def csvToExelNotExists() {
try {
String csvFileAddress = "./test.csv";
String xlsxFileAddress = "./autos.xlsx";
@EvgenJin
EvgenJin / groovy coockbook 1
Created July 20, 2020 19:11
#parsing xml
ru.gpb.mule.util.Utils.makeString(payload)
def response = new XmlSlurper().parseText(payload)
def reestr = new XmlSlurper().parseText(response as String)
def code = reestr.CreditRequest.@Code
println(reestr.CreditRequest.@Code)
return response
#create json
def ob = [:];
@EvgenJin
EvgenJin / groovy cb 2
Last active July 20, 2020 19:23
#коллекция
allDocs = [:]
model.documents.each{
allDocs.put(it.code, it.count)
}
params.add(new SimpleDateFormat("dd/MM/yyyy").format(new Date()))
def jms = new XmlSlurper().parseText(payload)
@EvgenJin
EvgenJin / groovy ck 3
Created July 20, 2020 19:28
// конверт даты приходит "yyyy-MM-dd" выходит "yyyy-MM-dd'T'HH:mm:ss.SSS"
def convertDate (date_str) {
if (date_str != "") {
date = Date.parse("yyyy-MM-dd",date_str)
return date.format("yyyy-MM-dd'T'HH:mm:ss.SSS")
} else {
return "1900-01-01"
}
}
@EvgenJin
EvgenJin / groovy decision maker
Created August 8, 2020 18:24
def main = [:]
main.myList = []
def addToList(list,name,con1,con2,con3,res) {
name = [:]
name.con1 = con1
name.con2 = con2
name.con3 = con3
name.res = res
list.push(name)