【Django】如何转化已有的数据表到Django模型--20230823
初步生成model.py
$ python manage.py inspectdb
$ python manage.py inspectdb > models.py
python manage.py inspectdb
# This is an auto-generated Django model module.
# You'll have to do the following manually to clean this up:
# * Rearrange models' order
# * Make sure each model has one field with primary_key=True
# * Make sure each ForeignKey and OneToOneField has `on_delete` set to the desired behavior
# * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table
# Feel free to rename the models, but don't rename db_table values or field names.
from django.db import modelsclass AuthGroup(models.Model):name = models.CharField(unique=True, max_length=150)class Meta:managed = Falsedb_table = 'auth_group'class AuthGroupPermissions(models.Model):id = models.BigAutoField(primary_key=True)group = models.ForeignKey(AuthGroup, models.DO_NOTHING)permission = models.ForeignKey('AuthPermission', models.DO_NOTHING)class Meta:managed = Falsedb_table = 'auth_group_permissions'unique_together = (('group', 'permission'),)class AuthPermission(models.Model):name = models.CharField(max_length=255)content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING)codename = models.CharField(max_length=100)class Meta:managed = Falsedb_table = 'auth_permission'unique_together = (('content_type', 'codename'),)class AuthUser(models.Model):password = models.CharField(max_length=128)last_login = models.DateTimeField(blank=True, null=True)is_superuser = models.IntegerField()username = models.CharField(unique=True, max_length=150)first_name = models.CharField(max_length=150)last_name = models.CharField(max_length=150)email = models.CharField(max_length=254)is_staff = models.IntegerField()is_active = models.IntegerField()date_joined = models.DateTimeField()class Meta:managed = Falsedb_table = 'auth_user'class AuthUserGroups(models.Model):id = models.BigAutoField(primary_key=True)user = models.ForeignKey(AuthUser, models.DO_NOTHING)group = models.ForeignKey(AuthGroup, models.DO_NOTHING)class Meta:managed = Falsedb_table = 'auth_user_groups'unique_together = (('user', 'group'),)class AuthUserUserPermissions(models.Model):id = models.BigAutoField(primary_key=True)user = models.ForeignKey(AuthUser, models.DO_NOTHING)permission = models.ForeignKey(AuthPermission, models.DO_NOTHING)class Meta:managed = Falsedb_table = 'auth_user_user_permissions'unique_together = (('user', 'permission'),)class Config(models.Model):id = models.BigAutoField(primary_key=True)config1 = models.CharField(max_length=135, blank=True, null=True)config2 = models.CharField(max_length=135, blank=True, null=True)config3 = models.CharField(max_length=135, blank=True, null=True)config4 = models.CharField(max_length=135, blank=True, null=True)config5 = models.CharField(max_length=135, blank=True, null=True)config6 = models.CharField(max_length=135, blank=True, null=True)config7 = models.CharField(max_length=135, blank=True, null=True)config8 = models.CharField(max_length=135, blank=True, null=True)config9 = models.CharField(max_length=135, blank=True, null=True)config10 = models.CharField(max_length=135, blank=True, null=True)config11 = models.CharField(max_length=135, blank=True, null=True)config12 = models.CharField(max_length=135, blank=True, null=True)config13 = models.CharField(max_length=135, blank=True, null=True)config14 = models.CharField(max_length=135, blank=True, null=True)config15 = models.CharField(max_length=135, blank=True, null=True)config16 = models.CharField(max_length=135, blank=True, null=True)config17 = models.CharField(max_length=135, blank=True, null=True)config18 = models.CharField(max_length=135, blank=True, null=True)config19 = models.CharField(max_length=135, blank=True, null=True)config20 = models.CharField(max_length=135, blank=True, null=True)config21 = models.CharField(max_length=135, blank=True, null=True)config22 = models.CharField(max_length=135, blank=True, null=True)config23 = models.CharField(max_length=135, blank=True, null=True)config24 = models.CharField(max_length=135, blank=True, null=True)config25 = models.CharField(max_length=135, blank=True, null=True)config26 = models.CharField(max_length=135, blank=True, null=True)config27 = models.CharField(max_length=135, blank=True, null=True)config28 = models.CharField(max_length=135, blank=True, null=True)config29 = models.CharField(max_length=135, blank=True, null=True)config30 = models.CharField(max_length=135, blank=True, null=True)config31 = models.CharField(max_length=135, blank=True, null=True)config32 = models.CharField(max_length=135, blank=True, null=True)config33 = models.CharField(max_length=135, blank=True, null=True)config34 = models.CharField(max_length=135, blank=True, null=True)config35 = models.CharField(max_length=135, blank=True, null=True)config36 = models.CharField(max_length=135, blank=True, null=True)config37 = models.CharField(max_length=135, blank=True, null=True)config38 = models.CharField(max_length=135, blank=True, null=True)config39 = models.CharField(max_length=135, blank=True, null=True)config40 = models.CharField(max_length=135, blank=True, null=True)config41 = models.CharField(max_length=135, blank=True, null=True)config42 = models.CharField(max_length=135, blank=True, null=True)config43 = models.CharField(max_length=135, blank=True, null=True)config44 = models.CharField(max_length=135, blank=True, null=True)config45 = models.CharField(max_length=135, blank=True, null=True)config46 = models.CharField(max_length=135, blank=True, null=True)config47 = models.CharField(max_length=135, blank=True, null=True)config48 = models.CharField(max_length=135, blank=True, null=True)config49 = models.CharField(max_length=135, blank=True, null=True)config50 = models.CharField(max_length=135, blank=True, null=True)class Meta:managed = Falsedb_table = 'config'class CsodTrainingAndTestRecord2(models.Model):id = models.BigAutoField(primary_key=True)user = models.CharField(db_column='USER', max_length=135, blank=True, null=True) # Field name made lowercase.user_id = models.CharField(db_column='USER_ID', max_length=135, blank=True, null=True) # Field name made lowercase.training_title = models.CharField(db_column='TRAINING_TITLE', max_length=135, blank=True, null=True) # Field name made lowercase.training_version = models.CharField(db_column='TRAINING_VERSION', max_length=135, blank=True, null=True) # Field name made lowercase.training_type = models.CharField(db_column='TRAINING_TYPE', max_length=135, blank=True, null=True) # Field name made lowercase.training_vendor = models.CharField(db_column='TRAINING_VENDOR', max_length=135, blank=True, null=True) # Field name made lowercase.training_status = models.CharField(db_column='TRAINING_STATUS', max_length=135, blank=True, null=True) # Field name made lowercase.training_hours = models.CharField(db_column='TRAINING_HOURS', max_length=135, blank=True, null=True) # Field name made lowercase.credits = models.CharField(db_column='CREDITS', max_length=135, blank=True, null=True) # Field name made lowercase.training_record_date = models.DateTimeField(db_column='TRAINING_RECORD_DATE', blank=True, null=True) # Field name made lowercase.accommodation_expense = models.CharField(db_column='Accommodation_Expense', max_length=135, blank=True, null=True) # Field name made lowercase.apply_reason = models.CharField(db_column='Apply_Reason', max_length=135, blank=True, null=True) # Field name made lowercase.compulsory_elective = models.CharField(db_column='Compulsory_Elective', max_length=135, blank=True, null=True) # Field name made lowercase.course_owner = models.CharField(db_column='Course_Owner', max_length=135, blank=True, null=True) # Field name made lowercase.currency = models.CharField(db_column='Currency', max_length=135, blank=True, null=True) # Field name made lowercase.facility_expense = models.CharField(db_column='Facility_Expense', max_length=135, blank=True, null=True) # Field name made lowercase.instructor_expense = models.CharField(db_column='Instructor_Expense', max_length=135, blank=True, null=True) # Field name made lowercase.instructor_full_name = models.CharField(db_column='Instructor_Full_Name', max_length=135, blank=True, null=True) # Field name made lowercase.instructor_id = models.CharField(db_column='Instructor_ID', max_length=135, blank=True, null=True) # Field name made lowercase.instructor_type = models.CharField(db_column='Instructor_Type', max_length=135, blank=True, null=True) # Field name made lowercase.material_expense = models.CharField(db_column='Material_Expense', max_length=135, blank=True, null=True) # Field name made lowercase.meal_expense = models.CharField(db_column='Meal_Expense', max_length=135, blank=True, null=True) # Field name made lowercase.note = models.CharField(db_column='Note', max_length=135, blank=True, null=True) # Field name made lowercase.other_expense = models.CharField(db_column='Other_Expense', max_length=135, blank=True, null=True) # Field name made lowercase.training_type_2 = models.CharField(db_column='Training_Type_2', max_length=135, blank=True, null=True) # Field name made lowercase.transportation_expense = models.CharField(db_column='Transportation_Expense', max_length=135, blank=True, null=True) # Field name made lowercase.unfinished_training_fee = models.CharField(db_column='Unfinished_Training_Fee', max_length=135, blank=True, null=True) # Field name made lowercase.class Meta:managed = Falsedb_table = 'csod_training_and_test_record2'class DjangoAdminLog(models.Model):action_time = models.DateTimeField()object_id = models.TextField(blank=True, null=True)object_repr = models.CharField(max_length=200)action_flag = models.PositiveSmallIntegerField()change_message = models.TextField()content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING, blank=True, null=True)user = models.ForeignKey(AuthUser, models.DO_NOTHING)class Meta:managed = Falsedb_table = 'django_admin_log'class DjangoContentType(models.Model):app_label = models.CharField(max_length=100)model = models.CharField(max_length=100)class Meta:managed = Falsedb_table = 'django_content_type'unique_together = (('app_label', 'model'),)class DjangoMigrations(models.Model):id = models.BigAutoField(primary_key=True)app = models.CharField(max_length=255)name = models.CharField(max_length=255)applied = models.DateTimeField()class Meta:managed = Falsedb_table = 'django_migrations'class DjangoSession(models.Model):session_key = models.CharField(primary_key=True, max_length=40)session_data = models.TextField()expire_date = models.DateTimeField()class Meta:managed = Falsedb_table = 'django_session'class EnglishPasslist(models.Model):id = models.BigAutoField(primary_key=True)function_name = models.CharField(db_column='FUNCTION_NAME', max_length=135, blank=True, null=True) # Field name made lowercase.department = models.CharField(db_column='DEPARTMENT', max_length=135, blank=True, null=True) # Field name made lowercase.engfunc = models.CharField(db_column='ENGFUNC', max_length=135, blank=True, null=True) # Field name made lowercase.employee_id = models.CharField(db_column='EMPLOYEE_ID', max_length=135, blank=True, null=True) # Field name made lowercase.chinese_name = models.CharField(db_column='CHINESE_NAME', max_length=135, blank=True, null=True) # Field name made lowercase.entry_date = models.DateTimeField(db_column='ENTRY_DATE', blank=True, null=True) # Field name made lowercase.group_grade = models.CharField(db_column='GROUP_GRADE', max_length=135, blank=True, null=True) # Field name made lowercase.highestscores = models.CharField(db_column='HIGHESTSCORES', max_length=135, blank=True, null=True) # Field name made lowercase.highestscores_test_date = models.CharField(db_column='HIGHESTSCORES_TEST_DATE', max_length=135, blank=True, null=True) # Field name made lowercase.passcurrent = models.CharField(db_column='PASSCURRENT', max_length=135, blank=True, null=True) # Field name made lowercase.highestscores_2year = models.CharField(db_column='HIGHESTSCORES_2YEAR', max_length=135, blank=True, null=True) # Field name made lowercase.highestscores_2year_test_date = models.CharField(db_column='HIGHESTSCORES_2YEAR_TEST_DATE', max_length=135, blank=True, null=True) # Field name made lowercase.highestscores_2year_invalid_date = models.CharField(db_column='HIGHESTSCORES_2YEAR_INVALID_DATE', max_length=135, blank=True, null=True) # Field name made lowercase.passcurrent_2year = models.CharField(db_column='PASSCURRENT_2YEAR', max_length=135, blank=True, null=True) # Field name made lowercase.pass_high_grade_2year = models.CharField(db_column='PASS_HIGH_GRADE_2YEAR', max_length=135, blank=True, null=True) # Field name made lowercase.trans_date = models.CharField(db_column='TRANS_DATE', max_length=135, blank=True, null=True) # Field name made lowercase.remark = models.CharField(db_column='REMARK', max_length=135, blank=True, null=True) # Field name made lowercase.buffer1 = models.CharField(max_length=135, blank=True, null=True)buffer2 = models.CharField(max_length=135, blank=True, null=True)buffer3 = models.CharField(max_length=135, blank=True, null=True)buffer4 = models.CharField(max_length=135, blank=True, null=True)buffer5 = models.CharField(max_length=135, blank=True, null=True)buffer6 = models.CharField(max_length=135, blank=True, null=True)buffer7 = models.CharField(max_length=135, blank=True, null=True)buffer8 = models.CharField(max_length=135, blank=True, null=True)buffer9 = models.CharField(max_length=135, blank=True, null=True)buffer10 = models.CharField(max_length=135, blank=True, null=True)record_date = models.DateTimeField(blank=True, null=True)class Meta:managed = Falsedb_table = 'english_passlist'class ManagementPasslist(models.Model):id = models.BigAutoField(primary_key=True)location = models.CharField(db_column='LOCATION', max_length=135, blank=True, null=True) # Field name made lowercase.function_code = models.CharField(db_column='FUNCTION_CODE', max_length=135, blank=True, null=True) # Field name made lowercase.function_name = models.CharField(db_column='FUNCTION_NAME', max_length=135, blank=True, null=True) # Field name made lowercase.deptid = models.CharField(db_column='DEPTID', max_length=135, blank=True, null=True) # Field name made lowercase.grade_range = models.CharField(db_column='GRADE_RANGE', max_length=135, blank=True, null=True) # Field name made lowercase.emplid = models.CharField(db_column='EMPLID', max_length=135, blank=True, null=True) # Field name made lowercase.name = models.CharField(db_column='NAME', max_length=135, blank=True, null=True) # Field name made lowercase.current_range_course_total = models.CharField(db_column='CURRENT_RANGE_COURSE_TOTAL', max_length=135, blank=True, null=True) # Field name made lowercase.current_range_1st_assessment_total = models.CharField(db_column='CURRENT_RANGE_1ST_ASSESSMENT_TOTAL', max_length=135, blank=True, null=True) # Field name made lowercase.current_range_present_total = models.CharField(db_column='CURRENT_RANGE_PRESENT_TOTAL', max_length=135, blank=True, null=True) # Field name made lowercase.current_range_2nd_assessment_total = models.CharField(db_column='CURRENT_RANGE_2ND_ASSESSMENT_TOTAL', max_length=135, blank=True, null=True) # Field name made lowercase.p1_rate = models.CharField(db_column='P1_RATE', max_length=135, blank=True, null=True) # Field name made lowercase.p2_rate = models.CharField(db_column='P2_RATE', max_length=135, blank=True, null=True) # Field name made lowercase.p3_rate = models.CharField(db_column='P3_RATE', max_length=135, blank=True, null=True) # Field name made lowercase.current_range_rate = models.CharField(db_column='CURRENT_RANGE_RATE', max_length=135, blank=True, null=True) # Field name made lowercase.record_date = models.DateTimeField(blank=True, null=True)buffer1 = models.CharField(max_length=135, blank=True, null=True)buffer2 = models.CharField(max_length=135, blank=True, null=True)buffer3 = models.CharField(max_length=135, blank=True, null=True)buffer4 = models.CharField(max_length=135, blank=True, null=True)buffer5 = models.CharField(max_length=135, blank=True, null=True)buffer6 = models.CharField(max_length=135, blank=True, null=True)buffer7 = models.CharField(max_length=135, blank=True, null=True)buffer8 = models.CharField(max_length=135, blank=True, null=True)buffer9 = models.CharField(max_length=135, blank=True, null=True)buffer10 = models.CharField(max_length=135, blank=True, null=True)class Meta:managed = Falsedb_table = 'management_passlist'class PeopleData(models.Model):pkid = models.IntegerField(blank=True, null=True)batchid = models.TextField(blank=True, null=True)bu = models.TextField(blank=True, null=True)bg = models.TextField(blank=True, null=True)site = models.TextField(blank=True, null=True)plant = models.TextField(blank=True, null=True)emplid = models.TextField(blank=True, null=True)name = models.TextField(blank=True, null=True)name_a = models.TextField(blank=True, null=True)hire_dt = models.DateTimeField(blank=True, null=True)sal_location_a = models.TextField(blank=True, null=True)company = models.TextField(blank=True, null=True)deptid = models.TextField(blank=True, null=True)location = models.TextField(blank=True, null=True)jobtitle_descr = models.TextField(blank=True, null=True)emailid = models.TextField(blank=True, null=True)email_address_a = models.TextField(blank=True, null=True)phone_a = models.TextField(blank=True, null=True)officer_level_a = models.TextField(blank=True, null=True)supervisor_id = models.TextField(blank=True, null=True)tree_level_num = models.TextField(blank=True, null=True)termination_dt = models.DateTimeField(blank=True, null=True)labor_type = models.TextField(blank=True, null=True)job_family = models.TextField(blank=True, null=True)grade = models.TextField(blank=True, null=True)job_entry_dt = models.DateTimeField(blank=True, null=True)grade_entry_dt = models.DateTimeField(blank=True, null=True)job_title_a = models.TextField(blank=True, null=True)last_updt_dt = models.DateTimeField(blank=True, null=True)jobcode = models.TextField(blank=True, null=True)action_reason = models.TextField(blank=True, null=True)sex = models.TextField(blank=True, null=True)birthdate = models.DateTimeField(blank=True, null=True)batch_id = models.TextField(blank=True, null=True)version_id = models.IntegerField(blank=True, null=True)class Meta:managed = Falsedb_table = 'people_data'class ProfessionPasslist(models.Model):id = models.BigAutoField(primary_key=True)location = models.CharField(db_column='LOCATION', max_length=135, blank=True, null=True) # Field name made lowercase.function_code = models.CharField(db_column='FUNCTION_CODE', max_length=135, blank=True, null=True) # Field name made lowercase.function_name = models.CharField(db_column='FUNCTION_NAME', max_length=135, blank=True, null=True) # Field name made lowercase.department = models.CharField(db_column='DEPARTMENT', max_length=135, blank=True, null=True) # Field name made lowercase.employee_id = models.CharField(db_column='EMPLOYEE_ID', max_length=135, blank=True, null=True) # Field name made lowercase.chinese_name = models.CharField(db_column='CHINESE_NAME', max_length=135, blank=True, null=True) # Field name made lowercase.entry_date = models.DateTimeField(db_column='ENTRY_DATE', blank=True, null=True) # Field name made lowercase.group_grade = models.CharField(db_column='GROUP_GRADE', max_length=135, blank=True, null=True) # Field name made lowercase.effected_date = models.CharField(db_column='EFFECTED_DATE', max_length=135, blank=True, null=True) # Field name made lowercase.pass_all = models.CharField(db_column='PASS_ALL', max_length=135, blank=True, null=True) # Field name made lowercase.all_small_test_current = models.CharField(db_column='ALL_SMALL_TEST_CURRENT', max_length=135, blank=True, null=True) # Field name made lowercase.pass_small_test_current = models.CharField(db_column='PASS_SMALL_TEST_CURRENT', max_length=135, blank=True, null=True) # Field name made lowercase.all_middle_test_current = models.CharField(db_column='ALL_MIDDLE_TEST_CURRENT', max_length=135, blank=True, null=True) # Field name made lowercase.pass_middle_test_current = models.CharField(db_column='PASS_MIDDLE_TEST_CURRENT', max_length=135, blank=True, null=True) # Field name made lowercase.all_final_test_current = models.CharField(db_column='ALL_FINAL_TEST_CURRENT', max_length=135, blank=True, null=True) # Field name made lowercase.pass_final_test_current = models.CharField(db_column='PASS_FINAL_TEST_CURRENT', max_length=135, blank=True, null=True) # Field name made lowercase.all_others_test_current = models.CharField(db_column='ALL_OTHERS_TEST_CURRENT', max_length=135, blank=True, null=True) # Field name made lowercase.pass_others_test_current = models.CharField(db_column='PASS_OTHERS_TEST_CURRENT', max_length=135, blank=True, null=True) # Field name made lowercase.pass_testrate_current = models.CharField(db_column='PASS_TESTRATE_CURRENT', max_length=135, blank=True, null=True) # Field name made lowercase.all_training_next = models.CharField(db_column='ALL_TRAINING_NEXT', max_length=135, blank=True, null=True) # Field name made lowercase.pass_traning_next = models.CharField(db_column='PASS_TRANING_NEXT', max_length=135, blank=True, null=True) # Field name made lowercase.pass_trainingrate_next = models.CharField(db_column='PASS_TRAININGRATE_NEXT', max_length=135, blank=True, null=True) # Field name made lowercase.all_small_test_next = models.CharField(db_column='ALL_SMALL_TEST_NEXT', max_length=135, blank=True, null=True) # Field name made lowercase.pass_small_test_next = models.CharField(db_column='PASS_SMALL_TEST_NEXT', max_length=135, blank=True, null=True) # Field name made lowercase.all_middle_test_next = models.CharField(db_column='ALL_MIDDLE_TEST_NEXT', max_length=135, blank=True, null=True) # Field name made lowercase.pass_middle_test_next = models.CharField(db_column='PASS_MIDDLE_TEST_NEXT', max_length=135, blank=True, null=True) # Field name made lowercase.all_final_test_next = models.CharField(db_column='ALL_FINAL_TEST_NEXT', max_length=135, blank=True, null=True) # Field name made lowercase.pass_final_test_next = models.CharField(db_column='PASS_FINAL_TEST_NEXT', max_length=135, blank=True, null=True) # Field name made lowercase.all_others_test_next = models.CharField(db_column='ALL_OTHERS_TEST_NEXT', max_length=135, blank=True, null=True) # Field name made lowercase.pass_others_test_next = models.CharField(db_column='PASS_OTHERS_TEST_NEXT', max_length=135, blank=True, null=True) # Field name made lowercase.pass_testrate_next = models.CharField(db_column='PASS_TESTRATE_NEXT', max_length=135, blank=True, null=True) # Field name made lowercase.trans_date = models.CharField(db_column='TRANS_DATE', max_length=135, blank=True, null=True) # Field name made lowercase.remark = models.CharField(db_column='REMARK', max_length=135, blank=True, null=True) # Field name made lowercase.pass_trans_cur = models.CharField(db_column='PASS_TRANS_CUR', max_length=135, blank=True, null=True) # Field name made lowercase.pass_trans_nex = models.CharField(db_column='PASS_TRANS_NEX', max_length=135, blank=True, null=True) # Field name made lowercase.buffer1 = models.CharField(max_length=135, blank=True, null=True)buffer10 = models.CharField(max_length=135, blank=True, null=True)buffer2 = models.CharField(max_length=135, blank=True, null=True)buffer3 = models.CharField(max_length=135, blank=True, null=True)buffer4 = models.CharField(max_length=135, blank=True, null=True)buffer5 = models.CharField(max_length=135, blank=True, null=True)buffer6 = models.CharField(max_length=135, blank=True, null=True)buffer7 = models.CharField(max_length=135, blank=True, null=True)buffer8 = models.CharField(max_length=135, blank=True, null=True)buffer9 = models.CharField(max_length=135, blank=True, null=True)record_date = models.DateTimeField(blank=True, null=True)class Meta:managed = Falsedb_table = 'profession_passlist'class TrainingImportCsodTrainingAndTestRecordForModel(models.Model):id = models.BigAutoField(primary_key=True)file = models.CharField(max_length=100)name = models.CharField(max_length=50)class Meta:managed = Falsedb_table = 'training_import_csod_training_and_test_record_for_model'class TrainingImportEnglishPasslistForModel(models.Model):id = models.BigAutoField(primary_key=True)file = models.CharField(max_length=100)name = models.CharField(max_length=50)class Meta:managed = Falsedb_table = 'training_import_english_passlist_for_model'class TrainingImportManagementPasslistForModel(models.Model):id = models.BigAutoField(primary_key=True)file = models.CharField(max_length=100)name = models.CharField(max_length=50)class Meta:managed = Falsedb_table = 'training_import_management_passlist_for_model'class TrainingImportProfessionPasslistForModel(models.Model):id = models.BigAutoField(primary_key=True)file = models.CharField(max_length=100)name = models.CharField(max_length=50)class Meta:managed = Falsedb_table = 'training_import_profession_passlist_for_model'class TrainingImportTrsTrainerMaintainForModel(models.Model):id = models.BigAutoField(primary_key=True)file = models.CharField(max_length=100)name = models.CharField(max_length=50)class Meta:managed = Falsedb_table = 'training_import_trs_trainer_maintain_for_model'class TrainingImportTrsTrainingAndTestRecordForModel(models.Model):id = models.BigAutoField(primary_key=True)file = models.CharField(max_length=100)name = models.CharField(max_length=50)class Meta:managed = Falsedb_table = 'training_import_trs_training_and_test_record_for_model'class TrainingImportZzRecordForModel(models.Model):id = models.BigAutoField(primary_key=True)file = models.CharField(max_length=100)name = models.CharField(max_length=50)class Meta:managed = Falsedb_table = 'training_import_zz_record_for_model'class TrsTrainerMaintain(models.Model):id = models.BigAutoField(primary_key=True)trainer_id = models.CharField(db_column='TRAINER_ID', max_length=135, blank=True, null=True) # Field name made lowercase.trainer_name = models.CharField(db_column='TRAINER_NAME', max_length=135, blank=True, null=True) # Field name made lowercase.deptment_id = models.CharField(db_column='DEPTMENT_ID', max_length=135, blank=True, null=True) # Field name made lowercase.plant = models.CharField(db_column='PLANT', max_length=135, blank=True, null=True) # Field name made lowercase.grade_code = models.CharField(db_column='GRADE_CODE', max_length=135, blank=True, null=True) # Field name made lowercase.score = models.CharField(db_column='SCORE', max_length=135, blank=True, null=True) # Field name made lowercase.honor = models.CharField(db_column='HONOR', max_length=135, blank=True, null=True) # Field name made lowercase.effective_date = models.CharField(db_column='EFFECTIVE_DATE', max_length=135, blank=True, null=True) # Field name made lowercase.iscurrent_grade = models.CharField(db_column='ISCURRENT_GRADE', max_length=135, blank=True, null=True) # Field name made lowercase.update_user = models.CharField(db_column='UPDATE_USER', max_length=135, blank=True, null=True) # Field name made lowercase.update_date = models.CharField(db_column='UPDATE_DATE', max_length=135, blank=True, null=True) # Field name made lowercase.employeeid = models.CharField(db_column='EMPLOYEEID', max_length=135, blank=True, null=True) # Field name made lowercase.location = models.CharField(db_column='LOCATION', max_length=135, blank=True, null=True) # Field name made lowercase.class Meta:managed = Falsedb_table = 'trs_trainer_maintain'class TrsTrainingAndTestRecord(models.Model):id = models.BigAutoField(primary_key=True)location = models.CharField(db_column='Location', max_length=135, blank=True, null=True) # Field name made lowercase.function_code = models.CharField(db_column='Function_Code', max_length=135, blank=True, null=True) # Field name made lowercase.function_name = models.CharField(db_column='Function_Name', max_length=135, blank=True, null=True) # Field name made lowercase.plant = models.CharField(db_column='Plant', max_length=135, blank=True, null=True) # Field name made lowercase.dept = models.CharField(db_column='Dept', max_length=135, blank=True, null=True) # Field name made lowercase.employee_no = models.CharField(db_column='Employee_NO', max_length=135, blank=True, null=True) # Field name made lowercase.name = models.CharField(db_column='Name', max_length=135, blank=True, null=True) # Field name made lowercase.grade_range = models.CharField(db_column='Grade_Range', max_length=135, blank=True, null=True) # Field name made lowercase.training_type = models.CharField(db_column='Training_Type', max_length=135, blank=True, null=True) # Field name made lowercase.priority = models.CharField(db_column='Priority', max_length=135, blank=True, null=True) # Field name made lowercase.type = models.CharField(db_column='Type', max_length=135, blank=True, null=True) # Field name made lowercase.course = models.CharField(db_column='Course', max_length=135, blank=True, null=True) # Field name made lowercase.schedule_code = models.CharField(db_column='Schedule_Code', max_length=135, blank=True, null=True) # Field name made lowercase.schedule_name = models.CharField(db_column='Schedule_Name', max_length=135, blank=True, null=True) # Field name made lowercase.course_or_test = models.CharField(db_column='Course_or_Test', max_length=135, blank=True, null=True) # Field name made lowercase.delivery_way_or_test_way = models.CharField(db_column='Delivery_Way_or_Test_Way', max_length=135, blank=True, null=True) # Field name made lowercase.start_date = models.DateTimeField(db_column='Start_Date', blank=True, null=True) # Field name made lowercase.end_date = models.DateTimeField(db_column='End_Date', blank=True, null=True) # Field name made lowercase.present_status = models.CharField(db_column='Present_Status', max_length=135, blank=True, null=True) # Field name made lowercase.pass_score = models.IntegerField(db_column='Pass_Score', blank=True, null=True) # Field name made lowercase.listening_score = models.IntegerField(db_column='Listening_Score', blank=True, null=True) # Field name made lowercase.reading_score = models.IntegerField(db_column='Reading_Score', blank=True, null=True) # Field name made lowercase.score = models.IntegerField(db_column='Score', blank=True, null=True) # Field name made lowercase.pass_yn = models.CharField(db_column='Pass_YN', max_length=135, blank=True, null=True) # Field name made lowercase.effective_date = models.CharField(db_column='Effective_Date', max_length=135, blank=True, null=True) # Field name made lowercase.duration = models.CharField(db_column='Duration', max_length=135, blank=True, null=True) # Field name made lowercase.venue = models.CharField(db_column='Venue', max_length=135, blank=True, null=True) # Field name made lowercase.trainer_assesor = models.CharField(db_column='Trainer_Assesor', max_length=135, blank=True, null=True) # Field name made lowercase.class Meta:managed = Falsedb_table = 'trs_training_and_test_record'class ZzRecord(models.Model):id = models.BigAutoField(primary_key=True)employee_id = models.CharField(db_column='Employee_ID', max_length=135, blank=True, null=True) # Field name made lowercase.name = models.CharField(db_column='Name', max_length=135, blank=True, null=True) # Field name made lowercase.role = models.CharField(db_column='Role', max_length=135, blank=True, null=True) # Field name made lowercase.class Meta:managed = Falsedb_table = 'zz_record'
修改部分信息
pkid = models.IntegerField(primary_key=True)
相关文章:
【Django】如何转化已有的数据表到Django模型--20230823
初步生成model.py $ python manage.py inspectdb $ python manage.py inspectdb > models.py python manage.py inspectdb # This is an auto-generated Django model module. # Youll have to do the following manually to clean this up: # * Rearrange models order…...

