def create_employee(): conn = data.get_connection('localhost', os.environ.get('C9_USER'), '', 'classicmodels') # employeeNumber = dao.get_next_employee_number(conn) employeeNumber = request.form.get('employeeNumber') print('employeeNumber: ', employeeNumber) lastName = request.form.get('lastName') firstName = request.form.get('firstName') extension = request.form.get('extension') email = request.form.get('email') officeCode = request.form.get('officeCode') reportsTo = request.form.get('reportsTo') jobTitle = request.form.get('jobTitle') conn = data.get_connection('localhost', os.environ.get('C9_USER'), '', 'classicmodels') dao.new_employee(conn, employeeNumber, lastName, firstName, extension, email, officeCode, reportsTo, jobTitle) conn.commit() return redirect(url_for('display_employees'))
def show_employees(office_code): conn = data.get_connection('localhost', os.environ.get('C9_USER'), '', 'classicmodels') cursor = dao.get_employees(conn, office_code) return render_template('employees.html', cursor=cursor)
def index(): conn = data.get_connection('localhost', os.environ.get('C9_USER'), '', 'classicmodels') cursor = dao.get_offices(conn) return render_template('index.template.html', cursor=cursor)
def process_create_product(): # extract out all the variables from the form product_code = request.form.get('productCode') product_name = request.form.get('productName') product_line = request.form.get('productLine') product_vendor = "default vendor" product_scale = 100 product_description = "Desc" quantity_in_stock = 10 buy_price = 19.99 MSRP = 25.00 # prepare the SQL sql = f""" insert into `products` (`productCode`, `productName`, `productLine`, `productScale`, `productVendor`, `productDescription`, `quantityInStock`, `buyPrice`, `MSRP`) VALUES ('{product_code}', '{product_name}', '{product_line}', '{product_scale}', '{product_vendor}','{product_description}', '{quantity_in_stock}', '{buy_price}', '{MSRP}' ) """ conn = data.get_connection('localhost', os.environ.get('C9_USER'), '', 'classicmodels') cursor = data.create_cursor(conn) cursor.execute(sql) conn.commit() return redirect(url_for('search'))
def index(): conn = data.get_connection('localhost', os.environ.get('C9_USER'), '', 'classicmodels') cursor = data.create_cursor(conn) cursor.execute(""" select * from `products` """) return render_template('index.template.html', cursor=cursor)
def search(): conn = data.get_connection('localhost', os.environ.get('C9_USER'), '', 'classicmodels') product_line_cursor = data.get_product_lines(conn) # create the query sql = """select * from `products` where 1""" # we use request.args to get whatever is in the query string selected_product_line = request.args.get('selected_product_line') if selected_product_line: print("Filtering by", selected_product_line) sql = sql + f" and `productLine` = '{selected_product_line}'" search_terms = request.args.get('search-by') # if search_terms is not None if search_terms: sql = sql + f" and `productName` like '%{search_terms}%'" products_cursor = data.create_cursor(conn) products_cursor.execute(sql) return render_template('search.template.html', product_lines=product_line_cursor, products=products_cursor, sql=sql)
def display_offices(): conn = data.get_connection('localhost', os.environ.get('C9_USER'), '', 'classicmodels') cursor_offices = dao.get_offices(conn) return render_template('offices.html', cursor_offices=cursor_offices)
def create_employee_form(): conn = data.get_connection('localhost', os.environ.get('C9_USER'), '', 'classicmodels') cursor_cty = dao.get_office_code_country(conn) cursor_rpt_to = dao.get_reports_to(conn) return render_template('create_employee_form.html', cursor_cty=cursor_cty, cursor_rpt_to=cursor_rpt_to)
def create_office(): officeCode = request.form.get('officeCode') city = request.form.get('city') phone = request.form.get('phone') addressLine1 = request.form.get('addressLine1') addressLine2 = request.form.get('addressLine2') state = request.form.get('state') country = request.form.get('country') postalCode = request.form.get('postalCode') territory = request.form.get('territory') conn = data.get_connection('localhost', os.environ.get('C9_USER'), '', 'classicmodels') dao.new_offices(conn, officeCode, city, phone, addressLine1, addressLine2, state, country, postalCode, territory) return redirect(url_for('display_offices'))
def display_employees(): conn = data.get_connection('localhost', os.environ.get('C9_USER'), '', 'classicmodels') # get the SQL data for selecting employees first name/last name at dropdown cursor_fn = dao.get_employees_fn(conn) cursor_ln = dao.get_employees_ln(conn) cursor_ct = dao.get_employees_ct(conn) cursor_jt = dao.get_employees_jt(conn) # get user input at dropdown for firstname and lastname when user submit via button user_input_fn = "" user_input_ln = "" user_input_ct = "" user_input_jt = "" if request.method == 'POST': user_input_fn = request.form.get('firstName') user_input_ln = request.form.get('lastName') user_input_ct = request.form.get('country') user_input_jt = request.form.get('jobTitle') # get SQL data for table with filters to display on employees_only.html cursor = dao.get_employees_filtered(conn, user_input_fn, user_input_ln, user_input_ct, user_input_jt) saved_list = list(cursor) # print('--------hello------') # print(saved_list) return render_template('employees_only.html', saved_list=saved_list, cursor_fn=cursor_fn, cursor_ln=cursor_ln, cursor_ct=cursor_ct, cursor_jt=cursor_jt)
import data import os conn = data.get_connection('localhost', os.environ.get('C9_USER'), '', 'classicmodels') cursor = data.create_cursor(conn) product_line = input("Please enter the product line: ") text_description = input("Please enter the description: ") sql = f""" insert into `productlines` (`productLine`, `textDescription`) VALUES ('{product_line}', '{text_description}') """ # remember to execute the query cursor.execute(sql) #commit the changes (i.e confirm the changes) conn.commit()
def create_product(): conn = data.get_connection('localhost', os.environ.get('C9_USER'), '', 'classicmodels') product_lines = data.get_product_lines(conn) return render_template('create_product.template.html', product_lines=product_lines)