SQLite attach detach 心得

c++ 伪代码

// 1. 新建对象
sqlite3* db=NULL;

// 2. open
const char *srcdbfile="c:\\xxxxx\\xxxx\xx1.db"
const char *another_dbfile="c:\\xxxxx\\xxxx\xx2.db"
sqlite3_open(srcdbfile, &db);

// 3.attach 
//注意 ATTACH 进来的 another_dbfile 一定要与已经 open 的 srcdbfile 放同一路径下 attach 才有效果.
char sql[512]={0}; char* error=0;
sprintf_s(sql,sizeof(sql),"detach database 'attach_db';"); //先尝试释放掉
int ret = sqlite3_exec(db, sql, 0, 0, &error);

sprintf_s(sql,sizeof(sql),"attach database '%s' as 'attach_db';",another_dbfile); // 再附加
ret = sqlite3_exec(db, sql, 0, 0, &error);

sprintf_s(sql,sizeof(sql),"begin transaction;");//开启事务
sqlite3_exec(db, sql, 0, 0, &error);

// 5.这步复杂的 sql 操作过程[略去]
sprintf_s(sql,sizeof(sql),"..................................................."); 
ret = sqlite3_exec(db, sql, 0, 0, &error);

// 6.分离
sprintf_s(sql,sizeof(sql),"detach database 'attach_db';"); 
ret = sqlite3_exec(db, sql, 0, 0, &error);

sprintf_s(sql,sizeof(sql),"commit transaction;");//提交事务
sqlite3_exec(db, sql, 0, 0, &error);

// 7.close
sqlite3_close(db)