Contents:
...
| Table of Contents | ||
|---|---|---|
|
Auth: true
params:
| Code Block | ||
|---|---|---|
| ||
params: {
currencyId: {
type: 'string',
optional: true,
},
type: {
type: 'string',
optional: true,
},
from: {
type: 'string',
optional: false,
},
to: {
type: 'string',
optional: false,
},
}, |
Responce:
A string is returned in Base64 format with the following encoded fields
For trading (columns):
Timestamp - standart date format
...
Side - Selects one of the values
"buy","sell"values according to the following rule
| Code Block | ||
|---|---|---|
| ||
ctx.meta.user.id === trade?.buyUserId ? 'buy' : 'sell'; |
...
Fee - The value and accuracy are taken by the following formula
| Code Block | ||
|---|---|---|
| ||
const fee = side === trade?.makerOrderSide
? side === 'buy'
? trade.maker_fee.toFixed(currenciesMap[base_currency])
: trade.maker_fee.toFixed(currenciesMap[quote_currency])
: side === 'buy'
? trade.taker_fee.toFixed(currenciesMap[base_currency])
: trade.taker_fee.toFixed(currenciesMap[quote_currency])
|
...
Role - The value is taken by the following formula
| Code Block | ||
|---|---|---|
| ||
const role = trade?.makerOrderSide === side ? 'Maker' : 'Taker'; |
...
For Trasactions (columns): in work
Logic:
Steps:
We check whether the specified date from which to take data does not exceed 3 months from today
We check what type of operations is being sought, trading or transactions.
type === 'trading'ORelseDepending on the required data, we form requests for trades or for operations to receive them based on a time interval.
Form an array of objects with keys that correspond to the column names and values for them.
Passing an array through a converter from an array of objects to a csv string
We convert the CSV string to base64 and return it to the front end to create a file and send it to the client
The frontend can generate text for a file in this way:
| Code Block | ||
|---|---|---|
| ||
const decodedBuffer = Buffer.from(base64Data, 'base64');
const text = decodedBuffer.toString('utf-8')
// base64Data - data from GQL
// text - text fromat for CSV file |
Trading
A query is formed to the Trade table and, based on the data, an array of objects with data in the following form is formed:
| Code Block | ||
|---|---|---|
| ||
const createHistoryForOneTrade = async (trade, currenciesMap) => {
const side = ctx.meta.user.id === trade?.buyUserId ? 'buy' : 'sell';
const [base_currency, quote_currency] = trade.market.split('-')
const fee = side === trade?.makerOrderSide
? side === 'buy'
? trade.maker_fee.toFixed(currenciesMap[base_currency])
: trade.maker_fee.toFixed(currenciesMap[quote_currency])
: side === 'buy'
? trade.taker_fee.toFixed(currenciesMap[base_currency])
: trade.taker_fee.toFixed(currenciesMap[quote_currency])
const role = trade?.makerOrderSide === side ? 'Maker' : 'Taker';
return {
Timestamp: trade.createdAt,
Market_pair: trade.market,
Side: side,
Price: trade.price,
Amount: trade.amount,
Total: trade.volume,
Fee: fee,
Role: role,
}
}
const tradeHistory = data.map(trade => {
return createHistoryForOneTrade(trade, currenciesMap)
}) |
currenciesMap - designed to take currency parameters and not make unnecessary queries to the database
| Code Block | ||
|---|---|---|
| ||
const allCurrencies = await ctx.call('DB_Currencies.find', {})
const currenciesMap = {}
allCurrencies.forEach(currency => {
currenciesMap[currency.id] = currency.precision
}) |
Converting to CSV
To convert to CSV format, there is a function that takes an array of objects of the same type. At the beginning, it forms the name of the columns taking the keys of the object, after which it searches through all objects taking the key values and writing them to a string in the format for csv
| Code Block | ||
|---|---|---|
| ||
convertToCSV(objArray){
let array = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;
let str = '';
const header = Object.keys(objArray[0])
str += header.join(',') + '\r\n';
for (let i = 0; i < array.length; i++) {
let line = '';
for (let index in array[i]) {
if (line !== '') line += ','
line += array[i][index];
}
str += line + '\r\n';
}
return str;
}, |