rom
rom copied to clipboard
query filter doesn't work, like at all
class Log(rom.Model):
user_id = rom.Integer(default=-1, index=True)
dnt = rom.Boolean(default=False)
session_id = rom.String(default='', index=True, keygen=rom.CASE_INSENSITIVE)
ip_address = rom.String(default='', index=True, keygen=rom.CASE_INSENSITIVE)
host = rom.Text(default='')
path = rom.Text(default='', index=True, keygen=rom.SIMPLE)
query_string = rom.Text(default='', index=True, keygen=rom.CASE_INSENSITIVE)
method = rom.String(default='', index=True, keygen=rom.SIMPLE)
payload = rom.Text(default='', index=True, keygen=rom.CASE_INSENSITIVE)
user_agent = rom.Text(default='', index=True, keygen=rom.CASE_INSENSITIVE)
status_code = rom.Integer(default=-1, index=True)
referrer = rom.Text(default='', index=True, keygen=rom.SIMPLE)
timestamp = rom.DateTime(default=datetime.now, index=True)
In: len( Log.query.filter(path='/').all() )
Out: 0
in: len( [log for Log.query.all() if log.path='/'] )
Out: 26847
Tried rom 0.40.1, 0.42.0, 0.42.6, 1.0.0, 1.0.1 Results are the same.
Why?
Changelog:
#----------------------------------- 1.0.0 -----------------------------------
[WARNING] data indexed in this version is NO LONGER COMPATIBLE with data indexed
in versions < 1.0.0, THIS VERSION WILL AUTOMATICALLY CONVERT YOUR INDEXES on
save, and older clients saving may not update indexes properly.
- What's in your Redis? Do you see index keys? Model keys? If you have model keys at least, you can always rebuild via:
# import all your models
rom.util.refresh_all_indexes()
- I need to fix
rom.util.refresh_all_indexes()
Check rom 1.0.2