def inicio(): if request.method == 'GET': return render_template('inicio.html') host = request.form.get('host') port = request.form.get('port') user = request.form.get('user') password = request.form.get('password') config = { 'host': host, 'port': int(port), 'user': user, 'password': password } archivo=open(CONEXION_PATH,"w") archivo.write(json.dumps(config)) archivo.close() createDB() db = databases() print(databases()) return render_template('basesEncontradas.html', dbs = db)
def index(): if path.exists(CONEXION_PATH): createDB() elif globals.DB == False: return render_template('configuracion.html') basedato = DB() return render_template('home.html', basedatos=basedato.basedato())
def registrosTablas(self,tabla): registros = [] createDB() cursor = g.DB.cursor() query = "USE "+ self.consBase cursor.execute(query) query = "SELECT * FROM "+ tabla cursor.execute(query) registros = cursor.fetchall() g.DB.close() return registros
def listarTablas(self,base): self.consBase = base tables = [] createDB() cursor = g.DB.cursor() query = "USE " + base cursor.execute(query) cursor.execute("SHOW TABLES") for table in cursor: tables.append(table) g.DB.close() return tables
def describirTablas(self,tablas): describe = [] createDB() cursor = g.DB.cursor() query = "USE "+ self.consBase cursor.execute(query) for tabla in tablas: query = "DESCRIBE "+ tabla[0] cursor.execute(query) desc = cursor.fetchall() describe.append(desc) g.DB.close() return describe
def setting(): dbData = { "database": request.form.get('dbName'), "user": request.form.get('userName'), "password": request.form.get('password'), "host": request.form.get('dbServer'), "port": int(request.form.get('dbPort')), } con = open(CONEXION_PATH, 'w') con.write(json.dumps(dbData)) con.close() createDB() installDB() return redirect(url_for('index'))
def instalacion(): datos = { "database": request.form.get('base_datos'), "user": request.form.get('usuario'), "password": request.form.get('contrasena'), "host": request.form.get('host'), "port": int(request.form.get('puerto')), } conexion = open(CONEXION_PATH, 'w') conexion.write(json.dumps(datos)) conexion.close() createDB() instalarDB() return redirect(url_for('index'))
def configuracion(): usuario = request.form.get('usuario') password = request.form.get('password') servidor = request.form.get('servidor') puerto = request.form.get('puerto') dbData = { 'host': servidor, 'port': int(puerto), 'user': usuario, 'password': password, } file = open('src/config/conexion.json', 'w') file.write(json.dumps(dbData)) file.close() createDB() return redirect(url_for('index'))
def instalar(): if request.method == 'GET': return redirect(url_for('instalar')) user = request.form.get('usuario') password = request.form.get('contrasena') server = request.form.get('servidor') port = request.form.get('puerto') dbData = { 'host': server, 'port': int(port), 'user': user, 'password': password } file = open('src/config/conexion.json', 'w') file.write(json.dumps(dbData)) file.close() createDB() global bases bases = GUIDBMODEL.listarBases() return render_template('mariadb/index.html', bases=bases)