Skip to content

Instantly share code, notes, and snippets.

View iuridiniz's full-sized avatar

Iuri Diniz iuridiniz

View GitHub Profile
from sqlalchemy import create_engine, Column, types, bindparam
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, scoped_session
from sqlalchemy.sql.expression import literal_column
engine = create_engine('sqlite:///:memory:', echo=True)
Base = declarative_base()
session = scoped_session(sessionmaker(bind=engine))
from sqlalchemy import create_engine, Column, types
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, scoped_session
from sqlalchemy.engine.reflection import Inspector
engine = create_engine('sqlite:///:memory:', echo=True)
Base = declarative_base()
session = scoped_session(sessionmaker(bind=engine))
from sqlalchemy import create_engine, Column, types
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, scoped_session
engine = create_engine('sqlite:///:memory:', echo=False)
Base = declarative_base()
session = scoped_session(sessionmaker(bind=engine))
class User(Base):
#!/usr/bin/env python
from sqlalchemy import create_engine, Column
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, scoped_session
from sqlalchemy import types
from sqlalchemy import event
engine = create_engine('sqlite:///:memory:', echo=False)
Base = declarative_base()
from sqlalchemy import create_engine, Column, types
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, scoped_session
Base = declarative_base()
class User(Base):
__tablename__ = "user"
id = Column(types.Integer, primary_key=True)
from sqlalchemy import create_engine, Column, types
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, scoped_session
Base = declarative_base()
class User(Base):
__tablename__ = "user"
id = Column(types.Integer, primary_key=True)
name = Column(types.String(255), nullable=True, default=None, server_default='NULL')
from __future__ import print_function
from sqlalchemy import create_engine, Column, types
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, scoped_session
from sqlalchemy.orm import Session
from sqlalchemy import ForeignKey
from sqlalchemy.orm import relationship, backref
from sqlalchemy import create_engine, Column, types
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, scoped_session
from sqlalchemy.sql import functions, expression, func
from sqlalchemy.ext.compiler import compiles
from datetime import datetime
Base = declarative_base()
@iuridiniz
iuridiniz / dst.sql
Last active February 3, 2017 23:17
day light save (DST)
DELIMITER $$
DROP FUNCTION IF EXISTS is_summer_time $$
CREATE FUNCTION is_summer_time(d datetime)
RETURNS boolean
DETERMINISTIC
BEGIN
-- summer time 2012~2018
IF d BETWEEN '2012-10-21 01:00:00' AND '2013-02-16 22:59:59' THEN RETURN true;
ELSEIF d BETWEEN '2013-10-20 01:00:00' AND '2014-02-15 22:59:59' THEN RETURN true;
# classes e objetos...
from Tkinter import Tk, Button, Entry, mainloop, END, LEFT, RIGHT, NORMAL
master = Tk()
master.wm_title("Calculadora")
e = Entry(master)
e['state'] = "readonly"
e.pack()