Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
34 lines (26 sloc) 1.25 KB
#--
install:
zip: install.zip
files: wiphoto/CSS wiphoto/images wiphoto/index.html wiphoto/js
exclude: \*~ \*/albums.js \*/photos.js \*/.DS_Store \*/\#\*
albums:
names: SELECT primaryKey, Name, Parent,ClassName FROM SqAlbum WHERE primaryKey < 999000
#ClassName= 'Album'
# AND albumGroup = 8192
#
# Find folders togetherwith albums in folders
# select primaryKey,parent,siblingOrder,repAlbumKeyForLoading from SqAlbum
# primaryKey is from names: SQL
photos: "SELECT sqPhotoInfo FROM AlbumsPhotosJoin where sqAlbum = #{primaryKey} ORDER BY photosOrder"
tree:
top: "SELECT PrimaryKey FROM sqAlbum WHERE Parent = 0 AND PrimaryKey < 999000"
nested: "SELECT PrimaryKey FROM sqAlbum WHERE Parent = #{id}"
photos:
# photoKeys is result of albums SQL above
# SqFileImage: photoKey,imageType -> primaryKey
# imageType 6 -> orig , 7 -> arch , 5-> thumb
thumb: "SELECT primaryKey FROM SqFileImage WHERE imageType = 5 AND photoKey = #{photoKey}"
image: "SELECT primaryKey FROM SqFileImage WHERE imageType = 6 AND photoKey = #{photoKey}"
# tpl below uses one of the 2 above
path: "SELECT relativePath FROM SqFileInfo WHERE primaryKey in (#{select})"
dimensions: "SELECT imageWidth, imageHeight FROM SqFileImage WHERE primaryKey in (#{select})"