sql - How to get the exact matched record in rails 3? -


items in database:

 => [#<item id: 1, item_collection: [:laptop, :computer, :mouse, :speaker]>,       #<item id: 2, item_collection: [:laptopandkeyboard, :disk, :screen]>]

below query give me both records (which include laptop , laptopandkeyboard).

item.where("item_collection ?", "%laptop%")   => [#<item id: 1, item_collection: [:laptop, :computer, :mouse, :speaker]>,       #<item id: 2, item_collection: [:laptopandkeyboard, :disk, :screen]>]

but want record has laptop only.

#<item id: 1, item_collection: [:laptop, :computer, :mouse, :speaker]>

serialized arrays add \n @ end of each item, can try this:

item.where("item_collection ?", "%laptop\n%")

another option fetch data , filter select, this:

item.all.select { |item| item.item_collection.include?(:laptop) }

Comments

Post a Comment

Popular posts from this blog

html - How to custom Bootstrap grid height? -

why bootstrap grid has height 591.067 ? did height came ? .main-post { padding: 20px; background-color: #fff; border: 1px solid #d8d8d8; margin-bottom: 100px; } .main-post .post-categories { margin-bottom: 10px } .main-post h3 { margin: 0 0 10px; color: #777; letter-spacing: -1px; font-weight: bold } .main-post .post-author, .main-post .post-date, .main-post .post-comments { font-size: 12px } .main-post img { display: block; margin: 10px 0; } .main-post .post-summary { line-height: 1.7; color: #888 } .main-post { color: #999 } <div class="col-sm-6"> <div class="main-post"> <h3 class="post-title"> <a href="#"> post title </a> </...
Read more

javascript - pass values from mssql to views in node -

being new node js , javascript . have been trying find solution problem . this app.js file var express=require ('express'); var bodyparser = require('body-parser'); var path = require ('path'); var sql = require('mssql'); var app = express(); const config = { user: 'sa', password: 'password', server: 'localhost\\sqlexpress', // can use 'localhost\\instance' connect named instance database: 'pcgdb', options: { encrypt: false // use if you're on windows azure } }; const request = new sql.request() //view engine app.set('view engine', 'ejs'); app.set('views', path.join(__dirname, 'views')) app.use(bodyparser.json()); app.use(bodyparser.urlencoded({extended: false})); app.get('/',function(req,res){ res.render('index') }); app.get('/new_project', function(req, res) { function(data,err){ ...
Read more

python - Getting 405 error while trying to download nltk data -

when try below code python -c "import nltk; nltk.download('punkt'); nltk.download('averaged_perceptron_tagger'); nltk.download('maxent_treebank_pos_tagger'); nltk.download('wordnet')" the console says [nltk_data] error loading punkt: http error 405: not allowed. [nltk_data] error loading averaged_perceptron_tagger: http error 405: [nltk_data] not allowed. [nltk_data] error loading maxent_treebank_pos_tagger: http error 405: [nltk_data] not allowed. [nltk_data] error loading wordnet: http error 405: not allowed. this caused down-age of github raw file link. meanwhile stop-gap solution manually download file: path_to_nltk_data=/home/username/nltk_data/ wget https://github.com/nltk/nltk_data/archive/gh-pages.zip unzip gh-pages.zip mv nltk_data-gh-pages/ $path_to_nltk_data we're working on finding alternative data , model downloading. meanwhile, @everyone please check script(s) , make sure you're not...
Read more