def delete_table_by_kwarg(self, table, **kwargs): """ SELECT table WHERE kwargs """ sf = NS() sf.table = self.convert_to_table(table) wheres = [] for i in range(len(list(kwargs.keys()))): passed = list(kwargs.keys())[i] value = kwargs[passed] if str(value).isdigit: wheres.append( "{} = {}".format(passed, value) ) else: wheres.append( "{} = '{}'".format(passed, value) ) sf.wherestring = " AND ".join(wheres) return self.sql(sf('delete from {table} where {wherestring}'))()
# RESULT NOW HAS username result.default_password = '******' result = system_call(result('echo {username}:{default_password} | /usr/sbin/chpasswd')) print(result) """ for line in careful: if ":"+who+":" in line: with open(path, 'a') as f: f.write( re.sub(':x:', ':changeme:', line) ) system_call("/usr/sbin/newusers {}".format(path)) os.remove(path) """ if __name__ == "__main__": dnet = Access() results = dnet.select_table('user_email_password_reset') # COLLAPSE SO WE ARE GUARENTEED TO BE WORKING WITH JUST ONE AT A TIME results = set(results) for row in results: sf = NS() sf.userid, sf.num, sf.fullname, sf.email = row print(sf('About to reset {fullname} ({num}) email password to changeme')) dnet.reset_email(str(sf.num)) print(sf('Done')) sf.table = dnet.convert_to_table('user_email_password_reset') command = dnet.sql(sf("delete from {table} where powerschoolid = '{num}'")) command()