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

from bottle import route, run

from json import JSONEncoder
from urllib import quote_plus

engine = create_engine(
    'mssql+pyodbc:///?odbc_connect=%s' % ())

Session = sessionmaker(bind=engine)
session = Session()
Base = declarative_base()

class EmployeeEncoder(JSONEncoder):
  def default(self, obj):
    return {"first_name" : obj.first_name,
            "last_name"  : obj.last_name,
            "email"      : obj.email,
            "id"         : obj.id}

class Employee(Base):
  __tablename__ = 'employee'
  id         = Column('emp_no'  , Integer, primary_key=True)
  first_name = Column('name'    , String)
  last_name  = Column('lastname', String)
  email      = Column('email'   , String)

@route('/employees')
def get_employees():
  employees = session.query(Employee).all()
  return EmployeeEncoder().encode(employees)

if __name__ == "__main__":
  run(port='8181')