Method get_sequence_query

web/db.py:1204–1210

(self, seqname)

        return query

    def get_sequence_query(self, seqname):
        import re

        # Ensure the sequence name is valid
        if not re.match(r"^[a-zA-Z_][a-zA-Z0-9_$]*$", seqname):
            raise ValueError(f"Invalid sequence name: {seqname}")
        return SQLQuery(f"; SELECT currval('{seqname}')")

    def _get_all_sequences(self):
        """Query postgres to find names of all sequences used in this database."""