Пример #1
0
def main(args):
	global time_of_last_run
	time_of_last_run = time.time()

	if sys.argv[1] == "additional":
		print(bcolors.HEADER + "We will be using a max of {} threads, a queue of {} {} releases. passwordstatus range {} to -1".format(run_threads, "{:,}".format(len(datas)), sys.argv[1], maxtries) + bcolors.ENDC)
	elif sys.argv[1] == "nfo":
		print(bcolors.HEADER + "We will be using a max of {} threads, a queue of {} {} releases. nfostatus range {} to -1".format(run_threads, "{:,}".format(len(datas)), sys.argv[1], maxtries) + bcolors.ENDC)
	else:
		print(bcolors.HEADER + "We will be using a max of {} threads, a queue of {} {} releases.".format(run_threads, "{:,}".format(len(datas)), sys.argv[1]) + bcolors.ENDC)
	time.sleep(2)

	def signal_handler(signal, frame):
		sys.exit(0)

	signal.signal(signal.SIGINT, signal_handler)

	if True:
		#spawn a pool of place worker threads
		for i in range(run_threads):
			p = queue_runner(my_queue)
			p.setDaemon(False)
			p.start()

	#now load some arbitrary jobs into the queue
	if sys.argv[1] == "additional":
		for release in datas:
			time.sleep(.02)
			my_queue.put(u("%s           =+=            %s           =+=            %s           =+=            %s           =+=            %s           =+=            %s           =+=            %s           =+=            %s           =+=            %s") % (release[0], release[1], release[2], release[3], release[4], release[5], release[6], release[7], release[8]))
	elif sys.argv[1] == "nfo":
		for release in datas:
			time.sleep(.02)
			my_queue.put(u("%s           =+=            %s           =+=            %s           =+=            %s") % (release[0], release[1], release[2], release[3]))
	elif sys.argv[1] == "movie":
		for release in datas:
			time.sleep(.02)
			my_queue.put(u("%s           =+=            %s           =+=            %s") % (release[0], release[1], release[2]))
	elif sys.argv[1] == "tv":
		for release in datas:
			time.sleep(.02)
			my_queue.put(u("%s           =+=            %s") % (release[0], release[1]))

	my_queue.join()

	if sys.argv[1] == "nfo":
		cur = info.connect()
		cur[0].execute("SELECT id from releases WHERE nfostatus <= -6")
		final = cur[0].fetchall()
		if len(datas) > 0:
			for item in final:
				run = "DELETE FROM releasenfo WHERE nfo IS NULL AND releaseid = %s"
				cur[0].execute(run, (item[0]))
				final = cur[0].fetchall()

		#close connection to mysql
		info.disconnect(cur[0], cur[1])

	print(bcolors.HEADER + "\nPostProcess {} Threaded Completed at {}".format(sys.argv[1],datetime.datetime.now().strftime("%H:%M:%S")) + bcolors.ENDC)
	print(bcolors.HEADER + "Running time: {}\n\n".format(str(datetime.timedelta(seconds=time.time() - start_time))) + bcolors.ENDC)
Пример #2
0
def main(args):
	global time_of_last_run
	time_of_last_run = time.time()

	print(bcolors.HEADER + "We will be using a max of {} threads, a queue of {}.".format(run_threads, "{:,}".format(len(datas))) + bcolors.ENDC)

	time.sleep(2)

	def signal_handler(signal, frame):
		sys.exit(0)

	signal.signal(signal.SIGINT, signal_handler)

	if True:
		#spawn a pool of place worker threads
		for i in range(run_threads):
			p = queue_runner(my_queue)
			p.setDaemon(False)
			p.start()

	#now load some arbitrary jobs into the queue
	if sys.argv[1] == "additional":
		for release in datas:
			time.sleep(.02)
			my_queue.put(u("%s  %s") % (sys.argv[1], release[0]))
	elif sys.argv[1] == "nfo":
		for release in datas:
			time.sleep(.02)
			my_queue.put(u("%s  %s") % (sys.argv[1], release[0]))
	elif sys.argv[1] == "movie":
		for release in datas:
			time.sleep(.02)
			my_queue.put(u("%s  %s") % (sys.argv[1], release[0]))
	elif sys.argv[1] == "tv":
		for release in datas:
			time.sleep(.02)
			my_queue.put(u("%s  %s") % (sys.argv[1], release[0]))

	my_queue.join()

	if sys.argv[1] == "nfo":
		cur = info.connect()
		cur[0].execute("SELECT id from releases WHERE nfostatus <= -6")
		final = cur[0].fetchall()
		if len(datas) > 0:
			for item in final:
				run = "DELETE FROM release_nfos WHERE nfo IS NULL AND releaseid = %s"
				cur[0].execute(run, (item[0]))
				final = cur[0].fetchall()

		#close connection to mysql
		info.disconnect(cur[0], cur[1])

	print(bcolors.HEADER + "\nPostProcess {} Threaded Completed at {}".format(sys.argv[1],datetime.datetime.now().strftime("%H:%M:%S")) + bcolors.ENDC)
	print(bcolors.HEADER + "Running time: {}\n\n".format(str(datetime.timedelta(seconds=time.time() - start_time))) + bcolors.ENDC)
