db.all("select * from tbl"+ year + behind +" where stat=0",(err, rows)=>{
rows.forEach(row=> nameArray.push(row.name));//console.log(nameArray);resolve(nameArray);})
date := strconv.Itoa(t.Year())+ strconv.Itoa(t.YearDay())if del {
cmd :="drop table if exists tbl"+ date
_, err := db.Exec(cmd)if err != nil {
fmt.Println("db table drop error")}}// table exist check
cmd :="select*from tbl"+ date
_, table_check := db.Query(cmd)// checked by using return codeif table_check != nil {
cmd ="create table if not exists tbl"+ date +"(id string primary key, name, time int, stat int)"
JavaScriptでのテーブル名の作成スクリプト
// calc file namelet d =newDate();let year = d.getFullYear();let month = d.getMonth();let day = d.getDate();let date1 =newDate(year,0,0);let date2 =newDate(year, month, day)let behind = Math.floor((date2 - date1)/(24*3600*1000));// convert milisec to day
db.serialize(()=>{
db.each("select * from tbl"+ year + behind +" where stat=0",(err, row)=>{
console.log(`${row.id}${row.name}${row.time}${row.stat}`);})});
//// DB handler//'use strict';const sqlite3 =require("sqlite3");const db =newsqlite3.Database("./myfare.db");
db.serialize(()=>{
db.each("select * from tbl202382 where stat=0",(err, row)=>{
console.log(`${row.id}${row.name}`);})});
db.close();
if port.IsUSB {
fmt.Printf(" USB ID %s:%s\n", port.VID, port.PID)
fmt.Printf(" USB serial %s\n", port.SerialNumber)
-->
USB ID 0403:6001
USB serial AD5232ED16
type PortDetails struct{
Name string
IsUSB bool
VID string
PID string
SerialNumber string
// Product is an OS-dependent string that describes the serial port, it may// be not always available and it may be different across OS.
Product string
}
VID/PIDの文字列をそのまま使って、
package main
import ("bufio""errors""fmt""log""os""go.bug.st/serial""go.bug.st/serial/enumerator")
func getPortName()(string, error){
ports, error := enumerator.GetDetailedPortsList()if error != nil {return"", error
}for _, port := range ports {/*
if port.IsUSB {
fmt.Printf(" USB ID %s:%s\n", port.VID, port.PID)
fmt.Printf(" USB serial %s\n", port.SerialNumber)
*/if port.IsUSB && port.VID =="0403"&& port.PID =="6001"{return port.Name, nil
}}return"", errors.New("M5Stack cplus is not conntected")}
func main(){
portName, err :=getPortName()if err != nil {
log.Fatal(err)
os.Exit(1)}
mode :=&serial.Mode{
BaudRate:115200,}
port, err := serial.Open(portName, mode)if err != nil {
log.Fatal(err)
os.Exit(1)}
scanner := bufio.NewScanner(port)for scanner.Scan(){
fmt.Println(scanner.Text())}}