def __update_aggregations__(self,additional_constraints=""): # get the current time stamp from the aggregator current_timestamp = self.aggregator.__get_timestamp__() print current_timestamp count, new_time = PanoptesAPI.__update_aggregations__(self," and created_at>\'" + str(current_timestamp) + "\'") self.aggregator.__set_timestamp__(new_time) return count,new_time
from postgres_aggregation import PanoptesAPI #import panoptesPythonAPI import os import yaml import urllib2 import requests import json if os.path.exists("/home/ggdhines"): base_directory = "/home/ggdhines" else: base_directory = "/home/greg" if __name__ == "__main__": site = os.getenv('SITE', "temp") stargazing = PanoptesAPI(0,0) a,count = stargazing.__get_stats__() print a,count #print count #environment = os.getenv('ENVIRONMENT', "staging") # try: # panoptes_file = open("config/aggregation.yml","rb") # except IOError: # panoptes_file = open(base_directory+"/Databases/aggregation.yml","rb") # api_details = yaml.load(panoptes_file) # # userid = api_details[environment]["name"] # password = api_details[environment]["password"]
conn = psycopg2.connect("dbname = 'supernova' host='localhost' user = '******' password='******'") cur = conn.cursor() try: cur.execute("DROP TABLE classifications") except psycopg2.InternalError as e: print e print "I can't drop our test database!" cur.execute("CREATE TABLE users (User_id INT PRIMARY KEY, User_name TEXT)") #cur.execute("INSERT INTO Cars VALUES(1,'Audi',52642)") #conn.commit() # prepared_stmt = session.prepare("INSERT INTO classification_model (user_id,created_at,user_ip,annotations,subject_id, classification_id) VALUES (?, ?, ?, ?, ?, uuid())") # stargazing = PanoptesAPI() stargazing.__cleanup__() cur.execute("PREPARE myplan AS " "INSERT INTO users (User_id, User_name) values ($1,$2)") for ii,t in enumerate(stargazing.__yield_classifications__()): # print t[3] # print t[3][0] # print type(t[3][0]) # print type(t[3]) # print json.loads(str(t[3])) #user_id,created_at,user_ip,annotations,subject_ids #print t[4] #print json.dumps(t[4]) try:
def __init__(self,http_update=False): PanoptesAPI.__init__(self,http_update,aggregator=IterativeAggregation)
from postgres_aggregation import PanoptesAPI #import panoptesPythonAPI import os import yaml import urllib2 import requests import json if os.path.exists("/home/ggdhines"): base_directory = "/home/ggdhines" else: base_directory = "/home/greg" if __name__ == "__main__": site = os.getenv('SITE', "temp") stargazing = PanoptesAPI(0, 0) a, count = stargazing.__get_stats__() print a, count #print count #environment = os.getenv('ENVIRONMENT', "staging") # try: # panoptes_file = open("config/aggregation.yml","rb") # except IOError: # panoptes_file = open(base_directory+"/Databases/aggregation.yml","rb") # api_details = yaml.load(panoptes_file) # # userid = api_details[environment]["name"] # password = api_details[environment]["password"] # https://panoptes-comments.firebaseio.com/stargazing2015-zooniverse-org/projects/1/volunteers-count%22