rom icon indicating copy to clipboard operation
rom copied to clipboard

query filter doesn't work, like at all

Open Goury opened this issue 4 years ago • 2 comments

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?

Goury avatar Jan 11 '21 03:01 Goury

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.
  1. 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()
  1. I need to fix rom.util.refresh_all_indexes()

josiahcarlson avatar Jan 11 '21 23:01 josiahcarlson

Check rom 1.0.2

josiahcarlson avatar Jan 12 '21 00:01 josiahcarlson