U++ forum: Welcome to the forum

Re: Image in database [message #31934 is a reply to message #31932]

Fri, 08 April 2011 21:10

Didier
Messages: 725
Registered: November 2008
Location: France

Contributor

Hi jibe,

I use a helper class in one of my apps.

It can be used with the following SQL schema description:

// ========================================
//          IMAGES
// ========================================
TABLE_(IMAGES)
	INT_	(IMG_ID) PRIMARY_KEY AUTO_INCREMENT
	INT_	(IMG_HASH)  INDEX
	INT_    (IMG_REFCOUNT) SQLDEFAULT(0) // reference counter
	LONGRAW_(IMG_DATA)
END_TABLE

NB: The hash and REFCOUNT are not used yet, they are intended for future devs.

The idea is to have all images in one table and manage references to these images in the other tables:

TABLE_(CLUBS)
	INT_    (CLUB_ID) PRIMARY_KEY AUTO_INCREMENT
	STRING_ (CLUB_NUMBER, 10)
	STRING_ (CLUB_NOM, 60)
	STRING_ (CLUB_ALIAS, 10)
	STRING_ (CLUB_ADRESSE, 250)
	STRING_ (CLUB_VILLE, 30)
	INT_    (CLUB_CODE_POSTAL)
	STRING_ (CLUB_NUM_TEL, 20)
	INT_    (CLUB_REF_LIGUE) REFERENCES(LIGUE)
	INT_    (CLUB_LOGO_SMALL_IMGREF)  SQLDEFAULT(-1)     **** IMAGE ****
	INT_    (CLUB_LOGO_BIG_IMGREF)    SQLDEFAULT(-1)     **** IMAGE ****
	STRING_ (CLUB_MAIL, 50)
END_TABLE

In order to use it you finally need to do something like this:

clubsData.CLUB_LOGO_BIG_IMGREF = ImageMgr::addImage( clubCtrls.imgPresentation.GetImage() );

or

clubCtrls.imgPresentation.SetData( ImageMgr::getImageString( clubsData.CLUB_LOGO_SMALL_IMGREF ) );

Hope this will be useful for you

Attachment: ImageMgr.tar.gz
(Size: 0.87KB, Downloaded 230 times)

Report message to a moderator