setup.js

'use strict';
(function() {
var fs = require('fs'),
    path = require('path'),
    tls = require('tls'),
    https = require('https'),
    Q = require('q'),
    twitterAPI = require('node-twitter-api'),
    log4js = require('log4js'),
    https = require('https'),
    promRegister = require('prom-client/lib/register'),
    prom = require('prom-client'),
    _ = require('lodash');

/*
 * Config file should look like this:
 *
 *  {
 *    "consumerKey": "...",
 *    "consumerSecret": "...",
 *    "cookieSecret": "...",
 *  }
 */
var configDir = process.env['BT_CONFIG_DIR'] || '/etc/blocktogether/';
var nodeEnv = process.env['NODE_ENV'] || 'development';
var configData = fs.readFileSync(path.join(configDir, 'config.json'), 'utf8');
var config = JSON.parse(configData);

var stats = {
  twitterSockets: new prom.Gauge('twitter_sockets', 'Number of open sockets to Twitter API'),
  twitterRequests: new prom.Gauge('twitter_requests', 'Number of pending requests to Twitter API')
}

var twitter = new twitterAPI({
    consumerKey: config.consumerKey,
    consumerSecret: config.consumerSecret
});
twitter.keepAliveAgent.maxSockets = 18;
setInterval(function() {
  var requests = twitter.keepAliveAgent.requests;
  var totalRequests = 0;
  for (var host in requests) {
    totalRequests += requests[host].length;
  }
  stats.twitterRequests.set(totalRequests);

  var sockets = twitter.keepAliveAgent.sockets;
  var totalSockets = 0;
  for (host in sockets) {
    totalSockets += sockets[host].length;
  }
  stats.twitterSockets.set(totalSockets);
}, 1000);

log4js.configure(path.join(configDir, nodeEnv, '/log4js.json'), {
  cwd: '/data/blocktogether/shared/log'
});
// The logging category is based on the name of the running script, e.g.
// blocktogether, action, stream, etc.
var scriptName = path.basename(require.main ? require.main.filename : 'repl')
  .replace(".js", "");
var logger = log4js.getLogger(scriptName);

var sequelizeConfigData = fs.readFileSync(
  path.join(configDir, 'sequelize.json'), 'utf8');
var c = JSON.parse(sequelizeConfigData)[nodeEnv];
var Sequelize = require('sequelize'),
    sequelize = new Sequelize(c.database, c.username, c.password, _.extend(c, {
      dialectOptions: _.extend(c.dialectOptions || {}, {
        bigNumberStrings: true,
        supportBigNumbers: true,
        charset: "utf8mb4",
        collate: "utf8mb4_unicode_ci"
      }),
      logging: function(message) {
        logger.trace(message);
      }
    }));
sequelize
  .authenticate()
  .error(function(err) {
    logger.error('Unable to connect to the database:', err);
  });

// Use snake_case for model accessors because that's SQL style.
var TwitterUser = sequelize.define('TwitterUser', {
  uid: { type: Sequelize.BIGINT.UNSIGNED, primaryKey: true },
  friends_count: Sequelize.INTEGER,
  followers_count: Sequelize.INTEGER,
  profile_image_url_https: Sequelize.STRING,
  screen_name: Sequelize.STRING,
  name: Sequelize.STRING,
  deactivatedAt: Sequelize.DATE,
  lang: Sequelize.STRING,
  statuses_count: Sequelize.INTEGER,
  // NOTE: This field doesn't exactly match the name of the corresponding field
  // in the Twitter User object ('created_at'), because that matches too closely
  // the Sequelize built-in createdAt, and would be confusing.
  account_created_at: Sequelize.DATE
});

/**
 * BtUser, shorthand for Block Together User. Contains the user-related data
 * specific to Block Together, as opposed to their Twitter user profile.
 */
var BtUser = sequelize.define('BtUser', {
  uid: { type: Sequelize.BIGINT.UNSIGNED, primaryKey: true },
  // Technically we should get the screen name from the linked TwitterUser, but
  // it's much more convenient to have it right on the BtUser object.
  screen_name: Sequelize.STRING,
  // Twitter credentials
  access_token: Sequelize.STRING,
  access_token_secret: Sequelize.STRING,
  // If non-null, the slug with which the user's shared blocks can be accessed.
  shared_blocks_key: Sequelize.STRING,
  // True if the user has elected to block accounts < 7 days old that at-reply.
  // If this field is true, Block Together will monitor their User Stream to
  // detect such accounts.
  block_new_accounts: Sequelize.BOOLEAN,
  // True if the user has elected to block accounts with < 15 followers that at-reply.
  // If this field is true, Block Together will monitor their User Stream to
  // detect such accounts.
  block_low_followers: Sequelize.BOOLEAN,
  // Whether the user elected to follow @blocktogether from the settings screen.
  // This doesn't actually track their current following status, but we keep
  // track of it so that if they re-load the settings page it remembers the
  // value.
  follow_blocktogether: Sequelize.BOOLEAN,
  // When a user revokes the app, deactivates their Twitter account, or gets
  // suspended, we set deactivatedAt to the time we observed that fact.
  // Since each of those states can be undone, we periodically retry credentials
  // for 30 days, and if the user comes back we set deactivatedAt back to NULL.
  // Otherwise we delete the BtUser and related data.
  // Users with a non-null deactivatedAt will be skipped when updating blocks,
  // performing actions, and streaming.
  deactivatedAt: Sequelize.DATE,
  // True if this user has any pending actions.
  pendingActions: { type: Sequelize.BOOLEAN, defaultValue: false },
  // A user may be paused manually if they have a large number of pending
  // actions or blocks, and work on their account is slowing down work on other
  // accounts. We don't execute actions or update blocks for paused users.
  paused: { type: Sequelize.BOOLEAN, defaultValue: false },
  // The number of blocks this user had at last fetch.
  blockCount: { type: Sequelize.INTEGER, defaultValue: 0 },
}, {
  instanceMethods: {
    /**
     * When logging a BtUser object, output just its screen name and uid.
     * To log all values, specify user.dataValues.
     */
    inspect: function() {
      return [this.screen_name, this.uid].join(" ");
    },
  }
});
BtUser.hasOne(TwitterUser, {foreignKey: 'uid'});

var Subscription = sequelize.define('Subscription', {
  author_uid: Sequelize.BIGINT.UNSIGNED,
  subscriber_uid: Sequelize.BIGINT.UNSIGNED
});
BtUser.hasMany(Subscription, {foreignKey: 'author_uid', as: 'Subscribers'});
BtUser.hasMany(Subscription, {foreignKey: 'subscriber_uid', as: 'Subscriptions'});
Subscription.belongsTo(BtUser, {foreignKey: 'author_uid', as: 'Author'});
Subscription.belongsTo(BtUser, {foreignKey: 'subscriber_uid', as: 'Subscriber'});

/**
 * SharedBlocks differ from Blocks because they represent a long-term curated
 * set of blocks, and are meant to be explicitly shared. Blocks and BlockBatches
 * are a simple representation of the current state of a user's blocks based on
 * what the Twitter API returns.
 */
var SharedBlock = sequelize.define('SharedBlock', {
  author_uid: Sequelize.STRING,
  sink_uid: Sequelize.STRING
});
SharedBlock.belongsTo(BtUser, {foreignKey: 'author_uid'});
SharedBlock.belongsTo(TwitterUser, {foreignKey: 'sink_uid'});

var Block = sequelize.define('Block', {
  sink_uid: Sequelize.BIGINT.UNSIGNED
}, {
  timestamps: false
});
Block.removeAttribute('id');

/**
 * Represents a batch of blocks fetched from Twitter, using cursoring.
 */
var BlockBatch = sequelize.define('BlockBatch', {
  source_uid: Sequelize.BIGINT.UNSIGNED,
  currentCursor: Sequelize.STRING,
  complete: Sequelize.BOOLEAN,
  size: Sequelize.INTEGER
});
BlockBatch.hasMany(Block, {onDelete: 'cascade'});
Block.belongsTo(TwitterUser, {foreignKey: 'sink_uid'});
BtUser.hasMany(BlockBatch, {foreignKey: 'source_uid', onDelete: 'cascade'});

/**
 * An action (block or unblock) that we performed on behalf of a user, or that
 * we observed the user perform from an external client (like twitter.com or
 * Twitter for Android).
 *
 * Pending actions are created when we intend to perform an action, and marked
 * 'done' once completed. External actions are marked with cause = 'external',
 * and are inserted with status = 'done' as soon as we observe them.
 */
var Action = sequelize.define('Action', {
  source_uid: Sequelize.BIGINT.UNSIGNED,
  sink_uid: Sequelize.BIGINT.UNSIGNED,
  type: { type: 'TINYINT', field: 'typeNum' }, // Block, unblock, or mute
  status: { type: 'TINYINT', field: 'statusNum' },
  // A cause indicates why the action occurred, e.g. 'bulk-manual-block',
  // or 'new-account'. When the cause is another Block Together user,
  // e.g. in the bulk-manual-block case, the uid of that user is recorded in
  // cause_uid. When cause is 'new-account' or 'low-followers'
  // the cause_uid is empty.
  cause: { type: 'TINYINT', field: 'causeNum' },
  cause_uid: Sequelize.BIGINT.UNSIGNED
}, {
  instanceMethods: {
    status_str: function() {
      return Action.statusNames[this.status];
    },
    cause_str: function() {
      return Action.causeNames[this.cause];
    },
    type_str: function() {
      return Action.typeNames[this.type];
    }
  }
});
// From a BtUser we want to get a list of Actions.
BtUser.hasMany(Action, {foreignKey: 'source_uid'});
// And from an Action we want to get a TwitterUser (to show screen name).
Action.belongsTo(TwitterUser, {foreignKey: 'sink_uid'});
// And also the screen name of the user who caused the action if it was from a
// subscription.
Action.belongsTo(BtUser, {foreignKey: 'cause_uid', as: 'CauseUser'});

Action.statusConstants = [
  undefined,
  "PENDING",
  "DONE",
  "CANCELLED_FOLLOWING",
  "CANCELLED_SUSPENDED",
  "CANCELLED_DUPLICATE",
  "CANCELLED_UNBLOCKED",
  "CANCELLED_SELF",
  "DEFERRED_TARGET_SUSPENDED",
  "CANCELLED_SOURCE_DEACTIVATED",
  "CANCELLED_UNSUBSCRIBED"
];

Action.statusNames = [];
for (var i = 0; i < Action.statusConstants.length; i++) {
  if (i == 0) continue;
  var name = Action.statusConstants[i];
  Action[name] = i;
  Action.statusNames[i] = name.toLowerCase().replace(/_/g, "-");
}

Action.causeConstants = [
  undefined,
  "EXTERNAL",
  "SUBSCRIPTION",
  "NEW_ACCOUNT",
  "LOW_FOLLOWERS",
  "BULK_MANUAL_BLOCK"
];
Action.causeNames = [];
for (var i = 0; i < Action.causeConstants.length; i++) {
  if (i == 0) continue;
  var name = Action.causeConstants[i];
  Action[name] = i;
  Action.causeNames[i] = name.toLowerCase().replace(/_/g, "-");
}
Action.cause_str = function() {
  return Action.causeNames[this.cause];
}

Action.typeConstants = [
  undefined,
  "BLOCK",
  "UNBLOCK",
  "MUTE",
];
Action.typeNames = [];
for (var i = 0; i < Action.typeConstants.length; i++) {
  if (i == 0) continue;
  var name = Action.typeConstants[i];
  Action[name] = i;
  Action.typeNames[i] = name.toLowerCase().replace(/_/g, "-");
}
Action.type_str = function() {
  return Action.typeNames[this.type];
}

// User to follow from settings page. In prod this is @blocktogether.
// Initially blank, and loaded asynchronously. It's unlikely the
// variable will be referenced before it is initialized.
var userToFollow = BtUser.build();
BtUser.find({
  where: {
    screen_name: config.userToFollow
  }
}).then(function(user) {
  _.assign(userToFollow, user);
}).catch(function(err) {
  logger.error(err);
});

var keepAliveAgent = new https.Agent({
  keepAlive: true,
  keepAliveMsecs: 1000 * 1000
});

/**
 * Make a request to update-blocks to update blocks for a user.
 * @param {BtUser} user
 * @returns {Promise.<null>} A promise that resolves once blocks are updated.
 */
function remoteUpdateBlocks(user) {
  var deferred = Q.defer();
  logger.debug('Requesting block update for', user);
  var opts = {
    method: 'POST',
    agent: keepAliveAgent,
    host: config.updateBlocks.host,
    port: config.updateBlocks.port,
    // Provide a client certificate so the server knows it's us.
    cert: fs.readFileSync(path.join(configDir, 'rpc.crt')),
    key: fs.readFileSync(path.join(configDir, 'rpc.key')),
    // For validating the self-signed server cert
    ca: fs.readFileSync(path.join(configDir, 'rpc.crt')),
    rejectUnauthorized: false
  };
  var req = https.request(opts, function(res) {
    deferred.resolve();
  });
  req.on('error', function(err) {
    // Ignore ECONNRESET: The server will occasionally close the socket, which
    // is fine.
    if (err.code != 'ECONNRESET') {
      logger.error(err);
      deferred.reject(err);
    }
  });
  req.end(JSON.stringify({
    uid: user.uid,
    callerName: scriptName
  }));
  return deferred.promise;
}

function gracefulShutdown() {
}

function statsServer(port) {
  var tlsOpts = {
    key: fs.readFileSync(path.join(configDir, 'rpc.key')),
    cert: fs.readFileSync(path.join(configDir, 'rpc.crt')),
    ca: fs.readFileSync(path.join(configDir, 'rpc.crt')),
    requestCert: true,
    rejectUnauthorized: true
  };
  var server = https.createServer(tlsOpts, function (req, res) {
    res.end(promRegister.metrics());
  });
  server.unref();
  server.listen(port);
  return server;
}

process.on('uncaughtException', function(err) {
  // log4js file appenders are not guaranteed to flush before exit, so it's
  // safer to write to stderr explicitly instead.
  process.stderr.write(new Date() + ': uncaught exception, shutting down: ' + err.stack + '\n');
  process.exit(133);
});

module.exports = {
  Action: Action,
  Block: Block,
  BlockBatch: BlockBatch,
  BtUser: BtUser,
  TwitterUser: TwitterUser,
  Subscription: Subscription,
  SharedBlock: SharedBlock,
  config: config,
  configDir: configDir,
  logger: logger,
  sequelize: sequelize,
  twitter: twitter,
  userToFollow: userToFollow,
  remoteUpdateBlocks: remoteUpdateBlocks,
  gracefulShutdown: gracefulShutdown,
  statsServer: statsServer
};
})();