int main(void) {
preparation_t queries[] = {
{ "rate",
"SELECT connectionStrength((select id from mode),$2,$1)" },
{ "getpage",
"select strength,title,songs.id from connections inner join songs on connections.blue = songs.id where red = (select id from mode) order by strength desc OFFSET $1 LIMIT $2;" }
};
PQinit();
gtk_init(NULL,NULL);
prepareQueries(queries);
GtkBuilder* builder = gtk_builder_new_from_string(gladeFile,gladeFileSize);
GtkWidget* top = GTK_WIDGET(gtk_builder_get_object(builder,"top"));
GtkTreeSelection* selection = GTK_TREE_SELECTION(
gtk_builder_get_object(builder,"song-selection"));
GtkButton* rateup = GTK_BUTTON(
gtk_builder_get_object(builder,"rateup"));
GtkButton* ratedown = GTK_BUTTON(
gtk_builder_get_object(builder,"ratedown"));
g_signal_connect(G_OBJECT(rateup),"clicked",G_CALLBACK(yay),selection);
g_signal_connect(G_OBJECT(ratedown),"clicked",G_CALLBACK(nay),selection);
GtkListStore* model = GTK_LIST_STORE(
gtk_builder_get_object(builder,"songs"));
fillNext(selection,model);
gtk_widget_show_all(top);
gtk_main();
}
void initializeDBLogger(const char * server, const char *user,
const char * password, const char * database,
DEALLOCATE_FUNC_POINTER func_p)
{
EventProcessor = createEventProcessor(logInThread, cloneExceptionPointer,
func_p);
memset(ErrorStr, 0, sizeof(ErrorStr));
if (createDatabaseConnection(server, user, password, database) == SUCCESS)
{
sprintf(ErrorStr, "DB connection created.");
}
else
{
sprintf(ErrorStr, "Failed to Create DB Connection. Error: %s",
getString((char *) mysql_error(Conn)));
}
logError(ErrorStr);
if (prepareQueries() == SUCCESS)
{
sprintf(ErrorStr, "Queries Prepared Successfully");
}
else
{
sprintf(ErrorStr, "Failed to Prepare Queries. Error: %s", getString(
(char *) mysql_error(Conn)));
}
logError(ErrorStr);
}
int main (int argc, char ** argv)
{
configInit();
if(!declare_pid("player")) {
puts("Player already found");
return 1;
}
srandom(time(NULL));
arguments = argv;
signalsSetup();
gst_init (NULL,NULL);
selectSetup();
onSignal(SIGUSR1,signalNext);
onSignal(SIGUSR2,restartPlayer);
preparation_t queries[] = {
{ "getTopRecording",
"SELECT queue.recording,"
"replaygain.gain,replaygain.peak,replaygain.level,"
"recordings.path "
"FROM queue INNER JOIN replaygain ON replaygain.id = queue.recording INNER JOIN recordings ON recordings.id = queue.recording ORDER BY queue.id ASC LIMIT 1" },
};
prepareQueries(queries);
GMainLoop* loop = g_main_loop_new (NULL, FALSE);
void done_quit() {
g_main_loop_quit(loop);
}
void RemoteBlastHttpRequestTask::prepare() {
prepareQueries();
algoLog.trace("Sequences prepared");
for (QList<Query>::iterator it = queries.begin(),end = queries.end();it!=end;it++) {
DataBaseFactory *dbf = AppContext::getDataBaseRegistry()->getFactoryById(cfg.dbChoosen);
if(dbf == NULL) {
stateInfo.setError(tr("Incorrect database"));
return;
}
HttpRequest *tmp = dbf->getRequest(this);
httpRequest.append(tmp);
}
algoLog.trace("Requests formed");
connect(&timer,SIGNAL(timeout()),SLOT(sl_timeout()));
timeout = true;
timer.setSingleShot(true);
int mult = cfg.aminoT ? 6 : 1; //if 6 requests - 6 times more wait
timer.start(cfg.retries*1000*60*mult);
}
ClientDAO::ClientDAO(IDatabase *pDB)
{
db=pDB;
prepareQueries();
}
void ClientDAO::restartQueries(void)
{
destroyQueries();
prepareQueries();
}
