query to get fakes from a subtraction

fake_query.py

import cx_Oracle

username = 'your_username'
password = 'your_password'
dsn = 'leovip148.ncsa.uiuc.edu/destest'
db = cx_Oracle.connect(username, password, dsn)
cursor = db.cursor()

cursor.execute('begin fixSynonyms(\'\',\'SNY1REPROC\'); end;')  # this points you to the right
                                                                 # tablespace

sub_name = 'SNp1_259300_SN-E2_combined_g_08+fakeSN_diff_mh.fits' # for the sake of example

query = 'SELECT DISTINCT SNFAKE_ID FROM SNOBS ' \
        'WHERE IMAGE_NAME_DIFF = :sub_name AND SNFAKE_ID != 0'
    
cursor.execute(query, sub_name=sub_name)
result = cursor.fetchall()

fake_query.result

[(247023,), (247024,), (247022,), (247021,), (216601,), (216753,)]

sncand_query.py

import cx_Oracle
 
username = 'your_username'
password = 'your_password'
dsn = 'leovip148.ncsa.uiuc.edu/destest'
db = cx_Oracle.connect(username, password, dsn)
cursor = db.cursor()
 
cursor.execute('begin fixSynonyms(\'\',\'SNY1REPROC\'); end;')  # this points you to the right
                                                                 # tablespace
 
sub_name = 'SNp1_259300_SN-E2_combined_g_08+fakeSN_diff_mh.fits' # for the sake of example
 
query = 'SELECT DISTINCT c.ID FROM (SNOBS o JOIN SNFAKE f on o.SNFAKE_ID = f.ID) '\
        'JOIN SNCAND c ON (f.ra > c.ra - :tol AND f.ra < c.ra + :tol and f.dec > '\
        'c.dec - :tol and f.dec < c.dec + :tol) WHERE o.IMAGE_NAME_DIFF = :sub_name AND o.SNFAKE_ID != 0'
    
cursor.execute(query, sub_name=sub_name, tol=0.0001)
result = cursor.fetchall()

sncand_query.results

[(1059883,), (1060191,), (1059887,), (1059889,), (1059884,), (1060190,)]