如何使用简单的Ruby脚本将数据库表导出为CSV

If you have a Rails project and want to export a table as a CSV, without having to go to all the trouble of finding a gem, installing and using it, then uninstalling it when it’s no longer needed, I have some good news. Here’s an easy and quick way to export a particular table from your database as a CSV file.

如果您有一个Rails项目，并且希望将表导出为CSV，而不必费心查找宝石，安装和使用它，然后在不再需要它时将其卸载，那么我有一些好消息。 这是一种从数据库中将特定表导出为CSV文件的简便快捷的方法。

This is the code that you need to run. You can put it as a rake task and run it, or run it another way.

这是您需要运行的代码 。 您可以将其作为rake任务运行并以其他方式运行。

As you can see, first we import CSV— we need it to do the writing of the CSV file with the data from the database. We then choose the location and the name for the file that we want to export it to, which in our case will be a file called data.csv included under repository public.

如您所见，首先我们导入CSV我们需要它来使用数据库中的数据编写CSV文件。 然后，我们选择要将其导出到的文件的位置和名称，在本例中将是存储库public下包含的名为data.csv的文件。

Then we set the table that we want to export and start writing. We could also change the attributes that we want to export — we don’t have to include them all as they are in the database.

然后，我们设置要导出的表并开始写入。 我们还可以更改要导出的属性-我们不必像在数据库中一样将它们全部包括在内。

That’s it! It’s that simple and yet very helpful.

而已！ 就是这么简单，但非常有帮助。

This article was originally published on Medium

本文最初发表于Medium

翻译自: https://www.freecodecamp.org/news/export-a-database-table-to-csv-using-a-simple-ruby-script-2/