如何在道达尔.js平台上保存和检索"RESTBuilder"的响应



受到这篇文章的启发,用vuejs建立一个加密货币比较网站

我想使用 total.js 平台编写一个单页应用程序,以从"coinmarketcap.com"API 获取硬币列表,并将响应存储到数据库中。我已经做了以下工作。但是我在存储收到的信息时出现错误。如何将收到的 json 文件保存到数据库或文件系统并在其他地方使用它?

1-我在"模型"文件夹中编写了一个名为"coins.js"的文件,其中包含以下代码

// For importing
const Fs = require('fs');
NEWSCHEMA('UsdPrice').make(function(schema) {
schema.define('price', Number);
schema.define('volume_24h', Number);
schema.define('percent_change_1h', Number);
schema.define('percent_change_24h', Number);
schema.define('percent_change_7d', Number);
schema.define('market_cap', Number);
schema.define('last_updated', Date);
});
NEWSCHEMA('Coin').make(function(schema) {
schema.define('id', Number);
schema.define('name', 'String(50)');
schema.define('symbol', 'String(40)');
schema.define('slug', 'String(50)');
schema.define('num_market_pairs', Number);
schema.define('date_added', Date);
schema.define('tags', '[String]');
schema.define('max_supply', Number);
schema.define('circulating_supply', Number);
schema.define('total_supply', Number);
schema.define('platform', 'String(20)');
schema.define('cmc_rank', Number);
schema.define('last_updated', Date);
schema.define('quote', '[Object]');
schema.define('USD', '[UsdPrice]');
schema.setSave(function($) {
var model = $.model;
var coin = U.extend({}, model.$clean());
// Extends model
coin.dateadded = F.datetime;
NOSQL('coins').insert(JSON.parse(JSON.stringify(coin)));
});
});

2-我在"控制器"文件夹中编写了一个名为"default.js"的文件,其中包含以下代码

exports.install = function() {
ROUTE('/', viwe_index);
ROUTE('POST /api/coins/  *coin --> @save');
};
function viwe_index() {
var self = this;
RESTBuilder.make(function(builder) {
builder.url('https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest? start=1&limit=2&convert=USD');
builder.header('X-CMC_PRO_API_KEY', 'b54bcf4d-1bca-4e8e-9a24-22ff2c3d462c');
builder.accept('application/json');
builder.header('Accept-Encoding', 'gzip');
builder.GET().plain().exec(function(err, response) {
//console.log(response);
AJAX('POST /api/coins/', 'coin', function(response){
response.$save();
});
});
}, function() {
self.view('index');
});
}

3-我在"views"文件夹中编写了一个名为"index.html"的文件,其中包含以下代码

@{layout('')}
<!DOCTYPE html>
<html>
<head>
<title>CryptoCompare</title>
<meta charset="utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=10" />
<meta name="format-detection" content="telephone=no"/>
<meta name="viewport" content="width=1024, user-scalable=yes" />
<meta name="robots" content="all,follow" />
<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<style type="text/css">
body { padding: 50px; margin: 0; font:normal 12px Arial; color: gray }
a { float:left; margin: 0 5px 0 0; font-size: 13px; }
p { background-color: #F0F0F0; padding: 5px; font:bold 15px Arial; }
</style>
</head>
<body>
<div>CryptoCompareTotal index</div>
</body>
</html>

当我取消注释"默认.js"中的"//console.log(响应(;"行时,我得到波纹管响应,但是当我评论它时,我收到错误。

{
"status": {
"timestamp": "2019-09-23T11:17:47.434Z",
"error_code": 0,
"error_message": null,
"elapsed": 10,
"credit_count": 1,
"notice": null
},
"data": [
{
"id": 1,
"name": "Bitcoin",
"symbol": "BTC",
"slug": "bitcoin",
"num_market_pairs": 8058,
"date_added": "2013-04-28T00:00:00.000Z",
"tags": [
"mineable"
],
"max_supply": 21000000,
"circulating_supply": 17952637,
"total_supply": 17952637,
"platform": null,
"cmc_rank": 1,
"last_updated": "2019-09-23T11:16:35.000Z",
"quote": {
"USD": {
"price": 9967.31536844,
"volume_24h": 12606470860.563,
"percent_change_1h": -0.0940096,
"percent_change_24h": -0.677549,
"percent_change_7d": -3.23074,
"market_cap": 178939594674.12457,
"last_updated": "2019-09-23T11:16:35.000Z"
}
}
},
{
"id": 1027,
"name": "Ethereum",
"symbol": "ETH",
"slug": "ethereum",
"num_market_pairs": 5641,
"date_added": "2015-08-07T00:00:00.000Z",
"tags": [
"mineable"
],
"max_supply": null,
"circulating_supply": 107859213.999,
"total_supply": 107859213.999,
"platform": null,
"cmc_rank": 2,
"last_updated": "2019-09-23T11:17:26.000Z",
"quote": {
"USD": {
"price": 210.843252214,
"volume_24h": 7065823660.95811,
"percent_change_1h": 0.108406,
"percent_change_24h": -0.423833,
"percent_change_7d": 9.19434,
"market_cap": 22741387460.794956,
"last_updated": "2019-09-23T11:17:26.000Z"
}
}
}
]
}

首先AJAX是 jComponent 函数,所以前端库,而不是后端总计.js库。

请尝试此代码,我没有API密钥,所以我无法尝试。

控制器:


exports.install = function() {
ROUTE('/', view_index);
};
function view_index() {
var self = this;
RESTBuilder.make(function(builder) {
builder.url('https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest? start=1&limit=2&convert=USD');
builder.header('X-CMC_PRO_API_KEY', 'b54bcf4d-1bca-4e8e-9a24-22ff2c3d462c');
builder.accept('application/json');
builder.header('Accept-Encoding', 'gzip');
builder.exec(function(err, response) {
// Here you could change response to your model
var model = response;
// Save to database without callback
// For usage please read docs: https://docs.totaljs.com/latest/en.html#api~global~%24SAVE 
$SAVE('Coin', model);
self.view('index');
});
});
}

架构文件的一部分:

schema.setSave(function($) {
var model = $.clean();
// Extends model
coin.dateadded = F.datetime;
NOSQL('coins').insert(model);
});

请阅读 response,您在 response.data 中有对象数组。

控制器

exports.install = function() {
ROUTE('/', view_index);
// or
// ROUTE('/');
};
function view_index() {
var self = this;
RESTBuilder.make(function(builder) {
builder.url('https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?start=1&limit=2&convert=USD');
builder.header('X-CMC_PRO_API_KEY', '07c1f1d1-681a-467e-8558-923da4d815c2');
builder.accept('application/json');
builder.header('Accept-Encoding', 'gzip');
builder.exec(function(err, response) {
var data = response.data;
data.wait(function(item, next) {
// Schema save
$SAVE('Coin', item);
// Or save directly to NOSQL
// NOSQL('coins').insert(item);
next();
}, function() {
self.view('index');
});
});
});
}

图式

schema.setSave(function($) {
var model = $.clean();
// Extends model
model.dateadded = F.datetime;
NOSQL('coins').insert(model);
});

最新更新