Should HDFStore.select respect local variable evaluation rules like query/eval?

[cpcloud]

example from #6901:

test.csv

title,hits
Al Lawson',30
'Blind' Willie McTell,20

df = pd.read_csv('test.csv', index_col=0)
store = pd.HDFStore('test.h5')
store.append('df', df)

should querying work the same as query/eval for select queries?

title = "Al Lawson'"
result = store.select('df', 'index == title')

or

result = store.select('df', 'index == @title')

the latter currently doesn't work

[jreback]

can u show what title is

[cpcloud]

done

[ariddell]

Thanks for your work on this. I realize querying strings isn't the most prominent use case.

I'll mention again that grabbing a variable from locals is something one almost never sees in Python (although it does occur in R a bit -- which might be something of a warning).

Here's a parallel case in the standard library in the sqlite API:

# Do this instead
t = ('RHAT',)
c.execute('SELECT * FROM stocks WHERE symbol=?', t)
print(c.fetchone())