# 必要な宣言
!「/home/fseigojp/node_modules/nadesiko3-sqlite3/nadesiko3-sqlite3.js」を取り込む。
#このフル記載が重要だった！
# ファイルを開く
「test.sqlite3」のSQLITE3開く。
# SQLを実行
『CREATE TABLE IF NOT EXISTS books(id, name)』を[]でSQLITE3実行。
『INSERT INTO books (id,name) VALUES(?,?)』を[1,"aaa"]でSQLITE3実行。
# SQLを実行して結果を得る
『SELECT * FROM books』を[]でSQLITE3全取得
それをJSONエンコードして表示。
以上をcnako3 test.nakoで実行できた
https://nadesi.com/v3/doc/index.php?nadesiko3-sqlite3%2FSQLite3&show 参照
-------------------------------------------------------------------------------
https://qiita.com/ryome/items/16659012ed8aa0aa1fac でexpress実習できたので
https://github.com/dgmd/johnny-five-express-sampleへすすむ。。。 一応うごいた
localhost:3000/led/on or offでled制御成功
const {Board,Led} = require("johnny-five");
// Load the node library that lets us talk JS to the Arduino
var board = new Board(); // Connect to the Arduino using that library
board.on("ready", function() { // Once the computer is connected to the Arduino
// Save convenient references to the LED pin and an analog pin
var LEDpin = new Led(13);
var express = require('express'); // Load the library we'll use to set up a basic webserver
var app = express(); // And start up that server
app.get('/', function(req, res) { // what happens when we go to `/`
res.send("Hello from `server.js`!"); // Just send some text
});
app.get('/hello', function(req, res) { // what ha1ppens when we go to `/hello`
res.sendFile('hello.html', { root: '.' }); // Send back the file `hello.html` located in the current directory (`root`)
});
app.get('/led/off', function(req, res) { // what happens when someone goes to `/led/off`
console.log("Someone told me to turn the led off…");
LEDpin.off(); // Set the pin referred to by the `LEDpin` variable 'low' (off)
res.send("Now the LED for pin 13 should be off."); // And tell the user that it should be off in the webpage
});
app.get('/led/on', function(req, res) { // what happens when someone goes to `/led/off`
console.log("Someone told me to turn the led on…");
LEDpin.on(); // Set the pin referred to by the `LEDpin` variable 'high' (on)
res.send("Now the LED for pin 13 should be on.") // And tell the user that it should be off in the webpage
});
app.listen(3000, function() { // Actually turn the server on
console.log("Server's up at http://localhost:3000!");
});
});
