SQLite

Rtt如何使用sqlite？

发布于 2017-03-01 20:34:41 浏览：5264 订阅该版

5 个回答

bernard 2017-03-01

这家伙很懒，什么也没写！

wdgui522 2017-03-01

这家伙很懒，什么也没写！

能否提供一个能编译通过的模板工程供参考，我自行在keil中添加的文件和目录，好像编译不能通过啊，提示....componentsexternalSQLite-3.8.1SQLiteLibsqlite3.c(24637): error:  #136: struct "stat" has no field "st_blksize"

```
static int fcntlSizeHint(rtthreadFile *pFile, i64 nByte){
  if( pFile->szChunk>0 ){
    i64 nSize;                    /* Required file size */
    struct stat buf;              /* Used to hold return values of fstat() */

if( osFstat(pFile->h, &buf) ) return SQLITE_IOERR_FSTAT;

nSize = ((nByte+pFile->szChunk-1) / pFile->szChunk) * pFile->szChunk;
    if( nSize>(i64)buf.st_size ){
      /* If the OS does not have posix_fallocate(), fake it. First use
      ** ftruncate() to set the file size, then write a single byte to
      ** the last byte in each block within the extended region. This
      ** is the same technique used by glibc to implement posix_fallocate()
      ** on systems that do not have a real fallocate() system call.
      */
      int nBlk = buf.st_blksize;  /* File-system block size */
      i64 iWrite;                 /* Next offset to write to */

if( robust_ftruncate(pFile->h, nSize) ){
        pFile->lastErrno = errno;
        return rtthreadLogError(SQLITE_IOERR_TRUNCATE, "ftruncate", pFile->zPath);
      }
      iWrite = ((buf.st_size + 2*nBlk - 1)/nBlk)*nBlk-1;
      while( iWrite<nSize ){
        int nWrite = seekAndWrite(pFile, iWrite, "", 1);
        if( nWrite!=1 ) return SQLITE_IOERR_WRITE;
        iWrite += nBlk;
      }
    }
  }

return SQLITE_OK;
}

```