======================== unified (from filesystem) ========================
                                         'bitrate'  '148.889'
                                        'duration'  '214'
                                          'artist'  'The Smashing Pumpkins'
                                     'text_people'  'Billy Corgan'
                                         'release'  'Adore'
                                           'title'  'Appels + Oranjes'
                                           'quals'  ("['Q-HAP-2', 'Q-UNU-1', 'Q-HHRNBTT-1', 'Q-JZFKS-1', 'Q-LOCALNESS-1', "
 "'Q-OLDST-3', 'q-syn-2', 'q-bass-3', 'q-busy-3', 'q-grit-3', 'q-play-2', "
 "'q-chart-4', 'q-drums-4', 'q-other-2', 'q-piano-1', 'q-vocals-1', "
 "'q-mixbeat-1']")
                                      'lastfmtags'  "['alternative rock', '90s', 'alternative', 'grunge', 'rock']"
                                     'discogstags'  "['rock', 'alternative rock']"
                             'musicbrainz_albumid'  ''
                       'musicbrainz_albumartistid'  ''
                            'musicbrainz_artistid'  ''
                             'musicbrainz_trackid'  ''
                                     'tracknumber'  '8'
                                      'tracktotal'  '16'
                                            'date'  '1998'
                                        'comments'  ''
                                           'genre'  'rock-gr-grunge'
                                             'bpm'  '113'
                                             'key'  '8A'
                                        'acoustid'  '1584daed-ad06-450b-8f89-f60e03859857'
rest: ''

======================== rawer (from filesystem) ========================

'APIC:'                                             type PictureType.COVER_FRONT (Cover (front)) b''
                                     
'COMM:CDDB Disc ID:XXX'                             'EF121E10'
'TALB' (Album/Movie/Show title)                     'Adore'
'TBPM' (BPM (beats per minute))                     '113'
'TCOM' (Composer)                                   'Billy Corgan'
'TCON' (Content type, a.k.a. Genre)                 'rock-gr-grunge'
'TDOR' (Original release time)                      '1998'
'TDRC' (Recording time)                             '1998-05-29'
'TEXT' (Lyricist/Text writer)                       'Billy Corgan'
'TIPL' (Involved people list)                       TIPL(encoding=<Encoding.UTF16: 1>, people=[['producer', 'Billy Corgan'], ['producer', 'Flood'], ['producer', 'Brad Wood']])
'TIT2' (Title/songname/content description)         'Appels + Oranjes'
'TKEY' (Initial key)                                '8A'
'TMED' (Media type)                                 'CD'
'TPE1' (Lead performer(s)/Soloist(s))               'The Smashing Pumpkins'
'TPE2' (Band/orchestra/accompaniment)               'The Smashing Pumpkins'
'TPOS' (Part of a set)                              '1/1'
'TPUB' (Publisher)                                  'Virgin/Hut Recordings'
'TRCK' (Track number/Position in set)               '8/16'
'TSO2'                                              'Smashing Pumpkins, The'
'TSOC'                                              'Corgan, Billy'
'TSOP' (Performer sort order)                       'Smashing Pumpkins, The'
'TSRC' (ISRC (international standard recording code))  'USVI29800020'
'TSSE' (Software/Hardware and settings used for encoding)  'Audiograbber 1.80, LAME dll 3.92, VBR 3, Stereo, High quality'
'TXXX:ASIN'                                         'B000006NPY'
'TXXX:Acoustid Id'                                  '1584daed-ad06-450b-8f89-f60e03859857'
'TXXX:Artists'                                      'The Smashing Pumpkins'
'TXXX:BARCODE'                                      '724384587925'
'TXXX:CATALOGNUMBER'                                '7243 8 45879 2 5/CDHUT 51'
'TXXX:MusicBrainz Album Artist Id'                  'ba0d6274-db14-4ef5-b28d-657ebde1a396'
'TXXX:MusicBrainz Album Id'                         'dbb0bd27-50d3-4c5a-bfba-989a5926d944'
'TXXX:MusicBrainz Album Release Country'            'XE'
'TXXX:MusicBrainz Album Status'                     'official'
'TXXX:MusicBrainz Album Type'                       'album'
'TXXX:MusicBrainz Artist Id'                        'ba0d6274-db14-4ef5-b28d-657ebde1a396'
'TXXX:MusicBrainz Release Group Id'                 '359699b3-8118-369e-9591-c96dcd07a853'
'TXXX:MusicBrainz Release Track Id'                 '55bfb353-55fd-3514-9c1a-0cd0d151b71e'
'TXXX:Q-HAP'                                        '2'
'TXXX:Q-HHRNBTT'                                    '1'
'TXXX:Q-JZFKS'                                      '1'
'TXXX:Q-LOCALNESS'                                  '1'
'TXXX:Q-OLDST'                                      '3'
'TXXX:Q-UNU'                                        '1'
'TXXX:SCRIPT'                                       'Latn'
'TXXX:discogstags'                                  ['rock', 'alternative rock']
'TXXX:lastfmtags'                                   ['alternative rock', '90s', 'alternative', 'grunge', 'rock']
'TXXX:mood'                                         'Electronic/Not party/Not acoustic/Not aggressive/Not sad/Relaxed/Not happy'
'TXXX:originalyear'                                 '1998'
'TXXX:q-bass'                                       '3'
'TXXX:q-busy'                                       '3'
'TXXX:q-chart'                                      '4'
'TXXX:q-drums'                                      '4'
'TXXX:q-grit'                                       '3'
'TXXX:q-mixbeat'                                    '1'
'TXXX:q-other'                                      '2'
'TXXX:q-piano'                                      '1'
'TXXX:q-play'                                       '2'
'TXXX:q-syn'                                        '2'
'TXXX:q-vocals'                                     '1'
'TXXX:replaygain_track_gain'                        '-1.89 dB'
'TXXX:replaygain_track_peak'                        '0.565409'
'UFID:http://musicbrainz.org'                       UFID(owner='http://musicbrainz.org', data=b'82190b06-c56a-493e-aa63-482564a51e8f')