【C语言】喝汽水问题
大家好!今天我们来学习C语言中的喝汽水问题! 目录 1. 题目内容: 2. 思路分析 2.1 方法一 2.2 方法二 2.3 方法三 3. 代码实现 3.1 方法一 3.2 方法二 3.3 方法三 1. 题目内容 喝汽水,1瓶汽水1元,2个空瓶可以…...

项目进度管理(4-2)关键链法和关键路径法的区别和联系
1 关键链法和关键路径法的主要区别 1.1 关键链法和关键路径法的关注焦点不同 关键路径法(CPM):关注项目中最长的路径,也就是所需时间最长的路径,这被称为关键路径。关键路径决定了项目的最早完成时间。关键链法&…...

基于Java+SpringBoot+Vue前后端分离医院后台管理系统设计和实现
博主介绍:✌全网粉丝30W,csdn特邀作者、博客专家、CSDN新星计划导师、Java领域优质创作者,博客之星、掘金/华为云/阿里云/InfoQ等平台优质作者、专注于Java技术领域和毕业项目实战✌ 🍅文末获取源码联系🍅 👇🏻 精彩专…...
二维数组传参
在C语言中,可以通过指针来传递二维数组。二维数组实际上是一个连续的内存块,可以使用指针来表示二维数组的行和列。以下是一个示例: #include <stdio.h>void myFunction(int arr[][3], int rows) {for (int i 0; i < rows; i) {fo…...

