Place Ghantoos

This time I needed this time to provision the NextGen SQL database with all the folders I’ve put on my server.

Again, i did a little python script. I scans your NextGen gallery folder, and enters all new folders as “galleries” in the SQL DB, and creates the thumbs for the pictures.

This was usefull for me. : )

You can download the script here.

#!/usr/bin/env python
#
# Dependencies:
#         - ImageMagick (for Ubuntu user, sudo apt-get install imagemagick :) )
#        - MySQL module for python (MySQLdb)
#        - getpass module for python

import MySQLdb
import os
import stat
from getpass import getpass
from sys import exit, argv

def usage():
    if len(argv) != 2:
        print "Usage: ./ngall_sql.py /path/to/ng/gallery/folder"
        exit(0)

##########
## main ##
##########

if __name__ == '__main__' :
	try:
		usage()

		password = getpass("Please enter password :")
		source = argv[1]

		try:
			conn = MySQLdb.connect (host = "localhost",
			user = "WORDPRESS_SQL_USER",
			passwd = password,
			db = "WORDPRESS_SQL_USER_PASSWORD")
		except MySQLdb.Error, e:
			print "Error %d: %s" % (e.args[0], e.args[1])
			exit (1)

		cursor = conn.cursor ()

		# put folder & pictures in an array
		folders = os.listdir(source)
		content = []

		for folder in folders:
			folder_test = os.lstat(source + folder)
			if stat.S_ISDIR(folder_test.st_mode):
				pictures = os.listdir(source + folder)
				files = []
				for picture in pictures:
				    picture_test = os.lstat(source + folder + '/' + picture)
				    if not stat.S_ISDIR(picture_test.st_mode):
				        files.append(picture)
				content.append([folder, files])

		# get existing galleries
		cursor.execute ("SELECT path from wp_ngg_gallery")
		rows = cursor.fetchall()
		existing_galleries = []
		for row in rows:
			existing_galleries.append(row[0].split('/').pop())

		# fetch the maximum pictureID (pid) and GalleryID(gid) to add above them
		# the try/except part is just in case script is launched on empty DB
		try:
			cursor.execute ("select MAX(pid) from wp_ngg_pictures;")
			pid = cursor.fetchall()[0][0] + 1
		except: pid = 1

		try:
			cursor.execute ("select MAX(gid) from wp_ngg_gallery;")
			gid = cursor.fetchall()[0][0] + 1
		except: gid = 1

		# Start processing folders & pictures
		for array in content:
			folder = array[0]

			if not folder in existing_galleries:
				print "## ADDING", folder
				if os.path.isdir(source + folder + '/thumbs') == False:
				    print "# adding thumb folder for:", folder
				    os.makedirs(source + folder + '/thumbs')
				    os.chmod(source + folder + '/thumbs', 0777)
				cursor.execute ("INSERT INTO wp_ngg_gallery (gid,name,path,title,galdesc,pageid,previewpic) \
					VALUES (%i,'%s', '%s', '%s','',0,%i);" %(gid,folder,"wp-content/gallery/" + folder,folder.replace('_',' '),pid))

				array[1].sort()
				for picture in array[1]:
				    print "    processing", picture
				    cursor.execute ("INSERT INTO wp_ngg_pictures (pid,galleryid,filename,description,alttext,exclude) \
					VALUES (%i,%i, '%s',NULL,'%s',0);" %(pid,gid,picture,picture))
				    os.popen('convert -resize "150x112" -quality 60 %s %s'
				        % (source + folder + '/' + picture, source + folder + '/thumbs/thumbs_' + picture))
				    pid += 1
				gid += 1

		cursor.close ()
		conn.commit ()
		conn.close ()
		print "done!"
	except KeyboardInterrupt:
		print 'Exiting on user request'