def get_information_image(image_name): driver = DatabaseDriver() args = [image_name] result = driver.query_db( """ select * from images where image_name= ? """, args) print("get_information_image {}".format(result)) return result
def del_user(user_id): try: driver = DatabaseDriver() args = [user_id] driver.exec_command("""delete users where user_id=?""", args) except Exception as e: print(e) return False return True
def get_image_name(): driver = DatabaseDriver() query = """select image_name from images""" result = driver.query_db(query) #print(result) return result
def del_container(container_id): try: driver = DatabaseDriver() args = [container_id] driver.exec_command( """delete from containers where container_id=?""", args) except Exception as e: print(e) return False return True
def delete_image(image_id): try: driver = DatabaseDriver() args = [image_id] driver.exec_command("""delete from images where image_id = ?""", args) except Exception as e: print(e) return False return True
def create_user(email, password, name, position): try: driver = DatabaseDriver() args = [email, password, name, position] new_id = driver.exec_command( """insert into users(email, password, name, position) values (?, ?, ?, ?, ?)""", args) return new_id except Exception as e: print(e) return False
def create_image(name, group): try: driver = DatabaseDriver() args = [name, group] new_id = driver.exec_command( """insert into images(image_name, igroup) values (?, ?)""", args) return new_id except Exception as e: print(e) return False
def insert_size(image_name): try: driver = DatabaseDriver() args = [image_name] new_id = driver.exec_command( """insert into images(isize) values (?)""", args) return new_id except Exception as e: print(e) return False
def create_container(image_id, cpu, memory, port, container_password, user_id): try: driver = DatabaseDriver() args = [image_id, cpu, memory, port, container_password, user_id] new_id = driver.exec_command( """insert into containers( image_id, cpu, memory, port, container_password,user_id) values (?, ?, ?, ?, ?,?)""", args) return new_id except Exception as e: print(e) return False
def edit_image(image_id, image_name, igroup): try: driver = DatabaseDriver() args = [image_name, igroup, image_id] driver.exec_command( 'update images set image_name = ?, igroup = ? where image_id = ?', args) except Exception as e: print(e) return False return True
def edit_user(user_id, email, password, name): try: driver = DatabaseDriver() args = [user_id, email, password, name] driver.exec_command( """update users set email=?, password=?, name=? where user_id=?""", args) except Exception as e: print(e) return False return True
def edit_user(user_id, mail, password, name, position): try: driver = DatabaseDriver() args = [mail, password, name, position, user_id] driver.exec_command( """update users set mail=?, user_password=?, user_name=?, position = ? where user_id=?""", args) except Exception as e: print(e) return False return True
def get_users(): try: result = DatabaseDriver().query_db("""select * from users""") except Exception as e: print(e) return False return result
def edit_container(cpu, memory, port, container_password, container_id): try: driver = DatabaseDriver() args = [cpu, memory, port, container_password, container_id] driver.exec_command( """update containers set cpu=?, memory=?, port=?, container_password=? where container_id =?""", args) except Exception as e: print(e) return False return True
def get_container_docker_id(container_id): try: query = 'select container_docker_id from containers where container_id = ?' args = [container_id] result = DatabaseDriver().query_db(query, args) return result except: return False
def insert_container_docker_id(result, container_docker_id): try: query = 'insert into containers(container_docker_id) values(?) where result=? ' args = [container_docker_id, result] result = DatabaseDriver().query_db(query, args) return result except: return False
def get_user(user_id): try: query = """select * from users where user_id = ?""" args = [user_id] result = DatabaseDriver().query_db(query, args, one=True) except Exception as e: print(e) return False return result
def find_mail(mail): try: query = """select mail from users where mail = ?""" args = [mail] result = DatabaseDriver().query_db(query, args, one=True) if result is not None: return True except Exception as e: return False return False
def get_image_id(image_name): try: query = """select image_id from images where image_name = ?""" args = [image_name] result = DatabaseDriver().query_db(query, args, one=True) except Exception as e: print(e) return False return result
def confirm_account(email, password): try: query = """select * from users where email = ? and password = ?""" args = [email, password] result = DatabaseDriver().query_db(query, args, one=True) except Exception as e: print(e) return False return result
def get_all_container(): query = 'select * from users join containers on users.user_id = containers.user_id join images on containers.image_id = images.image_id' result = DatabaseDriver().query_db(query) return result
def get_container(container_id): query = 'select * from users join containers on users.user_id = containers.user_id join images on containers.image_id = images.image_id where container_id = ?' args = [container_id] result = DatabaseDriver().query_db(query, args, one=True) return result
def get_image_name(image_id): query = 'select * from images where image_id = ?' args = [image_id] result = DatabaseDriver().query_db(query, args, one=True) return result
def create_image(name, group, size): query = 'insert into images(image_name, isize, igroup) values (?, ?, ?)' args = [name, size, group] result = result = DatabaseDriver().query_db(query, args, one=True) return result
def get_all_images(): query = 'select * from images' result = DatabaseDriver().query_db(query) return result
def edit_image(image_id, image_name, isize, igroup): query = 'update images set image_name = ?, isize = ?, igroup = ? where image_id = ?' args = [image_name, isize, igroup, image_id] result = DatabaseDriver().query_db(query, args, one=True)
def delete_image(image_id): result = DatabaseDriver().query_db( 'delete from images where image_id = ?') return result
def get_image_name(): query = 'select image_name from images' result = DatabaseDriver().query_db(query) return result