def check_connection(request, id_connection): connection = Connection.objects.get(id=id_connection) conn = ManagerConnection(connection.manager_db, connection.user, connection.passwd, connection.port, connection.host, connection.dbname) context = {'object': conn.check_connection()} return JsonResponse(context)
def test_connection(request): id_connection = request.POST['connection'] query = request.POST['query'] connection = Connection.objects.get(id=id_connection) conn = ManagerConnection(connection.manager_db, connection.user, connection.passwd, connection.port, connection.host, connection.dbname) context = {'object_list': conn.managerSQL(query)} return render(request, "01Connection/query_test.html", context)
def check_user(username, password): conn = ManagerConnection('postgresql', "mario", '123', "5432", "localhost", dbname="estudiantes") data = conn.managerSQL("select * from estudiante where nombre='" + username + "' and codigo_e=" + password) if len(data) > 0: return True return False
def list_db(request): manager_db = request.POST['manager_db'] user = request.POST['user'] passwd = request.POST['passwd'] port = request.POST['port'] host = request.POST['host'] conn = ManagerConnection(manager_db, user, passwd, port, host) context = {} dblist = conn.list_db() if dblist is not None: context = {'object_list': dblist} return JsonResponse(context)
def get_list_search(self, filter={}): connection = ManagerConnection(**self.connection.get_data_connection()) data = connection.managerSQL(self.query_sql) if data is not None: if len(filter) > 0: for key, value in filter.items(): filtered_data = [] for fact in data: if str(fact[key]) == str(value): filtered_data.append(fact) data = filtered_data return data return None
def get_fields_service(self): connection = ManagerConnection(**self.connection.get_data_connection()) return connection.getColumns(self.query_sql)
def is_active(self): connection = ManagerConnection(**self.connection.get_data_connection()) return connection.check_connection()
def is_online(self): if self.connection is None: return False connection = ManagerConnection(**self.connection.get_data_connection()) return connection.check_connection()