test-relation.c

linux下的电话本的最底层

/*	librecord2 - Record Object manipulation and storage library 2
 *
 *	Authors: YE Nan <[e-mail]> 
 *	
 *	This software and associated documentation files (the "Software") 
 *	are copyright (C) 2005 LiPS Linux Phone Standards Forum [FranceTelecom] 
 *	All Rights Reserved. 
 *
 *	A copyright license is hereby granted for redistribution and use of 
 *	the Software in source and binary forms, with or without modification, 
 *	provided that the following conditions are met: 
 *	- Redistributions of source code must retain the above copyright notice, 
 *	this copyright license and the following disclaimer. 
 *  - Redistributions in binary form must reproduce the above copyright 
 * 	notice, this copyright license and the following disclaimer in the 
 *	documentation and/or other materials provided with the distribution. 
 *	- Neither the name of LiPS  nor the names of its Members may be used 
 *	to endorse or promote products derived from the Software without 
 *	specific prior written permission. 
 *
 *	A patent license for any Necessary Claims owned by Members of LiPS Forum 
 *	to make, have made, use, import, offer to sell, lease and sell or otherwise 
 *	distribute any implementation compliant with the any specification adopted 
 *	by the LiPS Forumcan be obtained from the respective Members on reasonable 
 *	and non-discriminatory terms and conditions and under reciprocity, as 
 *	regulated in more detail in the Internal Policy of the LiPS Forum. 
 *
 *	THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDER, ITS MEMBERS AND CONTRIBUTORS 
 *	"AS IS", AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, 
 *	THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE 
 *	AND NON-INFRINGEMENT ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER, 
 *	ITS MEMBERS OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, 
 *	SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, 
 *	PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; 
 *	OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, 
 *	WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) 
 *	ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE 
 *	POSSIBILITY OF SUCH DAMAGE. 
 */

#include <stdio.h>
#include <stdlib.h>
#include <time.h>

#include <glib.h>
#include <database.h>

#define TEMPL_FNAME					"./sample.templ"

#define	DB_FNAME						"./sample.db"
#define	DB_ELEMENT_NAME_1		"sample1"
#define	DB_ELEMENT_NAME_2		"sample2"

typedef enum {
	REC_FIELD_UID						= 1,
	REC_FIELD_NAME					= 3,
	REC_FIELD_MOBILE				= 6,
	REC_FIELD_NUM_HOME			= 7,
	REC_FIELD_NUM_OFFICE		= 8,
	REC_FIELD_FAX						= 9,
	REC_FIELD_COMPANY				= 10,
	REC_FIELD_DEPART				= 11,
	REC_FIELD_WEBSITE				= 12,
	REC_FIELD_EMAIL					= 13,
	REC_FIELD_PICTURE				= 14,
	REC_FIELD_RINGTONE			= 15,
	REC_FIELD_ADDRESS				= 16,
	REC_FIELD_CUSTOM_FLOAT	= 17,
	REC_FIELD_CUSTOM_BINARY	= 18,
} RecordFields;

FieldTemplate * templ = NULL;

int main (int argc, char *argv[])
{
	RecordDB * db = NULL;
	RecordDBElement * element1 = NULL;
	RecordDBElement * element2 = NULL;
	RecordDBRelation * relation = NULL;
	
	templ = field_template_new_from_file(TEMPL_FNAME);
	
	db = record_db_new(DB_FNAME);

	element1 = record_db_element_new(db,
																	 DB_ELEMENT_NAME_1,
																	 templ);
	element2 = record_db_element_new(db,
																	 DB_ELEMENT_NAME_2,
																	 templ);

	relation = record_db_relation_new(db,
																		DB_ELEMENT_NAME_1,
																		DB_ELEMENT_NAME_2);

	record_db_open(db);
	record_db_relation_add(relation, 1, 2);
	record_db_relation_add(relation, 1, 4);
	record_db_relation_add(relation, 2, 4);
	record_db_relation_add(relation, 3, 4);
	record_db_relation_add(relation, 5, 6);
	record_db_relation_add(relation, 7, 8);
	record_db_relation_add(relation, 9, 10);
	record_db_close(db);
	
	if (TRUE)
	{
		guint32 uid = 0;
		Iterator * iter = NULL;
		gint i;
		
		record_db_open(db);
		
		uid = 1;
		g_print("%s(): relation of element1 (uid = %d):\n",
						__FUNCTION__,
						uid);
						
		record_db_relation_get(relation,
													 &iter,
													 uid,
													 TRUE);
		for (iterator_to_first(iter);
				 !iterator_at_last(iter);
				 iterator_next(iter))
		{
			guint32 rel_uid = *(guint32 *)iterator_current(iter);
			
			g_print("%s(): uid = %d\n",
							__FUNCTION__,
							rel_uid);
		}
		iterator_free(iter, TRUE);
		
		uid = 4;
		g_print("%s(): relation of element2 (uid = %d):\n",
						__FUNCTION__,
						uid);
						
		record_db_relation_get(relation,
													 &iter,
													 uid,
													 FALSE);
		for (iterator_to_first(iter);
				 !iterator_at_last(iter);
				 iterator_next(iter))
		{
			guint32 rel_uid = *(guint32 *)iterator_current(iter);
			
			g_print("%s(): uid = %d\n",
							__FUNCTION__,
							rel_uid);
		}
		iterator_free(iter, TRUE);

		record_db_close(db);
	}
	
	if (TRUE)
	{
		guint32 uid = PRIMARY_ID_INVALID;
		
		record_db_open(db);
		
		uid = 1;
		g_print("%s(): remove relations of element1 (uid = %d):\n",
						__FUNCTION__,
						uid);
		record_db_relation_remove(relation,
															uid, 
															PRIMARY_ID_INVALID);

		uid = 4;
		g_print("%s(): remove relations of element2 (uid = %d):\n",
						__FUNCTION__,
						uid);
		record_db_relation_remove(relation,
															PRIMARY_ID_INVALID, 
															uid);
		
		g_print("%s(): remove rest relations:\n",
						__FUNCTION__);
		record_db_relation_remove(relation,
															PRIMARY_ID_INVALID, 
															PRIMARY_ID_INVALID);
		record_db_close(db);
	}

	record_db_relation_free(relation);
	record_db_element_free(element1);
	record_db_element_free(element2);
	record_db_free(db);
	
	field_template_free(templ);
	
	return EXIT_SUCCESS;
}

/*
vi:ts=2:nowrap:ai:expandtab 
*/