agrosner / agrosner/DBFlow

SQL query is not created properly if foreignKey is reference to a table with multiple primaryKey

Offen
#1,739 3 Kommentare 0 Reaktionen 0 zugewiesene Personen Auf GitHub ansehen
Vorherrschende Sprache
Kotlin
Sterne
4.8k
Forks
593
Ø Merge
1 Min.
Gemergte PRs (30 T.)
1

Beschreibung

Wrong SQL query is generated when parent table having more than one primary key is referenced through foreign key in the child table

DBFlow Version: 4.2.4

Bug or Feature Request:
Fix the logic for creating SQL query when Parent table with more than 1 primary key is referenced through foreignKey in the child table

Description:

When a child table reference a parent table (having more than one primaryKey) through Foreign Key, the SQL query generated for the child table is wrong

Here is the example of the query generated for UPDATE operation.

@Override
public final String getUpdateStatementQuery() {
 return "UPDATE `ContactPhoneMapping` SET `contact_primaryId`=?,`contact_secondaryId`=?,`phoneNo`=?,`type`=? WHERE `contact_primaryId`=?,`contact_secondaryId`=? AND `phoneNo`=?";
}


Notice that "AND" is missing in the where condition for "contact_primaryId" and "contact_secondaryId"

Beitragsleitfaden

Für dieses Repository ist kein Beitragsleitfaden indexiert

Bewertung

Dieses Issue wurde noch nicht bewertet.

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.