Uploaded image for project: 'Qt Creator'
  1. Qt Creator
  2. QTCREATORBUG-21158

Use upsert to simplify database updates

    XMLWordPrintable

Details

    Description

      We very often insert an new value or update a value in a row. We can not simply override that column because we loose all other values in that row. So far we triy to insert and then to update if insert is not working. This creates much more code with branches which we have to maintain and to support. In the newest version of Sqlite there is support for upsert which only needs one command for it. We should not only use it but we should update in the long run the old code to it too. It is potentially faster too.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            Unassigned Unassigned
            bubke Marco Bubke
            Petref Saraci Petref Saraci (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes