So i have a large table that i don't want to add another column too. So i
made a has_one relationship to another table to hold some interesting info
about some of the things in the main table.
I have a vehicle table that has_one used_vehicle_attribute
(used_vehicle_attributes table).
indexes on used_vehicle.rb, which is an sti model of vehicle table
has_one :used_vehicle_attribute, :foreign_key => :vehicle_id
### Validations
#validates_presence_of :buyer_id, :message => "No buyer ID."
define_index "used_vehicle" do
indexes make_name
indexes model_name
indexes type
indexes dealership.zip_code.state_abbr
has mileage
has dealership.stars , :as => :stars
has dealership_id
has year
has sticker_price, :type => :float
has used_vehicle_attribute.trim_description_id, :as =>
:trim_description_id
has 'RADIANS(zip_codes.latitude)', :as => :latitude, :type =>
:float
has 'RADIANS(zip_codes.longitude)', :as => :longitude, :type =>
:float
set_property :latitude_attr => "latitude"
set_property :longitude_attr => "longitude"
end
The trim_description_id is present in the join created in
development.sphinx.conf on a rebuild. used_vehicle_attributes is left
outer joined with vehicles using vehicle_id so that all works fine.
A group by trim_description_id sort of works though the counts and things
seem to be off, but it seems to recognize this attribute.
What doesn't work is this:
UsedVehicle.search("Accord",:with => {:trim_description_id =>
10998189385240095927},:per_page => 500)
That is a singular trim_description_id that is in the
used_vehicle_attributes table and shows up when i do this:
UsedVehicle.search("Accord",:per_page => 500)
The column trim_description_id is an big unsigned int.
mysql> desc used_vehicle_attributes;
+---------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+---------------------+---------------------+------+-----+---------+----------------+
| id | bigint(20) unsigned | NO | PRI | NULL |
auto_increment |
| vehicle_id | bigint(20) | YES | MUL | NULL |
|
| trim_description_id | bigint(20) unsigned | YES | | NULL |
|
| created_at | datetime | NO | | NULL |
|
| updated_at | datetime | NO | | NULL |
|
I even tried adding a column that had some text in it and making an index
definition for that thinking maybe i couldn't have an attribute without an
index, but that still didn't work.
Here are my attributes in my development.sphinx.conf file
sql_range_step = 16777216
sql_attr_uint = sphinx_deleted
sql_attr_uint = class_crc
sql_attr_uint = mileage
sql_attr_uint = year
sql_attr_bigint = sphinx_internal_id
sql_attr_bigint = dealership_id
sql_attr_bigint = trim_description_id
sql_attr_float = stars
sql_attr_float = sticker_price
sql_attr_float = latitude
sql_attr_float = longitude
sql_query_info = SELECT * FROM `vehicles` WHERE `id` = (($id - 9) / 12)
thanks.
Erik
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/thinking-sphinx/-/9RgFoQYNLdsJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en.
