Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def Create():
- while(True):
- while(True):
- try:
- client = raw_input("Use ADC or CDS? : ")
- if client.lower() == "cds":
- connection = pymssql.connect("data.test.cds", "TestCds_hserve_user", "jRb3ZmslcXdjFbyA#",
- "TestCDSTicketing")
- if client.lower() == "adc":
- connection = pymssql.connect("data.test.adc", "TestAdc_hserve_user", "236c605a69356664",
- "TestAdcTicketing")
- cursor = connection.cursor()
- break
- except:
- print errorMessage
- seriesCode = raw_input("Enter serie's code: ")
- while (True):
- try:
- cursor.execute(sqlFindIssKey % seriesCode)
- isskey = cursor.fetchall()
- break
- except:
- print "Oups! Looks like there were an error! Please try again!"
- isskey_copy = raw_input("From which Frozen Attributes would you like to update? (enter isscode please): ")
- try:
- for data in isskey:
- cursor.execute(sqlUpdateFrAt % isskey_copy, data)
- break
- except:
- print "No Frozen Attributes were updated. Maybe there were a mistakes. Please start over."
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement