Python 3.5.2 - I need help with a script

#libraries
import pyodbc
import sys
import datetime

#loop that will ask user for input and then do a function based on user

#create definition to display function later
def option_one():
    getstore_UIN = input('Enter the store UIN (ex: TX001):')
    print('')
    print('You entered %s' % getstore_UIN)
    print('')
    getstore_Num = input('Enter the store number (ex:001):')
    print('')
    print('You entered %s' % getstore_Num)
    print('')
    getstore_FileName = input('Enter the store MDB file name (ex: UIN.mdb):')
    print('')
    print('You entered %s' % getstore_FileName)
    print('')
    getstore_Name = input('Enter the store name:')
    print('')
    print('You entered %s' % getstore_Name)
    print('')
    getstore_CIM = input('Enter the store ROW CIM number:')
    print('')
    print('You entered %s' % getstore_CIM)
    print('')
    getstore_OpeningDate = input('Enter the store opening date (ex: mm/dd/yy): ')
    print('')
    print('You entered %s' % getstore_OpeningDate)
    print('')
    getstore_Email = input('Enter the store shop email (ex:):')
    print('')
    print('You entered %s' % getstore_Email)
    print('')
    getstore_Bays = input('Enter the number of bays this store has:')
    print('')
    print('You entered %s' % getstore_Bays)
    print('')
    getstore_Operator = input('Enter the full name of the store operator:')
    print('')
    print('You entered %s' % getstore_Operator)
    print('')
    getstore_Phone = input('Enter the store phone number:')
    print('')
    print('You entered %s' % getstore_Phone)
    print('')
    getstore_Market = input('Enter the name of the market the store is in (ex: Denver, Houston, etc):')
    print('')
    print('You entered %s' % getstore_CIM)
    print('')
    getfranchisee_Email = input('Enter the of the email of the franchisee (ex: first.lastname@cbauto.net:')
    print('')
    print('You entered %s' % getfranchisee_Email)
    print('')
    getstore_Street = input('Enter the store street address:')
    print('')
    print('You entered %s' % getstore_Street)
    print('')
    getstore_City = input('Enter the city the store is in:')
    print('')
    print('You entered %s' % getstore_City)
    print('')
    getstore_state = input('Enter the state the store is in:')
    print('')
    print('You entered %s' % getstore_state)
    print('')
    getstore_zip = input('Enter the zip the store is in:')
    print('')
    print('You entered %s' % getstore_zip)
    print('')

    #create the ODBC connection to MSSQL
    cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER={SQL2};DATABASE={ROWTest};UID={sa};PWD={pw}')

    #create the cursor variable to activate the connection
    cursor = cnxn.cursor()

    #sql command that will execute the insert to the database
    SQLCommand = ("INSERT INTO StoreInfo (store_UIN, store_Num, store_FileName, store_Name, store_CIM, store_OpeningDate, store_Email, store_Bays, store_Operator, store_Phone, store_Market, franchisee_Email, store_Street, store_City, store_State, store_Zip) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")

    #variables that grab user input variables and passes them to SQL command
    store_UIN = getstore_UIN
    store_Num = getstore_Num
    store_FileName = getstore_FileName
    store_Name = getstore_Name
    store_CIM = getstore_CIM
    store_OpeningDate = getstore_OpeningDate
    store_Email = getstore_Email
    store_Bays = getstore_Bays
    store_Operator = getstore_Operator
    store_Phone = getstore_Phone
    store_Market = getstore_Market
    franchisee_Email = getfranchisee_Email
    store_Street = getstore_Street
    store_City = getstore_City
    store_State = getstore_state
    store_Zip = getstore_zip

    #execute SQL statement
    cursor.execute(SQLCommand, [store_UIN, store_Num, store_FileName, store_Name, store_CIM, store_OpeningDate, store_Email, store_Bays, store_Operator, store_Phone, store_Market, franchisee_Email, store_Street, store_City, store_State, store_Zip])

    #commit the sql command
    cnxn.commit()

    input('Press enter to exit program')
    

#variable that makes the exit variable
user_exit =  4
while True:
        #prints statements that lead the end-user to decide what they would like to do
    print('Welcome to the ROWriter Database applet! What would you like to do?')
    print('')
    print('1) Insert a new store CIM info...')
    print('2) Update an existing store CIM info...')
    print('3) Delete an exisiting store CIM info...')
    print('4) Exit the application...')

        #accepts user input and converts it to a string and stores into a variable
    user_input = int(input('Enter option:'))
    #if user input is equal to the exit variable then the application exits
    if user_input == user_exit:
        break
    elif user_input == 1:
            option_one()
    elif user_input == 2:
            print('Hello, world!')
            

Select allOpen in new window