def converter(c, f): """Connect c to f with constraints to convert from Celsius to Fahrenheit.""" u, v, w, x, y = [connector() for _ in range(5)] multiplier(c, w, u) multiplier(v, x, u) adder(v, y, f) constant(w, 9) constant(x, 5) constant(y, 32)
def thread(pid, socket): t = threading.currentThread() db_connection = db.DB(config.db_user, config.db_pass, config.db_host, config.db_instance) bashi = connector.connector(pid, t.getName(), db_connection) while True: client, address = socket.accept() client.send(bashi.check_data(client.recv(4096))) client.close()
def update (self, retString = False): myConn = connector() query = "INSERT INTO " + self.nome_tabela + " (order_type,price,num_coins,coin_type,date_creation) values (" + repr(self.order_type) + "," + repr(self.price) + "," + repr(self.num_coins) + "," + repr(self.coin_type) + ",TIMESTAMP '" + self.date_creation.strftime('%Y-%m-%d %H:%M:%S') + "');" if not retString: myConn.crud(query) else: return query
def __init__(self, config): if not self.getlock(): exit() self.config = config self.headers = {'User-Agent': self.config['Headers']['headers']} self.connector = connector(config) self.downloader = downloader(self.headers, self.connector, dataDir=self.config['Main']['Data'], numProcs=4)
def get_open_order(self, coin_type , order_type , num_coins, price ): query = "select * from " + self.nome_tabela + " where " query += "coin_type = '" + coin_type + "'" query += " and order_type = '" + order_type + "'" query += " and price = '" + repr(price) + "'" query += " and num_coins = '" + repr(num_coins) + "'" query += " and date_not_avaible is null " myConn = connector() return myConn.execute(query)
def create_keygen(details): conn=connector() login_datas=tuple(details.values()) import secrets key=secrets.token_urlsafe(16) query="insert into loggeduser values('{}','{}')".format(login_datas[0],key) connect=conn.cursor() connect.execute(query) conn.commit() conn.close() return key
def add_user(userid): try: conn=connector() status={'status':False} query="insert into users values {}".format(tuple(userid.values())) connect=conn.cursor() connect.execute(query) conn.commit() conn.close() status['status']=True except: status['status']=False finally: return status
def loginCheck(user_id, password): con = connector.connector() cursor = con.cursor() query = """select user_type from tbl_users where user_id = \'""" + user_id + """\' and user_pass = \'""" + password + """\'""" cursor.execute(query) chk = False for row in cursor: chk = True err = {} if (chk): err['er_no'] = row[0] err['er_msg'] = 'Login Successful' else: err['er_no'] = -1 err['er_msg'] = 'Login Failed. Due to invalid user_id or password' return err
def close_old_orders(self, array_open_orders): if len(array_open_orders) == 0: return placeholder = "?" placeholders = ", ".join(placeholder for unsed in array_open_orders) now = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S') query = "UPDATE " + self.nome_tabela + " set date_not_avaible = " query += "TIMESTAMP '" + now query += "' where date_not_avaible is NULL and coin_type = '" + self.coin_type + "' and oid not in (%s)" new_query = query % placeholders for i in array_open_orders: new_query = new_query.replace("?",repr(i),1) myConn = connector() myConn.crud(new_query)
def __init__(self, string, coin_type = "b", to_update = True): arrayList = [] totalQuery = "" d = json.loads(string); for i in d['asks']: self.price= i[0] self.num_coins = i[1] self.order_type = 'a' self.coin_type = coin_type dic = self.get_open_order(self.coin_type,self.order_type,self.num_coins,self.price) boolExist = len(dic) != 0 if to_update == True and not boolExist: totalQuery += self.update(True) elif boolExist: arrayList.append(dic[0][0]) for i in d['bids']: self.price= i[0] self.num_coins = i[1] self.order_type = 'b' self.coin_type = coin_type dic = self.get_open_order(self.coin_type,self.order_type,self.num_coins,self.price) boolExist = len(dic) != 0 if to_update == True and not boolExist: totalQuery += self.update(True) elif boolExist: arrayList.append(dic[0][0]) self.close_old_orders(arrayList) if len(totalQuery) > 0: myConn = connector() myConn.crud(totalQuery)
def establish_connection( ): #Setup WMI Connection, Get SID, UserPath and default WINDIR log_buddy.write_log("Execution", "ESTABLISHING REMOTE CONNECTION..") global rem_con, user_sid, user_path, system_root, base_user_dir, user_appdata_dir, user_local_appdata_dir, user_roaming_appdata_dir, win_dir, win_def print("\nBuilding Remote Connection..\n") try: if args.password is None: log_buddy.write_log("Execution", "PROMPTING FOR PASSWORD") password = getpass.getpass(prompt="Password for " + elevated_username + ":") log_buddy.write_log("Execution", "RECEIVED PASSWORD FROM USER") log_buddy.write_log("Execution", "CREATING OBJECT Connector.Connector") rem_con = connector.connector(target, elevated_username, password, user_target, domain) else: log_buddy.write_log("Execution", "PASSWORD PROVIDED AT STARTUP") rem_con = connector.connector(target, elevated_username, elevated_password, user_target, domain) except: print("CRITICAL ERROR Instantiating Connector.Connector") log_buddy.write_log( "Error", "CRITICAL ERROR Instantiating Connector.Connector") #print(traceback.print_exc(sys.exc_info())) tb = traceback.format_exc() log_buddy.write_log("Error", str(tb)) exit(0) try: rem_con.create_session() except: print( "CRITICAL ERROR Initializing WMI Connection..does your credential have Remote Access?" ) log_buddy.write_log( "Error", "CRITICAL ERROR Initializing WMI Connection..does your credential have Remote Access?" ) tb = traceback.format_exc() log_buddy.write_log("Error", str(tb)) exit(0) try: #Prepare some paths for replacement in artifacts user_sid, user_path = rem_con.get_sid() system_root = user_path[0] base_user_dir = system_root + ":\\Users\\" + user_target user_appdata_dir = base_user_dir + "\\" + "AppData" user_local_appdata_dir = user_appdata_dir + "\\" + "Local" user_temp_dir = user_local_appdata_dir + "\\" + "Temp" user_roaming_appdata_dir = user_appdata_dir + "\\" + "Roaming" config.user_sid = user_sid config.user_path = user_path config.system_root = system_root config.base_user_dir = base_user_dir config.user_appdata_dir = user_appdata_dir config.user_local_appdata_dir = user_local_appdata_dir config.user_roaming_appdata_dir = user_roaming_appdata_dir config.user_temp_dir = user_temp_dir win_def = 0 config.win_def = win_def log_buddy.write_log("Execution", "FOUND USER SID: " + user_sid) log_buddy.write_log("Execution", "FOUND USER PATH: " + user_path) log_buddy.write_log("Execution", "CALCULATED USER DIR: " + user_sid) log_buddy.write_log("Execution", "CALCULATED USER APPDATA DIR: " + user_appdata_dir) log_buddy.write_log("Execution", "CALCULATED USER APPDATA DIR: " + user_appdata_dir) except: #NEED SID for real functionality print("CRITICAL ERROR Getting Target User SID..") log_buddy.write_log("Error", "CRITICAL ERROR Getting Target User SID..") #print(traceback.print_exc(sys.exc_info())) tb = traceback.format_exc() log_buddy.write_log("Error", str(tb)) exit(0) try: log_buddy.write_log("Execution", "CHECKING FOR WINDIR DEFAULT LOCATION") win_dir = rem_con.get_windir() config.win_dir = win_dir print("Found WINDIR : " + win_dir) log_buddy.write_log("Execution", "FOUND DEFAULT WINDIR: " + win_dir) except: win_def = 1 config.win_def = win_def print("Failed Finding default WINDIR, using " + system_root + ":\Windows") print("SOFT ERROR Finding default WINDIR, using " + system_root + ":\Windows") log_buddy.write_log( "Error", "SOFT ERROR Finding default WINDIR, using " + system_root + ":\Windows") tb = traceback.format_exc() log_buddy.write_log("Error", str(tb)) try: print("Creating TEMPARTIFACT Directory on " + target) dir = system_root + ":\\Users\\" + elevated_username + "\TEMPARTIFACTS" rv = rem_con.make_dir(dir) if rv == 0: log_buddy.write_log( "Execution", "Successfully Created Remote TEMPARTIFACT DIR") else: print("ERROR CREATING TEMPARTIFACTS DIR") except: print("CRITICAL ERROR Creating TEMPARTIFACT DIR") log_buddy.write_log("Error", "CRITICAL ERROR Creating TEMPARTIFACT DIR") tb = traceback.format_exc() log_buddy.write_log("Error", str(tb)) exit(0) try: print("Mapping Network Drive..") result = rem_con.connect_drive() #print(result) log_buddy.write_log("Execution", target + " SUCCESSFULLY MAPPED") #if ("The command completed successfully." in str(result)): #RE DO THIS SECTION # pass #else: # print("CRITICAL ERROR Mapping Network Drive") # log_buddy.write_log("Error","CRITICAL ERROR Mapping Network Drive") # tb = traceback.format_exc() # log_buddy.write_log("Error",str(tb)) # exit(0) except: print("CRITICAL ERROR Mapping Network Drive") log_buddy.write_log("Error", "CRITICAL ERROR Mapping Network Drive") tb = traceback.format_exc() log_buddy.write_log("Error", str(tb)) exit(0)
def check_aadhar(aadharid): conn=connector() query="select * from users where aadhar='{}'".format(aadharid) connect=conn.cursor() return connect.execute(query)
def login(details): conn=connector() login_datas=tuple(details.values()) query="select * from users where email='{}' and password='******'".format(login_datas[0],login_datas[1]) connect=conn.cursor() return connect.execute(query)
def update (self): myConn = connector() query = "INSERT INTO " + self.nome_tabela + " (high,low,vol,last,buy,sell,date) values (" + repr(self.high) + "," + repr(self.low) + "," + repr(self.vol) + "," + repr(self.last) + "," + repr(self.buy) + "," + repr(self.sell) + ",TIMESTAMP '" + datetime.datetime.fromtimestamp(self.date).strftime('%Y-%m-%d %H:%M:%S') + "');" myConn.crud(query);
def converter(p, v, n, t): u = connector() multiplier(p, v, u) multiplier(n, t, u)
from connector import connector from constraint import adder, multiplier, constant def converter(c, f): """Connect c to f with constraints to convert from Celsius to Fahrenheit.""" u, v, w, x, y = [connector() for _ in range(5)] multiplier(c, w, u) multiplier(v, x, u) adder(v, y, f) constant(w, 9) constant(x, 5) constant(y, 32) celsius = connector('Celsius') fahrenheit = connector('Fahreheit') converter(celsius, fahrenheit) celsius['set_val']('user', 25) fahrenheit['set_val']('user', 212) celsius['forget']('user') fahrenheit['set_val']('user', 212)
def initConnector(self, scalper): user = self.users.find_one({"user": scalper['user']}) client = connector(user['api'], user['secret'], scalper['symbol']) return client
from connector import connector from constraint import multiplier def converter(p, v, n, t): u = connector() multiplier(p, v, u) multiplier(n, t, u) p = connector('p') v = connector('v') n = connector('n') t = connector('t') converter(p, v, n, t) p['set_val']('user', 25) v['set_val']('user', 30) n['set_val']('user', 35) p['forget']('user') v['forget']('user') n['forget']('user')
def initConnector(self, scalper): client = connector(self.api_key, self.secret_key, scalper['symbol']) return client
def check_email(emailid): conn=connector() query="select * from users where email='{}'".format(emailid) connect=conn.cursor() return connect.execute(query)
def update (self): myConn = connector() query = "INSERT INTO " + self.nome_tabela + " (tid,price,amount,type,date,coin_type) values (" + repr(self.trade_id) + "," + repr(self.price) + "," + repr(self.amount) + "," + repr(self.type_trade) + ",TIMESTAMP '" + datetime.datetime.fromtimestamp(self.date).strftime('%Y-%m-%d %H:%M:%S') + "','" + self.coin_type + "');" myConn.crud(query);
def __init__(self, booksCallback=None): self.database = connector.connector(booksCallback) self.scraper = scraper.scraper()
def exists (self): query = "select * from " + self.nome_tabela + " where tid = '" + repr(self.trade_id) + "' and coin_type = '" + self.coin_type + "';" myConn = connector() d = myConn.execute(query) return len(d) > 0
return: new_results where the objects have been re-ranked using category similarity scores as well. ''' def rerank(self, results, user): cat = self.collect_categories(results) u_cv = self.create_user_cv(user, cat) a_cvs = self.create_all_article_cvs(results, cat) cosine_scores = self.cosine_sim(u_cv, a_cvs) for r in results: r['_score'] = self.alpha * r['_score'] + ( 1 - self.alpha) * cosine_scores[r['_id']] return results if __name__ == '__main__': user = {'categories': ['Auto racing']} comp = Comparator(0.6) conn = connector(hostname='http://localhost:9200', index_name='articles') results = conn.search('australia') for d in results: del d['_source']['text'] print('Original:') for d in results: print(d['_source']['title'], d['_score']) new_results = comp.rerank(results, user) new_results.sort(key=lambda x: x['_score'], reverse=True) print('New:') for d in new_results: print(d['_source']['title'], d['_score'])
print('Hello, my master!\n') import connector spider=connector.connector() info_msg = 'You seaching \"{0}\" in {1} in deep level {2}'.format( spider.data['What'], spider.data['Where'].keys()[0], spider.data['How_deep']) print(info_msg) spider.deep_search() print('I\'m quiting')