diff options
| author | Uwe Klotz <uklotz@mixxx.org> | 2020-06-09 11:44:01 +0200 |
|---|---|---|
| committer | Uwe Klotz <uklotz@mixxx.org> | 2020-06-09 14:02:13 +0200 |
| commit | 099ccd8df2488de1545fb284107a67fca5b6f1ce (patch) | |
| tree | 0474e2b8379515a8c9e1e67d7c91b698c2fcde48 | |
| parent | bf5e5a2892e0f00556b81b5f4edc41d3157148ac (diff) | |
Split database variable bindings into separate rows
| -rw-r--r-- | src/library/dao/trackdao.cpp | 108 |
1 files changed, 88 insertions, 20 deletions
diff --git a/src/library/dao/trackdao.cpp b/src/library/dao/trackdao.cpp index 27f9813ff3..8fc25d14fa 100644 --- a/src/library/dao/trackdao.cpp +++ b/src/library/dao/trackdao.cpp @@ -356,28 +356,96 @@ void TrackDAO::addTracksPrepare() { m_pQueryLibraryInsert->prepare( "INSERT INTO library " "(" - "artist,title,album,album_artist,year,genre," - "tracknumber,tracktotal,composer,grouping," - "filetype,location,color,comment,url,rating,key,key_id," - "cuepoint,bpm,replaygain,replaygain_peak,wavesummaryhex," - "timesplayed,played,mixxx_deleted,header_parsed," - "channels,samplerate,bitrate,duration," - "beats_version,beats_sub_version,beats,bpm_lock," - "keys_version,keys_sub_version,keys," - "coverart_source,coverart_type,coverart_location," - "coverart_color,coverart_digest,coverart_hash," + "artist," + "title," + "album," + "album_artist," + "year," + "genre," + "tracknumber," + "tracktotal," + "composer," + "grouping," + "filetype," + "location," + "color," + "comment," + "url," + "rating," + "key," + "key_id," + "cuepoint," + "bpm," + "replaygain," + "replaygain_peak," + "wavesummaryhex," + "timesplayed," + "played," + "mixxx_deleted," + "header_parsed," + "channels," + "samplerate," + "bitrate," + "duration," + "beats_version," + "beats_sub_version," + "beats," + "bpm_lock," + "keys_version," + "keys_sub_version," + "keys," + "coverart_source," + "coverart_type," + "coverart_location," + "coverart_color," + "coverart_digest," + "coverart_hash," "datetime_added" ") VALUES (" - ":artist,:title,:album,:album_artist,:year,:genre," - ":tracknumber,:tracktotal,:composer,:grouping," - ":filetype,:location,:color,:comment,:url,:rating,:key,:key_id," - ":cuepoint,:bpm,:replaygain,:replaygain_peak,:wavesummaryhex," - ":timesplayed,:played,:mixxx_deleted,:header_parsed," - ":channels,:samplerate,:bitrate,:duration," - ":beats_version,:beats_sub_version,:beats,:bpm_lock," - ":keys_version,:keys_sub_version,:keys," - ":coverart_source,:coverart_type,:coverart_location," - ":coverart_color,:coverart_digest,:coverart_hash," + ":artist," + ":title," + ":album," + ":album_artist," + ":year," + ":genre," + ":tracknumber," + ":tracktotal," + ":composer," + ":grouping," + ":filetype," + ":location," + ":color," + ":comment," + ":url," + ":rating," + ":key," + ":key_id," + ":cuepoint," + ":bpm," + ":replaygain," + ":replaygain_peak," + ":wavesummaryhex," + ":timesplayed," + ":played," + ":mixxx_deleted," + ":header_parsed," + ":channels," + ":samplerate," + ":bitrate," + ":duration," + ":beats_version," + ":beats_sub_version," + ":beats," + ":bpm_lock," + ":keys_version," + ":keys_sub_version," + ":keys," + ":coverart_source," + ":coverart_type," + ":coverart_location," + ":coverart_color," + ":coverart_digest," + ":coverart_hash," ":datetime_added" ")"); |