code: def _add_value_to_dophot_table(
              self):
          
          self.log.info('starting the ``_add_value_to_dophot_table`` method')
  
          # ADD SEPARATION RANK TO DOPHOT TABLE
          sqlQuery = """
  UPDATE dophot_photometry a,
      (SELECT
          t.primaryId,
              (SELECT
                      COUNT(*) + 1
                  FROM
                      dophot_photometry t2
                  WHERE
                      t2.expname = t.expname
                          AND t2.orbfit_postions_id = t.orbfit_postions_id
                          AND t2.orbfit_separation_arcsec < t.orbfit_separation_arcsec) AS match_rank
      FROM
          dophot_photometry t where t.sep_rank is null) b
  SET
      a.sep_rank = b.match_rank
  WHERE
      a.primaryId = b.primaryId
          AND a.sep_rank IS NULL;
  """ % locals()
          writequery(
              log=self.log,
              sqlQuery=sqlQuery,
              dbConn=self.atlasMoversDBConn
          )
  
          sqlQuery = """UPDATE dophot_photometry d,
      orbfit_positions o
  SET
      d.object_name = o.object_name,
      d.orbital_elements_id = o.orbital_elements_id
  WHERE
      d.orbfit_postions_id = o.primaryId;""" % locals()
          writequery(
              log=self.log,
              sqlQuery=sqlQuery,
              dbConn=self.atlasMoversDBConn
          )
  
          self.log.info('completed the ``_add_value_to_dophot_table`` method')
          return None
docs: *add value to dophot table*