Usr db SQL lite

gistfile1.txt

[{"id":"7d5347d5.3b49c8","type":"comment","z":"fd04a8e8.b4e6d8","name":"capiamo se l'utente può accedere","info":"","x":450,"y":660,"wires":[]},{"id":"62478e9c.fbd76","type":"sqlite","z":"fd04a8e8.b4e6d8","mydb":"4e4abe36.17055","sqlquery":"msg.topic","sql":"","name":"user database","x":440,"y":740,"wires":[["c880155d.9512b8"]]},{"id":"f1a2fafc.6b8c38","type":"inject","z":"fd04a8e8.b4e6d8","name":"CREATE TABLE1","topic":"CREATE TABLE table1(id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, tag TEXT, ACCESSO1 TEXT, ACCESSO2 TEXT, ACCESSO3 TEXT)","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":"0.1","x":140,"y":700,"wires":[["62478e9c.fbd76"]]},{"id":"c880155d.9512b8","type":"debug","z":"fd04a8e8.b4e6d8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":630,"y":920,"wires":[]},{"id":"b788459b.65e6a8","type":"inject","z":"fd04a8e8.b4e6d8","name":"insert utente Pino Daniele","topic":"INSERT INTO table1 VALUES(1, \"Pino Daniele\",\"421418319424897128\",\"Y\", \"N\", \"N\")","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":170,"y":820,"wires":[["62478e9c.fbd76"]]},{"id":"312e9a48.dd6fa6","type":"inject","z":"fd04a8e8.b4e6d8","name":"Query for NFC TAG","topic":"SELECT DISTINCT name FROM table1 WHERE tag =  \"421418319424897128\"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":190,"y":1000,"wires":[["62478e9c.fbd76"]]},{"id":"27b3e990.056cf6","type":"inject","z":"fd04a8e8.b4e6d8","name":"insert utente Franco Battiato","topic":"INSERT INTO table1 VALUES(2, \"Franco Battiato\",\"521416319424807026\",\"N\", \"Y\", \"N\")","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":160,"y":880,"wires":[["62478e9c.fbd76"]]},{"id":"6e5a1c50.316254","type":"inject","z":"fd04a8e8.b4e6d8","name":"insert utente Francesco De Gregori","topic":"INSERT INTO table1 VALUES(3, \"Francesco De Gregori\",\"555556319424807026\",\"N\", \"Y\", \"N\")","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":140,"y":940,"wires":[["62478e9c.fbd76"]]},{"id":"4e4abe36.17055","type":"sqlitedb","z":"","db":"C:\\Users\\Davide Gomba\\Documents\\A-ITS\\online course\\db\\user-db.db","mode":"RWC"}]