Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how to remove \n from file?
#3
instead of writing the file like you do, look at configparser module from standard library. Your code will be way more clean and readable

import configparser

my_config="""[options]
verbose = 1
read_all = false
delete = true
received = false
delivered_to = false
message_log = /home/mail/log
message_log_verbose = true

[destination]
type = MDA_external
path = /usr/bin/exim
arguments = ("-i", "-bm", "user@localhost")
unixfrom = true"""

config = configparser.ConfigParser()
config.read_string(my_config)

cur  = conn.cursor() 
query = "SELECT user, passwd, server FROM pop"
cur.execute(query)
for idx, row in enumerate(cur, start=1):
    credentials = dict(zip(('username', 'password', 'server'), row))
    config['options'].update(credentials)
    with open(f'mail{idx}', 'w') as f:
        config.write(f)
instead of string my_config can be a dict

Also I don't know if MariaDB python connector supports DictCursor like MySQL connector, but if it does - you can use it.
bowlofred likes this post
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply


Messages In This Thread
how to remove \n from file? - by shams - Feb-03-2021, 04:07 PM
RE: how to remove \n from file? - by bowlofred - Feb-03-2021, 04:43 PM
RE: how to remove \n from file? - by buran - Feb-03-2021, 05:53 PM
RE: how to remove \n from file? - by shams - Feb-04-2021, 07:00 AM
RE: how to remove \n from file? - by buran - Feb-04-2021, 07:05 AM
RE: how to remove \n from file? - by shams - Feb-04-2021, 07:27 AM
RE: how to remove \n from file? - by buran - Feb-04-2021, 07:29 AM
RE: how to remove \n from file? - by shams - Feb-04-2021, 07:56 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Remove single and double quotes from a csv file in 3 to 4 column shantanu97 0 7,036 Mar-31-2021, 10:52 AM
Last Post: shantanu97
  How to remove empty struct from matlab file in python? python_newbie09 0 2,407 Jun-25-2019, 12:13 PM
Last Post: python_newbie09
  How to remove form feed from file gurbhej_singh 5 3,495 May-26-2019, 05:51 AM
Last Post: gurbhej_singh
  How to remove duplicates basis keys of a csv file Prince_Bhatia 2 3,469 Aug-09-2018, 10:57 AM
Last Post: Prince_Bhatia
  Remove extra lines from .csv file in comparison with another pedteles 1 3,024 Jun-08-2017, 04:09 PM
Last Post: nilamo

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020