h0v1n8-web/rotbot/common/queries.py

def create_ifnot_onrecord(self, table, name):
    record = self.db.one("SELECT name, network FROM " + table + " WHERE LOWER(name)=LOWER(%s) AND LOWER(network)=LOWER(%s)", (name, self.network, ))
    
    if record:  # On record.
        # Correct capitalisation of network name, if needed.
        if not self.network == record[1]:
            self.db.run("UPDATE networks SET name=%s WHERE LOWER(name)=LOWER(%s)", (self.network, self.network, ))
        
        # Correct capitalisation if needed.
        if not name == record[0]:
            self.db.run("UPDATE " + table + " SET name=%s WHERE LOWER(name)=LOWER(%s) AND network=%s", (name, name, self.network, ))
    
    # Create record.
    else:   # Not on record.
        self.db.run("INSERT INTO " + table + " (name, network) VALUES (%s, %s)", (name, self.network, ))