Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- void RequetteBDD::add(Files::Fichier file)
- {
- string query = "INSERT INTO files(titre,url,type,txt,lastcrawl) VALUES (?,?,?,?,?)";
- sql::PreparedStatement *prep_stmt;
- prep_stmt = con->prepareStatement(query);
- prep_stmt->setString(1,file.getNom()); //title
- prep_stmt->setString(2,file.getURL().getUri()); //url
- prep_stmt->setInt(3,file.getTypeInt()); //type
- //i also try :
- istringstream stream(file.getTextFull());
- prep_stmt->setBlob(4,&stream);
- //but the saved length was exactly the same.
- prep_stmt->setString(4,file.getTextFull()); //here is the probleme
- prep_stmt->setInt(5,time(NULL)); //timstamp
- prep_stmt->execute();
- delete prep_stmt;
- }
- CREATE TABLE IF NOT EXISTS `files` (
- `id` int(11) NOT NULL AUTO_INCREMENT ,
- `titre` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
- `url` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
- `type` int(1) NOT NULL DEFAULT '0' COMMENT ,
- `txt` longtext COLLATE utf8_unicode_ci NOT NULL,
- `lastcrawl` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement