当前位置: 首页>>代码示例>>C++>>正文

C++ connectDatabase函数代码示例

本文整理汇总了C++中connectDatabase函数的典型用法代码示例。如果您正苦于以下问题：C++ connectDatabase函数的具体用法？C++ connectDatabase怎么用？C++ connectDatabase使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。


在下文中一共展示了connectDatabase函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C++代码示例。

示例1: connectMaintenanceDatabase

/*
 * Try to connect to the appropriate maintenance database.
 */
PGconn *
connectMaintenanceDatabase(const char *maintenance_db, const char *pghost,
						   const char *pgport, const char *pguser,
						   enum trivalue prompt_password,
						   const char *progname)
{
	PGconn *conn;

	/* If a maintenance database name was specified, just connect to it. */
	if (maintenance_db)
		return connectDatabase(maintenance_db, pghost, pgport, pguser,
							   prompt_password, progname, false);

	/* Otherwise, try postgres first and then template1. */
	conn = connectDatabase("postgres", pghost, pgport, pguser, prompt_password,
						   progname, true);
	if (!conn)
		conn = connectDatabase("template1", pghost, pgport, pguser,
							   prompt_password, progname, true);

	if (!conn)
	{
		fprintf(stderr, _("%s: could not connect to databases \"postgres\" or \"template1\"\n"
						  "Please specify an alternative maintenance database.\n"),
				progname);
		fprintf(stderr, _("Try \"%s --help\" for more information.\n"),
				progname);
		exit(1);
	}

	return conn;
}
开发者ID:denishpatel，项目名称:postgres，代码行数:35，代码来源:common.c

示例2: qDebug

bool databaseSqlite::createDatabase(QWidget *parent,QString *path)
{

    if (!path)
    {//show dialog and get a newPath
        qDebug()<<"no hay path"<<*path;
        QString newPath = QFileDialog::getSaveFileName(parent,
                QObject::tr("Create Database"), misc::filesPath(),
                "SQLite3 (*.sqlite3)", 0, QFileDialog::DontConfirmOverwrite);

        if (newPath.isEmpty())
            return false;
        path=&newPath;
    }

    //create a copy of the database in the *path
    QString oldDb = QSqlDatabase::database().databaseName();
    closeDatabase();

    if (QFile::exists(*path)) {
        QMessageBox::critical(0, QObject::tr("Database Error"), QObject::tr("Database exists already."));

        if (!oldDb.isEmpty())
            connectDatabase(oldDb);

        return false;
    }

    if(!QFile::copy(":/sqlite/todoro.db",*path))
    {
        QString msg =QString("Copying database to %1 failed").arg(*path);
        QMessageBox::critical(0,"Error",msg);
        if (!oldDb.isEmpty())
            connectDatabase(oldDb);
        return false;
    }

    QFile::setPermissions(*path, QFile::ReadUser | QFile::WriteUser | QFile::WriteOwner | QFile::ReadOwner);

    if (!connectDatabase(*path)) {
        if (!oldDb.isEmpty())
            connectDatabase(oldDb);
        return false;
    }
    else {
        return true;
    }


}
开发者ID:lancedeimont，项目名称:todoro，代码行数:50，代码来源:databasesqlite.cpp

示例3: m_sHost

DependencyNameResolver::DependencyNameResolver(std::string host, std::string db, std::string user, std::string pass, uint32_t port) :
  m_sHost(host), m_sDB(db), m_sUser(user), m_sPassword(pass), m_uiPort(port)
{

//  m_db = (MysqlConnection *)NULL;
  connectDatabase();
}
开发者ID:kchristofferson，项目名称:urpackager，代码行数:7，代码来源:DependencyNameResolver.cpp

示例4: vacuum_all_databases

static void
vacuum_all_databases(bool full, bool verbose, bool and_analyze, bool analyze_only,
					 bool freeze, const char *host, const char *port,
					 const char *username, enum trivalue prompt_password,
					 const char *progname, bool echo, bool quiet)
{
	PGconn	   *conn;
	PGresult   *result;
	int			i;

	conn = connectDatabase("postgres", host, port, username, prompt_password, progname);
	result = executeQuery(conn, "SELECT datname FROM pg_database WHERE datallowconn ORDER BY 1;", progname, echo);
	PQfinish(conn);

	for (i = 0; i < PQntuples(result); i++)
	{
		char	   *dbname = PQgetvalue(result, i, 0);

		if (!quiet)
		{
			printf(_("%s: vacuuming database \"%s\"\n"), progname, dbname);
			fflush(stdout);
		}

		vacuum_one_database(dbname, full, verbose, and_analyze, analyze_only,
						 freeze, NULL, host, port, username, prompt_password,
							progname, echo);
	}

	PQclear(result);
}
开发者ID:adunstan，项目名称:pg-cvs-mirror，代码行数:31，代码来源:vacuumdb.c

