#!/usr/local/bin/python

import os
import BOL

c = BOL.init_db("atraditions")


for file, name, ext in os.walk("."):
	ext = [e[:-7] for e in ext if e.endswith("_sm.jpg")]
	print ext
	for ex in ext:
		print "insert into sidelights values ('', '%s', '%s_sm.jpg', '%s_bg.jpg', '%s_zm.jpg')" %(ex, ex, ex, ex)

	 	c.execute("insert into sidelights values ('', '%s', '%s_sm.jpg', '%s_bg.jpg', '%s_zm.jpg')" %(ex, ex, ex, ex))