当前位置：首页 > news >正文

【Django】如何转化已有的数据表到Django模型--20230823

news 2025/9/11 10:07:42

初步生成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…...

编程日记 2023/8/27 1:53:11

【C语言】喝汽水问题

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

编程日记 2023/8/27 1:52:10

项目进度管理（4-2）关键链法和关键路径法的区别和联系

1 关键链法和关键路径法的主要区别 1.1 关键链法和关键路径法的关注焦点不同关键路径法（CPM）：关注项目中最长的路径，也就是所需时间最长的路径，这被称为关键路径。关键路径决定了项目的最早完成时间。关键链法&…...

编程日记 2023/8/27 1:51:08

基于Java+SpringBoot+Vue前后端分离医院后台管理系统设计和实现

博主介绍：✌全网粉丝30W,csdn特邀作者、博客专家、CSDN新星计划导师、Java领域优质创作者,博客之星、掘金/华为云/阿里云/InfoQ等平台优质作者、专注于Java技术领域和毕业项目实战✌ 🍅文末获取源码联系🍅 👇🏻 精彩专…...

编程日记 2023/8/27 1:50:08

二维数组传参

在C语言中，可以通过指针来传递二维数组。二维数组实际上是一个连续的内存块，可以使用指针来表示二维数组的行和列。以下是一个示例： #include <stdio.h>void myFunction(int arr[][3], int rows) {for (int i 0; i < rows; i) {fo…...

编程日记 2023/8/27 1:49:07

AI 绘画Stable Diffusion 研究（十四）SD 图生图+剪映制作人物说话视频

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

编程日记 2023/8/27 1:48:05

ProPlot 基本语法及特点

文章目录简介多子图绘制处理共享轴标签“跨度”轴标签多子图序号的绘制更简单的颜色条和图例更加美观的颜色和字体简介科研论文配图多图层元素（字体、坐标轴、图例等）的绘制条件提出了更高要求，我们需要更改 Matplotlib 和 Seaborn 中的…...

编程日记 2023/8/27 1:47:04

element-template-admin get请求正常 post请求超市问题

最近搞全栈，想写个增删改查连接element-template-admin框架，postman测get和post请求都正常，到框架里直接超时，看网络请求一直是padding状态，后来经查阅资料，发现是这个template框架的问题解决方案&#x…...

编程日记 2023/8/27 1:46:02

Promise.all和promise.race的应用场景举例

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

编程日记 2023/8/27 1:45:00

go学习-指针标识符

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

编程日记 2023/8/27 1:43:58

LeetCode--HOT100题（42）

目录题目描述：108. 将有序数组转换为二叉搜索树（简单）题目接口解题思路代码 PS: 题目描述：108. 将有序数组转换为二叉搜索树（简单） 给你一个整数数组 nums ，其中元素已经按升序排列&#xf…...

编程日记 2023/8/27 1:42:54

leetcode-49.字母异位词分组-day20

...

编程日记 2023/8/27 1:41:53

YOLOv8教程系列：三、K折交叉验证——让你的每一份标注数据都物尽其用（yolov8目标检测+k折交叉验证法）

YOLOv8教程系列：三、K折交叉验证——让你的每一份标注数据都物尽其用（yolov8目标检测k折交叉验证法） 0.引言 k折交叉验证（K-Fold Cross-Validation）是一种在机器学习中常用的模型评估技术，用于估计模型的性…...

编程日记 2023/8/27 1:40:51

leetcode算法题--表示数值的字符串

原题链接：https://leetcode.cn/problems/biao-shi-shu-zhi-de-zi-fu-chuan-lcof/description/?envTypestudy-plan-v2&envIdcoding-interviews 题目类型有点新颖，有限状态机 // CharType表示当前字符的类型 // State表示当前所处的状态 type State…...

编程日记 2023/8/27 1:39:51

Docker安装及Docker构建简易版Hadoop生态

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

编程日记 2023/8/27 1:38:50

使用Burp Suite进行Web应用渗透测试

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

编程日记 2023/8/27 1:37:48

Github的使用指南

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

编程日记 2023/8/27 1:36:46

mongodb 添加加点 stateStr 停在 STARTUP

解决办法 PRIMARY 节点是的host 是否是内网IP，如果是内网IP 需要切换成外网IP 即可；...

编程日记 2023/8/27 1:35:46

c语言中编译过程与预处理

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

编程日记 2023/8/27 1:34:45

TP-LINK 路由器设置内网穿透

