def main():
# reads a .env file
konfab.read_env('../.env')
global pg_connection, mongo_db
pg_connection = konfab.getDBConnection(False)
mongo_db = konfab.getMongoConnection()
if pg_connection and mongo_db:
application.listen(8080)
tornado.ioloop.IOLoop.instance().start()
else:
sys.exit(0)
#
import os,sys
from main import do_remove_oldest_tweets, getDBConnection, getMongoConnection, read_env, getIdTimestamp
import psycopg2
import psycopg2.extras
from psycopg2 import DataError, InternalError, DatabaseError
def remove_html(days=3):
cur = pg_connection.cursor()
q = '''DELETE FROM htmlpages USING messages
WHERE htmlpages.url_id = CAST(messages.url_id as integer)
AND to_timestamp(messages.time) < now() - interval '%s' day
'''
cur.execute(q,[days])
pg_connection.commit()
cur.close()
def main():
remove_html(5)
do_remove_oldest_tweets(5)
if __name__ == '__main__':
read_env()
pg_connection = getDBConnection()
mongo_db = getMongoConnection()
main()
import os, sys
from main import do_remove_oldest_tweets, getDBConnection, getMongoConnection, read_env, getIdTimestamp
import psycopg2
import psycopg2.extras
from psycopg2 import DataError, InternalError, DatabaseError
def remove_html(days=3):
cur = pg_connection.cursor()
q = '''DELETE FROM htmlpages USING messages
WHERE htmlpages.url_id = CAST(messages.url_id as integer)
AND to_timestamp(messages.time) < now() - interval '%s' day
'''
cur.execute(q, [days])
pg_connection.commit()
cur.close()
def main():
remove_html(5)
do_remove_oldest_tweets(5)
if __name__ == '__main__':
read_env()
pg_connection = getDBConnection()
mongo_db = getMongoConnection()
main()