Return mysql query in python list

Question

Good Afternoon! How do I take the data that comes back from the sql query and play it in a list knowing that I need to return the query = to return the file folder + the files larger than the query.? Thanks for your help.

#Busca no banco de dados o ultimo Id inserido
cursor = conn.cursor()
cursor.execute('Select posicao, ArquivoLog from logbin where Id = (select max(Id) from logbin)')
recordset = cursor.fetchall()
execucao_anterior = recordset[0]
#Retorno da consulta mysql 
#bin-log.000028

#le os arquivos da pasta logs
os.chdir("C:\\Backups\\Logs\\")
lista = glob.glob("*.0*")
tm_lista = (len(lista))
posicao_na_lista = ((lista.index(arquivo_anterior)))   
print(posicao_na_lista)

#retorno
#bin-log.000028
#bin-log.000029
#bin-log.000030
#bin-log.000031

Answer 1

Hello! I made a query using Python’s Sqlite3 and saving the return of the query in a "txt" file. I hope it helps you.

import sqlite3
conteudo = []

conection = sqlite3.connect('banco.db')
c = conection.cursor()
c.execute('CREATE TABLE IF NOT EXISTS REMESSA (DATA VARCHAR(50), HORA VARCHAR(50), DESCRICAO VARCHAR(50))')
c.execute('INSERT INTO REMESSA (DATA,HORA,DESCRICAO) VALUES ("10","20","30")')
conection.commit()

teste = c.execute('SELECT * FROM REMESSA')

for row in teste:
    conteudo.append(row)
arquivo = open('C:/Teste/Arquivo_Teste_2.txt','w')
arquivo.writelines(str(conteudo))
arquivo.close()

Abs!