wellic

import psycopg2
import json

def main():
    with psycopg2.connect("host=localhost port=15432 "
            "dbname=mydb user=postgres password=postgres") as conn:

        #insertByObject(conn)
        #insertByText(conn)
        #select(conn)

wellic

"""Utilities for managing database sessions."""
from __future__ import with_statement

import contextlib
import functools

@contextlib.contextmanager
def temp_session(session_cls, **kwargs):
    """Quick and dirty context manager that provides a temporary Session object
       to the nested block. The session is always closed at the end of the block.

wellic

"""
This script demonstrates the use of nested transactions in SQLAlchemy, including
a workaround for an issue with the SQLite backend.

References:
http://docs.sqlalchemy.org/en/latest/orm/session_transaction.html#using-savepoint
http://docs.sqlalchemy.org/en/latest/dialects/sqlite.html#serializable-isolation-savepoints-transactional-ddl
"""

from sqlalchemy import Column, String, Integer

wellic

-- http://stackoverflow.com/questions/1124603/grouped-limit-in-postgresql-show-the-first-n-rows-for-each-group
-- http://www.postgresql.jp/document/9.2/html/tutorial-window.html

CREATE TABLE empsalary (
  depname varchar(10) not null
  , empno integer not null
  , salary integer not null
);

INSERT INTO empsalary (depname, empno, salary) VALUES ('develop', 11, 5200);

wellic

-- Create tables
CREATE TABLE groups (id serial NOT NULL, name character varying NOT NULL);
CREATE TABLE network_group_members (pid integer, cid integer NOT NULL);

-- Insert the groups
INSERT INTO groups (name) VALUES ('GROUP 1'),('GROUP 2'),('GROUP 3'),('GROUP 4'),('GROUP 5'),('GROUP 6'),('GROUP 7'),('GROUP 8'),('GROUP 9'),('GROUP 10'),('GROUP 11'),('GROUP 12'),('GROUP 13');
-- Build the "Network"
INSERT INTO network_group_members(pid,cid) VALUES (1,2),(1,3),(1,4),(2,5),(5,6),(5,7),(7,8),(3,9),(4,10),(4,11),(11,12),(12,13);

wellic

Starting localstack

C02STG51GTFM:localstack mpandit$ make infra
. .venv/bin/activate; exec localstack/mock/infra.py
Starting local dev environment. CTRL-C to quit.
Starting local Elasticsearch (port 4571)...
Starting mock ES service (port 4578)...
Starting mock S3 server (port 4572)...
Starting mock SNS server (port 4575)...

wellic

version: '2'

services:

  http-proxy:
    image: nginxproxy/nginx-proxy
    container_name: http-proxy
    privileged: true
    environment:
#      - DNS_IP=127.0.0.1

wellic

import re

# RFC 4122 states that the characters should be output as lowercase, but
#   that input is case-insensitive. When validating input strings,
#   include re.I or re.IGNORECASE per below:

def _create_pattern(version):
    return re.compile(
        (
            '[a-f0-9]{8}-' +

wellic

FROM ubuntu:20.04

ENV DEBIAN_FRONTEND="noninteractive"

WORKDIR /tmp

RUN apt-get update \
 && apt-get install -y software-properties-common \
 && add-apt-repository ppa:ondrej/php \
 && add-apt-repository ppa:ondrej/apache2 \

wellic

class Table(Base):
    id = Column(Integer, primary_key=True)
    _name = Column('name', String(24))

    @property
    def name(self):
        return self._name;

    @name.setter
    def name(self, value):