data-migrator sample 1

data-migrator-example1.py

from data_migrator import models, transform
from data_migrator.emitters import MySQLEmitter

def parse_b(v):
  if v == 'B':
    return 'transformed_B'
  else:
    return v.lower()

class Result(models.Model):
  id   = models.IntField(pos=0) # keep id
  uuid = models.UUIDField()     # generate new uuid4 field
  # replace NULLs and trim
  a    = models.StringField(pos=1, default='NO_NULL', max_length=5, nullable='NULL', replacement=lambda x:x.upper())
  # parse this field
  b    = models.StringField(pos=2, parse=parse_b, name='my_b')

  class Meta:
    table_name = 'new_table_name'

# django-esc like creating and saving of records (to a manager)
Result(a='my a', b='my b').objects.save()

if __name__ == "__main__":
  transform.Transformer(models=[Result], emitter=MySQLEmitter).process()