Insert with Where where I don’t have full value

Question

Example, I already have in the table the following value in the column NUM_IMPRESSAO:

K3244.K1019706.FSJC.08915

The new value I want to insert has only the last 4 digits (08915) and I need to insert it in the same line. Follow the select I tried to do:

def update_table(file_name, id):
        date = str(datetime.datetime.fromtimestamp(int(time.time())).strftime('%d/%m/%Y'))

        c.execute(f'UPDATE IMPRESSAO SET BINARY = ?,  DATA_ENVIO_BINARY = ? WHERE NUM_IMPRESSAO LIKE ?;', (file_name, date, id))
        c.commit()
        select_all()

But it’s not working.

Answer 1

I’m guessing the id is the NUM_IMPRESSAO, what you need to do is a split and put the "." as the value to divide the string in a array.

novoValor = str(id).split('.')

novoValor = novoValor[-1]

or use another class method string which is the rfind which returns the value where the searched character is. and then only pass it inside the string to the end.

novoValor = id[id.rfind('.')+1:]

use this variable novoValor and pass on your update.

c.execute(f'UPDATE IMPRESSAO SET BINARY = ?,  DATA_ENVIO_BINARY = ? ,NovoVaor = ? WHERE NUM_IMPRESSAO LIKE ?;', (file_name, date, novoValor, id))

For reference:

split

rfind