def makePost():
product = db_functions.getProductToPost(config.db)
if not product is None:
print product[1]
r.login(config.login, config.password)
affUrl = web_functions.generateAffLink(product[1])
if not affUrl is None:
r.submit(config.destinationSubreddit, product[2], url=affUrl)
db_functions.recordPost(product[0], config.db)
web_functions.submitUrl(product[2], affUrl)
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)