コード例 #1
0
ファイル: geocode.py プロジェクト: phestoem/patentprocessor
# Each city is split using , and | as separators. This for loop goes through
# each segment of each city and attempts to match it to a location.  
for separator_count in range(-1, c.execute("select max(separator_count(city)) from loc").fetchone()[0]+1):

    sep = separator_count
    print "------", separator_count, "------"
    replace_loc(geocode_replace_loc.domestic_sql()                     % (sep, separator_count))
    replace_loc(geocode_replace_loc.domestic_block_remove_sql()        % (sep, separator_count))
    replace_loc(geocode_replace_loc.domestic_first3_jaro_winkler_sql() % (sep, sep, geocode_setup.get_jaro_required('domestic_first3'), separator_count))
    replace_loc(geocode_replace_loc.domestic_last4_jaro_winkler_sql()  % (sep, sep, geocode_setup.get_jaro_required('domestic_last4'), separator_count))
    replace_loc(geocode_replace_loc.foreign_full_name_1_sql()          % (sep, separator_count))
    replace_loc(geocode_replace_loc.foreign_full_name_2_sql()          % (sep, separator_count))
    replace_loc(geocode_replace_loc.foreign_short_form_sql()           % (sep, separator_count))
    replace_loc(geocode_replace_loc.foreign_block_split_sql()          % (sep, separator_count))
    replace_loc(geocode_replace_loc.foreign_first3_jaro_winkler_sql()  % (sep, sep, geocode_setup.get_jaro_required('foreign_first3'), separator_count))
    replace_loc(geocode_replace_loc.foreign_last4_jaro_winkler_sql()   % (sep, sep, geocode_setup.get_jaro_required('foreign_last4'), separator_count))

### End of for loop

print "------ F ------"

# TODO: Put these calls into a function.
replace_loc(geocode_replace_loc.domestic_2nd_layer_sql())
replace_loc(geocode_replace_loc.domestic_first3_2nd_jaro_winkler_sql() % (geocode_setup.get_jaro_required('domestic_first3_2nd')))
replace_loc(geocode_replace_loc.foreign_full_name_2nd_layer_sql())
replace_loc(geocode_replace_loc.foreign_full_nd_2nd_layer_sql())
replace_loc(geocode_replace_loc.foreign_no_space_2nd_layer_sql())
replace_loc(geocode_replace_loc.foreign_first3_2nd_jaro_winkler_sql()  % (geocode_setup.get_jaro_required('foreign_first3_2nd')))

conn.commit()
c.close()
コード例 #2
0
ファイル: geocode.py プロジェクト: laironald/patentprocessor
# that function extensively.
# TODO: Figure out what these hardcoded parameters mean.
for scnt in range(-1, c.execute("select max(separator_count(city)) from loctbl.loc").fetchone()[0]+1):

    sep = scnt
    print "------", scnt, "------"
    replace_loc(geocode_replace_loc.domestic_sql()                     % (sep, scnt))
    replace_loc(geocode_replace_loc.domestic_block_remove_sql()        % (sep, scnt))
    replace_loc(geocode_replace_loc.domestic_first3_jaro_winkler_sql() % (sep, sep, geocode_setup.FIRST3_JARO_REQUIRED, scnt))
    replace_loc(geocode_replace_loc.domestic_last4_jaro_winkler_sql()  % (sep, sep, geocode_setup.LAST4_JARO_REQUIRED, scnt))
    replace_loc(geocode_replace_loc.foreign_full_name_1_sql()          % (sep, scnt))
    replace_loc(geocode_replace_loc.foreign_full_name_2_sql()          % (sep, scnt))
    replace_loc(geocode_replace_loc.foreign_short_form_sql()           % (sep, scnt))
    replace_loc(geocode_replace_loc.foreign_block_split_sql()          % (sep, scnt))
    replace_loc(geocode_replace_loc.foreign_first3_jaro_winkler_sql()  % (sep, sep, "20.92", scnt))
    replace_loc(geocode_replace_loc.foreign_last4_jaro_winkler_sql()   % (sep, sep, "20.90", scnt))

### End of for loop

print "------ F ------"

# TODO: Put these calls into a function.
replace_loc(geocode_replace_loc.domestic_2nd_layer_sql())
replace_loc(geocode_replace_loc.domestic_first3_2nd_jaro_winkler_sql() % ("14.95"))
replace_loc(geocode_replace_loc.foreign_full_name_2nd_layer_sql())
replace_loc(geocode_replace_loc.foreign_full_nd_2nd_layer_sql())
replace_loc(geocode_replace_loc.foreign_no_space_2nd_layer_sql())
replace_loc(geocode_replace_loc.foreign_first3_2nd_jaro_winkler_sql()  % ("24.95"))
replace_loc(geocode_replace_loc.domestic_zipcode_sql())

conn.commit()