========================== row from database ==========================
                                              'id'  1319318
                                            'path'  /data/Music/Bulk/00poprockelectronic/Smashing Pumpkins/Adore/Apples + Oranges.mp3
                                         'working'  None
                                         'bitrate'  148
                                    'duration_sec'  214
                                           'genre'  rock-gr-grunge
                                        'filesize'  4046604
                                           'mtime'  1636903062
                                   'redo_metaread'  0
                                        'rest_str'   00poprockelectronic Apples Oranges rock gr grunge
                                      'tag_artist'  The Smashing Pumpkins
                                     'tag_release'  Adore
                                       'tag_title'  Appels + Oranjes
                                             'bpm'  113.0
                                    'search_title'  'appels':1 'oranjes':2
                                   'search_artist'  'pumpkins':3 'smashing':2 'the':1
                                  'search_release'  'adore':1
                                     'search_rest'  '00poprockelectronic':1 'apples':2 'gr':5 'grunge':6 'oranges':3 'rock':4
                                    'search_combo'  '00poprockelectronic':7 'adore':6C 'appels':1A 'apples':8 'gr':11 'grunge':12 'oranges':9 'oranjes':2A 'pumpkins':5B 'rock':10 'smashing':4B 'the':3B
                                    'tag_tracknum'  8
                                      'num_images'  1
                                             'key'  8A
                                           'quals'  ['Q-HHRNBTT-1', 'q-vocals-1', 'Q-LOCALNESS-1', 'q-piano-1', 'q-mixbeat-1', 'q-play-2', 'Q-OLDST-3', 'Q-UNU-1', 'Q-JZFKS-1', 'q-busy-3', 'q-drums-4', 'q-syn-2', 'q-chart-4', 'q-other-2', 'Q-HAP-2', 'q-bass-3', 'q-grit-3']
                                      'lastfmtags'  ['alternative rock', '90s', 'alternative', 'grunge', 'rock']
                                        'tag_date'  1998
                                     'discogstags'  ['rock', 'alternative rock']

============================== file details ==============================
                                           'mtime'  1636903061.9070702  (2021-11-14 16:17:41)
                             'size'  4046604