Skip to content

Instantly share code, notes, and snippets.

@gennad
gennad / gist:2850881
Created June 1, 2012 09:56
Задача на SQL
--Есть 2 таблицы:
--users
--UID Name
--1 «Александр»
--2 «Семён»
--messages
--UID msg
--1 “A”
--1 “B”
@gennad
gennad / gist:2842895
Created May 31, 2012 11:49
Еще одна старая задача, не помню условие, но есть решение на Python
from decimal import Decimal, ROUND_HALF_UP
import logging
logging.basicConfig(level=logging.DEBUG)
# Constants for rounding
TWO_DIGITS_ROUND = Decimal("0.01")
SIX_DIGITS_ROUND = Decimal("0.000001")
result_lst = []
@gennad
gennad / gist:2842869
Created May 31, 2012 11:45
Задача на SQL
--Задача: есть таблица
fish
name CHAR(20)
price INT(5)
date DATE
--В таблице есть данные:
forel 2012-01-01 10
forel 2012-01-03 6
SELECT i.route_id, min(t.cost) m
FROM (SELECT DISTINCT route_id FROM tickets) AS i, tickets t
WHERE i.route_id = t.route_id AND
city_from='ABC' AND
city_to='ABC' AND
date_direct='2012-05-24' AND
date_back='2012-05-25' AND
expires > NOW()
GROUP BY t.route_id
ORDER BY m;
@gennad
gennad / gist:2836618
Created May 30, 2012 14:18
Python task
import time
from wsgiref.util import setup_testing_defaults
from wsgiref.simple_server import make_server
def timeit(func):
def wrapper(*a, **k):
t1 = time.time()
it = iter(func(*a, **k))
@gennad
gennad / euler8
Created May 14, 2012 10:03
Project Euler 8 problem
s = """
73167176531330624919225119674426574742355349194934
96983520312774506326239578318016984801869478851843
85861560789112949495459501737958331952853208805511
12540698747158523863050715693290963295227443043557
66896648950445244523161731856403098711121722383113
62229893423380308135336276614282806444486645238749
30358907296290491560440772390713810515859307960866
70172427121883998797908792274921901699720888093776
65727333001053367881220235421809751254540594752243
@gennad
gennad / gist:2290559
Created April 3, 2012 09:00
My .emacs
(setq org-directory "~/org/")
(load-file "/home/gennad/.emacs.d/emacs-for-python/epy-init.el")
;; To require
;;(add-to-list 'load-path "~/.emacs.d/http")
;;(require 'http-post-curl)
;;(require 'http-twiddle)
;;(load-file "/home/gennad/.emacs.d/http-post-curl.el")
@gennad
gennad / .zshrc
Created September 23, 2011 08:48
My .zshrc
# Set up the prompt
autoload -Uz promptinit
promptinit
prompt adam1
setopt histignorealldups sharehistory
# Use emacs keybindings even if our EDITOR is set to vi
bindkey -e
@gennad
gennad / templates.cc
Created August 31, 2011 17:57
templates
// function template
#include <iostream>
using namespace std;
template <class T>
T GetMax (T a, T b) {
T result;
result = (a>b)? a : b;
return (result);
}
@gennad
gennad / multithreading.cc
Created August 31, 2011 17:13
Multithreading in Unix
// Compile with g++ -o multithreading.o multithreading.cc -lpthread
#include <pthread.h>
#include <errno.h>
#include <signal.h>
#include <stdio.h>
#include <stdlib.h>
#include <time.h>
#include <unistd.h>
#include <string.h>