#!/usr/bin/python
# vim: set fileencoding=utf-8 ts=4 shiftwidth=4 softtabstop=4 expandtab:
# Copyright (c) 2010 kinote@kinote.org

import sys
import datetime


def int_to_datetime(i):
    # FIXME do correctly the conversion of date types
    return datetime.now()

conversion = [
    [('phpbb_users', 'auth_user'), (
        ('user_id', 'id'),
        ('username', 'username'),
        ('user_email', 'email'),
        ('user_password', 'password'),
        ('user_active', 'is_active'),
        ('user_lastvisit', 'last_login', int_to_datetime),
        ('user_regdate', 'date_joined', int_to_datetime),
    )],
    [('phpbb_users', 'usuarios_userprofile'), (
        ('user_id', 'id'),
        ('user_id', 'user_id'),
        ('user_viewemail', 'show_email'),
        ('user_website', 'url'),
        ('user_msnm', 'msn_id'),
    )],
]


def migrate(c):
    print "== %s -> %s" % c[0]
    for fields in c[1]:
        if len(fields) == 3:
            print "   %s -> %s() -> %s" % (fields[0], fields[2].__name__, fields[1])
        else:
            print "   %s -> %s" % (fields[0], fields[1])

def main(argv=None):
    if argv is None:
        argv = sys.argv
    for c in conversion:
        migrate(c)
    return 0
    

if __name__ == '__main__':
    sys.exit(main())