与Laravel持续集成与开发
问题描述:
我是Laravel的新手,目前正在致力于我的第一个项目。我曾与CI合作过,但从未与Laravel合作过。所以,这是我的Dev服务器的部署脚本。不知道这是否是最好的方法。无论如何,迁移部分给我一个错误。之后,我得到这个工作,我会尝试一些PHP插件来分析代码的质量,复制,单元测试等与Laravel持续集成与开发
请参见下面
脚本:
rsync -a . /var/www/html/dev/
cd /var/www/html/dev/
# cfg file for dev
cp .env.dev .env
# run composer
composer clearcache
composer install --optimize-autoloader
# optimize
php artisan cache:clear
php artisan optimize
php artisan route:cache | true
# migrate DB
php artisan migrate
错误:
[Illuminate\Database\QueryException]
SQLSTATE[42S01]: Base table or view already exists:
我是否应该在迁移之前删除所有表格?如果是这样,我不知道使用它们进行自动部署有什么用处。此外,我们的表格中充满了测试数据(手动填充,因为我们不想自动播种)。
答
在运行迁移之前,不应删除所有表。
此错误来自您的migrations
表和您的migrations
在database\migrations
文件夹有冲突。
在返回以继续配置Jenkins之前,您应该解决此冲突。
我的建议:
您应该使用Rocketeer为控制您的项目发布版本。
您可以通过shared
文件夹共享您的.env
文件。
你可以运行composer install
和npm install
默认配置为火箭手。
这是我的步骤安装和配置火箭人:
安装火箭人:
$ wget http://rocketeer.autopergamene.eu/versions/rocketeer.phar
$ chmod +x rocketeer.phar
$ mv rocketeer.phar /usr/local/bin/rocketeer
//TODO Install PHP for Jenkins server
$ sudo apt-get install php
//TODO Check rocketeer
$ rocketeer check
No connections have been set, please create one: (production) <~ Succeed
安装远程服务器的信息
$ cd /var/lib/jenkins/drone-deploy/drone-deploy/server-dev
$ rocketeer ignite
No connections have been set, please create one: (production)develop
No host is set for [develop], please provide one:35.166.x.x
No username is set for [develop], please provide one:ec2-user
No password or SSH key is set for [develop], which would you use? (key) [key/password]key
Please enter the full path to your key (/var/lib/jenkins/.ssh/id_rs/var/lib/jenkins/.ssh/xxx.pem
If a keyphrase is required, provide it
No repository is set for [repository], please provide one:[email protected]:xx/xxxxxx.git
No username is set for [repository], please provide one:xxx
No password is set for [repository], please provide one:
develop/0 | Ignite (Creates Rocketeer's configuration)
What is your application's name ? (drone-php)drone_deploy
The Rocketeer configuration was created at server-dev/.rocketeer
配置
$ cd /var/lib/jenkins/drone-deploy/drone-deploy/drone-php
$ nano .rocketeer/config.php
Replace connections name production --> develop //It's Rocketeer bug
$ nano .rocketeer/remote.php
'root_directory' => '/var/www/html/',
'shared' => [
'storage/logs',
'storage/framework/sessions',
'.env',
],
'permissions' => [
// The folders and files to set as web writable
'files' => [
//'app/database/production.sqlite',
'bootstrap',
'storage',
'public',
],
// Here you can configure what actions will be executed to set
// permissions on the folder above. The Closure can return
// a single command as a string or an array of commands
'callback' => function ($task, $file) {
return [
sprintf('chmod -R 777 %s', $file),
sprintf('chmod -R g+s %s', $file),
sprintf('chown -R ec2-user:ec2-user %s', $file),
];
},
],
$ nano .rocketeer/strategies.php
//'test' => 'Phpunit',
'test' => '',
//return $composer->install([], ['--no-interaction' => null, '--no-dev' => null, '--prefer-dist' => null]);
return $composer->install([]);
运行TE ST
rocketeer deploy --on="develop" --tests
如果迁移失败,然后尝试重新迁移数据库时,通常只得到这个消息。 –
@RossWilson,你似乎是对的。那么,当某些迁移失败以避免这种情况时,如何继续? –
您通常会在本地/ dev环境中遇到这些错误,并在问题进入生产之前解决问题。当它发生在您的开发环境中时,您可以手动删除所有表或者只检查不存在于您的迁移表中的表,然后简单地删除该表,然后回滚并迁移。 –