:-eval(consult("utils.prova")).

:- eval(biogridmeta_use_001()).

location(database,biogridmeta,"jdbc:mysql://localhost/biogridmeta","guest","guestdb").

biogridmeta_use_001() :-
	println(["===========================biogridmeta use 001==========================="]),
	dbopen(biogridmeta,DB),
	issue_query(DB).

issue_query(DB) :-
	println(["---------------------------------------------------------------------"]),
	println(["The first 10 counts of terms with the same name and counts>4:"]),
   % The equivalent SELECT statement is:
   % select name from term group by name having count(*)>4 limit 10
	sql_select(DB,entities,[name,N],[options,'limit 10']),
	println([N],"->").

