def post(self): try: data = request.json connector.collection('employee').insert_one(data) return jsonify({'success': True, 'message': 'success!'}) except: return jsonify({'success': False, 'message': 'error!'})
def post(self): try: data = request.json connector.collection('service').insert_one(data) return jsonify({'message': 'success', 'status': True}) except: return jsonify({'message': 'error', 'status': False})
def delete(self, id): try: where = {'_id': ObjectId(id)} value = {'$set': {'status': False}} connector.collection('employee').update_one(where, value) return jsonify({'success': True, 'message': 'success!'}) except: return jsonify({'success': False, 'message': 'error!'})
def delete(self, id): try: where = {'_id': ObjectId(id)} value = {'$set': {'delived': True}} connector.collection('service').update_one(where, value) return jsonify({'message': 'success', 'status': True}) except: return jsonify({'message': 'error', 'status': False})
def put(self, id): try: data = request.json where = {'_id':ObjectId(id)} value = {'$set':{'username':data['username'], 'password':data['password'], 'role':data['role']}} connector.collection('user').update_one(where, value) return jsonify({'message':'success', 'status':True}) except: return jsonify({'message':'error', 'status':False})
def put(self, id): try: data = request.json where = {'_id':ObjectId(id)} value = {'$set':{'client':data['client'], 'brand':data['brand'], 'model':data['model'], 'year':data['year'], 'milage':data['milage'], 'cilinder':data['cilinder'], 'colour':data['colour'], 'transmision':data['transmision']}} connector.collection('automobile').update_one(where, value) return jsonify({'success':True, 'message':'success!'}) except: return jsonify({'success':False, 'message':'error!'})
def get(self): try: document = connector.collection('service').find({'status':True}) employee = [] amount = [] data = [] for item in document: if not self.in_list(employee, item['employee']): employee.append(item['employee']) for item in employee: get = connector.collection('service').find({'employee':item}) amount.append(get.count()) data.append({'data':amount}) return jsonify({'success':True, 'message':'success', 'data':data, 'employee':employee}) except: return jsonify({'success':False, 'message':'error!'})
def get(self): try: document = connector.collection('automobile').find({'status':True}) brands = [] data = [] for item in document: if not self.in_list(brands, item['brand']): brands.append(item['brand']) for item in brands: one = connector.collection('automobile').find({'brand':item, 'transmision':'Automatico'}) two = connector.collection('automobile').find({'brand':item, 'transmision':'Automatizadas o secuenciales'}) thr = connector.collection('automobile').find({'brand':item, 'transmision':'Automatizada de doble embrague'}) fou = connector.collection('automobile').find({'brand':item, 'transmision':'CVT'}) data.append({'data':[one.count(), two.count(), thr.count(), fou.count()],'label':item}) return jsonify({'success':True, 'message':'success', 'data':data}) except: return jsonify({'success':False, 'message':'error!'})
def get(self, username, password): try: document = connector.collection('user').find_one({"username":username, "password":password, 'status':True}) data = {'id':str(document['_id']), 'username':document['username'], 'password':document['password'], 'role':document['role'], 'status':document['status']} return jsonify({'message':'success', 'status':True, 'data':data}) except: return jsonify({'message':'error', 'status':False})
def get(self, id): try: document = connector.collection('user').find_one({'_id':ObjectId(id)}) data = {'id':str(document['_id']), 'username':document['username'], 'password':document['password'], 'role':document['role'], 'status':document['status']} response = {'message':'success', 'status':True, 'data':data} return jsonify(response) except: return jsonify({'message':'error', 'status':False})
def get(self): try: ListA = [] ListB = [] data = [] document = connector.collection('automobile').find({'status':True}) for item in document: ListA.append(int(item['year'])) document = connector.collection('automobile').find({'status':True}) for item in document: ListB.append(int(item['cilinder'])) data.append(self.correlation(ListA, ListA)) document = connector.collection('automobile').find({'status':True}) for item in document: ListA.append(int(item['milage'])) document = connector.collection('automobile').find({'status':True}) for item in document: ListB.append(int(item['cilinder'])) data.append(self.correlation(ListA, ListA)) document = connector.collection('automobile').find({'status':True}) for item in document: ListA.append(int(item['milage'])) document = connector.collection('automobile').find({'status':True}) for item in document: ListB.append(int(item['year'])) data.append(self.correlation(ListA, ListA)) label = ['Año-Cilindraje', 'Kilometraje-Cilindraje', 'Kilometraje-Año'] return jsonify({'success':True, 'message':'success', 'data':data, 'label':label}) except: return jsonify({'success':False, 'message':'error!'})
def put(self, id): try: data = request.json where = {'_id': ObjectId(id)} value = { '$set': { 'name': data['name'], 'address': data['address'], 'nss': data['phone'], 'rfc': data['rfc'], 'curp': data['curp'], 'phone': data['phone'], 'email': data['email'], 'birthDate': data['birthDate'], 'salary': data['salary'], 'role': data['role'] } } connector.collection('employee').update_one(where, value) return jsonify({'success': True, 'message': 'success!'}) except: return jsonify({'success': False, 'message': 'error!'})
def get(self): try: document = connector.collection('user').find({'status':True}) data = [] for field in document: data.append({'id':str(field['_id']), 'username':field['username'], 'password':field['password'], 'role':field['role'], 'status':field['status']}) response = {'message':'success', 'status':True, 'data':data} return jsonify(response) except: return jsonify({'message':'error', 'status':False})
def get(self, id): try: document = connector.collection('automobile').find_one({'_id':ObjectId(id)}) data = {'id':str(document['_id']), 'client':document['client'], 'brand':document['brand'], 'model':document['model'], 'year':document['year'], 'milage':document['milage'], 'cilinder':document['cilinder'], 'colour':document['colour'], 'transmision':document['transmision'], 'status':document['status']} response = {'success':True, 'message':'success!', 'data':data} return jsonify(response) except: return jsonify({'success':False, 'message':'error!'})
def get(self, id): try: document = connector.collection('service').find_one( {'_id': ObjectId(id)}) data = { 'id': str(document['_id']), 'auto': document['auto'], 'employee': document['employee'], 'entreDate': document['entreDate'], 'endedDate': document['endedDate'], 'description': document['description'], 'delived': field['delived'], 'finished': field['finished'], 'status': document['status'] } response = {'message': 'success', 'status': True, 'data': data} return jsonify(response) except: return jsonify({'message': 'error', 'status': False})
def get(self, id): try: document = connector.collection('automobile').find({'client':id}) data = [] for field in document: data.append({'id':str(field['_id']), 'client':field['client'], 'brand':field['brand'], 'model':field['model'], 'year':field['year'], 'milage':field['milage'], 'cilinder':field['cilinder'], 'colour':field['colour'], 'transmision':field['transmision'], 'status':field['status']}) response = {'success':True, 'message':'success!', 'data':data} return jsonify(response) except: return jsonify({'success':False, 'message':'error!'})
def get(self): try: document = connector.collection('service').find({'status': True}) data = [] for field in document: data.append({ 'id': str(field['_id']), 'auto': field['auto'], 'client': field['client'], 'employee': field['employee'], 'entreDate': field['entreDate'], 'endedDate': field['endedDate'], 'description': field['description'], 'delived': field['delived'], 'finished': field['finished'], 'status': field['status'] }) response = {'message': 'success', 'status': True, 'data': data} return jsonify(response) except: return jsonify({'message': 'error', 'status': False})
def get(self, id): try: document = connector.collection('employee').find_one( {'_id': ObjectId(id)}) data = { 'id': str(document['_id']), 'name': document['name'], 'address': document['address'], 'nss': document['phone'], 'rfc': document['rfc'], 'curp': document['curp'], 'phone': document['phone'], 'email': document['email'], 'birthDate': document['birthDate'], 'salary': document['salary'], 'role': document['role'], 'status': document['status'] } response = {'success': True, 'message': 'success!', 'data': data} return jsonify(response) except: return jsonify({'success': False, 'message': 'error!'})
def get(self): try: document = connector.collection('employee').find({'status': True}) data = [] for field in document: data.append({ 'id': str(field['_id']), 'name': field['name'], 'address': field['address'], 'nss': field['phone'], 'rfc': field['rfc'], 'curp': field['curp'], 'phone': field['phone'], 'email': field['email'], 'birthDate': field['birthDate'], 'salary': field['salary'], 'role': field['role'], 'status': field['status'] }) response = {'success': True, 'message': 'success!', 'data': data} return jsonify(response) except: return jsonify({'success': False, 'message': 'error!'})
import math # Connector to MongoDB from Connector import connector # ListA = [85, 80, 83, 70, 81, 65, 64, 72, 69, 75, 75, 72, 81, 71] # ListB = [85, 90, 86, 96, 80, 70, 65, 95, 70, 80, 70, 81, 75, 91] ListA = [] ListB = [] document = connector.collection('automobile').find({'status': True}) for item in document: ListA.append(int(item['year'])) print(ListA) document = connector.collection('automobile').find({'status': True}) for item in document: ListB.append(int(item['cilinder'])) print(ListB) def Media(Lista): Total = 0 for Elemento in Lista: Total += Elemento return Total / len(Lista) def DesviacionEstandar(Lista, Media): i = 0 Total = 0
def get(self): try: connector.collection('automobile').find({'status':True}) return jsonify({'success':True, 'message':'success'}) except: return jsonify({'success':False, 'message':'error!'})