def pbsearch_sql(c,option,q):
if ':' in q: # tag
(tags,q) = q.split(':')
tag_list = [t[1:] for t in tags.split(' ') if t.startswith('#')]
else:
tag_list = []
order_by = " order by "+util.sort_option[util.sql_orderby(c)]
query = query_build(q,tag_list,option,order_by);
output = []
for r in c.execute(query):
tags = ' '.join(map(lambda x: '#'+x, (r["tags"].strip().split(' ')))) if r['tags'] else ""
launch_count = ' +'+str(r["launch_count"]) if r["launch_count"] else ''
icon = "icon-%d.png"%((r['mark']<<1)+r['private'])
output.append({"title": title_build(r['description']),
"subtitle": r['host']+" "+tags+launch_count, # "uid": r['hash'],
"arg": r['href'],
"quicklookurl": r['href'],
"mods": {"cmd": {"subtitle": "[Copy] %s"%r['href']}},
"icon":{ "path": icon}
})
add_head_bottom(c,q,output,tag_list,option)
print json.dumps({"items": output})
def pbsearch_sql(c, option, q):
if ':' in q: # tag
(tags, q) = q.split(':')
tag_list = [t[1:] for t in tags.split(' ') if t.startswith('#')]
else:
tag_list = []
order_by = " order by " + util.sort_option[util.sql_orderby(c)]
query = query_build(q, tag_list, option, order_by)
output = []
for r in c.execute(query):
tags = ' '.join(
map(lambda x: '#' + x,
(r["tags"].strip().split(' ')))) if r['tags'] else ""
launch_count = ' +' + str(
r["launch_count"]) if r["launch_count"] else ''
icon = "icon-%d.png" % ((r['mark'] << 1) + r['private'])
output.append({
"title": title_build(r['description']),
"subtitle":
r['host'] + " " + tags + launch_count, # "uid": r['hash'],
"arg": r['href'],
"quicklookurl": r['href'],
"mods": {
"cmd": {
"subtitle": "[Copy] %s" % r['href']
}
},
"icon": {
"path": icon
}
})
add_head_bottom(c, q, output, tag_list, option)
print json.dumps({"items": output})
def process_option(c,q):
result = []
help_back_string = "enter to go Back"
help_select_string = ""
mods = {
"ctrl": {"valid": False, "subtitle": ""},
"alt": {"valid": False, "subtitle": ""},
"cmd": {"valid": False, "subtitle": ""},
"shift": {"valid": False, "subtitle": ""}
}
mark = util.filter_mark(c)
private = util.filter_private(c)
sort = util.sql_orderby(c)
if q.startswith("_mark"):
result.append({"title": "mark [filter] - "+util.filter_option[mark],
"subtitle": help_back_string,
"valid": False,
"autocomplete":"_",
"mods": mods
})
add_option_submenu(result,mods,"mark",mark)
elif q.startswith("_private"):
result.append({"title": "private [filter] - "+util.filter_option[private],
"subtitle": help_back_string,
"valid": False,
"autocomplete":"_",
"mods": mods
})
add_option_submenu(result,mods,"private",private)
elif q.startswith("_sort"):
result.append({"title": "sort - "+util.sort_option[sort],
"subtitle": help_back_string,
"valid": False,
"autocomplete":"_",
"mods": mods
})
add_option_submenu(result,mods,"sort",sort)
elif q.startswith("_pbauth"):
result.append({"title": "_pbauth username:token",
"subtitle": "Setup Pinboard authentication token",
"valid": False,
"mods": mods
})
if ' ' in q and ':' in q:
result[0]['valid'] = True
result[0]['arg'] = '_auth='+q.split(' ')[1]
result[0]['subtitle'] = "Enter to set"
else:
result.append({"title": "Settings",
"subtitle": "enter to go Back",
"valid": False,
"autocomplete": "",
"mods": mods
})
result.append({"title": "mark [filter] - "+util.filter_option[mark],
"subtitle": help_select_string,
"valid": False,
"autocomplete":"_mark",
"mods": mods
})
result.append({"title": "private [filter] - "+util.filter_option[private],
"subtitle": help_select_string,
"valid": False,
"autocomplete":"_private",
"mods": mods
})
result.append({"title": "sort - "+util.sort_option[sort],
"subtitle": help_select_string,
"valid": False,
"autocomplete":"_sort",
"mods": mods
})
auth = util.authinfo(c)
if auth:
result.append({"title": "> Pinboard User - %s"%auth.split(':')[0],
"subtitle": 'enter to change',
"valid": False,
"autocomplete":"_pbauth ",
"mods": mods
})
result.append({"title": ">> Download pinboard data",
"subtitle": 'enter to reload pinboard',
"valid": True,
"arg": "_pbreload",
"autocomplete":"_pbreload ",
"mods": mods
})
else:
result.append({"title": ">> Login Pinboard account",
"subtitle": 'pbauth - username:token',
"valid": False,
"autocomplete":"_pbauth ",
"mods": mods
})
print json.dumps({"items": result})
def process_option(c, q):
result = []
help_back_string = "enter to go Back"
help_select_string = ""
mods = {
"ctrl": {
"valid": False,
"subtitle": ""
},
"alt": {
"valid": False,
"subtitle": ""
},
"cmd": {
"valid": False,
"subtitle": ""
},
"shift": {
"valid": False,
"subtitle": ""
}
}
mark = util.filter_mark(c)
private = util.filter_private(c)
sort = util.sql_orderby(c)
if q.startswith("_mark"):
result.append({
"title": "mark [filter] - " + util.filter_option[mark],
"subtitle": help_back_string,
"valid": False,
"autocomplete": "_",
"mods": mods
})
add_option_submenu(result, mods, "mark", mark)
elif q.startswith("_private"):
result.append({
"title":
"private [filter] - " + util.filter_option[private],
"subtitle":
help_back_string,
"valid":
False,
"autocomplete":
"_",
"mods":
mods
})
add_option_submenu(result, mods, "private", private)
elif q.startswith("_sort"):
result.append({
"title": "sort - " + util.sort_option[sort],
"subtitle": help_back_string,
"valid": False,
"autocomplete": "_",
"mods": mods
})
add_option_submenu(result, mods, "sort", sort)
elif q.startswith("_pbauth"):
result.append({
"title": "_pbauth username:token",
"subtitle": "Setup Pinboard authentication token",
"valid": False,
"mods": mods
})
if ' ' in q and ':' in q:
result[0]['valid'] = True
result[0]['arg'] = '_auth=' + q.split(' ')[1]
result[0]['subtitle'] = "Enter to set"
else:
result.append({
"title": "Settings",
"subtitle": "enter to go Back",
"valid": False,
"autocomplete": "",
"mods": mods
})
result.append({
"title": "mark [filter] - " + util.filter_option[mark],
"subtitle": help_select_string,
"valid": False,
"autocomplete": "_mark",
"mods": mods
})
result.append({
"title":
"private [filter] - " + util.filter_option[private],
"subtitle":
help_select_string,
"valid":
False,
"autocomplete":
"_private",
"mods":
mods
})
result.append({
"title": "sort - " + util.sort_option[sort],
"subtitle": help_select_string,
"valid": False,
"autocomplete": "_sort",
"mods": mods
})
auth = util.authinfo(c)
if auth:
result.append({
"title": "> Pinboard User - %s" % auth.split(':')[0],
"subtitle": 'enter to change',
"valid": False,
"autocomplete": "_pbauth ",
"mods": mods
})
result.append({
"title": ">> Download pinboard data",
"subtitle": 'enter to reload pinboard',
"valid": True,
"arg": "_pbreload",
"autocomplete": "_pbreload ",
"mods": mods
})
else:
result.append({
"title": ">> Login Pinboard account",
"subtitle": 'pbauth - username:token',
"valid": False,
"autocomplete": "_pbauth ",
"mods": mods
})
print json.dumps({"items": result})