示例5: cluster_one_database

static void
cluster_one_database(const char *dbname, bool verbose, const char *table,
					 const char *host, const char *port,
					 const char *username, enum trivalue prompt_password,
					 const char *progname, bool echo)
{
	PQExpBufferData sql;

	PGconn	   *conn;

	initPQExpBuffer(&sql);

	appendPQExpBuffer(&sql, "CLUSTER");
	if (verbose)
		appendPQExpBuffer(&sql, " VERBOSE");
	if (table)
		appendPQExpBuffer(&sql, " %s", table);
	appendPQExpBuffer(&sql, ";\n");

	conn = connectDatabase(dbname, host, port, username, prompt_password,
						   progname, false);
	if (!executeMaintenanceCommand(conn, sql.data, echo))
	{
		if (table)
			fprintf(stderr, _("%s: clustering of table \"%s\" in database \"%s\" failed: %s"),
					progname, table, dbname, PQerrorMessage(conn));
		else
			fprintf(stderr, _("%s: clustering of database \"%s\" failed: %s"),
					progname, dbname, PQerrorMessage(conn));
		PQfinish(conn);
		exit(1);
	}
	PQfinish(conn);
	termPQExpBuffer(&sql);
}
开发者ID:AXLEproject，项目名称:postgres，代码行数:35，代码来源:clusterdb.c

示例6: ScientistId

bool Database::conncetScientistToComputer(Connected newCon)
{
    bool result;

    string sciName = newCon.getNameOne();
    string comName = newCon.getNameTwo();

    int sciId = ScientistId(sciName);
    cout << "integerinn sci " << sciId;
    int comId = ScientistId(comName);
    cout << "integerinn com" << comId;

    QSqlQuery query(connectDatabase());

    query.prepare ("INSERT INTO ScientistComputersConnect VALUES(:sciId, :comId)");
    query.bindValue(":sciId", QString::number(sciId));
    query.bindValue(":comId", QString::number(comId));

    if (!query.exec())
    {
        qDebug() << query.lastError().text();
        result = false;
    }

    return result;
}
开发者ID:Dagnyb，项目名称:VLN-1，代码行数:26，代码来源:database.cpp

示例7: cluster_all_databases

static void
cluster_all_databases(const char *host, const char *port,
					  const char *username, bool password,
					  const char *progname, bool echo, bool quiet)
{
	PGconn	   *conn;
	PGresult   *result;
	int			i;

	conn = connectDatabase("template1", host, port, username, password, progname);
	result = executeQuery(conn, "SELECT datname FROM pg_database WHERE datallowconn;", progname, echo);
	PQfinish(conn);

	for (i = 0; i < PQntuples(result); i++)
	{
		char	   *dbname = PQgetvalue(result, i, 0);

		if (!quiet)
			fprintf(stderr, _("%s: clustering database \"%s\"\n"), progname, dbname);

		cluster_one_database(dbname, NULL,
							 host, port, username, password,
							 progname, echo, quiet);
	}

	PQclear(result);
}
开发者ID:berkeley-cs186，项目名称:course-fa07，代码行数:27，代码来源:clusterdb.c

示例8: query

list<Connected> Database::ComputerToScientistId(string Id)
{
    list<Connected> result = list<Connected>();

    QSqlQuery query(connectDatabase());

    query.prepare("SELECT * FROM Computers  "
                  "INNER JOIN ScientistComputersConnect, Scientists "
                  "ON ScientistComputersConnect.ScientistID = Scientists.Id "
                  "AND ScientistComputersConnect.ComputersID = Computers.Id "
                  "WHERE ScientistComputersConnect.ScientistID = :SciId "
                  "ORDER BY Scientists.Name" );

    query.bindValue(":SciId", QString::fromStdString(Id));

    if (!query.exec())
    {
        qDebug() << query.lastError().text();
    }

    query.exec();

    result = databaseToComputerScientistlist (query);

    return result;
}
开发者ID:Dagnyb，项目名称:VLN-1，代码行数:26，代码来源:database.cpp