Пример #3
0
    where = "r.proc_par2 = 0"
elif sys.argv[1] == "miscsorter":
    where = "r.nfostatus = 1 AND r.proc_nfo = 1 AND r.proc_sorter = 0 AND r.isrenamed = 0"
elif sys.argv[1] == "predbft":
    extrawhere = ""
    where = "1=1"
    rowlimit = "LIMIT %s" % (threads)

cur[0].execute("SELECT %s FROM releases r %s WHERE %s %s %s %s %s" %
               (select, join, where, extrawhere, groupby, orderby, rowlimit))
datas = cur[0].fetchall()

guids = int(len(datas))

#close connection to mysql
info.disconnect(cur[0], cur[1])

if not datas:
    print(bcolors.HEADER + "No Work to Process" + bcolors.ENDC)
    sys.exit()

my_queue = queue.Queue()
time_of_last_run = time.time()


class queue_runner(threading.Thread):
    def __init__(self, my_queue):
        threading.Thread.__init__(self)
        self.my_queue = my_queue

    def run(self):
Пример #4
0
	datas = cur[0].fetchall()
elif sys.argv[1] == "movie" and len(sys.argv) == 3 and sys.argv[2] == "clean":
	cur[0].execute("SELECT LEFT(guid, 1) FROM releases WHERE nzbstatus = 1 AND isrenamed = 1 AND searchname IS NOT NULL AND imdbid IS NULL AND categoryid BETWEEN 2000 AND 2999 GROUP BY LEFT(guid, 1) "+orderBY+" LIMIT 16")
	datas = cur[0].fetchall()
elif sys.argv[1] == "movie":
	cur[0].execute("SELECT LEFT(guid, 1) FROM releases WHERE nzbstatus = 1 AND searchname IS NOT NULL AND imdbid IS NULL AND categoryid BETWEEN 2000 AND 2999 GROUP BY LEFT(guid, 1) "+orderBY+" LIMIT 16")
	datas = cur[0].fetchall()
elif sys.argv[1] == "tv" and len(sys.argv) == 3 and sys.argv[2] == "clean":
	cur[0].execute("SELECT LEFT(guid, 1) FROM releases WHERE nzbstatus = 1 AND isrenamed = 1 AND searchname IS NOT NULL AND rageid = -1 AND categoryid BETWEEN 5000 AND 5999 GROUP BY LEFT(guid, 1) "+orderBY+" LIMIT 16")
	datas = cur[0].fetchall()
elif sys.argv[1] == "tv":
	cur[0].execute("SELECT LEFT(guid, 1) FROM releases WHERE nzbstatus = 1 AND searchname IS NOT NULL AND rageid = -1 AND categoryid BETWEEN 5000 AND 5999 GROUP BY LEFT(guid, 1) "+orderBY+" LIMIT 16")
	datas = cur[0].fetchall()

#close connection to mysql
info.disconnect(cur[0], cur[1])

if not datas:
	print(bcolors.HEADER + "No Work to Process" + bcolors.ENDC)
	sys.exit()

my_queue = queue.Queue()
time_of_last_run = time.time()

class queue_runner(threading.Thread):
	def __init__(self, my_queue):
		threading.Thread.__init__(self)
		self.my_queue = my_queue

	def run(self):
		global time_of_last_run