Skip to content

Instantly share code, notes, and snippets.

View alexesDev's full-sized avatar

Alexey Yurchenko alexesDev

  • Digital Nomad
View GitHub Profile
@alexesDev
alexesDev / CircleRenderer.cpp
Last active January 4, 2018 20:48
Simple CircleRenderer feature for margum engine
#include "CircleRenderer.h"
#include "Types.h"
#include <Magnum/Mesh.h>
#include <Magnum/Buffer.h>
#include <Magnum/SceneGraph/Camera.h>
#include <Magnum/Shaders/Flat.h>
#include <Magnum/Primitives/Circle.h>
#include <Magnum/Trade/MeshData2D.h>
@alexesDev
alexesDev / array_agg_mult.sql
Last active November 24, 2017 09:15
Выборка заказов из PG для обучения нейронной сети (тормознутый вариант, потому что генерирует много дубльданных для удобства)
-- array_agg не поддерживает массивы
create aggregate array_agg_mult(anyarray) (
SFUNC = array_cat,
STYPE = anyarray,
INITCOND = '{}'
);
WITH RECURSIVE tree AS (
SELECT id, parent_path, ARRAY[]::INTEGER[] AS ancestors
FROM core.items
WHERE parent_id is null
UNION ALL
SELECT i.id, i.parent_path, tree.ancestors || i.parent_id
FROM core.items i, tree
WHERE i.parent_id = tree.id
function makeString(iv) {
var value = iv;
var methods = {
immutableAdd: function(v) {
return makeString(value + v);
},
mutableAdd: function(v) {
value += v;
return methods;
@alexesDev
alexesDev / pixel.js
Created September 30, 2017 07:32
Flow types for Facebook Pixel
if (!process.env.FACEBOOK_PIXEL_ID) {
// eslint-disable-next-line no-console
console.warn('process.env.FACEBOOK_PIXEL_ID not set');
}
/* eslint-disable */
!function(f,b,e,v,n,t,s)
{if(f.fbq)return;n=f.fbq=function(){n.callMethod?
n.callMethod.apply(n,arguments):n.queue.push(arguments)};
if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';
const getForm = state => ({
name: state.quickOrder.name,
phone: `7${state.quickOrder.phone}`,
});
const dataSelector = createStructuredSelector({
form: getForm,
cart: state => state.cart,
});
var selector1 = ...
var selector2 = ...
var selector3 = ...
var all = createSelector(
selector1, selector2, selector3,
(selector1, selector2, selector3) => ({ selector1, selector2, selector3 })
);
var all = createStructuredSelector({
@alexesDev
alexesDev / slugify.sql
Created September 1, 2017 07:37
PostgreSQL russian translit
create or replace function public.slugify(str text)
returns text
language plpgsql
as $$
declare
_out text;
begin
_out := translate(
trim(both ' ' from lower(str)),
'абвгдеёзийклмнопрстуфыэ',
#!/bin/bash
ADDR=$1
echo $ADDR
firewall-cmd --permanent --zone=drop --add-rich-rule="
rule family='ipv4'
source address=${ADDR}
port protocol='tcp' port='2377' accept"
fetch('http://...')
.then(res => res.json())
.then(data => dispatch(autodux.actions.success(data)));