Roman Dibikhin dibikhin

Software Developer

dibikhin / Insert with Id output

Created November 12, 2014 13:07

T-SQL insert test returning Id of a new row

+CREATE TABLE Customers
+(
+	Id		INT 			IDENTITY(1,1) NOT NULL,
+	Name	NVARCHAR(255)	NOT NULL
+);
+GO
+SET IDENTITY_INSERT Customers OFF;

dibikhin / C# OPP

Last active August 29, 2015 14:09

Polymorphism & inheritance sample for LinqPad, http://www.linqpad.net

	void Main()
	{
	IAreaComputable circle = new Сircle(5);
	IAreaComputable square = new Square(5);
	Quadrilateral rhombus = new Rhombus(5, 7);

	circle.ComputeArea().Dump();
	square.ComputeArea().Dump();
	((IAreaComputable)rhombus).ComputeArea().Dump();
	}

dibikhin / server.js

Last active January 31, 2016 22:40

	// Read to end first, then solve one by one.

	var express = require('express');

	// #0. Load 'multer' here.

	// #1. Use 'uploads' folder for multer's upload here.

	var app = express();

dibikhin / asyncify.js

Last active June 10, 2020 11:13

Asyncify and wrap with catch

	const handleErrors = (err) => { console.error(err); return null }

	const wrap = (f) =>
	(...args) =>
	(
	(
	async () => f(...args)
	)()
	).catch(handleErrors)

dibikhin / build_friends_network.js

Created April 30, 2020 23:25

Build friends network

	a = a.map(x => ({id: x.id, fids: x.friendsIds}))
	data = {}
	data.nodes = a.map(x => ({ id: x.id }))
	data.links = a.reduce((acc, cur) => {
	const links = cur.fids.map(x => ({ source: cur.id, target: x }))
	return acc.concat(links)
	}, [])

dibikhin / parse_fb_signed_request.js

Last active July 14, 2020 09:19

testing parsing fb signed requests