Flow

[siddukp]

Customer signup with email id and password(CommonDb.users id:1 email: bansal@flipkart.com )
POST /api//users

const mainDomain = 'tenantapp.com';
const linodeIp = '120.120.120.120'
// either we can use this function of we can keep *.tenantapp.com -> 120.120.120.120
// linode centos server with ip 120.120.120.120
const createDNS = (subdomain) => {
  rp({
    url: `https://api.digitalocean.com/api/domains/${mainDomain}/A`,
    method: POST',
    body: { subdomain, ip: linodeIp }
  })
}

export async function create(req, res, next) {
  const user = await CommonDb.User.create({ email: req.body.email }); // id:1
  const domain = req.body.email.split('@')[1];
  const subdomain = domain.split('.')[0];

  const project = 'nps_feedback';
  const connectionString = await MySQLApi.createDb(`${subdomain}_${project}`);

  const client = await CommonDb.Client.create({ user_id: user.id, name:  subdomain, connectionString   });
  await SequelizeApi.migrateDb(connectionString);
  await SequelizeApi.seedDb(connectionString);

  // all subdomains pointing to one machine as wildcard dns entry
  user.update({ client_id: client.id });
  res.json({ message: 'Signup successful, Provisioning done from http://${subdomain}.${mainDomain}'})

}
domain: flipkart.tenantapp.com


1. dbinfo = DB Creation Script
2. dbId = saveDbInfoToCommonDbClientsTable(dbInfo)
3.