def remove(self): deletedevices = conexion.Add( 'delete from devices where environment = %s', [self.id]) deleteClient = conexion.Add( "delete from clients where enviroment = %s", [self.id]) delete = conexion.Add("delete from bridge where id_environments = %s", [self.id]) deleteEnv = conexion.Add("delete from environments where id = %s", [self.id])
def delete_client(self): cmm1 = conexion.Add( "delete from devices where (environment = %s and client = %s)", [self.enviroment, self.identification]) cmm2 = conexion.Add( "delete from clients where (enviroment = %s and identification = %s)", [self.enviroment, self.identification]) if cmm1: return 'Ok'
def create(self): now = datetime.datetime.now() - datetime.timedelta(hours=5) insert = conexion.Add( "insert into environments (img,name,key_code,creation_date,created_by) values (%s,%s,%s,%s,%s)", [self.img, self.name, self.key_code, now, self.created_by]) consult = conexion.search( "select id from environments where key_code = %s", [self.key_code]) insert2 = conexion.Add( "insert into bridge (id_user,id_environments,v_admin,linking_date,state) values (%s,%s,%s,%s,%s)", [self.created_by, consult[0][0], 1, now, 1])
def remove_sevice(self): now = datetime.now() cmm = conexion.Add( "update devices set status = %s , departure_date = %s where (id = %s and environment = %s)", [self.status, now, self.id, self.enviroment]) if cmm: return 'Ok'
def change_status(self): now = datetime.now() cmm = conexion.Add( "update devices set status = %s, start_process = %s, process_start_date = %s where id = %s and environment = %s", [self.status, self.user, now, self.id, self.enviroment]) if cmm: return 'Ok'
def modification_pass(self): now = datetime.now() respuesta = conexion.Add( 'update users set password = %s, recovery_date = %s where code = %s', [self.password, now, self.code]) if respuesta: return 'Ok'
def create_user(self): respuesta = conexion.Add( "insert into users (name,surname,email,password,img,activated,code) values (%s,%s,%s,%s,%s,%s,%s);", [ self.name, self.surname, self.email, self.password, "https://firebasestorage.googleapis.com/v0/b/datafilter-32b92.appspot.com/o/profile%2Fpngegg.png?alt=media&token=3f31a154-ef66-487c-abfd-962b3c349e88", 0, self.code ])
def add_client(self): cmm = conexion.Add( "insert into Clients (id,enviroment,email,name,surname,phone,address) values (%s,%s,%s,%s,%s,%s,%s)", [ self.id, self.enviroment, self.email, self.name, self.surname, self.phone, self.address ]) if cmm: return 'Ok'
def save_info_repair(self): cmm = conexion.Add( "update devices set failure = %s, diagnosis = %s, solution = %s where (id = %s and environment = %s)", [ self.failure, self.diagnosis, self.solution, self.id, self.enviroment ]) if cmm: return 'Ok'
def edit_client(self): cmm = conexion.Add( "update clients set name = %s, surname = %s, email = %s, phone = %s, address = %s where (enviroment = %s and identification = %s)", [ self.name, self.surname, self.email, self.phone, self.address, self.enviroment, self.identification ]) if cmm: return 'Ok'
def search_clients(self): data = {} data['clients'] = [] cmm = conexion.Add("select * from Clients where (enviroment = %s and id = %s)",[self.enviroment, self.id]) if(cmm): for i in cmm: data['clients'].append({'id':i[0],'enviroment':i[1],'email':i[2],'name':i[3],'surname':i[4],'phone':i[5],'address':i[6]}) return data['clients'] else: return None
def edit_device(self): cmm = conexion.Add( 'update devices set type = %s, model = %s, brand = %s, serial = %s, accessories = %s, conditions = %s, work_to_do = %s where id = %s', [ self.device, self.model, self.brand, self.serial, self.accessories, self.condition, self.work_to_do, self.id ]) if (cmm): return cmm else: return None
def add_device(self): now = datetime.now() cmm = conexion.Add( "insert into devices (client,environment,user,type,model,brand,serial,accessories,conditions,work_to_do,status,admission_date) values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)", [ self.client, self.enviroment, self.user, self.device, self.model, self.brand, self.serial, self.accessories, self.condition, self.work_to_do, 1, now ]) if cmm: return 'Ok'
def send_email_recover(self): respuesta = conexion.search( 'select name,email from users where email = %s', [self.email]) if respuesta: for i in respuesta: now = datetime.now() + timedelta(hours=24) resp = conexion.Add( 'update users set code=%s, recovery_date= %s where email = %s', [self.code, now, self.email]) return i[0] else: return None
def manage_user_join_by_Code(self): now = datetime.now() data = {} data['manage'] = [] consult1 = conexion.search('select count(*) from bridge b, users u, environments e where b.id_user = u.id and b.id_environments = e.id and e.key_code = %s and b.id_user = %s',[self.key_code,self.id]) if(consult1[0][0] != 0): return "stError" else: consult = conexion.search('select id from environments where key_code = %s',[self.key_code]) if(consult): consult2 = conexion.Add('insert into bridge (id_user,id_environments,v_admin,linking_date,state) values (%s,%s,%s,%s,%s)',[int(self.id),int(consult[0][0]),0,now,1]) else: return "stError101"
def check_repair(self): now = datetime.now() cmm = conexion.search( "select failure,diagnosis,solution from devices where (id = %s and environment = %s)", [self.id, self.enviroment]) if (self.status == 3): if (cmm[0][0] != None and cmm[0][1] != None and cmm[0][2] != None): if ((len(cmm[0][0]) != 0) and (len(cmm[0][1]) != 0) and (len(cmm[0][2]) != 0)): cod = conexion.Add( "update devices set status = %s,finish_date = %s where (id = %s and environment = %s)", [self.status, now, self.id, self.enviroment]) return "success" else: return 'error3' else: return 'error3'
def edit_name(self): update = conexion.Add( 'update users set name = %s, surname = %s where id = %s', [self.name, self.surname, self.id]) if update: return 'Ok'
def save_picture(self): update = conexion.Add("update users set img = %s where id = %s", [self.img, self.id]) return 'Ok'
def manage_change_status(self): update = conexion.Add("update bridge set state = %s where id = %s", [self.state, self.id]) return None
def main_register_client(self, identification, env, name, surname, email, phone, address): create = conexion.Add( 'insert into clients (identification,enviroment,name,surname,email,phone,address) values (%s,%s,%s,%s,%s,%s,%s)', [identification, env, name, surname, email, phone, address]) return None
def activated_account(self): respuesta = conexion.Add( 'update users set activated = %s where code = %s', [self.activated, self.code])
def contact_us(self): cmm = conexion.Add( "insert into contact_information (name,email,message,viewed) values (%s,%s,%s,%s)", [self.name, self.email, self.message, self.viewed]) if cmm: return 'Ok'
def change_password(self): update = conexion.Add('update users set password = %s where id = %s', [self.password, self.id]) if update: return 'Ok'
def manega_users_remove(self): consult = conexion.Add("delete from bridge where id = %s", [self.id]) return consult
def delete(self): cmm = conexion.Add( "delete from devices where id = %s and environment = %s", [self.id, self.enviroment]) if cmm: return 'Ok'