def get_pkgs_match_input(self, input_string):
# Select package name match input string.
input_string = input_string.lower()
pkg_names = []
argv = [
"SELECT pkg_name FROM software WHERE pkg_name LIKE ?",
("%" + unicode(input_string) + "%", )
]
cache_info = self.get_info_from_cache_soft_db(argv)
if cache_info:
for (pkg_name, ) in cache_info:
pkg_names.append(pkg_name)
else:
search_key = "*%s*" % input_string
software_list = Software.select().where(
Software.pkg_name % search_key,
Software.language == self.default_lang_obj)
for soft in software_list:
pkg_names.append(soft.pkg_name)
# Sort package name.
pkg_names = sorted(
pkg_names,
cmp=lambda pkg_name_a, pkg_name_b: self.sort_match_pkgs(
pkg_name_a, pkg_name_b, input_string))
return pkg_names
def get_pkgs_match_input(self, input_string):
# Select package name match input string.
input_string = input_string.lower()
pkg_names = []
argv = [
"SELECT pkg_name FROM software WHERE pkg_name LIKE ?",
("%" + unicode(input_string) + "%",)
]
cache_info = self.get_info_from_cache_soft_db(argv)
if cache_info:
for (pkg_name, ) in cache_info:
pkg_names.append(pkg_name)
else:
search_key = "*%s*" % input_string
software_list = Software.select().where(Software.pkg_name % search_key, Software.language==self.default_lang_obj)
for soft in software_list:
pkg_names.append(soft.pkg_name)
# Sort package name.
pkg_names = sorted(
pkg_names,
cmp=lambda pkg_name_a, pkg_name_b: self.sort_match_pkgs(pkg_name_a, pkg_name_b, input_string))
return pkg_names
def get_software_obj(self, pkg_name):
try:
soft = Software.select().where(
Software.pkg_name == pkg_name,
Software.language == self.current_lang_obj).get()
except:
soft = None
return soft
def insert_description(lang):
if not SoftwareData.init_language(lang.lang_code):
print "No data for lang:", lang
else:
print "\ntotal for %s: %s" % (lang.lang_code, SoftwareData.select().count())
i = 0
for s in SoftwareData.select():
try:
software_obj = Software.objects.get(pkg_name=s.pkg_name)
except:
software_obj = Software(pkg_name=s.pkg_name)
software_obj.save()
try:
l10n_obj = SoftwareL10n.objects.get(software=software_obj, language_code=lang)
except:
l10n_obj = SoftwareL10n(software=software_obj, language_code=lang, alias_name=s.alias_name, short_desc=s.short_desc, long_desc=s.long_desc)
l10n_obj.save()
i += 1
print "\rProgress: %s" % i,
def get_software_obj(self, pkg_name):
try:
soft = Software.select().where(Software.pkg_name == pkg_name, Software.language == self.current_lang_obj).get()
except:
soft = None
return soft
