database-migrations
Here are 213 public repositories matching this topic...
I still cannot really find neither here nor in the docs how to set up a "many to many" relationship with a pivot table. From de docs:
public function up()
{
$table = $this->table('tags');
$table->addColumn('tag_name', 'string')
->save();
$refTable = $this->table('tag_relationships');
$refTable->addColumn('tag_id', 'integer', ['null' =
I have previously run rails g migration AddMissingIndexes
I wanted to run it again but there is a name clash with the previous migration. Would be helpful it it automatically added a number to the name or something or had an options to manually change the name
#26 showed that there might be a situation when all tests pass, the response is expected, but it was not explicitly covered with @api.response() decorator. I think we will need to override Api.output from flask_restplus/api.py (note, there is already customization on Api class in flask_restplus_patched, so you can just add this patch there), so we can check what responses are defined on th
Add more tests
While working on wrapper to invoke the command from nodejs, I've found that it would be more flexible to specify the database url via a command line argument rather than having dbmate read it from a .env file. This allows the app and testing environment to provide the database url after loading it however it wants.
[Package] Multi-tenant Database Schema Manager for Laravel
-
Updated
Jan 14, 2020 - PHP
Powerful SQL migration toolkit for Rust.
-
Updated
Jan 19, 2020 - Rust
Describe the bug
Currently the options are not mentioned in the docs but shown in the CLI.
See https://github.com/seppevs/migrate-mongo/blob/master/bin/migrate-mongo.js#L45
To Reproduce
Run migrate-mongo --help
Usage: migrate-mongo [options] [command]
Options:
-V, --version output the version number
-h, --help output usagLightweight script to compare two database
-
Updated
Jan 17, 2020 - PHP
Log error misleading
The logs are constantly telling me the source is consistent, the show_status command that they are inconsistent:
In pg_lib.py,
check_source_consistent method currently reads:
(pseudo code):
if source_consistent:
if source_consistent[0]:
(update t_replica_tables ...)
log(consistent)
else:
log(inconsistent)
else:
log(consistent)
Line 3306 o
Sorry to hammer you with change requests :P. I just thought that allowing recursion in migration directories would make a practical implementation of different migration environments easier. For example:
db/
├── backups/
├── init.sql
└── migrations
├── schema/
│ ├── 1485643154-create_my_cool_table.sql
│ ├── 1485648520-create_other_cool_table.sql
│ └── 148564860
The case "up should deprecate object models of previous versions" fails to throw SQLException as expected.
The problem is caused by Slick 3.1.0 and SQLite. See more in: slick/slick#1402
A client defined a schema as CUBE and REF.
In schemacrawler, this comes back as "CUBE" or "REF", which our code isn't handling (note
SchemaCrawler.java:426 and SchemaRetriever:181)
A Migration Code Generator for Phinx
-
Updated
Jan 15, 2020 - PHP
See: https://github.com/amberframework/micrate/blob/master/src/micrate/cli.cr#L65
This'd look better with HEREDOC syntax:
puts <<-MESSAGE
Micrate will not run these migrations because they may have been written with an older database model in mind.
You should probably check if they need to be updated and rename them so they are considered a newer version.
MESSAGE
end
deDocumentation
Hey. I'm looking for a lightweight database migration tool and found this project through the Slick documentation. It seems to be up-to-date and the example looks intriguing. I was wondering if it is a good fit for my project and started reading the source code. That helped my understanding a bit, but the "big picture" is still quite blurry.
I'd like to read some high-level documentation, like
From @dmromanov on May 13, 2018 18:0
- CakePHP Version: 3.6.2
- Migrations plugin version: 1.8.1
- Bake plugin version: 1.7.3
- Database server (MySQL, SQLite, Postgres): MySQL 5.7, 8.0
- PHP Version: PHP 7.2.3
- Platform / OS: Ubuntu 18.04
We have the following DB.
CREATE TABLE `test` (
`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
`iso6392` char(2) NOT NULL COMMENT 'CPython ETL(Extract-Transform-Load) tool / Data migration tool
-
Updated
Nov 18, 2019 - Python
A Stack Overflow-inspired PostgreSQL migration library with strict ordering and immutable migrations
-
Updated
Jan 10, 2020 - TypeScript
Developer tool helps to sync migrations without refreshing the database
-
Updated
Nov 30, 2019 - PHP
Golang Database Management and Code Generation
-
Updated
Jan 9, 2020 - Go
Database Migration tool for PHP
-
Updated
Nov 14, 2019 - PHP
Simple library writen in PHP without framework dependancy for database version control. Supports Sqlite, MySql, Sql Server and Postgres
-
Updated
Jan 17, 2020 - PHP
These are specific to Flyway Pro and Enterprise but should be trivial to add.
See
- https://flywaydb.org/documentation/gradle/undo
- https://flywaydb.org/documentation/gradle/migrate#undoSqlMigrationPrefix
- https://flywaydb.org/documentation/gradle/migrate#errorHandlers
- https://flywaydb.org/documentation/gradle/migrate#dryRunOutput
It would be great to get this in before 5.0.0 goes fi
Addon bundle for Dropwizard to support Flyway for database migrations
-
Updated
Jan 7, 2020 - Java
Improve this page
Add a description, image, and links to the database-migrations topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the database-migrations topic, visit your repo's landing page and select "manage topics."
Which version and edition of Flyway are you using?
v6.0.7
Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin)
Command-line
Which database are you using (type & version)?
MSSQL 14.0.x
Which operating system are you using?
Win10 x64
What did you do?
Just doing meat-and-potatoes migration.
What did y