text: """
  """
  import json
  import os
  import random
  from fuzzywuzzy import fuzz
  from itertools import chain
  from copy import deepcopy
  
  
  class Database(object):
      def __init__(self, db_path):
          super(Database, self).__init__()
          # loading databases
          domains = ['restaurant', 'hotel', 'attraction', 'train', 'hospital', 'taxi', 'police']
          self.dbs = {}
          for domain in domains:
              with open(os.path.join(db_path, domain+"_db.json")) as f:
                  self.dbs[domain] = json.load(f)
  
      def query(self, domain, constraints, ignore_open=False, soft_contraints=(), fuzzy_match_ratio=60):
          """Returns the list of entities for a given domain
          based on the annotation of the belief state"""
          # query the db
          if domain == 'taxi':
              return [{'taxi_colors': random.choice(self.dbs[domain]['taxi_colors']),
              'taxi_types': random.choice(self.dbs[domain]['taxi_types']),
              'taxi_phone': ''.join([str(random.randint(1, 9)) for _ in range(11)])}]
          if domain == 'police':
              return deepcopy(self.dbs['police'])
          if domain == 'hospital':
              department = None
              for key, val in constraints:
                  if key == 'department':
                      department = val
              if not department:
                  return deepcopy(self.dbs['hospital'])
              else:
                  return [deepcopy(x) for x in self.dbs['hospital'] if x['department'].lower() == department.strip().lower()]
          constraints = list(map(lambda ele: ele if not(ele[0] == 'area' and ele[1] == 'center') else ('area', 'centre'), constraints))
  
          found = []
          for i, record in enumerate(self.dbs[domain]):
              constraints_iterator = zip(constraints, [False] * len(constraints))
              soft_contraints_iterator = zip(soft_contraints, [True] * len(soft_contraints))
              for (key, val), fuzzy_match in chain(constraints_iterator, soft_contraints_iterator):
                  if val == "" or val == "dont care" or val == 'not mentioned' or val == "don't care" or val == "dontcare" or val == "do n't care":
                      pass
                  else:
                      try:
                          record_keys = [k.lower() for k in record]
                          if key.lower() not in record_keys:
                              continue
                          if key == 'leaveAt':
                              val1 = int(val.split(':')[0]) * 100 + int(val.split(':')[1])
                              val2 = int(record['leaveAt'].split(':')[0]) * 100 + int(record['leaveAt'].split(':')[1])
                              if val1 > val2:
                                  break
                          elif key == 'arriveBy':
                              val1 = int(val.split(':')[0]) * 100 + int(val.split(':')[1])
                              val2 = int(record['arriveBy'].split(':')[0]) * 100 + int(record['arriveBy'].split(':')[1])
                              if val1 < val2:
                                  break
                          # elif ignore_open and key in ['destination', 'departure', 'name']:
                          elif ignore_open and key in ['destination', 'departure']:
                              continue
                          elif record[key].strip() == '?':
                              # '?' matches any constraint
                              continue
                          else:
                              if not fuzzy_match:
                                  if val.strip().lower() != record[key].strip().lower():
                                      break
                              else:
                                  if fuzz.partial_ratio(val.strip().lower(), record[key].strip().lower()) < fuzzy_match_ratio:
                                      break
                      except:
                          continue
              else:
                  res = deepcopy(record)
                  res['Ref'] = '{0:08d}'.format(i)
                  found.append(res)
  
          return found
  
  
  if __name__ == '__main__':
      db = Database(db_path = "/Users/Yam/Yam/chatbot/chatbot/data/db")
      print(db.query("train", [['departure', 'cambridge'], ['destination','peterborough'], ['day', 'tuesday'], ['arriveBy', '11:15']]))
  