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()