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)
