#!/usr/bin/env python3
# -*- coding: utf-8 -*-

"""
在下面的程序中，SQLalchemy声明了一个User表，同时创建了一个Session，向这个表添加了一条记录
"""

from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String
from sqlalchemy.orm import sessionmaker

engine = create_engine('mysql+pymysql://test:test@localhost/test')
Base = declarative_base()
Session = sessionmaker(bind=engine)

class User(Base):
    __tablename__ = 'users'

    id = Column(Integer, primary_key=True)
    name = Column(String(32))
    fullname = Column(String(32))
    password = Column(String(32))

    def __repr__(self):
        return "<User(name='{}', fullname='{}', password='{}')".format(
            self.name, self.fullname, self.password)

# 这里的创建语句的含义是，如果表已经存在的话，就不会再创建了
Base.metadata.create_all(engine)

session = Session()
ed_user = User(name='ed', fullname='Ed Jones', password='edpassword')
session.add(ed_user)
session.commit()