AI 绘画Stable Diffusion 研究(十四)SD 图生图+剪映制作人物说话视频
大家好,我是风雨无阻。 前一篇,我们详细介绍了使用 SadTlaker制作数字人视频案例,感兴趣的朋友请前往查看:AI 绘画Stable Diffusion 研究(十三)SD数字人制作工具SadTlaker使用教程。 对于没有安装 SadTlaker 插件的朋友…...

ProPlot 基本语法及特点
文章目录 简介多子图绘制处理共享轴标签“跨度”轴标签多子图序号的绘制 更简单的颜色条和图例更加美观的颜色和字体 简介 科研论文配图多图层元素(字体、坐标轴、图例等)的绘制条件提出了更高要求,我们需要更改 Matplotlib 和 Seaborn 中的…...
element-template-admin get请求正常 post请求超市问题
最近搞全栈,想写个增删改查连接element-template-admin框架,postman测get和post请求都正常,到框架里直接超时,看网络请求一直是padding状态,后来经查阅资料,发现是这个template框架的问题 解决方案&#x…...

Promise.all和promise.race的应用场景举例
Promise.all( ).then( )适用于处理多个异步任务,且所有的异步任务都得到结果时的情况。 <template><div class"box"><el-button type"primary" plain click"clickFn">点开弹出框</el-button></div> &…...

