api.js

"use strict";
var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database('tsdns.sqlite');
var express = require('express');
var app = express();
var config = require('./config.json');

db.serialize(function() {
  db.run("CREATE TABLE IF NOT EXISTS zones (id integer primary key, zone varchar(100),target varchar(50))");
});

app.get('/list', function (req, res) {
  if( req.headers.authorization == config.api_key ){
    var zone = req.params.zone;
    db.all("SELECT * FROM zones", function(err, rows) {
      res.send('{"result":"success","message":' + JSON.stringify( rows ) + '}');
    });
  }else{
    res.statusCode = 403;
    res.send('{"result":"error","message":"Invalid auth token"}');
  }
});

app.get('/add/:zone/:target', function (req, res) {
  if( req.headers.authorization == config.api_key ){
    var zone = req.params.zone;
    var target = req.params.target;
    var sql = "INSERT INTO zones(zone,target) VALUES(?,?)";
    var stmt = db.prepare(sql,zone,target);
    stmt.run();
    stmt.finalize();
    res.statusCode = 201;
    res.send('{result:"success"}');
  }else{
    res.statusCode = 403;
    res.send('{"result":"error","message":"Invalid auth token"}');
  }
});

app.get('/del/:zone', function (req, res) {
  if( req.headers.authorization == config.api_key ){
    var zone = req.params.zone;
    var sql = "DELETE FROM zones WHERE zone =?";
    var stmt = db.prepare(sql,zone);
    stmt.run();
    stmt.finalize();
    res.statusCode = 202;
    res.send('{result:"success"}');
  }else{
    res.statusCode = 403;
    res.send('{"result":"error","message":"Invalid auth token"}');
  }
});

app.get('/get/:zone', function (req, res) {
  if( req.headers.authorization == config.api_key ){
    var zone = req.params.zone;
    db.all("SELECT * FROM zones WHERE zone=?",zone, function(err, row) {
      res.statusCode = 200;
      res.send('{"result":"success","message":' + JSON.stringify( row ) + '}');
    });
  }else{
    res.statusCode = 403;
    res.send('{"result":"error","message":"Invalid auth token"}');
  }
});

module.exports = app;