TP-LINK 路由器设置内网穿透开发中经常遇到调用第三方软件回调调试的情况，例如微信开发，支付回调等测试，用内网穿透是一种简单的方式也是偷懒的方式。以TP-LINK路由器为例实现内网穿透登录路由器 2.找到路由器虚拟服务器，添加…...

编程日记 2023/8/27 1:33:44

Android Wi-Fi 连接失败日志分析

1. Android wifi 关键日志总结 (1) Wi-Fi 断开 (CTRL-EVENT-DISCONNECTED reason3) 日志相关部分： 06-05 10:48:40.987 943 943 I wpa_supplicant: wlan0: CTRL-EVENT-DISCONNECTED bssid44:9b:c1:57:a8:90 reason3 locally_generated1解析： CTR…...

编程新知 2025/7/17 12:52:44

【Linux】shell脚本忽略错误继续执行

在 shell 脚本中，可以使用 set -e 命令来设置脚本在遇到错误时退出执行。如果你希望脚本忽略错误并继续执行，可以在脚本开头添加 set e 命令来取消该设置。举例1 #!/bin/bash# 取消 set -e 的设置 set e# 执行命令，并忽略错误 rm somefile…...

编程新知 2025/6/21 16:23:04

stm32G473的flash模式是单bank还是双bank？

今天突然有人stm32G473的flash模式是单bank还是双bank？由于时间太久，我真忘记了。搜搜发现，还真有人和我一样。见下面的链接：https://shequ.stmicroelectronics.cn/forum.php?modviewthread&tid644563 根据STM32G4系列参考手…...

编程新知 2025/9/2 16:59:45

如何在看板中有效管理突发紧急任务

在看板中有效管理突发紧急任务需要：设立专门的紧急任务通道、重新调整任务优先级、保持适度的WIP（Work-in-Progress）弹性、优化任务处理流程、提高团队应对突发情况的敏捷性。其中，设立专门的紧急任务通道尤为重要，这能…...

编程新知 2025/9/9 7:19:04

第一篇：Agent2Agent (A2A) 协议——协作式人工智能的黎明

AI 领域的快速发展正在催生一个新时代，智能代理（agents）不再是孤立的个体，而是能够像一个数字团队一样协作。然而，当前 AI 生态系统的碎片化阻碍了这一愿景的实现，导致了“AI 巴别塔问题”——不同代理之间…...

编程新知 2025/8/19 20:28:20

根据万维钢·精英日课6的内容，使用AI（2025）可以参考以下方法：

根据万维钢精英日课6的内容，使用AI（2025）可以参考以下方法： 四个洞见模型已经比人聪明：以ChatGPT o3为代表的AI非常强大，能运用高级理论解释道理、引用最新学术论文，生成对顶尖科学家都有用的…...

编程新知 2025/8/19 6:37:10

PAN/FPN

import torch import torch.nn as nn import torch.nn.functional as F import mathclass LowResQueryHighResKVAttention(nn.Module):"""方案 1: 低分辨率特征 (Query) 查询高分辨率特征 (Key, Value).输出分辨率与低分辨率输入相同。"""def __…...

编程新知 2025/7/6 7:40:12

Spring AI Chat Memory 实战指南：Local 与 JDBC 存储集成

一个面向 Java 开发者的 Sring-Ai 示例工程项目，该项目是一个 Spring AI 快速入门的样例工程项目，旨在通过一些小的案例展示 Spring AI 框架的核心功能和使用方法。项目采用模块化设计，每个模块都专注于特定的功能领域，便于学习和…...

编程新知 2025/7/28 10:33:30

Spring AOP代理对象生成原理

代理对象生成的关键类是【AnnotationAwareAspectJAutoProxyCreator】，这个类继承了【BeanPostProcessor】是一个后置处理器在bean对象生命周期中初始化时执行【org.springframework.beans.factory.config.BeanPostProcessor#postProcessAfterInitialization】方法时…...

编程新知 2025/9/7 8:44:55

【iOS】 Block再学习

iOS Block再学习文章目录 iOS Block再学习前言Block的三种类型__ NSGlobalBlock____ NSMallocBlock____ NSStackBlock__小结 Block底层分析Block的结构捕获自由变量捕获全局(静态)变量捕获静态变量__block修饰符forwarding指针 Block的copy时机block作为函数返回值将block赋给…...

编程新知 2025/9/9 10:03:35

初步生成model.py

修改部分信息

相关文章：