#

# You should have received a copy of the GNU Affero General Public License

# along with this program.  If not, see <https://www.gnu.org/licenses/>.

import functools

import mimetypes

import re

import sqlite3

import urllib.parse as urlparse

import rt

 PRIMARY KEY (ticket_id, attachment_id)

)"""

    @classmethod

    def setup(cls, cache_path: Path) -> Optional[sqlite3.Connection]:

        try:

            cursor = db.cursor()

            cursor.execute(cls.CREATE_TABLE_SQL)

            cursor.execute('SELECT url FROM RTLinkCache LIMIT 1')

            have_data = cursor.fetchone() is not None

        except sqlite3.OperationalError:

            # If we couldn't get this far, sqlite provides no benefit.