def postTodos(): data = request.data data_dict = json.loads(data) new_todo = data_dict["name"] insert_query(new_todo) results = select_query() return make_response(results), 201
def insert_into_db(request, response_dict, process_time_ms): parameters_dict = { 'args': request.args, 'form': request.form, 'cookies': request.cookies, 'headers': request.headers, 'method': request.method, 'base_url': request.base_url, 'remote_addr': request.remote_addr } parameters_dict = r_remove_key(parameters_dict, set()) response_dict = r_remove_key(response_dict, set()) db.insert_query(json.dumps(parameters_dict), json.dumps(response_dict), process_time_ms)
def insert_data(): try: query = "INSERT INTO DEPARTMENT (Dname, Dnumber) VALUES (%s, %s)" # 1 data = ('Research', 5) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 2 data = ('Administration', 4) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 3 data = ('Headquarters', 1) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 4 data = ('Software', 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 5 data = ('Hardware', 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 6 data = ('Sales', 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 7 data = ('HR', 9) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 8 data = ('Networking', 3) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 9 data = ('QA', 11) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) except Exception as e: traceback.print_exc() logging.error('Error in INSERT_DATA: %s', e)
def q7_3(): try: query = "INSERT INTO `PROJECT` (Pname, Pnumber, Plocation, Controlling_department) VALUES (%s, %s, %s, %s)" data = ('TEST', 15, 'Dallas', 5) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) except Exception as e: traceback.print_exc() logging.error('Error in INSERT_DATA: %s', e)
def q7_2(): try: query = "INSERT INTO `WORKS_ON` (Essn, Pno, Hours) VALUES (%s, %s, %s)" data = ('1234567890', 4, 10.0) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) except Exception as e: traceback.print_exc() logging.error('Error in INSERT_DATA: %s', e)
def query_add(): try: title = request.form["title"].strip() sql = request.form["sql"].strip() tags = request.form["tags"].strip() desc = request.form["desc"].strip() who = request.form["who"].strip() if len(title) == 0 or len(sql) == 0: flash("Title and Sql are required fields", "error") return redirect(url_for("index")) db.insert_query(title, sql, tags, desc, who) flash("Query Added!", "success") return redirect(url_for("index")) except Exception as e: app.logger.error("Fatal error", exc_info=True) flash("Fatal error. Contact Administrator", "error") return redirect(url_for("index"))
def q4_1(): try: query = "INSERT INTO `DEPARTMENT`(`Dname`, `Dnumber`, `Manager_ssn`, `Manager_start_date`) " \ "VALUES (%s, %s, %s, STR_TO_DATE(%s, '%d-%b-%Y'))" data = ('Services', 1, '123456789', '11-AUG-2012') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) except Exception as e: traceback.print_exc() logging.error('Error in INSERT_DATA: %s', e)
def q4_3(): try: query = "INSERT INTO `DEPARTMENT`(`Dname`, `Dnumber`, `Manager_ssn`, `Manager_start_date`) " \ "VALUES (%s, %s, %s, STR_TO_DATE(%s, '%d-%b-%Y'))" data = ('Customers', 12, '333445555', '14-JAN-2013') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) except Exception as e: traceback.print_exc() logging.error('Error in INSERT_DATA: %s', e)
def q4_2(): try: query = "INSERT INTO `DEPARTMENT`(`Dname`, `Dnumber`, `Manager_ssn`, `Manager_start_date`) " \ "VALUES (%s, %s, %s, STR_TO_DATE(%s, '%d-%b-%Y'))" data = ('Purchasing', 3, '990110110', '02-FEB-2013') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) except Exception as e: traceback.print_exc() logging.error('Error in INSERT_DATA: %s', e)
def q4_6(): try: query = "INSERT INTO `EMPLOYEE` (Fname, Minit, Lname, SSN, Birth_date, Address, Sex, Salary, Supervisor, " \ "Department) VALUES (%s, %s, %s, %s, STR_TO_DATE(%s, '%d-%b-%Y'), %s, %s, %s, %s, %s)" data = ('Jane', 'B', 'Smith', '666666606', '01-MAR-1980', '3556 W Second Street,Miami,FL', 'F', 85000, '666666603', 5) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) except Exception as e: traceback.print_exc() logging.error('Error in INSERT_DATA: %s', e)
def q7_1(): try: query = "INSERT INTO `EMPLOYEE` (SSN, Fname, Minit, Lname, Address, Sex, Birth_date, Salary, Supervisor, " \ "Department) VALUES (%s, %s, %s, %s, %s, %s, STR_TO_DATE(%s, '%d-%b-%Y'), %s, %s, %s)" data = ('1234567890', 'Dhruvi', 'R', 'Rajput', '4 ABC Street, XYZ Town 12345', 'F', '11-AUG-2012', 55000, '333445555', 5) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) except Exception as e: traceback.print_exc() logging.error('Error in INSERT_DATA: %s', e)
def insert_data(): try: query = "INSERT INTO EMPLOYEE (Fname, Minit, Lname, SSN, Birth_date, Address, Sex, Salary, Department) " \ "VALUE (%s, %s, %s, %s, STR_TO_DATE(%s,'%d-%b-%Y'), %s, %s, %s, %s)" # 1 data = ('James', 'E', 'Jordan', '888665151', '10-NOV-1927', '450 Stone,Houston,TX', 'M', 55000, 1) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 2 data = ('Frank', 'T', 'Wong', '333445555', '08-DEC-1945', '638 Voss,Houston,TX', 'M', 40000, 5) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 3 data = ('Jennifer', 'S', 'Wallace', '987654321', '20-JUN-1931', '291 Berry,Bellaire,TX', 'F', 43000, 4) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 4 data = ('Jared', 'D', 'James', '111111100', '10-OCT-1966', '123 Peachtr,Atlanta,GA', 'M', 85000, 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 5 data = ('Alex', 'D', 'Freed', '444444400', '09-OCT-1950', '4333 Pillsbury,Milwaukee,WI', 'M', 89000, 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 6 data = ('John', 'C', 'James', '555555500', '30-JUN-1975', '766 Bloomington,Sacramento,CA', 'M', 81000, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 7 data = ('John', 'B', 'Smith', '123456789', '09-Jan-1955', '731 Fondren,Houston,TX', 'M', 30000, 5) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 8 data = ('Alicia', 'J', 'Zelaya', '999887777', '19-JUL-1958', '3321 Castle,Spring,TX', 'F', 25000, 4) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 9 data = ('Ramesh', 'K', 'Narayan', '666884444', '15-SEP-1952', '971 Fire Oak,Humble,TX', 'M', 38000, 5) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 10 data = ('Joyce', 'A', 'English', '453453453', '31-JUL-1962', '5631 Rice Oak,Houston,TX', 'F', 25000, 5) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 11 data = ('Ahmad', 'V', 'Jabbar', '987987987', '29-MAR-1959', '980 Dallas,Houston,TX', 'M', 25000, 4) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 12 data = ('Jon', 'C', 'Jones', '111111101', '14-NOV-1967', '111 Allgood,Atlanta,GA', 'M', 45000, 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 14 data = ('Justin', None, 'Mark', '111111102', '12-JAN-1966', '2342 May,Atlanta,GA', 'M', 40000, 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 15 data = ('Brad', 'C', 'Knight', '111111103', '13-FEB-1968', '176 Main St.,Atlanta,GA', 'M', 44000, 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 16 data = ('Evan', 'E', 'Wallis', '222222200', '16-JAN-1958', '134 Pelham,Milwaukee,WI', 'M', 92000, 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 17 data = ('Josh', 'U', 'Zell', '222222201', '22-MAY-1954', '266 McGrady,Milwaukee,WI', 'M', 56000, 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 18 data = ('Andy', 'C', 'Vile', '222222202', '21-JUN-1944', '1967 Jordan,Milwaukee,WI', 'M', 53000, 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 19 data = ('Tom', 'G', 'Brand', '222222203', '16-DEC-1966', '112 Third St,Milwaukee,WI', 'M', 62500, 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 19 data = ('Jenny', 'F', 'Vos', '222222204', '11-NOV-1967', '263 Mayberry,Milwaukee,WI', 'F', 61000, 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 20 data = ('Chris', 'A', 'Carter', '222222205', '21-MAR-1960', '565 Jordan,Milwaukee,WI', 'F', 43000, 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 21 data = ('Kim', 'C', 'Grace', '333333300', '23-OCT-1970', '667 Mills Ave,Sacramento,CA', 'F', 79000, 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 22 data = ('Jeff', 'H', 'Chase', '333333301', '07-JAN-1970', '15 Bradbury,Sacramento,CA', 'M', 44000, 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 23 data = ('Bonnie', 'S', 'Bays', '444444401', '19-JUN-1956', '111 Hollow,Milwaukee,WI', 'F', 70000, 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 24 data = ('Alec', 'C', 'Best', '444444402', '18-JUN-1966', '233 Solid,Milwaukee,WI', 'M', 60000, 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 25 data = ('Sam', 'S', 'Snedden', '444444403', '31-JUL-1977', '97 Windy St,Milwaukee,WI', 'M', 48000, 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 26 data = ('Nandita', 'K', 'Ball', '555555501', '16-APR-1969', '222 Howard,Sacramento,CA', 'M', 62000, 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 27 data = ('Bob', 'B', 'Bender', '666666600', '17-APR-1968', '8794 Garfield,Chicago,IL', 'M', 96000, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 28 data = ('Jill', 'J', 'Jarvis', '666666601', '14-JAN-1966', '6234 Lincoln,Chicago,IL', 'F', 36000, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 29 data = ('Kate', 'W', 'King', '666666602', '16-APR-1966', '1976 Boone Trace,Chicago,IL', 'F', 44000, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 30 data = ('Lyle', 'G', 'Leslie', '666666603', '09-JUN-1963', '417 Hancock Ave,Chicago,IL', 'M', 41000, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 31 data = ('Billie', 'J', 'King', '666666604', '01-JAN-1960', '556 Washington,Chicago,IL', 'F', 38000, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 32 data = ('Megan', 'G', 'Jones', '254937381', '02-MAR-1961', '528 Stone CT,Chicago,IL', 'F', 62000, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 33 data = ('Jon', 'A', 'Kramer', '666666605', '22-AUG-1964', '1988 Windy Creek,Seattle,WA', 'M', 41500, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 34 data = ('Ray', 'H', 'King', '666666606', '16-AUG-1949', '213 Delk Road,Seattle,WA', 'M', 44500, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 35 data = ('Gerald', 'D', 'Small', '666666607', '15-MAY-1962', '122 Ball Street,Dallas,TX', 'M', 29000, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 36 data = ('Arnold', 'A', 'Head', '666666608', '19-MAY-1967', '233 Spring St,Dallas,TX', 'M', 33000, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 37 data = ('Helga', 'C', 'Pataki', '666666609', '11-MAR-1969', '101 Holyoke St,Dallas,TX', 'F', 32000, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 38 data = ('Naveen', 'B', 'Drew', '666666610', '23-MAY-1970', '198 Elm St,Philadelphia,PA', 'M', 34000, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 39 data = ('Carl', 'E', 'Reedy', '666666611', '21-JUN-1977', '213 Ball St,Philadelphia,PA', 'M', 32000, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 40 data = ('Sammy', 'G', 'Hall', '666666612', '11-JAN-1970', '433 Main Street,Miami,FL', 'M', 37000, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 41 data = ('Red', 'A', 'Bacher', '666666613', '21-MAY-1980', '196 Elm Street,Miami,FL', 'M', 33500, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 42 data = ('Roy', 'C', 'Lewallen', '999999999', '02-MAR-1977', '14 Wynncrest Street,Dallas,TX', 'M', 75500, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 43 data = ('John', 'T', 'Ed', '222333444', '18-FEB-1981', '4505 West St,Rochester,NY', 'M', 30000, 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 44 data = ('Jennifer', 'A', 'Joy', '223344667', '19-MAY-1976', '1204 Main St,Miami,FL', 'F', 45000, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 45 data = ('Kim', 'G', 'Ted', '444222666', '15-APR-1968', '3648 Tree Cir,Austin,TX', 'M', 50000, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 46 data = ('Juan', 'G', 'Linda', '112244668', '23-JUN-1965', '1210 Apple St,Austin,TX', 'F', 55000, 9) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 47 data = ('Jose', 'H', 'Barbara', '343434344', '28-FEB-1955', '905 East St,Kleen,TX', 'F', 35000, 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 48 data = ('willie', 'D', 'Mary', '234234234', '20-DEC-1961', '101 South St,Arlington,TX', 'F', 12000, 9) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 49 data = ('Erin', 'A', 'Maxfield', '242535609', '22-DEC-1971', '123 Copper St,Arlington,TX', 'F', 72000, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 50 data = ('Sunil', 'D', 'Gupta', '110110110', '01-FEB-2001', '4312 Bowen Rd,Arlington,TX', 'M', 80000, 3) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 51 data = ('Penny', 'G', 'Wolowitz', '673466642', '21-JAN-1974', '42 South Blvd,Miami,FL', 'F', 17000, 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 52 data = ('Michael', 'A', 'Morgan', '636669233', '11-MAY-1984', '26 Sunset Blvd,Miami,FL', 'M', 73500, 5) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 53 data = ('Sheldon', 'C', 'Cucuou', '849934919', '22-MAR-1974', '11 Hollywood Blvd,Dallas,TX', 'M', 35500, 8) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 54 data = ('Debra', 'T', 'Hall', '202843824', '11-MAR-1983', '45 NY St,Rochester,NY', 'F', 30000, 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 55 data = ('Jisha', 'A', 'Carpenter', '292740167', '29-MAY-1985', '194 Beachdr,Miami,FL', 'F', 15000, 1) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 56 data = ('Gregory', 'G', 'Laurie', '444212096', '15-SEP-1969', '78 Tree Cir,Houston,TX', 'M', 90000, 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 57 data = ('Lisa', 'G', 'House', '101248268', '29-JUN-1975', '12 Maple St,Austin,TX', 'F', 85000, 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 58 data = ('Leonard', 'H', 'Moody', '349273344', '09-FEB-1973', '908 Greek Row,Austin,TX', 'M', 45000, 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 59 data = ('Jake', 'D', 'Sheen', '245239264', '25-DEC-1954', '20 North Co,Arlington,TX', 'M', 52000, 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 60 data = ('Wilson', 'A', 'Holmes', '242916639', '02-JUN-1971', '21 South Co,Arlington,TX', 'M', 72500, 4) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 61 data = ('Cameron', 'D', 'Thirteen', '111422203', '04-MAY-2001', '22 Univ Blvd,Arlington,TX', 'F', 80000, 4) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 62 data = ('Joseph', 'K', 'Kirkish', '913323708', '04-MAR-1996', '22 UT Blvd,Austin,TX', 'M', 95000, 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 63 data = ('Andrea', 'M', 'Sondrini', '614370310', '30-DEC-1996', '1450 Worthington St,Houston,TX', 'F', 65000, 5) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 64 data = ('Cindy', 'K', 'Burklow', '432765098', '23-FEB-1984', '2015 Neil Ave,Miami,FL', 'F', 45000, 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 65 data = ('Zach', 'A', 'Geller', '913353347', '15-AUG-1990', '333 PikeWay,Seattle,WA', 'M', 55000, 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 66 data = ('Alex', 'C', 'Yu', '001614905', '17-OCT-1980', '626 Mary St,Dallas,TX', 'M', 50000, 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 67 data = ('Richard', 'T', 'Koelbel', '214370999', '3-APR-1976', '50 Elk St,Chicago,IL', 'M', 85000, 4) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 68 data = ('Christina', 'S', 'Hisel', '241625699', '5-JUL-1986', '37 Church Row,Rochester,NY', 'F', 45000, 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 69 data = ('Percy', 'M', 'Liang', '398172999', '12-JUN-1991', '14 Maple St,Austin,TX', 'M', 55000, 9) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 70 data = ('James', 'U', 'Miller', '906218888', '27-MAY-1978', '13 Fifth St,Seattle,WA', 'M', 75000, 5) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) except Exception as e: traceback.print_exc() logging.error('Error in INSERT_DATA: %s', e)
def insert_data(): try: query = "INSERT INTO WORKS_ON (Essn, Pno, Hours) VALUES (%s, %s, %s)" # 1 data = ('123456789', 5, 32.5) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 2 data = ('123456789', 6, 7.5) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 3 data = ('666884444', 7, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 4 data = ('453453453', 5, 20.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 5 data = ('453453453', 6, 20.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 6 data = ('333445555', 7, 10.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 7 data = ('333445555', 7, 10.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 8 data = ('333445555', 10, 10.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 9 data = ('333445555', 20, 10.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 10 data = ('242535609', 70, 20.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 11 data = ('242535609', 62, 20.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 12 data = ('999887777', 30, 30.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 13 data = ('999887777', 10, 10.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 14 data = ('987987987', 10, 35.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 15 data = ('987987987', 30, 5.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 16 data = ('987654321', 30, 20.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 17 data = ('987654321', 20, 15.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 18 data = ('888665555', 20, 5.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 19 data = ('111111100', 61, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 20 data = ('111111101', 61, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 21 data = ('111111102', 61, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 22 data = ('111111103', 61, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 23 data = ('222222200', 62, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 24 data = ('222222201', 62, 48.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 25 data = ('222222202', 62, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 26 data = ('222222203', 62, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 27 data = ('222222204', 62, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 28 data = ('222222205', 62, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 29 data = ('333333300', 63, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 30 data = ('333333301', 63, 46.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 31 data = ('444444400', 91, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 32 data = ('444444401', 91, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 33 data = ('444444402', 91, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 34 data = ('444444403', 91, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 35 data = ('555555500', 92, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 36 data = ('555555501', 92, 44.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 37 data = ('666666601', 91, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 38 data = ('666666603', 91, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 39 data = ('666666604', 91, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 40 data = ('666666605', 92, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 41 data = ('666666606', 91, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 42 data = ('666666607', 61, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 43 data = ('666666608', 62, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 44 data = ('666666609', 63, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 45 data = ('666666610', 61, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 46 data = ('666666611', 61, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 47 data = ('666666612', 61, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 48 data = ('666666613', 61, 30.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 49 data = ('666666613', 62, 10.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 50 data = ('666666613', 63, 10.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 51 data = ('999999999', 5, 2.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 52 data = ('999999999', 6, 2.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 53 data = ('999999999', 7, 4.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 54 data = ('999999999', 10, 4.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 55 data = ('999999999', 20, 4.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 56 data = ('999999999', 30, 4.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 57 data = ('999999999', 61, 4.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 58 data = ('999999999', 62, 4.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 59 data = ('999999999', 63, 4.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 60 data = ('999999999', 70, 2.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 61 data = ('999999999', 91, 2.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 62 data = ('999999999', 92, 1.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 63 data = ('999999999', 95, 3.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 64 data = ('254937381', 70, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 65 data = ('222333444', 91, 10.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 66 data = ('223344667', 63, 20.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 67 data = ('444222666', 62, 25.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 68 data = ('112244668', 95, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 69 data = ('343434344', 63, 40.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 70 data = ('234234234', 95, 35.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 71 data = ('913323708', 92, 33.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 72 data = ('636669233', 4, 11.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 73 data = ('614370310', 3, 45.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 74 data = ('849934919', 95, 23.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 75 data = ('432765098', 63, 25.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 76 data = ('444212096', 63, 25.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 77 data = ('913353347', 22, 30.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 78 data = ('292740167', 5, 25.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 79 data = ('202843824', 11, 20.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 80 data = ('673466642', 22, 4.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 81 data = ('101248268', 29, 10.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 82 data = ('245239264', 11, 25.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 83 data = ('242916639', 4, 5.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 84 data = ('906218888', 29, 15.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 85 data = ('001614905', 13, 18.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 86 data = ('245239264', 10, 25.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 87 data = ('349273344', 29, 15.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 88 data = ('242916639', 11, 20.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 89 data = ('214370999', 10, 35.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 90 data = ('111422203', 4, 45.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 91 data = ('398172999', 70, 10.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 92 data = ('241625699', 61, 4.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 93 data = ('245239264', 5, 5.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 94 data = ('349273344', 6, 10.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 95 data = ('242916639', 7, 10.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 96 data = ('214370999', 5, 4.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 97 data = ('111422203', 6, 5.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) # 98 data = ('398172999', 7, 10.0) print(db.insert_query(query, data)) logging.info(str(query) + " " + str(data)) except Exception as e: traceback.print_exc() logging.error('Error in INSERT_DATA: %s', e)
def insert_data(): try: query = "INSERT INTO PROJECT (Pname, Pnumber, Plocation, Controlling_department) VALUES (%s, %s, %s, %s)" # 1 data = ('EntityAnnot', 4, 'Houston', 5) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 2 data = ('Analysis', 5, 'Sacramento', 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 3 data = ('EventManagement', 6, 'Sacramento', 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 4 data = ('FoodDistribution', 7, 'Sacramento', 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 5 data = ('Computerization', 10, 'Stafford', 4) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 6 data = ('ConfigMgmt', 11, 'Atlanta', 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 7 data = ('DataMining', 13, 'Sacramento', 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 8 data = ('Reorganization', 20, 'Houston', 1) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 9 data = ('Benefits', 30, 'Stafford', 4) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 10 data = ('OperatingSystem', 61, 'Sacramento', 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 11 data = ('DatabaseSystems', 62, 'Atlanta', 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 12 data = ('Middleware', 63, 'Atlanta', 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 13 data = ('Advertizing', 70, 'Arlington', 9) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 14 data = ('InkjetPrinters', 91, 'Milwaukee', 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 15 data = ('LaserPrinters', 92, 'Milwaukee', 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 16 data = ('HumanResource', 95, 'Arlington', 9) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 17 data = ('SearchEngine', 22, 'Arlington', 6) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 18 data = ('MotherBoard', 29, 'Milwaukee', 7) print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) except Exception as e: traceback.print_exc() logging.error('Error in INSERT_DATA: %s', e)
def insert_data(): try: query = "INSERT INTO DEPT_LOCATIONS (Dnumber, Dlocation) VALUES (%s, %s)" # 1 data = (1, 'Houston') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 2 data = (4, 'Stafford') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 3 data = (5, 'Bellaire') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 4 data = (5, 'Sugarland') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 5 data = (5, 'Houston') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 6 data = (6, 'Atlanta') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 7 data = (6, 'Sacramento') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 8 data = (7, 'Milwaukee') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 9 data = (8, 'Chicago') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 10 data = (8, 'Dallas') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 11 data = (8, 'Philadephia') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 12 data = (8, 'Seattle') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 13 data = (8, 'Miami') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 14 data = (9, 'Arlington') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 15 data = (11, 'Austin') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) except Exception as e: traceback.print_exc() logging.error('Error in INSERT_DATA: %s', e)
def insert_data(): try: query = "INSERT INTO DEPENDENT (Essn, Dependent_name, Sex, Birth_date, Relationship) " \ "VALUES (%s, %s, %s, STR_TO_DATE(%s,'%d-%b-%Y'), %s)" # 1 data = ('888665151', 'Mary Alice', 'F', '10-NOV-1924', 'Spouse') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 2 data = ('444444400', 'Kathy', 'F', '09-OCT-1944', 'Spouse') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 3 data = ('999887777', 'John Smith', 'M', '19-JUL-1956', 'Spouse') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 4 data = ('987987987', 'Khadeja Begum', 'F', '29-MAR-1949', 'Spouse') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 5 data = ('987987987', 'Jalil Ahmad', 'M', '29-MAR-1929', 'Children') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 6 data = ('222222200', 'Jay Wallis', 'M', '16-JAN-1956', 'Spouse') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 7 data = ('222222202', 'Mindy Vile', 'F', '21-JUN-1942', 'Spouse') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 8 data = ('222222202', 'Amenda Vile', 'F', '21-JUN-1914', 'Children') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 9 data = ('222222204', 'Amy Vos', 'F', '11-NOV-1963', 'Spouse') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 10 data = ('222222204', 'james Vos', 'M', '11-NOV-1937', 'Children') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 11 data = ('444444401', 'William Bayes', 'M', '19-JUN-1954', 'Spouse') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 12 data = ('444444401', 'Amy Bayes', 'F', '18-JUN-1926', 'Children') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 13 data = ('444444401', 'Tom Bayes', 'M', '20-JUN-1926', 'Children') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 14 data = ('666666601', 'Mary Jarvice', 'F', '14-JAN-1964', 'Spouse') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 15 data = ('666666602', 'Bond King', 'M', '16-APR-1964', 'Spouse') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 16 data = ('666666604', 'Monia King', 'F', '01-JAN-1955', 'Spouse') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 17 data = ('666666605', 'Aly Kramer', 'F', '22-AUG-1961', 'Spouse') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 18 data = ('666666606', 'Chistina King', 'F', '16-AUG-1948', 'Spouse') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 19 data = ('666666607', 'Alex Small', 'F', '15-MAY-1960', 'Spouse') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 20 data = ('666666608', 'Katherin Head', 'F', '19-MAY-1964', 'Spouse') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 21 data = ('666666608', 'Monica Head', 'F', '19-MAY-1937', 'Children') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) # 22 data = ('666666608', 'Rachel Head', 'M', '18-MAY-1937', 'Children') print(db.insert_query(query, data)) logging.info(str(query) + ' ' + str(data)) except Exception as e: traceback.print_exc() logging.error('Error in INSERT_DATA: %s', e)