For quite sometime, I haven't tried executing SQLs manually in Rails. But, try as I may not to create a specific model for this scenario, I just couldn't.
So, in the meantime that I had to do the manual insert, I encountered a problem with strings with single quotes. Particularly those names that have O', etc.
This gives you an error in SQL insert.
name = "O'Neil"
ActiveRecord::Base.connection.execute("INSERT INTO names (name) values ('" + name + "')")
This one will do the trick:
name = "O'Neil"
ActiveRecord::Base.connection.execute("INSERT INTO names (name) values ('" + ActiveRecord::Base.connection.quote(name) + "')")
Anyhow, to avoid more troubles, just create a model. It does many other tasks for you like this automatic escaping of single quotes, etc.
Author
Maricris Nonato
I turn tech ideas into websites using Ruby. I'm a budding Buddhist practitioner, passionate about health & fitness, a certified yoga teacher, and a cat fanatic!
Recent posts
Tags
- cats
- yoga
- blood pressure
- elecom
- scrum
- coderkitty
- RailsGirls
- workstation
- creativity
- live book signing
- healthy living
- lowering blood pressure
- crafting
- movies
- reviews
- new year
- blessings
- faith
- quotes to live by
- travelers notebook
- Bujo
- planners
- Monday Motivation
- himalayan salt lamp
- productivity
- life tips
- happiness
- success
- ruby
- digital ocean
- regex
- programming
- humor
- music
- pyromusical
- sphinx
- mac
- games
- musings
- yogi
- namaste
- photography
- hobby
- slimming
- sendmail
- lifestyle
- memes
- open letter
- sports
- shooting
- events
- meetups
- tech talks
- rails
- datatables
- sorting
- cycling
- COVID-19
- wishlist
- xmas
- tradition
- song lyrics
- life lessons
- poems
- short story
- food
- living life
- nginx
- technology
- youtube
- my Nyey
- meditation
- new normal
- jump rope
- two-wheel journey
- planner girl
- rubyist
- culture
- Filipino
- mental health
- counseling
- self-care
Advertise
Newsletter
Instagram Feed
Links
I'm sharing with you P150 gift from GoFutureFresh! Click here to accept my gift.