I found the rails console and learned that you can do blackmagic such as: DB.exec(<<~SQL) UPDATE topics SET title = 'psql redo!' WHERE id = 886 SQL How do I find out what commands/functions can be executed in the console? How do I learn more about this wizardry? Note: if not already obvious…

You really need to learn about rails and not directly modify that database. What I did was find a rails book and read it. And at some point I also looked at a Ruby book. I’m old enough to remember when books were the only way to learn about computers. As I understand it, there are many sites on the …

Rails console speaks ruby. As Discourse is open source, you can learn low level programming it by reading the source code in GitHub.

t=Topic.find(123) t.title=‘my new title’ t.save or t.update(title: ‘my new title’) Thanks. One thing I couldn’t figue out was how to assign a value with a value pulled from somewhere e.g. t.update(title: topic2.find(123).title)

You could do something like: t = Topic.find(123) t.update(title: Topic.find(124).title) But that’s more trouble than it’s worth. You can do things in steps: t1 = Topic.find(123) t2 = Topic.find(124) t1.update(title: t2.title)

[图片] Jay Pfaffman: What I did was find a rails book and read it. Me too: About this Book :: Why's (Poignant) Guide to Ruby

[图片] simon: t1 = Topic.find(123) Although this could easily cause an exception (which you are advised to rescue), so you might want to use find_by as an alternative which will return nil rather than raising an exception, depending on how you want to manage things.

Man. I always thought RoR was a relic from the noughties, I never imagined finding myself learning this! :slight_smile:

Sql is a relic from the 1960s. :winking_face_with_tongue:

I’m actually using AI to write SQL queries. It can do it way faster than me!

Rails 控制台命令

开发

simon 2024 年3 月 24 日 09:14 5

您可以这样做：

t = Topic.find(123)
t.update(title: Topic.find(124).title)

但这比它本身更麻烦。您可以分步进行：

t1 = Topic.find(123)
t2 = Topic.find(124)
t1.update(title: t2.title)

话题		回复	浏览量
Ruby on rails console command Development rails-console	1	1112	2020 年5 月 5 日
Running raw SQL in rails console Development	2	3081	2019 年3 月 19 日
Adding bulk categories Support	5	1003	2020 年8 月 26 日
Writing directly to the database Development	17	663	2024 年3 月 24 日
Setting a category to use the solved plugin via console Development	3	1079	2019 年1 月 31 日

Rails 控制台命令

相关话题