Last active

Embed URL

HTTPS clone URL

SSH clone URL

You can clone with HTTPS or SSH.

Download Gist

Drupal, Galleria field - mass image upload. Python script creates sql commands. Z Shell functions for easy use included.

View .zshrc
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93
setopt extended_glob csh_null_glob
 
maintenance() {
 
echo "Maintenance mode."
 
cat <<EOF | mysql -u drupal -pPASSWORD drupal && echo "OK."
DELETE FROM variable WHERE name = 'site_offline';
INSERT INTO variable (name, value) VALUES ('site_offline', 's:1:"1";');
DELETE FROM cache WHERE cid = 'variables';
EOF
 
}
 
online() {
 
echo "Online mode."
 
cat <<EOF | mysql -u drupal -pPASSWORD drupal && echo "OK."
UPDATE variable SET value = 's:1:"0";' WHERE name = 'site_offline';
DELETE FROM cache WHERE cid = 'variables';
EOF
 
}
 
getVid() {
 
if [ -n "$2" ]
then
echo "select nid,vid,title from node_revisions where nid=$2" | mysql -u USER -p$1 -h HOST DATABASE
else
echo "Usage: getVid [Password] [Nid]"
fi
 
}
 
prepare() {
 
if [ -z "$3" ]
then
echo "Usage: prepare [new photo directory] [nid] [vid]"
else
 
if [ -e "/var/www/sites/default/files/$1" ]
then
echo "Directory $1 exists."
else
 
IMAGEDIR=$1
mkdir "/var/www/sites/default/files/$IMAGEDIR"
cp *.JPG *.jpg *.png *.PNG "/var/www/sites/default/files/$IMAGEDIR/"
 
chown -R www-data.www-data "/var/www/sites/default/files/$IMAGEDIR/"
chmod ogu+r "/var/www/sites/default/files/$IMAGEDIR/"
 
for x in galleria_teaser gallery_assist-default-thumbnail-100 node-gallery-display medium nail imagefield_thumbs teaser_sticky ; do mkdir "$x" ; mkdir "$x/$IMAGEDIR" ; done
 
online
 
for x in galleria_teaser gallery_assist-default-thumbnail-100 node-gallery-display medium nail teaser_sticky ; do for f in *.JPG *.jpg *.png *.PNG ; do wget -O "$x/$IMAGEDIR/$f" "http://localhost/sites/default/files/imagecache/$x/$IMAGEDIR/$f"; done; done
 
maintenance
 
cp -r gallery_assist-default-thumbnail-100/* imagefield_thumbs/
for x in galleria_teaser gallery_assist-default-thumbnail-100 node-gallery-display medium nail imagefield_thumbs teaser_sticky ; do ls -1 "$x/$IMAGEDIR" | wc --lines ; done
 
mkdir imagecache
 
mv galler* medium/ nail/ node-gallery-display/ teaser_sticky/ imagecache/
 
mkdir "$IMAGEDIR"
 
mv *.JPG *.jpg *.png *.PNG "$IMAGEDIR"
 
~/files2galleriasql.py "$2" "$3" 0 "$IMAGEDIR"/* >../photo.sql
 
fi
fi
 
}
 
mo() {
encfs /root/data /root/dec
}
 
um(){
umount /root/dec
}
 
 
 
 
View .zshrc
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126
#!/usr/bin/env python2.7
 
"""
Usage:
files2galleriasql.py [Node Id] [Revision Id] [delta] [image1] [image2] ...
The sql script (fills Drupal Galleria field) is written to the standard output.
Obtaining revision id from nid (node id):
select * from node_revisions where nid=[nid]\G
Obtaining revision id and last delta:
select vid,max(delta) from content_field_galleria where nid=[nid]\G
Empty galleria field:
delta = 0, field_galleria_fid = NULL, field_galleria_list = NULL, field_galleria_data = NULL
Requires: Python Imaging Library (PIL) http://www.pythonware.com/products/pil/ (package python-imaging on Ubuntu)
Drupal path to the images: sites/default/files/
Drupal image cache: sites/default/files/{imagefield_thumbs,imagecache/node-gallery-display} (generated automatically)
###############
Pre-generating imagecache (preset) images (galleria_teaser gallery_assist-default-thumbnail-100 node-gallery-display medium nail imagefield_thumbs teaser_sticky)
###############
See attached Z Shell .zshrc file.
# imagefield_thumbs = gallery_assist-default-thumbnail-100
export IMAGEDIR=name_of_new_image_directory
mkdir "/var/www/sites/default/files/$IMAGEDIR"
cp *.JPG *.jpg *.png "/var/www/sites/default/files/$IMAGEDIR/"
for x in galleria_teaser gallery_assist-default-thumbnail-100 node-gallery-display medium nail imagefield_thumbs teaser_sticky ; do mkdir "$x" ; mkdir "$x/$IMAGEDIR" ; done
for x in galleria_teaser gallery_assist-default-thumbnail-100 node-gallery-display medium nail teaser_sticky ; do for f in *.JPG *.jpg *.png ; do wget -O "$x/$IMAGEDIR/$f" "http://localhost/sites/default/files/imagecache/$x/$IMAGEDIR/$f"; done; done
cp -r gallery_assist-default-thumbnail-100/* imagefield_thumbs/
for x in galleria_teaser gallery_assist-default-thumbnail-100 node-gallery-display medium nail imagefield_thumbs teaser_sticky ; do ls -1 "$x/$IMAGEDIR" | wc --lines ; done
mkdir imagecache
mv galler* medium/ nail/ node-gallery-display/ teaser_sticky/ imagecache/
mkdir "$IMAGEDIR"
mv *.JPG *.jpg *.png "$IMAGEDIR"
~/files2galleriasql.py 361 363 0 $IMAGEDIR/* >test.sql
# Test environment: upload images and directories to the production environment (directory sites/default/files/)
"""
 
import PIL.Image
import os.path
import sys
import time
 
 
class Img():
def __init__(self,f):
self.image=PIL.Image.open(f)
self.mime='image/'+self.image.format.lower()
(self.width,self.height) = self.image.size
 
self.image.fp.seek(0,2)
self.filesize=self.image.fp.tell()
 
self.filename = f
 
 
def sql(self,nodeId,revisionId,delta):
sql = """
insert into files (uid,filename,filepath,filemime,filesize,status,timestamp)
values('1','%s','sites/default/files/%s','%s','%s','1','%s');
set @fid = last_insert_id();
insert into filefield_meta(fid,width,height,duration,audio_format,audio_sample_rate,audio_channel_mode,audio_bitrate,audio_bitrate_mode,tags)
values (@fid,%s,%s,0,'',0,'',0,'','a:0:{}');
INSERT INTO `content_field_galleria`(vid,nid,delta,field_galleria_fid,field_galleria_list,field_galleria_data)
VALUES (%s,%s,%s,@fid,1,concat('a:13:{s:11:\"description\";s:0:\"\";s:3:\"fid\";s:',length(@fid),':\"',@fid,'\";s:5:\"width\";i:%s;s:6:\"height\";i:%s;s:8:\"duration\";i:0;s:12:\"audio_format\";s:0:\"\";s:17:\"audio_sample_rate\";i:0;s:18:\"audio_channel_mode\";s:0:\"\";s:13:\"audio_bitrate\";i:0;s:18:\"audio_bitrate_mode\";s:0:\"\";s:4:\"tags\";a:0:{}s:3:\"alt\";s:0:\"\";s:5:\"title\";s:0:\"\";}'));
""" % (self.filename,self.filename,self.mime,self.filesize,int(time.time()),\
self.width,self.height,\
revisionId,nodeId,delta,self.width,self.height)
return sql
 
if __name__ == '__main__':
 
if len(sys.argv)<5:
print __doc__
exit(1)
try:
nodeId = int(sys.argv[1])
revisionId = int(sys.argv[2])
delta = int(sys.argv[3])
except ValueError:
raise RuntimeError('nodeId, revisionId, delta must be integer')
 
print 'SET NAMES utf8;'
print """delete from content_field_galleria
where vid=%s and nid=%s
and field_galleria_fid IS NULL
and field_galleria_list IS NULL
and field_galleria_data IS NULL;
""" % (revisionId,nodeId)
 
for x in range(4,len(sys.argv)):
try:
img = Img(sys.argv[x])
except IOError:
raise RuntimeError("Can't open file "+sys.argv[x])
 
print img.sql(nodeId,revisionId,delta)
delta+=1
 
View .zshrc
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Method imagecache_image_flush doesn't remove (pre-generated) images from the disc.
It is called when the article has been edited.
 
diff --git a/www/sites/all/modules/imagecache/imagecache.module b/www/sites/all/modules/imagecache/imagecache.module
index 1584304..6aa5501 100644
--- a/www/sites/all/modules/imagecache/imagecache.module
+++ b/www/sites/all/modules/imagecache/imagecache.module
@@ -1127,11 +1127,6 @@ function imagecache_preset_flush($preset) {
* The Drupal file path to the original image.
*/
function imagecache_image_flush($path) {
- foreach (imagecache_presets() as $preset) {
- $derivative_path = imagecache_create_path($preset['presetname'], $path);
- module_invoke_all('imagecache_image_flush', $derivative_path, $preset, $path);
- file_delete($derivative_path);
- }
}
function imagecache_action($actionid) {
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.