import spectrum database

#!/usr/bin/env python
# import spectrum database

import os

# Defining Django env settings
from django.core.management import setup_environ; import settings; setup_environ(settings)

from devices.models import Devices

FILES_PATH='/home/mauro/spectrum/files/'

# devices model access
dev = Devices.objects

for _file_ in os.listdir(FILES_PATH):
    with open(os.path.join(FILES_PATH, _file_)) as fp:
        linhas = [reg.split(',') for reg in fp.readlines()[1:]]
        for reg in linhas:
            _device_ = Device(hostname=reg[0],
                                           designacao=reg[1],
                                           ip_wan=reg[2],
                                           ip_lan=reg[3],
                                           mascara_lan=reg[4],
                                           comunity=reg[5],
                                           cidade=reg[6],
                                           dial_backup=reg[7])
            _device_.save()