【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.找到路由器虚拟服务器,添加…...

基于uniapp+WebSocket实现聊天对话、消息监听、消息推送、聊天室等功能,多端兼容
基于 UniApp + WebSocket实现多端兼容的实时通讯系统,涵盖WebSocket连接建立、消息收发机制、多端兼容性配置、消息实时监听等功能,适配微信小程序、H5、Android、iOS等终端 目录 技术选型分析WebSocket协议优势UniApp跨平台特性WebSocket 基础实现连接管理消息收发连接…...

ESP32读取DHT11温湿度数据
芯片:ESP32 环境:Arduino 一、安装DHT11传感器库 红框的库,别安装错了 二、代码 注意,DATA口要连接在D15上 #include "DHT.h" // 包含DHT库#define DHTPIN 15 // 定义DHT11数据引脚连接到ESP32的GPIO15 #define D…...

屋顶变身“发电站” ,中天合创屋面分布式光伏发电项目顺利并网!
5月28日,中天合创屋面分布式光伏发电项目顺利并网发电,该项目位于内蒙古自治区鄂尔多斯市乌审旗,项目利用中天合创聚乙烯、聚丙烯仓库屋面作为场地建设光伏电站,总装机容量为9.96MWp。 项目投运后,每年可节约标煤3670…...
【Go语言基础【12】】指针:声明、取地址、解引用
文章目录 零、概述:指针 vs. 引用(类比其他语言)一、指针基础概念二、指针声明与初始化三、指针操作符1. &:取地址(拿到内存地址)2. *:解引用(拿到值) 四、空指针&am…...

vulnyx Blogger writeup
信息收集 arp-scan nmap 获取userFlag 上web看看 一个默认的页面,gobuster扫一下目录 可以看到扫出的目录中得到了一个有价值的目录/wordpress,说明目标所使用的cms是wordpress,访问http://192.168.43.213/wordpress/然后查看源码能看到 这…...
腾讯云V3签名
想要接入腾讯云的Api,必然先按其文档计算出所要求的签名。 之前也调用过腾讯云的接口,但总是卡在签名这一步,最后放弃选择SDK,这次终于自己代码实现。 可能腾讯云翻新了接口文档,现在阅读起来,清晰了很多&…...
GitHub 趋势日报 (2025年06月06日)
📊 由 TrendForge 系统生成 | 🌐 https://trendforge.devlive.org/ 🌐 本日报中的项目描述已自动翻译为中文 📈 今日获星趋势图 今日获星趋势图 590 cognee 551 onlook 399 project-based-learning 348 build-your-own-x 320 ne…...
Python+ZeroMQ实战:智能车辆状态监控与模拟模式自动切换
目录 关键点 技术实现1 技术实现2 摘要: 本文将介绍如何利用Python和ZeroMQ消息队列构建一个智能车辆状态监控系统。系统能够根据时间策略自动切换驾驶模式(自动驾驶、人工驾驶、远程驾驶、主动安全),并通过实时消息推送更新车…...

Unity UGUI Button事件流程
场景结构 测试代码 public class TestBtn : MonoBehaviour {void Start(){var btn GetComponent<Button>();btn.onClick.AddListener(OnClick);}private void OnClick(){Debug.Log("666");}}当添加事件时 // 实例化一个ButtonClickedEvent的事件 [Formerl…...

Ubuntu Cursor升级成v1.0
0. 当前版本低 使用当前 Cursor v0.50时 GitHub Copilot Chat 打不开,快捷键也不好用,当看到 Cursor 升级后,还是蛮高兴的 1. 下载 Cursor 下载地址:https://www.cursor.com/cn/downloads 点击下载 Linux (x64) ,…...