go学习-指针 标识符
指针,以及标识符 1.指针 (1).基本介绍 1)基本数据类型,变量存的值,也叫值类型 2)获取变量的地址用&,比如 var num int ,获取num的地址:&num 3)指针类型&…...

LeetCode--HOT100题(42)
目录 题目描述:108. 将有序数组转换为二叉搜索树(简单)题目接口解题思路代码 PS: 题目描述:108. 将有序数组转换为二叉搜索树(简单) 给你一个整数数组 nums ,其中元素已经按 升序 排列…...

YOLOv8教程系列:三、K折交叉验证——让你的每一份标注数据都物尽其用(yolov8目标检测+k折交叉验证法)
YOLOv8教程系列:三、K折交叉验证——让你的每一份标注数据都物尽其用(yolov8目标检测k折交叉验证法) 0.引言 k折交叉验证(K-Fold Cross-Validation)是一种在机器学习中常用的模型评估技术,用于估计模型的性…...
leetcode算法题--表示数值的字符串
原题链接:https://leetcode.cn/problems/biao-shi-shu-zhi-de-zi-fu-chuan-lcof/description/?envTypestudy-plan-v2&envIdcoding-interviews 题目类型有点新颖,有限状态机 // CharType表示当前字符的类型 // State表示当前所处的状态 type State…...

