This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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): |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/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() |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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) | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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') |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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() |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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() |