$OCSSWROOT/bin/seadasutils/ancDB.py

[oo_processing]

Dear Support,

The function delete_record doesn't work as expected, probably because it's not extensively tested.
The current V2024.0, from line 134

Code: Select all

        
        else:
            satid = self.check_file(filename, starttime=starttime)
            ancids = conn.execute('select ancid from satancinfo where satid = ?', [satid])
            for a in ancids:
                c.execute('DELETE from satancinfo where ancid = ?', [a[0]])
                c.execute('DELETE from ancfiles where ancid = ?', [a[0]])

Using ancid as key to delete records in tables satancinfo and ancfiles would delete records needed by other satid. Therefore my suggestion is

Code: Select all

        else:
            satid = self.check_file(filename, starttime=starttime)
            c.execute('DELETE from satancinfo where satid = ?', [satid])
            c.execute('DELETE from satfiles where satid = ?', [satid])

Thanks,
Yuyuan

[OB SeaDAS - xuanyang02]

Thanks, Yuyuan for your suggestion! We'll test your code and adopt it accordingly.

[oo_processing]

Excited to see the new code implemented in tag V2025.1

Cheers!
Yuyuan