print datetime.datetime.now().strftime('[%Y-%m-%d][%H:%M:%S]') + "Started"
import sys, os
from pgget import Connection
from kurum import Kurum
from excel_format.cv import CografiVeriFormu
from excel_format.dicts import *
from excel_format.mv import MetaveriFormu
from excel_format.dyag import DonanimYazilimFormu
from excel_format.ob import OrganizasyonBirimiFormu
from excel_format.ma import MevzuatAnalizFormu
from excel_format.sp import ServisPaylasimFormu
user_input = 0
# create connection
cnn = Connection()
kurumListe = cnn.getlistofdata('kurum','objectid, adi','analiz_tamamlandi_first is true')
for i in kurumListe:
print i[0], "-----" , i[1].decode('utf-8')
user_input = raw_input("Kurum ID'sini giriniz(Tum Kurumlar icin -1): ")
if int(user_input) == -1:
kurum = cnn.getlistofdata('kurum', 'objectid', 'analiz_tamamlandi_first is true')
else:
kurum = cnn.getlistofdata('kurum', 'objectid', 'objectid = '+str(user_input))
cvdict = dict_veri_katmani
mvdict = dict_metaveri_katmani
from pgget import Connection
cnn = Connection()
class FormData:
def __init__(self, katmanDurumu, veriGuncelligi, veriKoordinat,
veriEksizliklik, veriMantiksal, veriKonumsal, veriZamansal, veriTematik,
veriSayisal, veriOznitelik, wmsDurum, wmsOgc, wfsDurum, wfsOgc,
metaveriDurumu, metaveriCbsgm,
cbsBirimiDurumu, cbsPersonelDurumu, donanimYeterli, kamunetBagli, ipsecBagli,
katman_aciklama, oid, projeksiyon, datum, vk_zamansal_gecerlilik
):
self.oid = oid
self.katmanDurumu = katmanDurumu
self.veriGuncelligi = veriGuncelligi
self.veriKoordinat = veriKoordinat
self.veriEksizliklik = veriEksizliklik
self.veriMantiksal = veriMantiksal
self.veriKonumsal = veriKonumsal
self.veriZamansal = veriZamansal
self.veriTematik = veriTematik
self.wmsDurum = wmsDurum
self.wmsOgc = wmsOgc
self.wfsDurum = wfsDurum
self.wfsOgc = wfsOgc
self.metaveriDurumu = metaveriDurumu
self.metaveriCbsgm = metaveriCbsgm
import xlsxfunctions
import time
import sys
from pgget import Connection
cnn = Connection()
kurum = cnn.getlistofdata('kurum', 'objectid',
'analiz_tamamlandi_first is true')
toolbar_width = 61
# setup toolbar
sys.stdout.write("[%s]" % (" " * toolbar_width))
sys.stdout.flush()
sys.stdout.write("\b" *
(toolbar_width + 1)) # return to start of line, after '['
for i in kurum:
a = xlsxfunctions.KurumTablosu(i[0])
a.veri_turu()
a.veriformati()
# a.projeksiyondatum
a.veri_eksiksizlik()
a.mantiksal_tutarlilik()
a.vk_konumsal()
a.vk_zamansal()
a.vk_tematik()
a.vk_guncel()
a.vk_ogc()
# -*- coding: utf-8 -*-
import datetime
print datetime.datetime.now().strftime(
'[%Y-%m-%d][%H:%M:%S]') + "Importing Modules"
from pgget import Connection
from kurum import Kurum
from excel_format.dicts import *
from excel_format.cv import CografiVeriFormu
from excel_format.mv import MetaveriFormu
from excel_format.sp import ServisPaylasimFormu
from excel_format.sp_dict import dict_servis_paylasim
# create connection
cnn = Connection()
kurum = cnn.getlistofdata('kurum', 'objectid',
'analiz_tamamlandi_first is true')
counter = 0
cvdict = dict_veri_katmani
mvdict = dict_metaveri_katmani
spdict = dict_servis_paylasim
for i in kurum:
newKurum = Kurum(i[0])
print datetime.datetime.now().strftime('[%Y-%m-%d][%H:%M:%S]'), unicode(
newKurum.adi)
ek2_oid = newKurum.ek2_oid
kurumKatmanalri = cnn.getlistofdata(