示例9: reindex_all_databases

static void
reindex_all_databases(const char *host, const char *port,
					  const char *username, enum trivalue prompt_password,
					  const char *progname, bool echo, bool quiet)
{
	PGconn	   *conn;
	PGresult   *result;
	int			i;

	conn = connectDatabase("postgres", host, port, username, prompt_password, progname);
	result = executeQuery(conn, "SELECT datname FROM pg_database WHERE datallowconn ORDER BY 1;", progname, echo);
	PQfinish(conn);

	for (i = 0; i < PQntuples(result); i++)
	{
		char	   *dbname = PQgetvalue(result, i, 0);

		if (!quiet)
		{
			printf(_("%s: reindexing database \"%s\"\n"), progname, dbname);
			fflush(stdout);
		}

		reindex_one_database(dbname, dbname, "DATABASE", host, port, username,
							 prompt_password, progname, echo);
	}

	PQclear(result);
}
开发者ID:Epictetus，项目名称:postgres，代码行数:29，代码来源:reindexdb.c

示例10: connectDatabase

void cfDatabase::addUser(std::string uid, std::string name)
{
    connectDatabase();

    std::string input = "INSERT INTO users(uid, name) VALUES(\""+uid+"\", \""+name+"\");";
    if(sqlite3_exec(db, input.c_str(), callback, 0, &errMsg) == 1) std::cout << "[ERROR]:" << sqlite3_errmsg(db) << "\n";

    disconnectDatabase();
}
开发者ID:JeroenMathon，项目名称:ColdFusion，代码行数:9，代码来源:database.cpp

示例11: connectDatabase

void ProfileManager::update140()
{
    std::cout << "QupZilla: Upgrading profile version from 1.4.0..." << std::endl;

    connectDatabase();

    QSqlQuery query;
    query.exec("ALTER TABLE search_engines ADD COLUMN postData TEXT");
}
开发者ID:AwkwardDev，项目名称:qupzilla，代码行数:9，代码来源:profilemanager.cpp

示例12: QWidget

SelectareLunaFereastra::SelectareLunaFereastra(QSqlDatabase *db, QWidget *parent)
: QWidget(parent)
, m_db (db)
{
    // Incerc sa ma conected la baza de date
    if (!m_db || !m_db->isOpen())
    {
        m_db = new QSqlDatabase();
        if (!connectDatabase(*m_db))
        {
            showError("Eroare fisiere", "100: Anumite fisiere au nu pot fi gasite!");
            exit(0);
        }
    }

    this->setStyleSheet("QPushButton { font-size: 10pt; padding:10px; padding-left: 50px; padding-right:50px;}"
                        "QComboBox { font-size: 10pt; padding:10px; }");

    m_comboBoxAn = new QComboBox();
    construiesteAnii();
    connect(m_comboBoxAn, SIGNAL(currentIndexChanged(QString)), this, SLOT(construiesteLunile(QString)));

    m_comboBoxLuna = new QComboBox();

    if (m_comboBoxAn->count() != 0)
        construiesteLunile(m_comboBoxAn->currentText());

    m_buttonVizualizareLuna = new QPushButton("Vizualizare luna");
    connect(m_buttonVizualizareLuna, SIGNAL(clicked()), this, SLOT(vizualizareLuna()));

    m_buttonVizualizareAn = new QPushButton("Vizualizare an");
    connect(m_buttonVizualizareAn, SIGNAL(clicked()), this, SLOT(vizualizareAn()));

    m_buttonMembrii = new QPushButton("Membrii");
    connect(m_buttonMembrii, SIGNAL(clicked()), this, SLOT(vizualizareMembrii()));

    // TODO
    /**/ m_buttonMembrii->setEnabled(false);

    m_buttonIesire = new QPushButton("Iesire");
    connect(m_buttonIesire, SIGNAL(clicked()), this, SLOT(close()));

    verificAnNou();

    m_comboBoxAn->setCurrentIndex(m_comboBoxAn->count()-1);

    m_layoutPrincipal = new QVBoxLayout();
    m_layoutPrincipal->addWidget(m_comboBoxAn);
    m_layoutPrincipal->addWidget(m_comboBoxLuna);
    m_layoutPrincipal->addWidget(m_buttonVizualizareLuna);
    m_layoutPrincipal->addWidget(m_buttonVizualizareAn);
    m_layoutPrincipal->addWidget(m_buttonMembrii);
    m_layoutPrincipal->addWidget(m_buttonIesire);

    this->setLayout(m_layoutPrincipal);
}
开发者ID:Aykelith，项目名称:PlicuriBiserica，代码行数:56，代码来源:SelectareLunaFereastra.cpp

