aboutsummaryrefslogtreecommitdiff
path: root/src/mailman_pgp/model/sighash.py
blob: 2dddc029ab3ffe6331116f0fd9fcf671b6dfbaef (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
# Copyright (C) 2017 Jan Jancar
#
# This file is a part of the Mailman PGP plugin.
#
# This program is free software; you can redistribute it and/or modify it under
# the terms of the GNU General Public License as published by the Free
# Software Foundation, either version 3 of the License, or (at your option)
# any later version.
#
# This program is distributed in the hope that it will be useful, but WITHOUT
# ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
# FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for
# more details.
#
# You should have received a copy of the GNU General Public License along with
# this program.  If not, see <http://www.gnu.org/licenses/>.

""""""
from sqlalchemy import Column, DateTime, LargeBinary, String

from mailman_pgp.model.base import Base


class PGPSigHash(Base):
    """"""

    __tablename__ = "sighash"

    hash = Column(LargeBinary, primary_key=True)
    fingerprint = Column(String(50), index=True)
    time = Column(DateTime)

    @staticmethod
    def find(hash=None, fingerprint=None):
        kws = {}
        if hash is not None:
            kws['hash'] = hash
        if fingerprint is not None:
            kws['fingerprint'] = fingerprint
        if len(kws) == 0:
            return None
        return PGPSigHash.query().filter_by(**kws).all()