old_contents: # -*- coding: utf-8 -*-
  
  # Copyright 2019 The Matrix.org Foundation C.I.C.
  #
  # Licensed under the Apache License, Version 2.0 (the "License");
  # you may not use this file except in compliance with the License.
  # You may obtain a copy of the License at
  #
  #     http://www.apache.org/licenses/LICENSE-2.0
  #
  # Unless required by applicable law or agreed to in writing, software
  # distributed under the License is distributed on an "AS IS" BASIS,
  # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  # See the License for the specific language governing permissions and
  # limitations under the License.
  
  class TermsStore(object):
      def __init__(self, sydent):
          self.sydent = sydent
  
      def getAgreedUrls(self, user_id):
          cur = self.sydent.db.cursor()
          res = cur.execute(
              "select url from accepted_terms_urls "
              "where user_id = ?", (user_id,),
          )
  
          urls = []
          for url, in res:
              urls.append(row[0])
  
          return urls
  
      def addAgreedUrls(self, user_id, urls):
          cur = self.sydent.db.cursor()
          res = cur.executemany(
              "insert or ignore into accepted_terms_urls (user_id, url) values (?, ?)",
              ((user_id, u) for u in urls),
          )
          self.sydent.db.commit()
  
new_contents: # -*- coding: utf-8 -*-
  
  # Copyright 2019 The Matrix.org Foundation C.I.C.
  #
  # Licensed under the Apache License, Version 2.0 (the "License");
  # you may not use this file except in compliance with the License.
  # You may obtain a copy of the License at
  #
  #     http://www.apache.org/licenses/LICENSE-2.0
  #
  # Unless required by applicable law or agreed to in writing, software
  # distributed under the License is distributed on an "AS IS" BASIS,
  # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  # See the License for the specific language governing permissions and
  # limitations under the License.
  
  class TermsStore(object):
      def __init__(self, sydent):
          self.sydent = sydent
  
      def getAgreedUrls(self, user_id):
          cur = self.sydent.db.cursor()
          res = cur.execute(
              "select url from accepted_terms_urls "
              "where user_id = ?", (user_id,),
          )
  
          urls = []
          for url, in res:
              urls.append(url)
  
          return urls
  
      def addAgreedUrls(self, user_id, urls):
          cur = self.sydent.db.cursor()
          res = cur.executemany(
              "insert or ignore into accepted_terms_urls (user_id, url) values (?, ?)",
              ((user_id, u) for u in urls),
          )
          self.sydent.db.commit()
  
subject: Fix terms POST