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
