Try a rake task. For example: Create the file /lib/tasks/bootstrap.rake In the file, add a task to create your default user: namespace :bootstrap do desc “Add the default user” task :default_user => :environment do User.create( :name => ‘default’, :password => ‘password’ ) end desc “Create the default comment” task :default_comment => :environment do Comment.create( :title … Read more
[Edit: The original reply below is from pre SVN 1.7, and there this was the best way to solve the problem (although it is not the primary use case of svnsync). In SVN 1.7 client or later there is the svnrdump tool that does more directly what you are trying to achieve)] use svnsync to … Read more
It’s funny though, MongoDB was born to respond to the schema problems in RDBMS. You don’t have to migrate anything, all you have to do is set the default value in the schema definition if the field is required. new Schema({ name: { type: string } }) to: new Schema({ name: { type: string }, … Read more
The create table as feature in PostgreSQL may now be the answer the OP was looking for. https://www.postgresql.org/docs/9.5/static/sql-createtableas.html create table my_table_copy as select * from my_table This will create an identical table with the data. Adding with no data will copy the schema without the data. create table my_table_copy as select * from my_table with … Read more
Update: See @GwynBleidD’s comment below for the problems this solution can cause, and see @Rockallite’s answer below for an approach that’s more durable to future model changes. Assuming you have a fixture file in <yourapp>/fixtures/initial_data.json Create your empty migration: In Django 1.7: python manage.py makemigrations –empty <yourapp> In Django 1.8+, you can provide a name: … Read more
You can use both YEAR(timestamp) and WEEK(timestamp), and use both of the these expressions in the SELECT and the GROUP BY clause. Not overly elegant, but functional… And of course you can combine these two date parts in a single expression as well, i.e. something like SELECT CONCAT(YEAR(timestamp), “https://stackoverflow.com/”, WEEK(timestamp)), etc… FROM … WHERE .. … Read more
Following the Jenkins wiki, you’ll have to: Install a fresh Jenkins instance on the new server Be sure the old and the new Jenkins instances are stopped Archive all the content of the JENKINS_HOME of the old Jenkins instance Extract the archive into the new JENKINS_HOME directory Do not forget to change the owner of … Read more
First, create a dump on server A. A$ redis-cli 127.0.0.1:6379> CONFIG GET dir 1) “dir” 2) “/var/lib/redis/” 127.0.0.1:6379> SAVE OK This ensures dump.rdb is completely up-to-date, and shows us where it is stored (/var/lib/redis/dump.rdb in this case). dump.rdb is also periodically written to disk automatically. Next, copy it to server B: A$ scp /var/lib/redis/dump.rdb myuser@B:/tmp/dump.rdb … Read more
You will need to post the table definitions for the source and destination tables for us to figure out where the issue is but the bottom line is that one of your columns in the source table is bigger than your destination columns. It could be that you are changing formats in a way you … Read more
In SSMS in the Object Explorer, right click on the database, right-click and pick “Tasks” and then “Generate Scripts”. This will allow you to generate scripts for a single or all tables, and one of the options is “Script Data”. If you set that to TRUE, the wizard will generate a script with INSERT INTO … Read more