python - 如何使用现有的 SQL Server 数据库

Question

我以程序员的身份开始我的实践，但我有一个问题，那就是在我所在的公司，他们给了我一个包含 60,000 个数据的测试数据库，我阅读了说明如何获取表格的文档，我可以做到，但是在获得它们的那一刻，这些表的外键中带有整数数据，有没有办法使用 Django ORM 来使用这些表，这是我的模型：

from django.db import models


class TipoNovedad(models.Model):
    id_tnov = models.AutoField(db_column='Id_TNov', primary_key=True)  # Field name made lowercase.
    nom_nov = models.CharField(db_column='Nom_Nov', max_length=100)  # Field name made lowercase.
    desc_nov = models.CharField(db_column='Desc_Nov', max_length=250)  # Field name made lowercase.
    manejo_tiempo = models.CharField(db_column='Manejo_Tiempo', max_length=20)  # Field name made lowercase.
    dias = models.CharField(db_column='Dias', max_length=20, blank=True, null=True)  # Field name made lowercase.
    estado = models.BooleanField(db_column='Estado')  # Field name made lowercase.

    class Meta:
        db_table = 'Tipo_Novedad'


class Novedades(models.Model):
    id_nov = models.AutoField(db_column='Id_Nov', primary_key=True)  # Field name made lowercase.
    # is in the foreign key of the novelty model
    id_tnov = models.IntegerField(db_column='Id_TNov')  # Field name made lowercase.
    n_identificacion = models.CharField(db_column='N_Identificacion', max_length=20)  # Field name made lowercase.
    fec_registro = models.DateTimeField(db_column='Fec_Registro')  # Field name made lowercase.
    fec_inicio = models.DateField(db_column='Fec_Inicio', blank=True, null=True)  # Field name made lowercase.
    fec_fin = models.DateField(db_column='Fec_Fin', blank=True, null=True)  # Field name made lowercase.
    fec_nov = models.DateField(db_column='Fec_Nov', blank=True, null=True)  # Field name made lowercase.
    hora_inicio = models.CharField(db_column='Hora_Inicio', max_length=5, blank=True, null=True)  # Field name made lowercase.
    hora_fin = models.CharField(db_column='Hora_Fin', max_length=5, blank=True, null=True)  # Field name made lowercase.
    report_tm = models.BooleanField(db_column='Report_TM')  # Field name made lowercase.
    id_usuario_creacion = models.IntegerField(db_column='Id_Usuario_Creacion')  # Field name made lowercase.
    id_usuario_ultimaactualizacion = models.IntegerField(db_column='Id_Usuario_UltimaActualizacion')  # Field name made lowercase.
    id_sedenov = models.IntegerField(db_column='Id_SedeNov', blank=True, null=True)  # Field name made lowercase.
    id_estadonov = models.IntegerField(db_column='Id_EstadoNov')  # Field name made lowercase.
    observacion = models.TextField(db_column='Observacion', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        db_table = 'Novedades'

标签： pythonsql-serverdjango