ValueError must have exactly one of create read write append mode

Question

Traceback (most recent call last):
  File "C:/ScriptsPython/pythonProject/Criar_Banco.py", line 16, in <module>
    with open(nome_arquivo, 'rw') as csvfile, arquivo_temp:
ValueError: must have exactly one of create/read/write/append mode

import csv
import shutil
from tempfile import NamedTemporaryFile

nome_arquivo = 'exemplo.csv'
arquivo_temp = NamedTemporaryFile(delete=False)

with open('exemplo.csv', 'r') as csvfile, arquivo_temp:
    reader = csv.DictReader(csvfile)
    campos = ['SUBSCRIBERID',
              'SERIALNUMBER',
              'DEVICE_TYPE_NAME',
              'FIRSTCONTACTTIME',
              'LASTCONTACTTIME',
              'LASTACTIVATIONTIME',
              'SOFTWAREVERSION',
              'EXTERNALIPADDRESS',
              'PRODUCT_CLASS',
              'MANUFACTURER',
              'OUI',
              'MODEL_NAME',
              'ACTIVATED',
              'DELETED',
              'NASIP',
              'NASPORT',
              'NRC',
              'REPLACED_BY',
              'SERVICETYPEID',
              'UPTIME',
              'FIRSTUSAGEDATE',
              'HARDWAREVERSION',
              'SPECVERSION',
              'PROVISIONCODE',
              'ADDITIONALHARDWAREVERSION',
              'ADDITIONALSOFTWAREVERSION',
              'VENDORCONFIGFILENUMBEROFENTRIES',
              'MACADDR',
              'MAC_5G']
    writer = csv.DictWriter(arquivo_temp, fieldnames=campos)
    writer.writeheader()
    for linha in reader:
        print(linha)
        if linha['PRODUCT_CLASS'] == 'HGU_Askey_Sophia':
            linha['MAC_5G'] = 'teste'
            print(linha)
        writer.writerow(linha)
    shutil.move(arquivo_temp.name, nome_arquivo)

Answer 1

You can open a file for simultaneous reading and writing but it won't work the way you expect:

with open('file.txt', 'w') as f:
    f.write('abcd')

with open('file.txt', 'r+') as f:  # The mode is r+ instead of r
    print(f.read())  # prints "abcd"

    f.seek(0)        # Go back to the beginning of the file
    f.write('xyz')

    f.seek(0)
    print(f.read())  # prints "xyzd", not "xyzabcd"!

You can overwrite bytes or extend a file but you cannot insert or delete bytes without rewriting everything past your current position. Since lines aren't all the same length, it's easiest to do it in two seperate steps:

lines = []

# Parse the file into lines
with open('file.txt', 'r') as f:
    for line in f:
        if line.startswith('text to replace'):
            line = 'new text\n'

        lines.append(line)

# Write them back to the file
with open('file.txt', 'w') as f:
    f.writelines(lines)

    # Or: f.write(''.join(lines))