This bash script splits a dumpfile of one database into separate files for each table and names with csplit and names them accordingly: #!/bin/bash #### # Split MySQL dump SQL file into one file per table # based on https://gist.github.com/jasny/1608062 #### #adjust this to your case: START=”/– Table structure for table/” # or #START=”/DROP TABLE … Read more
In my opinion, it cannot be that hard. So let’s try it: 0. Imports You need to import three annotations: import org.junit.After; import org.junit.Before; import org.junit.Test;` After you’ve made the next few changes, you won’t need import junit.framework.TestCase;. 1. Annotate test* Methods All methods beginning with public void test must be preceded by the @Test … Read more
Execute: python manage.py dumpdata > datadump.json Next, change your settings.py to the mysql database. Finally: python manage.py loaddata datadump.json
The only tool that has incremental import seems to be git-cvsimport. If you want to convert (migrate) from CVS to Git, the best solution for now seems to be mentioned above cvs2git mode of cvs2svn. See also Interfaces Frontends And Tools page on Git wiki, section about interaction with other revision control systems.
You should be able to feed that dump file straight into psql: /path/to/psql -d database -U username -W < /the/path/to/sqlite-dumpfile.sql If you want the id column to “auto increment” then change its type from “int” to “serial” in the table creation line. PostgreSQL will then attach a sequence to that column so that INSERTs with … Read more
rake db:rollback STEP=1 Is a way to do this, if the migration you want to rollback is the last one applied. You can substitute 1 for however many migrations you want to go back. For example: rake db:rollback STEP=5 Will also rollback all the migration that happened later (4, 3, 2 and also 1). To … Read more
At the moment it is compiling bigger projects on Ubuntu 10.04. Here you can install and integrate it easily with the binutils-gold package (if you remove that package, you get your old ld). Gcc will automatically use gold then. Some experiences: gold doesn’t search in /usr/local/lib gold doesn’t assume libs like pthread or rt, had … Read more
Here’s how you should do it: change_column :users, :admin, :boolean, :default => false But some databases, like PostgreSQL, will not update the field for rows previously created, so make sure you update the field manaully on the migration too.
How to migrate using south. Lets say we got two apps: common and specific: myproject/ |– common | |– migrations | | |– 0001_initial.py | | `– 0002_create_cat.py | `– models.py `– specific |– migrations | |– 0001_initial.py | `– 0002_create_dog.py `– models.py Now we want to move model common.models.cat to specific app (precisely to … Read more
I’ve done something like this once. The main source of problems was that C++ is more strict about types, as you suspected. You’ll have to add casts where void* are mixed with pointers of other types. Like allocating memory: Foo *foo; foo = malloc(sizeof(*foo)); The above is typical C code, but it’ll need a cast … Read more