Exemplos de GJDB.management em Python

Exemplo n.º 1

def getCityDistrictStreet(sql=''):
    management = GJDB()
    management.management()
    management.selectDB('management')
    management.executeDB('SET NAMES UTF8;')
    if sql == '':
        sql = 'SELECT city.short_name city_name, city.domain, district.short_name district_name,district.url, street.street_name, street.url FROM street INNER JOIN district INNER JOIN city ON district.district_id=street.district_id AND city.city_id=district.city_id;'
    return management.selectData(sql)

Exemplo n.º 2

Arquivo: SEMURL.py Projeto: hfutsuchao/Python2.6

def getCityDistrictStreet(sql=''):
    management = GJDB()
    management.management()
    management.selectDB('management')
    management.executeDB('SET NAMES UTF8;')
    if sql == '':
        sql = 'SELECT city.short_name city_name, city.domain, district.short_name district_name,district.url, street.street_name, street.url FROM street INNER JOIN district INNER JOIN city ON district.district_id=street.district_id AND city.city_id=district.city_id;'
    return management.selectData(sql)

Exemplo n.º 3

#coding:utf-8
from GJDB import GJDB

DB = GJDB()

DB.management()

DB.selectDB('management')

DB.selectData("set names utf8;")

#print DB.selectData("SELECT city.domain,street.street_id,street.script_index,street.street_name,street.url FROM street INNER JOIN district INNER JOIN city ON district.district_id=street.district_id AND city.city_id=district.city_id where city.short_name='北京' and district.short_name='海淀' and street.street_name='西二旗'")

with open('districtStreetM.txt', 'r') as streetAddFile:
    for streetAdd in streetAddFile:
        try:
            city, district, streets = streetAdd.split('\t')
        except:
            continue
        streetDic = streets[:-1].split(',')
        for street in streetDic:
            sql = "SELECT city.domain,street.street_id,street.script_index,street.street_name,street.url FROM street INNER JOIN district INNER JOIN city ON district.district_id=street.district_id AND city.city_id=district.city_id where city.short_name='" + city + "' and district.short_name = '" + district + "' and street.street_name='" + street + "'"
            sql2 = "SELECT city.domain FROM district INNER JOIN city ON city.city_id=district.city_id where city.short_name='" + city + "' and district.short_name = '" + district + "'"
            if len(DB.selectData(sql)) == 0:
                if len(DB.selectData(sql2)) >= 0:
                    print city, district, street
                    #pass
                else:
                    #print sql2
                    pass
        #print city, district, streetDic

Exemplo n.º 4

Arquivo: streetAdd.py Projeto: hfutsuchao/Python2.6

#coding:utf-8
from GJDB import GJDB

DB = GJDB()

DB.management()

DB.selectDB('management')

DB.selectData("set names utf8;")

#print DB.selectData("SELECT city.domain,street.street_id,street.script_index,street.street_name,street.url FROM street INNER JOIN district INNER JOIN city ON district.district_id=street.district_id AND city.city_id=district.city_id where city.short_name='北京' and district.short_name='海淀' and street.street_name='西二旗'")

with open('districtStreetM.txt','r') as streetAddFile:
    for streetAdd in streetAddFile:
        try:
            city, district, streets = streetAdd.split('\t')
        except:
            continue
        streetDic = streets[:-1].split(',')
        for street in streetDic:
            sql = "SELECT city.domain,street.street_id,street.script_index,street.street_name,street.url FROM street INNER JOIN district INNER JOIN city ON district.district_id=street.district_id AND city.city_id=district.city_id where city.short_name='" + city + "' and district.short_name = '" + district + "' and street.street_name='" + street + "'"
            sql2 = "SELECT city.domain FROM district INNER JOIN city ON city.city_id=district.city_id where city.short_name='" + city + "' and district.short_name = '" + district + "'"
            if len(DB.selectData(sql)) == 0:
                if len(DB.selectData(sql2)) >=0:
                    print city, district, street
                    #pass
                else:
                    #print sql2
                    pass
        #print city, district, streetDic