import MySQLdb
d = MySQLdb.connect('localhost', 'root', '', 'junk')
c = d.cursor()
#c.execute('set names utf8');
c.execute ('select * from users')
results = c.fetchall()
c.execute('use ghestalt')
for r in results:
    print r
    name = r[5].tostring()
    names = name.split(' ', 1)
    if len(names) == 1: names.append('')
    
    c.execute('insert into auth_user (username, first_name, last_name, password, is_active, last_login, date_joined) values (%s, %s, %s, %s, 1, %s, %s)',
	      (r[0], names[0], names[1], 'sha1$' + r[1] + '$' + r[2], r[6], r[6]))
    c.execute('select id from auth_user where username = %s', r[0])
    uid, = c.fetchone()
    c.execute("insert into app_userprofile (first_name, last_name, user_id, role, create_date) values (%s, %s, %s, 'User', %s)",
    	      (names[0], names[1], uid, r[6]))