Docker安装及Docker构建简易版Hadoop生态
一、首先在VM创建一个新的虚拟机将Docker安装好 更新系统:首先打开终端,更新系统包列表。 sudo apt-get update sudo apt-get upgrade下图是更新系统包截图 安装Docker:使用以下命令在Linux上安装Docker。 sudo apt-get install -y docker.i…...

使用Burp Suite进行Web应用渗透测试
使用Burp Suite进行Web应用渗透测试是一种常见的方法,可以帮助发现Web应用程序中的安全漏洞和弱点。 步骤: 准备工作: 首先,确保已经安装了Burp Suite,并配置浏览器以使用Burp Suite作为代理。 配置代理:…...

Github的使用指南
首次创建仓库 1.官网创建仓库 打开giuhub官网,右上角点击你的头像,随后点击your repositories 点击New开始创建仓库 如下图为创建仓库的选项解释 出现如下界面就可以进行后续的git指令操作了 2.git上传项目 进入需上传项目的所在目录,打开…...

mongodb 添加加点 stateStr 停在 STARTUP
解决办法 PRIMARY 节点是的host 是否是内网IP,如果是内网IP 需要切换成外网IP 即可;...

c语言中编译过程与预处理
提示:文章写完后,目录可以自动生成,如何生成可参考右边的帮助文档 文章目录 前言一、c语言的编译与链接1、编译与链接概述2、编译与链接详解 二、c语言预处理1.c语言中内置的预定义符号2、#define定义标识符3、#define定义宏4、#define 替换规…...

