#include #include #include using namespace std; int main() { mysqlpp::Connection con; mysqlpp::Result res; try { con.connect("mysql_cpp_data","localhost", "root", "olathe"); } catch(const mysqlpp::ConnectionFailed& er) { cerr << "Connection failed: " << er.what() << endl; return EXIT_FAILURE; } mysqlpp::Query query = con.query(); query << "Drop database if exists Music_Inventory;" << "CREATE DATABASE Music_Inventory;" << "Use Music_Inventory;"; query << "CREATE TABLE `Artists`" << "(" << "`ID` TINYINT(3) UNSIGNED NOT NULL," << "`First Name` CHAR(15) NOT NULL," << "`Last Name` CHAR(25) NOT NULL," << "PRIMARY KEY (`ID`)" << ");" << "INSERT INTO `Artists` VALUES (1,'FACT','(N/A)');" << "INSERT INTO `Artists` VALUES (2,'Thrice','(N/A)');" << "INSERT INTO `Artists` VALUES (3,'Shugo','Tokumaru');" << "INSERT INTO `Artists` VALUES (4,'Silversun','Pickups');"; query << "CREATE TABLE `Songs`" << "(" << "`ISBN` CHAR(14) NOT NULL," << "`Title` VARCHAR(100) NOT NULL," << "`Cost` DECIMAL(4,2) NOT NULL," << "`ID` TINYINT(3) UNSIGNED NOT NULL," << "PRIMARY KEY (`ISBN`)" << ");" << "INSERT INTO `Songs` VALUES ('351-0042755810','Key',0.99, 1);" << "INSERT INTO `Songs` VALUES ('351-0042755811','Blink of the Shadow',0.99, 1);" << "INSERT INTO `Songs` VALUES ('593-0042752815','Daedalus',0.99, 2);" << "INSERT INTO `Songs` VALUES ('593-0042752816','Digging My Own Grave',0.99, 2);" << "INSERT INTO `Songs` VALUES ('588-0042726023','Clocca',0.99, 3);" << "INSERT INTO `Songs` VALUES ('588-0042726025','Hidamari',0.99, 3);" << "INSERT INTO `Songs` VALUES ('589-0042726348','Rusted Wheel',0.99, 4);" << "INSERT INTO `Songs` VALUES ('589-0042726353','Checkered Floor',0.99, 4);"; cout << "New database creation complete."; //res = query.store(); }