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)
