Increment a numeric string in 1

Question

I want to add 1 to a counter that is represented as a string. the goal is to get the sequence of numbers later. For example: from 000570370 to 000570371.

part of the code:

 def rangeOrdemServ(self):
        db = self.conexaoBanco()
        cursor = db.cursor()
        cursor.execute("SELECT ordem_serv_num FROM ordem_serv ORDER BY id DESC LIMIT 1")
        dadosOrdemServ = cursor.fetchone()
        db.commit()
        global rec
        dados1 = [dadosOrdemServ]
        dados2 = [1]
        dados3 = (dados1) + (dados2)

        self.entrOrdServ.insert(END,dados3)

when I run this code get the following answer: [('000005703701021',), 1], and not the expected 000005703701022

Answer 1

Use this function:

def incrementarStringNumericaEmUm(stringNumerica):

    qtdDigitosComZeros = len(stringNumerica)
    originalComoNumero = int(stringNumerica)
    qtdDigitosSemZeros = len(str(originalComoNumero))
    resultadoComoNumero = originalComoNumero + 1

    qtdZerosNaOriginal = qtdDigitosComZeros - qtdDigitosSemZeros


    if len(str(resultadoComoNumero)) == qtdDigitosSemZeros:
        # Não houve "vai um"
        return ('0' * qtdZerosNaOriginal) + str(resultadoComoNumero)
    else:
        # Aumentou um dígito no resultado, então precisamos colocar um zero a menos
        return ('0' * (qtdZerosNaOriginal - 1)) + str(resultadoComoNumero)

It takes a numeric string in the format you have in dadosOrdemServ and returns a numeric string with the value incremented in one. For this she counts how many zeros she has in the original, then converts the original to an integer, increments that number into one, turns that number into a string and concatenates back the zeros, taking care to put a minus zero in case of "will a".