django-admin.py dumpdata to SQL statements

Question

I'm trying to dump my data to SQL statements. the django-admin.py dumpdata provides only json,xml,yaml. so:

does someone know a good way to do it?!

I tried that:

def sqldumper(model):

result = ""
units = model.objects.all().values()
for unit in units:
    statement = "INSERT INTO myapp.model "+str(tuple(unit.keys())).replace("'", "")+" VALUES " + str(tuple(unit.values()))+"\r\n"
    result+=statement
return result

so I'm going over the model values myself, and make the INSERT statement myself. then I thought of using "django-admin.py sql" to get the "CREATE" statement.. but then I don't know how to use this line from inside my code (and not through the command-line). I tried os.popen and os.system, but it doesn't really work.. any tips about that?

I'll put it clearly: how do you use the "manage.py sql " from inside your code?

I add something like this to my view:

import os, sys
import imp
from django.core.management import execute_manager

sys_argv_backup = sys.argv
imp.find_module("settings")
import settings
sys.argv = ['','sql','myapp']
execute_manager(settings)
sys.argv = sys_argv_backup

the thing is - it works.. but it writes the statements to the stdout... it's something, but not perfect. I'll try using django.core.management.sql.sql_create directly, we'll see how it goes..

thanks

Don · Accepted Answer · 2011-05-04 10:05:59Z

3

I suggest to use SQL-specific dump program (e.g. mysqldump for MySQL).

For sqlite embedded in Python, you can look this example not involving Django:

# Convert file existing_db.db to SQL dump file dump.sql
import sqlite3, os

con = sqlite3.connect('existing_db.db')
with open('dump.sql', 'w') as f:
    for line in con.iterdump():
        f.write('%s\n' % line)

edited May 4, 2011 at 10:05

answered May 4, 2011 at 9:25

Don

17.7k13 gold badges67 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

nivniv Over a year ago

I thought about it, but let's say I'm using the ordinary sqlite3 that you get from django. I know it's easy on MySQL, but how do you do it on sqlite?

nivniv Over a year ago

I added some "steps" I made to the question above, it's not perfect, but it's something to make me closer to the goal.. thanks though Don

Collectives™ on Stack Overflow

django-admin.py dumpdata to SQL statements

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related