def __init__(self): config = Config() config.load() db_setting = config.get_database_setting() self.engine = create_engine('mysql+pymysql://' + db_setting["user"] + ':' + db_setting["pass"] + '@' + db_setting["host"] + '/' + db_setting["db"] + '?charset=utf8', echo=True) metadata = MetaData() self.images = Table('images', metadata, Column('id', Integer, primary_key=True), Column('url', String(255)), Column('mission_id', String(255)), Column('image_id', String(255)), Column('image_date', DATETIME), Column('lat', String(255)), Column('lon', String(255)), Column('focal_length', String(255)), Column('geo_name', String(255)), Column('fet', String(255)), Column('rec_type', String(255)), Column('downloaded', BOOLEAN), Column('uploaded', BOOLEAN), Column('image_name', String(255)) ) self.missions = Table('missions', metadata, Column('id', Integer, primary_key=True), Column('start_date', DATETIME), Column('end_date', DATETIME), Column('mission_id', String(255)), Column('inclination', String(255)), Column('program', String(255)), Column('film_id', String(255)), Column('progress', BOOLEAN), Column('database_img', String(255)) ) metadata.create_all(self.engine)