Python3: Can't write to text file with obtained data from SQL table

Question

I think I am stucked on an easy job as a beginner but have to ask this question. My objective is to create another list from data obtained from a SQL Table. This list will be created in acocrdance with the input data by user.

The SQL table has no problem, but I couldn't write on a txt file despite not receiving an error message. Where is the problem?

import sqlite3
db = sqlite3.connect("air2.sql")
cs = db.cursor()


epcs = dict()
for i in range(19):
    epcs[i] = 0

def addepc():

    epcNo = input("EPC No:")
    a = "SELECT * FROM 'epcval5' WHERE epc='EPC{}'".format(epcNo)

    cs.execute(a)
    data = cs.fetchone()
    print("You have selected this EPC:")
    for i in data:
        print(i)

    b = "SELECT value FROM 'epcval5' as float WHERE epc='EPC{}'".format(epcNo)
    cs.execute(b)
    epcv = cs.fetchone()
    res = str('.'.join(str(ele) for ele in epcv))
    print(type(res))

    with open('epcs.txt', 'w') as f:
        epcs[epcNo] = res
        f.write(epcs[epcNo])

addepc()
        print("Done! Press ENTER to continue")

        input()

Yeah interstingly now it works, thank you for your valuable comments anyway — unintention7
– unintention7, Commented Apr 19, 2020 at 14:36

Julián Vinetz · Accepted Answer · 2020-04-19 14:04:03Z

1

You could use pandas to write it to a csv file

with sqlite3.connect(DB_FILENAME) as con:
    df = pd.read_sql_query('your sql query',con)

df.to_csv('file_name')

answered Apr 19, 2020 at 14:04

Julián Vinetz

264 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

unintention7 Over a year ago

Thanks for recommendation, but the text file looks updated now. I still don't understand why it looks like unwritten at the begining. Sorry for trouble fellas...

Collectives™ on Stack Overflow

Python3: Can't write to text file with obtained data from SQL table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related