const db = knex({
  client: 'pg',
  connection: {
    connectionString: process.env.DATABASE_URL,
    ssl: true
  }
});

const app = express();
const PORT = process.env.PORT || 3000;
app.listen(PORT, () => {
	console.log('Server is running on port: ', PORT);
});
app.use(bodyParser.json());
app.use(cors2());

app.post('/signin', (req, res) => {signinC.handleSignIn(req, res, db, bcrypt)});
app.post('/register', (req, res) => {registerC.handleRegister(req, res, db, bcrypt)});
app.get('/profile/:id', (req, res) => {profileC.handleProfile(req, res, db)});
app.put('/image', (req, res) => {imageC.handleImage(req, res, db)});
app.post('/imageUrl', (req, res) => {imageUrl.handleApiCall(req, res)});
app.get('/', (req, res) => {res.json('Live: https://github.com/jayli3n/facial-recognition-web-app')});

const handleRegister = (req, res, db, bcrypt) => {
	const {email, name, password} = req.body;
	const hash = bcrypt.hashSync(password);
	db.transaction(trx => {
		trx.insert({
			email: email,
			hash: hash
		})
		.into('login')
		.returning('email')
		.then(loginEmail => {
			trx('users')
			.insert({
				name: name,
				email: loginEmail[0],
				joined: new Date()
			}).returning('*')
			.then(user => {
				res.json(user[0]);
			})
			.then(trx.commit)
			.catch(trx.rollBack)
		}).catch(err => res.status(400).json('Unable to register.'))
	}).catch(err => res.status(400).json('Unable to register.'));
}

module.exports = {
	handleRegister: handleRegister
};