'Check if this host has already been added to the database, if not add it in.'

def add_computer(self, ip, hostname, domain, os, dc=None):

    domain = domain.split('.')[0].upper()
    cur = self.conn.cursor()
    cur.execute('SELECT    *    FROM    computers    WHERE    ip    LIKE    ?', [ip])
    results = cur.fetchall()
    if (not len(results)):
        cur.execute('INSERT    INTO    computers    (ip,    hostname,    domain,    os,    dc)    VALUES    (?,?,?,?,?)', [ip, hostname, domain, os, dc])
    else:
        for host in results:
            if ((hostname != host[2]) or (domain != host[3]) or (os != host[4])):
                cur.execute('UPDATE    computers    SET    hostname=?,    domain=?,    os=?    WHERE    id=?', [hostname, domain, os, host[0]])
            if ((dc != None) and (dc != host[5])):
                cur.execute('UPDATE    computers    SET    dc=?    WHERE    id=?', [dc, host[0]])
    cur.close()
    return cur.lastrowid
