I hereby claim:
- I am jgomo3 on github.
- I am jgomo3 (https://keybase.io/jgomo3) on keybase.
- I have a public key whose fingerprint is E8CA 7677 6DF0 F87E 23D7 21DA BE66 27F0 D1C6 243A
To claim this, I am signing this object:
I hereby claim:
To claim this, I am signing this object:
import psycopg2 as pg | |
from io import BytesIO | |
from collections import defaultdict | |
from contextlib import contextmanager | |
from psycopg2.extensions import ISOLATION_LEVEL_AUTOCOMMIT, ISOLATION_LEVEL_READ_COMMITTED | |
READ_COMMIT = ISOLATION_LEVEL_READ_COMMITTED | |
AUTO_COMMIT = ISOLATION_LEVEL_AUTOCOMMIT |
#!/bin/sh | |
# consolidar.sh | |
# | |
# 10 de junio de 2016 | |
# Concatena a los pdf de la carpeta `Preliminares` los pdf | |
# correspondientes con el mismo nombre en la carpeta `Respuestas` | |
# y el resultado lo genera con el mismo nombre en la carpeta | |
# Consolidados. | |
# |
CREATE TEMPORARY TABLE object_with_cases | |
( | |
id int, | |
case int | |
); | |
INSERT INTO object_with_cases | |
(id, case) | |
VALUES | |
(3, 1) |
import random | |
import re | |
import sys | |
def get_text(file): | |
return file.read() | |
def scramble(word): | |
return \ | |
('' if len(word) == 0 else word[0]) + \ |
import functools | |
@functools.lru_cache(maxsize=None) | |
def redu(n, s=0): | |
if n < 1 or s < -2 or s > 2: | |
return None | |
if n == 1: | |
if s == 0: | |
return [(1, 0)] | |
else: |
def redu(n, c): | |
return (n + c)//3 | |
T = [0, -1, 1] | |
N = int(input()) | |
while N > 1: | |
C = T[N%3] | |
R = redu(N, C) |
#!/usr/bin/env python3 | |
import unittest | |
def build_sieve(n): | |
"""Create the extended and optimized Sieve of Eratosthenes. | |
The size of the sieve is `N` | |
`sieve[i]`` is `0` if `i` is prime |
#!/bin/sh | |
echo "Stopping firewall and allowing everyone..." | |
iptables -F | |
iptables -X | |
iptables -t nat -F | |
iptables -t nat -X | |
iptables -t mangle -F | |
iptables -t mangle -X | |
iptables -P INPUT ACCEPT | |
iptables -P FORWARD ACCEPT |
-- Sin CTE | |
select | |
nombre | |
, comp.cantidad_suma as cant_comp | |
, fact.cantidad_suma as cant_fact | |
from | |
productos as prod | |
, (select sum(cantidad) as cantidad_suma, producto from compras) as comp | |
, (select sum(cantidad) as cantidad_suma, producto from facturas) as fact | |
where |