我有一个带有长with字段的mysql表。我已经成功地将blob记录插入到表中,并使用python将它们解压缩回磁盘上的文件中。
现在,我希望从表中选择最新版本的blob,并使用c++和mysql连接器将其写入磁盘上的文件。这是我到目前为止掌握的密码。
它似乎适用于较小的blobs,但对我数据库中的大blobs则不够。最大缓冲区大小似乎接近1000000。
如何从mysql选择中编写大的长from文件?
string appname = "rocket.exe";
driver = get_driver_instance();
con = driver->connect(mysql_server, mysql_user, mysql_password);
con->setSchema("app");
stmt = con->createStatement();
sqlstring =
"select installer"
" from app_table"
" where appname = '" + appname + "'"
" order by version desc "
" limit 1";
std::istream *blob;
res = stmt->executeQuery(sqlstring);
while (res->next()) {
blob = res->getBlob("installer");
}
char buffer[1000000];
memset(buffer, '\0', 1000000);
blob->read((char*)buffer,1000000);
std::ofstream outfile ("rocket2.exe",std::ofstream::binary);
outfile.write (buffer,1000000);
outfile.close();
delete res; // resultset
delete stmt; // statement
delete con; // connection 发布于 2013-10-13 19:32:17
发布于 2013-10-14 15:06:09
其中缓冲区定义为put:
std::vector<char> buffer(1000000, '\0');
blob->read(&buffer[0], buffer.size()); https://stackoverflow.com/questions/19166612
复制相似问题