I had an data import task for django application. Client moved data
from several databses into new one. All legacy databases had same
model, so there was proper django model created for them. And I had
problem with importing data from all those legacy system. I've sniffed
a bit and on the base of django code created something like this:
#Script for switching connections between databases
import django
import types
import MySQLdb as Database
from django.db.backends import util
from MySQLdb.constants import FIELD_TYPE
from MySQLdb.converters import conversions
django_conversions = conversions.copy()
django_conversions.update({
types.BooleanType: util.rev_typecast_boolean,
FIELD_TYPE.DATETIME: util.typecast_timestamp,
FIELD_TYPE.DATE: util.typecast_date,
FIELD_TYPE.TIME: util.typecast_time,
})
def switch(_conf):
instance = django.db.connection
try:
instance.connection.close()
except AttributeError:
pass
instance.connection = None
def cursor():
if not instance._valid_connection():
kwargs = {
'user': _conf['DATABASE_USER'],
'db': _conf['DATABASE_NAME'],
'passwd': _conf['DATABASE_PASSWORD'],
'conv': django_conversions,
}
if _conf['DATABASE_HOST'].startswith('/'):
kwargs['unix_socket'] = _conf['DATABASE_HOST']
else:
kwargs['host'] = _conf['DATABASE_HOST']
if _conf['DATABASE_PORT']:
kwargs['port'] = int(_conf['DATABASE_PORT'])
if hasattr(instance, 'options'):
kwargs.update(instance.options)
instance.connection = Database.connect(**kwargs)
cursor = instance.connection.cursor()
if instance.connection.get_server_info() >= '4.1':
cursor.execute("SET NAMES 'utf8'")
# if settings.DEBUG:
# return util.CursorDebugWrapper(MysqlDebugWrapper(cursor),
instance)
return cursor
instance.cursor = cursor
return
Function takes as argument hash with connection params.
Regards
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
