def _tv_remote_action(arg): if arg in _remote_key_codes: key_code = _remote_key_codes[arg] with samsungctl.Remote(config.SAMSUNG) as remote: remote.control(key_code) else: log.e(f"TV: parameter does not exist: {arg}")
def add_to_db(json_line): '''add entry in json form to database, add fitting _id''' if 'COMPLETED' in json_line: try: entry = json.loads(json_line) except ValueError: with open(tempfile.mktemp(), 'w') as f: f.write(json_line) logging.e("invalid json line: %s, see %s", line[:80], f.name) if results._db().runs.count( {"stop_time": parser.parse(entry['stop_time']['$date'])}): logging.warn("seems to already exist: %s", line[:40]) return entry['_id'] = results._next_id() imp = subprocess.Popen(["mongoimport", "-c", "runs", "-d", "sacred"], stdin=subprocess.PIPE) imp.communicate(input=json.dumps(entry)) else: logging.info("skipped line starting with %s", line[:40])
def login(request # type: Request ): if request.method == 'GET': cursor = connection.cursor(); with open("jayson.json") as json_file: json_data = json.load(json_file) datae = json_data["data"] e(datae) numb = 1 for datie in datae: try: cursor.execute("""INSERT INTO product ( `model_num`, `name`, `description`, `price`, `status` ) VALUES (%s,%s,%s,%s,%s)""", [datie['Model'], datie['Model'], 'CPU', str(random.randint(10000,50000)), 1 ]) cursor.execute(""" INSERT INTO `pc_maker`.`cpu` (`id`, `base_clock`, `boost_clock`, `cores`, `threads`, `L1_cache`, `L2_cache`, `L3_cache`, `unlocked`, `socket`, `passmark`) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)""", [ cursor.lastrowid, datie['Max Boost'], datie['Base Clock'], datie['# of CPU Cores'], datie['# of Threads'], datie['Total L1 Cache'], datie['Total L2 Cache'], datie['Total L3 Cache'], 'True', 1, random.randint(40000,100000) ]) except Exception as ioj: print('oij') return Response({ "something": "somethingwe", "data": datae }) elif request.method == 'POST': data = request.data try: email = data['email'] password = data['password'] e(password) result = run_basic_query(f'select * from user where username like \"{email}\"') e(result) dickt = dict(zip(result['desc'], result['result'][0])) e(password) real_password = dickt['u_password'] if password == real_password: e('itsthesame') dickt['status'] = "success"; user_id = dickt['id'] e(user_id) cursor = connection.cursor() cursor.execute('select * from admin_table where id = %s',(str(user_id))) if(cursor.rowcount == 1): dickt['admin'] = True return Response( dickt ) else: Response({ "status": "Unsuccessful" }) except Exception as err: e(err) return Response({ "error": "Bad request " }) return Response( { "status": "Faliure", "reason": "Wrong password has been entered" } )
import SoccerUtil as su import logging from logging import debug as d,info as i,warning as w,error as e,critical as c # logging.basicConfig(level=logging.DEBUG) print(su.LEAGUE) # debug('a') # info('b') # error('c') # warning('d') # critical('e') # critical(su.LEAGUE) d('a') i('b') e('c') w('d') c('e') c(su.LEAGUE) # # # f = open("const.json",encoding="utf-8") # # setting = json.load(f) # # print(setting) #
def register(request # type: Request ): cursor = connection.cursor() if request.method == 'POST': data = request.data # type: dict quer_str = ' ' try: action = data['action'] email = data['email'] def verify_existance(): q_result = be( f'select count(*) from user where email = \"{email}\" ') e(q_result['result'][0][0]) num = q_result['result'][0][0] return num == 0 if action == 'register': password = data['password'] first_name = data['first_name'] middle_name = data['middle_name'] last_name = data['last_name'] if verify_existance(): try: cursor.execute( """insert into user (email,u_password,first_name,middle_name,last_name) values ( %s, %s, %s, %s, %s )""", (email, password, first_name, middle_name, last_name)) q_result = cursor.execute( f'select * from user where id = (select max(id) from user)' ) return Response({ "result": cursor.lastrowidd, "status": "Successful", "with": dict( zip([desc[0] for desc in cursor.description], [item for item in list(cursor)[0]])) }) except Exception as excepp: return Response({ "oisdj": "osdhjios", "error": str(excepp) }) else: return Response({ "error": "User already exists, use forgot password or update credentials" }) elif action == 'update': if not verify_existance(): try: quer_str = ' ' datacpy = dict(data) del datacpy['email'] del datacpy['action'] # del datacpy['image'] for desc in datacpy.keys(): print(desc) quer_str += str(desc) + ' = \"' + str( datacpy[desc][0]) + '\"' + ', ' quer_str = quer_str[:-2] + ' ' print(quer_str) q_res = iq( f'update \"user\" set {quer_str} where \"username\" like \"{email}\"' ) return Response({ "result": "Updated successfully", "row": q_res.lastrowid }) except Exception as excep: e(excep) except Exception as excep: e(excep) return Response({"error": "Error in the fields given"})
def verify_existance(): q_result = be( f'select count(*) from user where email = \"{email}\" ') e(q_result['result'][0][0]) num = q_result['result'][0][0] return num == 0