Function post_hosts_add

ddserver/interface/pages/user/hosts.py:112–156

Add a new hostname.

(user,
                   data,
                   db,
                   config,
                   messages)

         config = 'ddserver.config:Config',
         messages = 'ddserver.interface.message:MessageManager')
def post_hosts_add(user,
                   data,
                   db,
                   config,
                   messages):
  ''' Add a new hostname. '''

  # We do net check passed suffix, as mysql will tell us later on

  encrypted_password = pwd.encrypt(data.password)

  with db.cursor() as cur:
    cur.execute('''
      SELECT *
      FROM `hosts`
      WHERE `user_id` = %(user_id)s
    ''', {'user_id': user.id})

    # users can have an individual hostname limit, unlimited hostnames (-1)
    # or have no limit set in the db to use the default from the config
    if ((user.maxhosts is None and cur.rowcount >= int(config.dns.max_hosts)) or
        (user.maxhosts is not None and
         (int(cur.rowcount >= user.maxhosts) and int(user.maxhosts) is not -1))):
      messages.error('Maximum number of hosts reached')
      bottle.redirect('/user/hosts/list')

    cur.execute('''
      INSERT
      INTO `hosts`
      SET `hostname` = %(hostname)s,
          `address` = %(address)s,
          `description` = %(description)s,
          `password` = %(password)s,
          `user_id` = %(user_id)s,
          `suffix_id` = %(suffix_id)s
    ''', {'hostname': data.hostname,
          'address': data.address,
          'description': data.description,
          'password': encrypted_password,
          'user_id': user.id,
          'suffix_id': data.suffix})

  messages.success('Ok, done.')

  bottle.redirect('/user/hosts/list')