def get_all_wallets(*args): if args: response = database.new_query( "SELECT id, currency, name, address FROM wallets WHERE currency='" + args[0] + "' ;") else: response = database.new_query( "SELECT id, currency, name, address FROM wallets;") return list(response)
def get_raw_addresses(currency): raw_data = database.new_query( "select wallets.address from wallets where (parent_group is NULL or parent_group = '') AND currency='" + currency + "' ;") response = [] for row in raw_data: response.append(row[0]) return response
def get_address_by_group(group_id): raw_data = database.new_query( "select wallets.address from wallets inner join wallet_group on wallets.id=wallet_group.wallet_id and wallet_group.group_id=" + str(group_id) + ";") response = [] for row in raw_data: response.append(row[0]) return response
def get_addresses(currency): raw_data = database.new_query( "select wallets.address from wallets left join groups on groups.id=wallets.parent_group WHERE wallets.currency='" + currency + "' order by wallets.currency;") response = [] for row in raw_data: response.append(row[0]) return response
def get_column_to_show(): response = database.new_query( "SELECT `name`,`value` FROM settings WHERE name LIKE 'dash_show_%' ;") columns_data = {} for column in response: if column[1] == 'True': columns_data[column[0]] = True else: columns_data[column[0]] = False return columns_data
def get_all_groups(): raw_data = database.new_query("SELECT id, name, currency FROM groups;") all_groups = [([0] * 3) for i in range(len(raw_data))] i = 0 for row in raw_data: all_groups[i][0] = row[0] all_groups[i][1] = row[1] all_groups[i][2] = row[2] i += 1 return all_groups
def get_groups_for(currency): raw_data = database.new_query( "SELECT id, name FROM groups WHERE currency='" + currency + "' ;") all_groups = [([0] * 2) for i in range(len(raw_data))] i = 0 for row in raw_data: all_groups[i][0] = row[0] all_groups[i][1] = row[1] i += 1 return all_groups
def get_addresses_with_names(currency): raw_data = database.new_query( "SELECT wallets.address, wallets.name, wallets.id FROM `wallets` LEFT JOIN `wallet_group` ON wallet_group.wallet_id=wallets.id WHERE wallet_group.wallet_id IS NULL AND wallets.currency='" + currency + "';") response = [] for row in raw_data: tmp_list = [] tmp_list.append(row[0]) tmp_list.append(row[1]) tmp_list.append(row[2]) response.append(tmp_list) return response
def update_coin_prices_settings(coin, new_exchange): if_exist = database.new_query( "SELECT count(1) FROM `coins_prices` WHERE `name`='" + coin + "'")[0][0] if if_exist: response = database.new_argument_query( "UPDATE `coins_prices` SET `exchange`=? WHERE `name`=?", (new_exchange, coin)) else: response = database.new_argument_query( "INSERT INTO `coins_prices` (`exchange`, `name`) VALUES (?, ?)", (new_exchange, coin)) return response
def get_btc_price(): exchange = database.new_query("SELECT `exchange` FROM `coins_prices` WHERE `name`='btc';") if exchange: exchange = exchange[0][0] if exchange == "poloniex": return poloniex.get_btc_price() if exchange == "btc-e": return btc_e.get_btc_price() if exchange == "bittrex": return bittrex.get_btc_price() if exchange == "bitfinex": return bitfinex.get_btc_price() else: return -1
def get_price(currency): exchange = database.new_query("SELECT `exchange` FROM `coins_prices` WHERE `name`='"+ currency.lower() +"';") if exchange: exchange = exchange[0][0] if exchange == "poloniex": return poloniex.get_price(currency) if exchange == "btc-e": return btc_e.get_price(currency) if exchange == "bittrex": return bittrex.get_price(currency) if exchange == "bitfinex": return bitfinex.get_price(currency) if exchange == "coinmarketcap": return coinmarketcap.get_price(currency) else: return -1
def get_columns_details(): response = database.new_query( "SELECT `name`,`value`,`description` FROM settings WHERE name LIKE 'dash_show_%' ;" ) columns_data = [] for column in response: tmp_data = [] tmp_data.append(column[0]) if column[1] == 'True': tmp_data.append(True) else: tmp_data.append(False) tmp_data.append(column[2]) columns_data.append(tmp_data) return columns_data
def get_group_details(id): raw_data = database.new_query( "SELECT name, currency FROM groups WHERE id='" + id + "' ;") return list(raw_data[0])
def get_all_keys(): return database.new_query( "SELECT `id`, `public_key`, `private_key` FROM `exchanges_api_keys` ;")
def get_coin_prices_settings(): response = database.new_query( "SELECT `id`, `name`, `exchange` FROM coins_prices;") return list(response)
def get_wallets(currency): response = database.new_query( "SELECT id, exchange FROM wallets WHERE currency;") return list(response)
def get_key(type, exchange_id): response = database.new_query("SELECT `" + type + "` FROM exchanges_api_keys WHERE `id`='" + str(exchange_id) + "';") password = request.cookies.get('password') return decrypt_key(str(response[0][0]), password)
def get_refresh_interval(): return database.new_query( "SELECT `value` FROM `settings` WHERE `name`='dash_interval'")[0][0]
def get_exchanges(): response = database.new_query("SELECT id, exchange FROM exchanges_api_keys;") return list(response)