In this question, e4c5 suggests updating tables in the legacy database with a single primary key to work with Django. However, every table referencing the updated table will be using the composite primary key as reference and will therefore not work in Django. Is there a way to either update the tables so they would use the new primary key, or a workaround for this?
Working with composite primary key and foreign keys in django project with legacy database
179 Views Asked by Kasper Skjeggestad At
1
There are 1 best solutions below
Related Questions in DJANGO
- Django Admin Panel and Sub URLs Returning 404 Error on Deployment
- How to return HTTP Get request response from models class in Django project
- Issue with Quantity Increment in Django E-commerce Cart
- Can't install Pipenv on Windows
- use dict from python in django html template and also in js
- 'pyodbc.Cursor' object has no attribute 'callproc', mssql with django
- Django socketio process
- Root path analogue in uWSGI as in Uvicorn
- Django - ModuleNotFoundError: No module named 'backend'
- Does Python being a loosely typed programming language make it less secure?
- sorl-thumbnail adds a background color when padding is used
- Can't connect to local postgresql server from my docker container
- Why ProductHunt api dont work with Python?
- why i have to put extra space in before write option selected because it show error if i don't ' option:selected'
- Django Arrayfield migration to cloud sql (Postgresql) not creating the column
Related Questions in FOREIGN-KEYS
- Visual Studio scaffolded Create form does not work in ASP.NET Core 8 MVC
- Claves combinadas
- The specified data type in the EF modelBuilder doesn't correspond to the one that is created
- Sequelize foreign key vs SQL how to implement it
- Laravel Relationship Using An OR Condition on the joining field
- Displaying country and capital names instead of IDs on Laravel order page
- Creating a chat table in database from 2 separated tables
- Efficiently read Firestore's document reference field contents
- Unable to insert FK value to a table
- Moodle Database - Reverse Engineering ERD
- Gorm Foreign Keys
- How to eager load both forward and backward relationships in SQLAchemy one-to-many relation
- I'm getting incorrect values when counting annotations
- Unable to Edit Record with Foreign Key Relationship in ASP.NET Core MVC with Entity Framework
- Updating ordinal numbers for child records in MySQL table
Related Questions in COMPOSITE-PRIMARY-KEY
- Entity Framework Core: how to get table B which references with table A with 2 composite keys
- @IdClass with @Inheritance(strategy = InheritanceType.SINGLE_TABLE)
- How to update a part of primary key if it is a combination of three columns
- One to many relationship with a composite key table
- Create Key using two columns and do a left join SQL
- Selecting the right keys for a DDB table
- How can I use composite primary keys in django?
- Making (3) composite primary key less redundant
- Extract symbols from an Array that has been converted to a String?
- How to auto increment one column of a postgres composite primary key?
- Alembic - composite primary key results in incorrect table definition for MySQL
- ManyToMany relationship to self with composite key with Spring-Repository
- Unexpected outcome of the "before insert" triger with subquery and EXISTS predicate along with further PK violation
- Laravel Migration: Second foreign key not created as secondary key in phpMyAdmin
- Unable to Create a Primary Key Foreign Key Relationship with Composite Primary Key in TypeORM
Related Questions in LEGACY-DATABASE
- Trying to identify the spec/format for datafiles with these markers
- MySQL query error when using NOT EXISTS()
- Django how to add a model instance with a foreign key field if the referenced model instance does not exist
- Legacy VB app with no source code accesses MSSQL with 'sa' and a 6-digit password. Work around for password policy?
- Rewrite legacy php-native code to Laravel with no downtime
- Count Group By and Separate If Included in Both Group
- postgreSQL 8.4.20: How to solve missing oldestXID in pg_control preventing use of pg_upgrade on a legacy CentOS 6.4 server?
- mysql/mariadb strict_trans_table mode. Log before enabling
- Connect django to legacy postgresql database, already exist and have 1 table
- How to access a legacy database without creating a new table in it in Django
- Django content type table data migration while upgrading from 1.6 to 2.2 with legacy database
- Django running migrations on legacy database
- Migrate to LINQ To SQL or Entity Framework
- django rest framework apis using legacy db without creating django default tables
- Working with composite primary key and foreign keys in django project with legacy database
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
I make a virtual primary key field implementation, that represents composite key as a single json value, that tricks Django, and allows to access to legacy db without table altering - https://viewflow.medium.com/the-django-compositeforeignkey-field-get-access-to-a-legacy-database-without-altering-db-tables-74abc9868026