TP-LINK 路由器设置内网穿透
TP-LINK 路由器设置内网穿透 开发中经常遇到调用第三方软件回调调试的情况,例如微信开发,支付回调等测试,用内网穿透是一种简单的方式也是偷懒的方式。 以TP-LINK路由器为例实现内网穿透 登录路由器 2.找到路由器虚拟服务器,添加…...
【决胜公务员考试】求职OMG——见面课测验1
2025最新版!!!6.8截至答题,大家注意呀! 博主码字不易点个关注吧,祝期末顺利~~ 1.单选题(2分) 下列说法错误的是:( B ) A.选调生属于公务员系统 B.公务员属于事业编 C.选调生有基层锻炼的要求 D…...

自然语言处理——Transformer
自然语言处理——Transformer 自注意力机制多头注意力机制Transformer 虽然循环神经网络可以对具有序列特性的数据非常有效,它能挖掘数据中的时序信息以及语义信息,但是它有一个很大的缺陷——很难并行化。 我们可以考虑用CNN来替代RNN,但是…...

分布式增量爬虫实现方案
之前我们在讨论的是分布式爬虫如何实现增量爬取。增量爬虫的目标是只爬取新产生或发生变化的页面,避免重复抓取,以节省资源和时间。 在分布式环境下,增量爬虫的实现需要考虑多个爬虫节点之间的协调和去重。 另一种思路:将增量判…...
#Uniapp篇:chrome调试unapp适配
chrome调试设备----使用Android模拟机开发调试移动端页面 Chrome://inspect/#devices MuMu模拟器Edge浏览器:Android原生APP嵌入的H5页面元素定位 chrome://inspect/#devices uniapp单位适配 根路径下 postcss.config.js 需要装这些插件 “postcss”: “^8.5.…...
【Go语言基础【12】】指针:声明、取地址、解引用
文章目录 零、概述:指针 vs. 引用(类比其他语言)一、指针基础概念二、指针声明与初始化三、指针操作符1. &:取地址(拿到内存地址)2. *:解引用(拿到值) 四、空指针&am…...

