Denys Synashko itnow

itnow / sql_alchemy_samples.py

Created May 30, 2018 21:37 — forked from olgakogan/sql_alchemy_samples.py

SQL Alchemy Samples

	########## CASE IN UPDATE STATEMENT ############

	from sqlalchemy import case

	# single value modification (the 'else' is not mandatory)
	session.query(User).update({User.status : case([(User.status == "pending", "approved")], else_=User.status)}, False)

	# multiple values modification
	session.query(User).update({User.status : case([(User.status == "pending", "approved"),
	(User.status == "waiting", "deprecated_status")])}, False)

itnow / sqlalchemy_example.py

Created May 30, 2018 21:33 — forked from podhmo/sqlalchemy_example.py

sqlalchemy query example.

	import sqlalchemy as sa
	import sqlalchemy.orm as orm
	from sqlalchemy.ext.declarative import declarative_base
	from sqlalchemy.ext.declarative import declared_attr
	from sqlalchemy.orm import scoped_session, sessionmaker

	DBSession = scoped_session(sessionmaker())
	class BaseMixin(object):
	query = DBSession.query_property()
	id = sa.Column(sa.Integer, primary_key=True)

itnow / match.py

Created May 17, 2018 21:17 — forked from Deepwalker/match.py

Something about matching for trafaret

itnow / Python_Makefile

Created April 30, 2018 19:38 — forked from vechnoe/Makefile

Makefile Django example

	PROJECT_DIR=$(shell pwd)
	VENV_DIR?=$(PROJECT_DIR)/.env
	PIP?=$(VENV_DIR)/bin/pip
	PYTHON?=$(VENV_DIR)/bin/python
	MANAGE?=$(PROJECT_DIR)/manage.py

	.PHONY: all clean test run requirements install virtualenv

	all: virtualenv install create_database migrate_db create_admin loaddata

itnow / _core.py

Created January 2, 2017 08:30 — forked from justanr/_core.py

Clean Architecture In Python

	from abc import ABC, ABCMeta, abstractmethod
	from collections import namedtuple
	from itertools import count


	PayloadFactory = namedtuple('PayloadFactory', [
	'good', 'created', 'queued', 'unchanged', 'requires_auth',
	'permission_denied', 'not_found', 'invalid', 'error'
	])
	"""