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)
