ajpenalosa
6/15/2018 - 5:12 PM

Connection

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);
    
        });

    })

}