var mysql = require("mysql");
var inquirer = require('inquirer');
var items = [];
var connection = mysql.createConnection({
host: "localhost",
// Your port; if not 3306
port: 3306,
// Your username
user: "root",
// Your password
password: "root",
database: "greatbay_db"
});
connection.connect(function(err) {
if (err) throw err;
// console.log("connected as id " + connection.threadId);
startApp();
});
function startApp() {
inquirer.prompt([
{
type: "list",
message: "Would you like to [POST] an auction or [BID] on an auction?",
choices: ["POST", "BID"],
name: "choice"
}
]).then(options => {
if ( options.choice === "POST" ) {
postItem();
}
else {
bidOnItem();
}
});
};
function postItem() {
inquirer.prompt([
{
type: "input",
name: "name",
message: "What is the name of the item?"
},
{
type: "input",
name: "price",
message: "What is the starting price?"
}
]).then(item => {
console.log(item);
var query = connection.query("INSERT INTO items SET ? ", {
name: item.name,
price: item.price
},
function(err, res) {
console.log("\r\nItem has been posted!\r\n");
startApp()
}
);
console.log(query.sql);
});
}
function bidOnItem() {
connection.query("SELECT * FROM items", function(err, res) {
if(err) throw err;
for ( var i = 0; i < res.length; i++ ) {
var itemObject = { id: res[i].id, name: res[i].name };
items.push(itemObject);
}
inquirer.prompt([
{
type: "list",
name: "name",
choices: items,
message: "What auction would you like to place a bid in?"
},
{
type: "input",
name: "price",
message: "How much would you like to bid?"
}
]).then(item => {
console.log(item);
var query = connection.query("UPDATE items SET ? WHERE ? ",
[
{
price: item.price
},
{
name: item.name
}
],
function(err, res) {
console.log(res)
}
);
console.log(query.sql);
});
})
}