def update_result(table_store): storage = Storage(google_key_path='igenie-project-key.json') query = 'UPDATE `' + table_store +'` SET Status = "inactive" WHERE Status = "active"' try: result = storage.get_bigquery_data(query) except Exception as e: print(e)
def update_result(table_store): storage = Storage(google_key_path=args.service_key_path) query = 'UPDATE `' + table_store + '` SET Status = "inactive" WHERE Status = "active"' try: result = storage.get_bigquery_data(query) except Exception as e: print(e)
def update_result(table_store): #storage = Storage(google_key_path='/Users/kefei/Documents/Igenie_Consulting/keys/igenie-project-key.json') storage = Storage(google_key_path='igenie-project-key.json') query = 'UPDATE `' + table_store + '` SET Status = "inactive" WHERE Status = "active"' try: result = storage.get_bigquery_data(query) except Exception as e: print(e)
def update_result(table_store,choice): if choice == 1: table_store = 'pecten_dataset_test.Fundamental_current_ranking2' else: table_store = 'pecten_dataset_test.Fundamental_growth_ranking2' storage = Storage(google_key_path='/Users/kefei/Documents/Igenie_Consulting/keys/igenie-project-key.json') storage = Storage(google_key_path='igenie-project-key.json' ) query = 'UPDATE `' + table_store +'` SET Status = "inactive" WHERE Status = "active"' try: result = storage.get_bigquery_data(query) except Exception as e: print(e)
def update_result(args): table_store = args.table_storage if args.environment == 'test': dataset = 'pecten_dataset_test' else: dataset = 'pecten_dataset' #storage = Storage(google_key_path='/Users/kefei/Documents/Igenie_Consulting/keys/igenie-project-key.json') storage = Storage(google_key_path=args.service_key_path) query = 'UPDATE `' + dataset + '.' + table_store + '` SET Status = "inactive" WHERE Status = "active"' try: result = storage.get_bigquery_data(query) except Exception as e: print(e)