# -*- coding: utf-8 -*-
##----------------------------------------------------------------------
## geodecode
##----------------------------------------------------------------------
## Copyright (C) 2007-2014 The NOC Project
## See LICENSE for details
##----------------------------------------------------------------------

# Python modules
import re
import requests
# NOC modules
from noc.sa.models import *
from noc.inv.models import *
from noc.inv.models.object import *
from noc.lib.nosql import get_db

rx_city = re.compile(
        r"^(г\.|пгт\.|пос\.|с\.)+(?P<city>(\S+ \S+ \S+|\S+ \S+|\S+))")
rx_street = re.compile(
        r"^ ул\.+(?P<street>(\S+ \S+ \S+|\S+ \S+|\S+))")
rx_house = re.compile(
        r"^ д\.+(?P<house>(\d+\S+|\d+))")

rx_room = re.compile(
        r"^ п\.+(?P<room>(\d+\S+|\d+))")

db = get_db()
om = db.noc.objectmodels

K = 0
k = 0

for mo in tuple(ManagedObject.objects.filter(
    administrative_domain=1)):
    mo_id = mo.id
    name = mo.name
    postaddress = mo.postaddress.encode("UTF-8")
#
#    print ""
#    print postaddress
#
    postaddress = postaddress.split(',')
    match = rx_city.search(postaddress[0])
    if match:
        city = match.group("city")
#
#
    else:
        continue
    try:
        match = rx_street.search(postaddress[1])
    except IndexError:
        continue
    if match:
        street = match.group("street")
    else:
        continue
    try:
        match = rx_house.search(postaddress[2])
    except IndexError:
        continue
    if match:
        house = match.group("house")
    else:
        continue
    try:
        match = rx_room.search(postaddress[3])
    except IndexError:
        continue
    if match:
        room = match.group("room")
    else:
        continue

    pop =  'г.'.decode('UTF-8') + (city).decode('UTF-8') + ' | ' + 'ул.'.decode('UTF-8') + (street).decode('UTF-8') + ', д.'.decode('UTF-8') + (house).decode('UTF-8')
    room = pop + ' | ' + "Подъезд №".decode('UTF-8') + room
    rack = room + ' | ' + "Ящик №1".decode('UTF-8')

    K += 1
    if city:
#

#        try:
            print rack
            url="http://geocode-maps.yandex.ru/1.x/?geocode=" + city + ",+" + street.replace(' ', '+') + ",+дом+" + house +"&format=json"
            urlopen = requests.get(url)
            obj = urlopen.json()
            coord = obj["response"]["GeoObjectCollection"]["featureMember"][0]["GeoObject"]["Point"]["pos"].split(' ')
            x = coord[0]
            y = coord[1]
            print str(y), str(x)

            if not Object.objects.filter(name = pop):
                Object(
                    name = pop,
                    model = om.find_one({"name": "PoP | Access"})["_id"],
                    data = {"container": {"container": True},
                        "geopoint": {
                            "x": x,
                            "y": y},
                        "pop": {"level": 20}
                        }
                ).save()
                print pop

            if not Object.objects.filter(name = room):
                Object(
                    name = room,
                    model = om.find_one({"name": "Room"})["_id"],
                    data = {"container": {"container": True}}
                ).save()
                print room

            if not Object.objects.filter(name = rack):
                Object(
                    name = rack,
                    model = om.find_one({"name": 'NoName | Rack | 19" 42U 1000mm Shelf'})["_id"],
                    data = {"container": {"container": True}}
                ).save()
                print rack

            # Уложить mo в Rack

            k += 1
            print "\n\n"
            break
#        except:
#            break
#            continue

print K, k