"insert into" query to create albums. Can it be done?

andreste Joined: 2006-06-02 Posts: 123	Posted: Fri, 2006-10-20 13:18
	hello, I have to create about 300 albums so I'm wondering if using an "insert into '....'" query directly to the database could work. I don't want to screw up things, so I'm asking first.
	XUser login Username: * Password: * Create new account Request new password
valiant Joined: 2003-01-04 Posts: 32509	Posted: Fri, 2006-10-20 19:58
	you should use the Gallery API, not SQL statements. the G2 sql schema and the dependencies are not obvious. only by using the API you ensure that you don't corrupt the data integrity of your database. you can build a script with GalleryEmbed::init, GalleryCoreApi::createAlbum, GalleryEmbed::done. see documentation -> API -> GalleryCore -> GalleryEmbed, GalleryCoreApi.

valiant Joined: 2003-01-04 Posts: 32509	Posted: Fri, 2006-10-20 19:59
	also consider: - http://codex.gallery2.org/index.php/Downloads:Galleryadd.pl_NG - add item from server

andreste Joined: 2006-06-02 Posts: 123	Posted: Fri, 2006-10-20 21:36
	Thanks Valiant, I'll use the Add from server function. I thought it could be used for photos only, not whole directories, so I actually forgot about it altogether; until now! thanks again!

XUser login