RabbitMQ入门4.1.0版本(基于java、SpringBoot操作)
RabbitMQ 一、RabbitMQ概述 RabbitMQ RabbitMQ最初由LShift和CohesiveFT于2007年开发,后来由Pivotal Software Inc.(现为VMware子公司)接管。RabbitMQ 是一个开源的消息代理和队列服务器,用 Erlang 语言编写。广泛应用于各种分布…...

力扣热题100 k个一组反转链表题解
题目: 代码: func reverseKGroup(head *ListNode, k int) *ListNode {cur : headfor i : 0; i < k; i {if cur nil {return head}cur cur.Next}newHead : reverse(head, cur)head.Next reverseKGroup(cur, k)return newHead }func reverse(start, end *ListNode) *ListN…...
多模态图像修复系统:基于深度学习的图片修复实现
多模态图像修复系统:基于深度学习的图片修复实现 1. 系统概述 本系统使用多模态大模型(Stable Diffusion Inpainting)实现图像修复功能,结合文本描述和图片输入,对指定区域进行内容修复。系统包含完整的数据处理、模型训练、推理部署流程。 import torch import numpy …...
MySQL 部分重点知识篇
一、数据库对象 1. 主键 定义 :主键是用于唯一标识表中每一行记录的字段或字段组合。它具有唯一性和非空性特点。 作用 :确保数据的完整性,便于数据的查询和管理。 示例 :在学生信息表中,学号可以作为主键ÿ…...

永磁同步电机无速度算法--基于卡尔曼滤波器的滑模观测器
一、原理介绍 传统滑模观测器采用如下结构: 传统SMO中LPF会带来相位延迟和幅值衰减,并且需要额外的相位补偿。 采用扩展卡尔曼滤波器代替常用低通滤波器(LPF),可以去除高次谐波,并且不用相位补偿就可以获得一个误差较小的转子位…...