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)

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

[image] 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 console commands

Development

pfaffman (Jay Pfaffman) March 25, 2024, 1:19pm 14

There are many examples in the data explorer plugin and category.

Topic		Replies	Views
Ruby on rails console command Development rails-console	1	1112	May 5, 2020
Running raw SQL in rails console Development	2	3081	March 19, 2019
Adding bulk categories Support	5	1003	August 26, 2020
Writing directly to the database Development	17	663	March 24, 2024
Setting a category to use the solved plugin via console Development	3	1079	January 31, 2019

Rails console commands

Related topics