python怎样进行主键合并_python-如何在Django中为我的模型设置两个主键字段

如果您应该在旧版数据库上使用django，则无法修改db_schema

有一种解决方法(丑陋的)方法可以解决此问题

覆盖模型的保存或删除功能

# use raw sql statement to save or delete object

class BaseModel(models.Model):

def get_max_length_unique_key(self):

max_len_unique_key = []

for unique_key in self._meta.unique_together:

if len(unique_key) > len(max_len_unique_key):

max_len_unique_key = unique_key

return max_len_unique_key

def get_db_conn(self):

db_cnn = DbManage(db_ip, db_port, DATABASES_USER, DATABASES_PASSWORD, self._meta.db_table)

db_cnn.connect()

return db_cnn

def save(self, *args, **kwargs):

self.delete()

cnn, databasename = self.get_db_conn()

update_tables = self._meta.db_table

key_list = ""

values_list = ""

for field in self._meta.fields:

key_list += "%s," % field.name

values_list += "\'%s\'," % str(getattr(self, field.name))

key_list = key_list[:len(key_list) - 1]

values_list = values_list[:len(values_list) - 1]

sql = "insert into %s(%s) values(%s)" % (update_tables, key_list, values_list)

logger.info("insert new record to %s" % databasename)

cnn.excute_sql(sql)

cnn.close()

def delete(self, *args, **kwargs):

cnn = self.get_db_conn()

update_tables = self._meta.db_table

sql = "delete from %s where " % update_tables

for uk in self.get_max_length_unique_key():

sql += "%s=\'%s\' and " % (uk, getattr(self, uk))

sql = sql[:len(sql) - 4]

logger.info("delete record from %s" % update_tables)

cnn.excute_sql(sql)

cnn.close()

pass

class Meta:

abstract = True

class ImageList(BaseModel):

field1 = models.CharField(primary_key=True, max_length=30)

field2 = models.CharField(primary_key=True, max_length=30)

field3 = models.CharField(primary_key=True, max_length=30)

body = models.CharField(max_length=2000, blank=True, null=True)

updated_on = models.DateTimeField(blank=True, null=True)

class Meta:

managed = True

db_table = 'image_list'

unique_together = (('field1', 'field2', 'field3'),)