*add value to dophot table*

def _add_value_to_dophot_table(
            self):
        """*add value to dophot table*
        """
        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