Shulou(Shulou.com)06/02 Report--

This article introduces the relevant knowledge of "how to customize the primary key of Django model". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Recently, I am working on a new project. The data engineer has created some new tables in the database, and the data tables have been filled with data, but I need to use these data tables in my project written in django. I used django's ORM in my development, so I need to create a model model, but some data tables already exist, and the primary key of some tables is not the id field. Django defaults to the model add id field. And set it as the primary key and let it increment itself. So I started by changing the table structure of the existing data table, adding the id field, and assigning a value to id to set the primary key to id. Later, because the primary key of the data table changed, there were some problems with the previously written script to crawl data, and there was a lot of duplicate data in the data table. Finally, the deduplication is done through the sql statement.

Delete from video_data where id not in (select temp.min_id from (select min (id) min_id from video_data group by aweme_id) as temp

Back to the title, I later searched the django model custom primary key on Bing and referred to the official documentation of django to find a solution. If you want to customize the primary key of the specified model, you can set the parameter primary_key=True on the field that you want to set as the primary key.

For example:

Aweme_id = models.BigIntegerField (verbose_name= "works id", db_index=True, primary_key=True)

In this way, the primary key of the model is changed to the aweme_id field.

This is the end of the content of "how to customize the Django model to specify the primary key". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.