def __loader_maker__(self, fields, name, delimiter='\\t'):
builder = MutableString()
builder += 'LOAD TABLE #{0} (\n'.format(name)
builder += string.join([' {0:<32}'.format(aux.name) for aux in fields], '\'{0}\',\n'.format(delimiter)) + '\'\\x0d\\x0a\'\n'
builder += ') FROM \'{{file}}\'\n'
builder += 'ESCAPES OFF QUOTES OFF';
return builder.__str__()
def __table_maker__(self, fields, name):
builder = MutableString()
builder = 'CREATE TABLE #{0} (\n'.format(name)
builder += string.join([' {0:<32} : {1}'.format(aux.name, self.get_type(aux)) for aux in fields], ',\n')
builder += ');\n'
builder += 'COMMIT;'
return builder.__str__()
