#!/usr/bin/python3
# coding: utf-8 
"""
__title__ = ""
__author__ = "Hans"
__mtime__ = "2017/3/31 0031"
# code is far away from bugs with the god animal protecting
I love animals. They taste delicious.
┏┓ ┏┓
┏┛┻━━━┛┻┓
┃ ☃ ┃
┃ ┳┛ ┗┳ ┃
┃ ┻ ┃
┗━┓ ┏━┛
┃ ┗━━━┓
┃ 神兽保佑 ┣┓
┃　永无BUG！ ┏┛
┗┓┓┏━┳┓┏┛
┃┫┫ ┃┫┫
┗┻┛ ┗┻┛
"""
from sqlalchemy import Column, String, create_engine, Integer
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base


# 创建对象基类
Base = declarative_base()

# 定义Pic对象
class Pic(Base):
    # 表的名字
    __tablename__ = 'pic'
    # 表结构
    id = Column(Integer(), primary_key=True)
    site = Column(String(100))
    pic = Column(String(1000))

# 初始化数据库连接
engine = create_engine('mysql+mysqlconnector://root:root@localhost:3306/crawler')
# 创建DBSession 类型:
DBSession = sessionmaker(bind=engine)
# 创建session对象
session = DBSession()
result = session.query(Pic).filter(Pic.id==5).first()
print(result)