Write python mariadb qurey in lines?

shams · 02-03-2021, 06:46 AM

This is python code, query the table pop form mariadb and writing the three columns of each row to a file in one line with comma separated:

Code:

cur  = conn.cursor()
query = "SELECT user, passwd, server FROM pop"
cur.execute(query)
for idx, row in enumerate(cur, start=1):
        with open(f'mail{idx}.txt', 'w') as f:
                f.write(','.join(row))

I want to write the each row to file in three lines like this:

Code:

User= user
pssword= passwd
server= server

Syndacate · 02-03-2021, 09:10 PM

Quote:

Originally Posted by shams

This is python code, query the table pop form mariadb and writing the three columns of each row to a file in one line with comma separated:

Code:

cur  = conn.cursor()
query = "SELECT user, passwd, server FROM pop"
cur.execute(query)
for idx, row in enumerate(cur, start=1):
        with open(f'mail{idx}.txt', 'w') as f:
                f.write(','.join(row))

I want to write the each row to file in three lines like this:

Code:

User= user
pssword= passwd
server= server

I'm not familiar with MariaDB, but why not just wrap the file write around the db access and write each iteration? That is to say:

Code:

with open(f'mail{idx}.txt', 'w') as f:
        for idx, row in enumerate(cur, start=1):
                f.write(row + '\n')

EDIT:
I don't think this is what you want, but your post is a little confusing. If you want 3 separate text files, each containing a comma separated list, looks like you have it.
If you want one text file where each row of the file contains the row of the db, then that's what I put above. I don't understand how the bottom piece correlates to what you're asking.

Maybe you meant you want a separate file for each db row where each row in the file is a col of the db like you showed at the bottom? If that's the case. But I have no idea what this has to do with the comma separated list you mentioned:

Code:

for idx, row in enumerate(cur, start=1):
        with open(f'mail{idx}.txt', 'w') as f:
                f.write('User={0}\nPassword={1}\nServer={2}\n'.format(row[0], row[1], row[2]))
                # Alternatively argument to write can be: f'User={row[0]}\nPassword={row[1]}\nServer={row[2]}\n'  - but I prefer the former, just preference.

dugan · 02-03-2021, 09:19 PM

Code:

for idx, row in enumerate(cur, start=1):
        with open(f'mail{idx}.txt', 'w') as f:
                f.write(f'User= {row[0]}\n')
                f.write(f'pssword= {row[1]}\n')
                f.write(f'server= {row[2]}\n')

evo2 · 02-03-2021, 09:27 PM

Code:

cur  = conn.cursor()
query = "SELECT user, passwd, server FROM pop"
cur.execute(query)
for idx, row in enumerate(cur, start=1):
  with open(f'mail{idx}.txt', 'w') as f:
    f.write('User= {}\npssword= {}\nserver= {}\n'.format(*row))