示例13: printFull

void cfDatabase::modifyUser(std::string id, std::string name)
{
    printFull();
    connectDatabase();

    std::string input = "UPDATE users SET name=\""+name+"\" WHERE ID="+id+";";
    if(sqlite3_exec(db, input.c_str(), callback, 0, &errMsg) == 1) std::cout << "[ERROR]:" << sqlite3_errmsg(db) << "\n";

    disconnectDatabase();
}
开发者ID:JeroenMathon，项目名称:ColdFusion，代码行数:10，代码来源:database.cpp

示例14: connectMaintenanceDatabase

/*
 * Try to connect to the appropriate maintenance database.
 */
PGconn *
connectMaintenanceDatabase(const char *maintenance_db, const char *pghost,
						   const char *pgport, const char *pguser,
						   enum trivalue prompt_password,
						   const char *progname)
{
	PGconn	   *conn;

	/* If a maintenance database name was specified, just connect to it. */
	if (maintenance_db)
		return connectDatabase(maintenance_db, pghost, pgport, pguser,
							   prompt_password, progname, false);

	/* Otherwise, try postgres first and then template1. */
	conn = connectDatabase("postgres", pghost, pgport, pguser, prompt_password,
						   progname, true);
	if (!conn)
		conn = connectDatabase("template1", pghost, pgport, pguser,
							   prompt_password, progname, false);

	return conn;
}
开发者ID:devmario，项目名称:postgres，代码行数:25，代码来源:common.c

示例15: reindex_one_database

static void
reindex_one_database(const char *name, const char *dbname, const char *type,
					 const char *host, const char *port, const char *username,
			  enum trivalue prompt_password, const char *progname, bool echo,
					 bool verbose)
{
	PQExpBufferData sql;

	PGconn	   *conn;

	initPQExpBuffer(&sql);

	appendPQExpBufferStr(&sql, "REINDEX");

	if (verbose)
		appendPQExpBufferStr(&sql, " (VERBOSE)");

	if (strcmp(type, "TABLE") == 0)
		appendPQExpBuffer(&sql, " TABLE %s", name);
	else if (strcmp(type, "INDEX") == 0)
		appendPQExpBuffer(&sql, " INDEX %s", name);
	else if (strcmp(type, "SCHEMA") == 0)
		appendPQExpBuffer(&sql, " SCHEMA %s", name);
	else if (strcmp(type, "DATABASE") == 0)
		appendPQExpBuffer(&sql, " DATABASE %s", fmtId(name));
	appendPQExpBufferChar(&sql, ';');

	conn = connectDatabase(dbname, host, port, username, prompt_password,
						   progname, false, false);

	if (!executeMaintenanceCommand(conn, sql.data, echo))
	{
		if (strcmp(type, "TABLE") == 0)
			fprintf(stderr, _("%s: reindexing of table \"%s\" in database \"%s\" failed: %s"),
					progname, name, dbname, PQerrorMessage(conn));
		if (strcmp(type, "INDEX") == 0)
			fprintf(stderr, _("%s: reindexing of index \"%s\" in database \"%s\" failed: %s"),
					progname, name, dbname, PQerrorMessage(conn));
		if (strcmp(type, "SCHEMA") == 0)
			fprintf(stderr, _("%s: reindexing of schema \"%s\" in database \"%s\" failed: %s"),
					progname, name, dbname, PQerrorMessage(conn));
		else
			fprintf(stderr, _("%s: reindexing of database \"%s\" failed: %s"),
					progname, dbname, PQerrorMessage(conn));
		PQfinish(conn);
		exit(1);
	}

	PQfinish(conn);
	termPQExpBuffer(&sql);
}
开发者ID:0x0FFF，项目名称:postgres，代码行数:51，代码来源:reindexdb.c


注：本文中的connectDatabase函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。