parthpower

WhatsApp On Web Monitor

What It does

It gives notifications when someone goes online or offline or typing. Open chat of the contact you want to monitor and start script.

Simple Way

• Create a bookmark and Add the content of bookermarklet as url. (or goto http://parthpower.github.io/serviceworkers/whatsappmonitor.html)
• Goto whatsapp on web and click on the bookmark.
• Open chat of the contact you want to monitor.

hest

def get_count(q):
    count_q = q.statement.with_only_columns([func.count()]).order_by(None)
    count = q.session.execute(count_q).scalar()
    return count

q = session.query(TestModel).filter(...).order_by(...)

# Slow: SELECT COUNT(*) FROM (SELECT ... FROM TestModel WHERE ...) ...
print q.count()