while True: #Get the newest 10 post from the subreddit posts = r.get_subreddit(config.subreddit).get_new(limit=10) #loop through each submission for post in posts: print post.title productUrl = functions.removeAffiliateLink(post.url) if not db_functions.productExists(productUrl, config.db): print 'not exist' db_functions.addSubreddit(post.subreddit_id, post.subreddit.display_name, config.db) db_functions.addRedditUser(post.author.id, post.author.name, config.db) db_functions.addRedditPost(post.id, post.title, post.url, post.subreddit_id, post.author.id, post.created_utc, config.db) #ADD check if already copied if functions.aliexpressLink(post.url): r.login(config.login, config.password) affUrl = web_functions.generateAffLink(post.url) print affUrl r.submit(config.destinationSubreddit2, post.title, url=affUrl) #db_functions.recordPost(product[0], config.db) web_functions.submitUrl(post.title, affUrl) db_functions.addProduct(productUrl, post.title, config.db) functions.showCountdown(60) #sleep for an hour functions.showCountdown(60*60)
import praw import time from config import config from functions import db_functions from functions import functions from datetime import datetime r = praw.Reddit(user_agent=config.userAgentString) while True: #Get the top n reddit post from the subreddit posts = r.get_subreddit(config.subreddit).get_new(limit=1000) #loop through each submission for post in posts: try: productUrl = functions.removeAffiliateLink(post.url) db_functions.addSubreddit(post.subreddit_id, post.subreddit.display_name, config.db) db_functions.addRedditUser(post.author.id, post.author.name, config.db) db_functions.addRedditPost(post.id, post.title, post.url, post.subreddit_id, post.author.id, post.created_utc, config.db) #check if this is an aliexpress link if functions.aliexpressLink(productUrl): print productUrl db_functions.addProduct(productUrl, post.title, config.db) except: pass #sleep for an hour functions.showCountdown(60*60)