//client

import React from 'react';
import $ from 'jquery';
import styles from './photowheel.css';

class PhotoWheel extends React.Component {
	constructor(props) {
		super(props);
    this.state = {
    	photos: [],
    	restaurant: 2
    }
	}

componentWillMount() {
  this.getData();
}

getData() {
  $.ajax({
    method: 'POST',
    url: '/photos',
    data: {result: this.state.restaurant},
    success: (data) => {
      this.setState({
        photos: data
      });
    }
  });

}

	render() {
		return (
	  <div className="hi">hi
		  {this.state.photos.map((ele) => {
			  <img src={ele}/>
			})
		  }

	  </div>
		);
  }
}

export default PhotoWheel;



//server

var express = require('express');
var app = express();
var parser = require('body-parser');
var db = require('../database/index.js');

app.use(parser.json());
app.use(parser.urlencoded({ extended: true }));
app.use(express.static('./public'));



app.post('/photos', (req, res) => {
  console.log(req.body.result);
  db.getAllPictures(req.body.result, (data) => {
	  res.send(data);
  });
});

var port = process.env.PORT || 3001;

app.listen(port, () => console.log("Connected on port 3001"));


//db
var mysql = require('mysql');


var db = mysql.createConnection({
	multipleStatements: true,
  host: 'localhost',
  user: 'root',
  password: 'nick',
  database: 'photos'
});


db.connect((err) => {
	if (err) {
		throw err;
	}
	console.log('connected to db');
});

var getAllPictures = function(restaurant, cb) {
	db.query(`SELECT url FROM pictures where restaurant = ${restaurant}`, (err, result) => {
	  if(err) {
	  	console.log(err);
	  }	else {
	  	cb(result);
	  }
	});
}