當前位置: 首頁>>代碼示例>>Python>>正文


Python DatabaseController.insertNewStudentRecord方法代碼示例

本文整理匯總了Python中DatabaseController.insertNewStudentRecord方法的典型用法代碼示例。如果您正苦於以下問題:Python DatabaseController.insertNewStudentRecord方法的具體用法?Python DatabaseController.insertNewStudentRecord怎麽用?Python DatabaseController.insertNewStudentRecord使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在DatabaseController的用法示例。


在下文中一共展示了DatabaseController.insertNewStudentRecord方法的1個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的Python代碼示例。

示例1: insertNewStudentRecord

# 需要導入模塊: import DatabaseController [as 別名]
# 或者: from DatabaseController import insertNewStudentRecord [as 別名]
def insertNewStudentRecord(schoolId, firstName, surname, dateOfBirth, phoneNumber, emailAddress, streetName1, streetName2, townOrCity, county):
    personId = 0
    addressId = 0
    studentId = 0   
    personIdRecord = DatabaseController.getPersonId(firstName, surname, dateOfBirth, phoneNumber, emailAddress)
    if personIdRecord.__len__() == 0:
        countRecord = DatabaseController.countNumberOfPersonRecords()
        personId = int(countRecord[0][0]) + 1
        DatabaseController.insertNewPersonRecord(personId, firstName, surname, dateOfBirth, phoneNumber, emailAddress)
    else:
        personId = int(personIdRecord[0][0])

    addressIdRecord = DatabaseController.getAddressId(streetName1, streetName2, townOrCity, county)
    if addressIdRecord.__len__() == 0:
        countRecord = DatabaseController.countRecordsInAddressTable()
        addressId = int(countRecord[0][0]) + 1
        DatabaseController.insertNewAddressRecord(addressId, streetName1, streetName2, townOrCity, county)
    else:
        addressId = int(addressIdRecord[0][0])

    studentIdRecord = DatabaseController.getStudentIdFromPersonId(personId)
    if studentIdRecord.__len__() == 0:
        countRecord = DatabaseController.countNumberOfStudentRecords()
        studentId = int(countRecord[0][0]) + 1
        DatabaseController.insertNewStudentRecord(studentId, personId, addressId)
    else:
        studentId = int(studentIdRecord[0][0])
    DatabaseController.insertNewSchoolStudentRecord(schoolId, studentId)
開發者ID:ajc24,項目名稱:ProjectY4,代碼行數:30,代碼來源:DataProcessing.py


注:本文中的DatabaseController.insertNewStudentRecord方法示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台,相關代碼片段篩選自各路編程大神貢獻的開源項目,源碼版權歸原作者所有,傳播和使用請參考對應項目的License;未經允許,請勿轉載。