删除架构迁移RubyonRailssqlite3-DeletedSchemaMigrationRubyonRailssqlite3

2  

Did you delete db\schema.rb or db\migrate files too?

您是否也删除了db \ schema.rb或db \ migrate文件?

In the first case you can try move db file to other location and execute:

在第一种情况下,您可以尝试将db文件移动到其他位置并执行:

rake db:migrate

If you removed schema.rb and migration files you can execute

如果删除了schema.rb和迁移文件,则可以执行

rails generate migration

and recreate migration manually.

并手动重新创建迁移。

1  

So long as you don't need to run rake db:migrate again you'll be fine. Otherwise you'll run into problems.

只要你不需要再运行rake db:migrate就可以了。否则你会遇到问题。

I probably should do this in Ruby, but i'm more familiar with Perl - so here's a quick script that'll help you resurect the schema_migrations table

我可能应该在Ruby中这样做,但我对Perl更熟悉 - 所以这里有一个快速的脚本,可以帮助你恢复schema_migrations表

!#/usr/bin/perl

opendir(DH, 'path/to/rails/app/db/migrate');

while($filename = readdir(DH))
{
    next unless $filename =~ /\.rb$/;
    @parts = split("_", $filename);
    print "INSERT INTO schema_migration VALUES (" . $parts[0] . ");\n";
}

running the script will give you a series of insert statements that'll then be able to copy and paste into the sqllite command line tool

运行该脚本将为您提供一系列插入语句,然后可以将这些语句复制并粘贴到sqllite命令行工具中

0  

or you can just kill the DB and restart

或者你可以杀死数据库并重新启动

rake db:drop; rake db:migrate; rake db:test:prepare