Menu

[r331]: / cms / trunk / benchmarks / create.cpp  Maximize  Restore  History

Download this file

118 lines (111 with data), 2.9 kB

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
#include <dbi/dbixx.h>
#include <stdio.h>
#include <ctime>
#include <stdlib.h>
#include <iostream>
using namespace std;
using namespace dbixx;
string readfile(char const *n)
{
string res;
FILE *f=fopen(n,"r");
if(!f) { perror(n); exit(1); };
char buffer[1024];
int num;
while((num=fread(buffer,1,1024,f))>0) {
buffer[num]=0;
res+=buffer;
}
fclose(f);
return res;
}
int main(int argv,char **argc)
{
if(argv!=3) {
cerr<<"Usage: POSTS COMMENTS-per-POST\n";
return 1;
}
string title="לחיות עם גרסה יציבה של דביאן";
string content=readfile("content.txt");
string comm_content=readfile("comm_content.txt");
string abstract=readfile("abstract.txt");
session sql;
try{
sql.driver("mysql");
sql.param("dbname","cppcms");
sql.param("username","root");
sql.param("password","root");
/* sql.driver("pgsql");
sql.param("dbname","cppcms");
sql.param("username","a.tonkikh");*/
/* sql.driver("sqlite3");
sql.param("dbname","cppcms.db");
sql.param("sqlite3_dbdir","../db");*/
sql.connect();
sql<<"begin",exec();
int i,j;
char buffer[256];
/* sql<<"insert into users values(1,'artik','artik')",exec();
sql<<"insert into options values(0,'כותרת הבלוג')",exec();
sql<<"insert into options values(1,'תיאור הבלוג')",exec();
for(i=0;i<5;i++) {
snprintf(buffer,sizeof(buffer),"page %d",i);
sql<<"insert into pages(author_id,title,content,is_open) "
"values(1,?,?,1)",buffer,(abstract+content),exec();
}*/
for(i=0;i<2;i++) {
snprintf(buffer,sizeof(buffer),"category %d",i);
// sql<<"insert into cats(name) values(?)",buffer,exec();
int id=sql.rowid();
cerr<<id<<endl;
snprintf(buffer,sizeof(buffer),"group %d",i);
sql<<"insert into link_cats(name) values(?)",buffer,exec();
id=sql.rowid();
for(int j=0;j<5;j++) {
snprintf(buffer,sizeof(buffer),"link %d",i*3+j);
sql<<"insert into links(cat_id,title,url,description) "
"values(?,?,'http://','')",id,buffer,exec();
}
}
/*
int P=atol(argc[1]);
int C=atol(argc[2]);
time_t tb;
time(&tb);
for(i=0;i<P;i++){
std::tm t;
time_t ct=tb+i*C;
localtime_r(&ct,&t);
sql<< "insert into posts(author_id,title,"
"abstract,content,publish,is_open,comment_count) "
"values (?,?,?,?,?,?,?)",
1,title,abstract,content,t,1,C,
exec();
int id=sql.rowid();
for(j=i%2;j<10;j+=2) {
sql<<"insert into post2cat values(?,?,?,?)",
id,j+1,t,1,exec();
}
for(j=0;j<C;j++){
ct=i*C+j;
localtime_r(&ct,&t);
sql<< "insert into comments "
"(post_id,author,email,url,content,"
" publish_time) "
"values(?,?,?,?,?,?)",
id,"someone","mail@mail.ru","www.google.com",
comm_content,t,
exec();
}
}*/
sql<<"commit",exec();
}
catch(dbixx_error const &e){
cerr<<e.what()<<endl;
}
catch(...)
{
cerr<<"Other error\n";
}
return 0;
}
MongoDB Logo MongoDB