def delCounter(self, ):
db = models()
total = db(db.counter.id == 1).select().first()
totalLeaks = total.total if total else 0
if totalLeaks > 0:
db(db.counter.id == 1).update(total=totalLeaks - 1)
db.commit()
def insertLeak(self, username, email, password, database):
db = models()
db.leaks.insert(username=username,
email=email,
password=password,
database=database)
db.commit()
def getLeaks(self, data, searchby):
db = models()
if searchby == 'email':
results = db(db.leaks.email.contains(
data, case_sensitive=False)).select()
elif searchby == 'password':
results = db(db.leaks.password.contains(
data, case_sensitive=False)).select()
return results
def saveMassLeaks(self,leaks):
allLeaks = list()
counter = 0
for leak in leaks:
leak = str(leak).strip()
if leak:
leak = leak.strip().split(',')
if len(leak) == 4:
counter += 1
allLeaks.append({"email":leak[0],"username":leak[1],"password":leak[2],"database":leak[3]})
db = models()
db.leaks.bulk_insert(allLeaks)
db.commit()
self.addCounter(counter)
def updatePassword(self, oldpass, newpass):
db = models()
total = db(db.leaks.password == oldpass).count()
db(db.leaks.password == oldpass).update(password=newpass)
db.commit()
return total
def getTotal(self, ):
db = models()
total = db(db.counter.id == 1).select().first()
return total.total if total else 0
def addCounter(self, n):
db = models()
total = db(db.counter.id == 1).select().first()
totalLeaks = total.total if total else 0
db.counter.update_or_insert(db.counter.id == 1, total=totalLeaks + n)
db.commit()
def getAll(self, ):
db = models()
results = db().select(db.leaks.ALL)
return results
def deleteLeak(self, leakid):
db = models()
db(db.leaks.id == leakid).delete()
db.commit()
self.delCounter()
def lastEntries(self, ):
db = models()
results = db().select(db.leaks.ALL,
orderby=~db.leaks.id,
limitby=(0, 10))
return results
