andreisavu / music-share

Web application for music sharing. A personal scalability experiment.

This URL has Read+Write access

music-share / search.py
100644 22 lines (15 sloc) 0.419 kb
raw blame history 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

import web
 
def update(id, info):
	pass
 
def get_by_id(id, db):
	file = db.query('select * from ms_files where id=$id', vars={'id':id})
	return file[0]
 
def get_related(id, db):
	return []
 
def get(q, db):
	if not q:
		return []
	pq = [t.strip() for t in q.split(' ') if len(t.strip())!=0]
	pq = '%' + '%'.join(pq) + '%'
	files = db.query('select * from ms_files where filename like $q', vars={'q':pq})
	return files