Home | History | Annotate | Download | only in src
      1 /*
      2 ** 2010 September 31
      3 **
      4 ** The author disclaims copyright to this source code.  In place of
      5 ** a legal notice, here is a blessing:
      6 **
      7 **    May you do good and not evil.
      8 **    May you find forgiveness for yourself and forgive others.
      9 **    May you share freely, never taking more than you give.
     10 **
     11 *************************************************************************
     12 **
     13 ** This file contains a VFS "shim" - a layer that sits in between the
     14 ** pager and the real VFS.
     15 **
     16 ** This particular shim enforces a quota system on files.  One or more
     17 ** database files are in a "quota group" that is defined by a GLOB
     18 ** pattern.  A quota is set for the combined size of all files in the
     19 ** the group.  A quota of zero means "no limit".  If the total size
     20 ** of all files in the quota group is greater than the limit, then
     21 ** write requests that attempt to enlarge a file fail with SQLITE_FULL.
     22 **
     23 ** However, before returning SQLITE_FULL, the write requests invoke
     24 ** a callback function that is configurable for each quota group.
     25 ** This callback has the opportunity to enlarge the quota.  If the
     26 ** callback does enlarge the quota such that the total size of all
     27 ** files within the group is less than the new quota, then the write
     28 ** continues as if nothing had happened.
     29 */
     30 #include "sqlite3.h"
     31 #include <string.h>
     32 #include <assert.h>
     33 
     34 /*
     35 ** For an build without mutexes, no-op the mutex calls.
     36 */
     37 #if defined(SQLITE_THREADSAFE) && SQLITE_THREADSAFE==0
     38 #define sqlite3_mutex_alloc(X)    ((sqlite3_mutex*)8)
     39 #define sqlite3_mutex_free(X)
     40 #define sqlite3_mutex_enter(X)
     41 #define sqlite3_mutex_try(X)      SQLITE_OK
     42 #define sqlite3_mutex_leave(X)
     43 #define sqlite3_mutex_held(X)     ((void)(X),1)
     44 #define sqlite3_mutex_notheld(X)  ((void)(X),1)
     45 #endif /* SQLITE_THREADSAFE==0 */
     46 
     47 
     48 /************************ Object Definitions ******************************/
     49 
     50 /* Forward declaration of all object types */
     51 typedef struct quotaGroup quotaGroup;
     52 typedef struct quotaConn quotaConn;
     53 typedef struct quotaFile quotaFile;
     54 
     55 /*
     56 ** A "quota group" is a collection of files whose collective size we want
     57 ** to limit.  Each quota group is defined by a GLOB pattern.
     58 **
     59 ** There is an instance of the following object for each defined quota
     60 ** group.  This object records the GLOB pattern that defines which files
     61 ** belong to the quota group.  The object also remembers the size limit
     62 ** for the group (the quota) and the callback to be invoked when the
     63 ** sum of the sizes of the files within the group goes over the limit.
     64 **
     65 ** A quota group must be established (using sqlite3_quota_set(...))
     66 ** prior to opening any of the database connections that access files
     67 ** within the quota group.
     68 */
     69 struct quotaGroup {
     70   const char *zPattern;          /* Filename pattern to be quotaed */
     71   sqlite3_int64 iLimit;          /* Upper bound on total file size */
     72   sqlite3_int64 iSize;           /* Current size of all files */
     73   void (*xCallback)(             /* Callback invoked when going over quota */
     74      const char *zFilename,         /* Name of file whose size increases */
     75      sqlite3_int64 *piLimit,        /* IN/OUT: The current limit */
     76      sqlite3_int64 iSize,           /* Total size of all files in the group */
     77      void *pArg                     /* Client data */
     78   );
     79   void *pArg;                    /* Third argument to the xCallback() */
     80   void (*xDestroy)(void*);       /* Optional destructor for pArg */
     81   quotaGroup *pNext, **ppPrev;   /* Doubly linked list of all quota objects */
     82   quotaFile *pFiles;             /* Files within this group */
     83 };
     84 
     85 /*
     86 ** An instance of this structure represents a single file that is part
     87 ** of a quota group.  A single file can be opened multiple times.  In
     88 ** order keep multiple openings of the same file from causing the size
     89 ** of the file to count against the quota multiple times, each file
     90 ** has a unique instance of this object and multiple open connections
     91 ** to the same file each point to a single instance of this object.
     92 */
     93 struct quotaFile {
     94   char *zFilename;                /* Name of this file */
     95   quotaGroup *pGroup;             /* Quota group to which this file belongs */
     96   sqlite3_int64 iSize;            /* Current size of this file */
     97   int nRef;                       /* Number of times this file is open */
     98   quotaFile *pNext, **ppPrev;     /* Linked list of files in the same group */
     99 };
    100 
    101 /*
    102 ** An instance of the following object represents each open connection
    103 ** to a file that participates in quota tracking.  This object is a
    104 ** subclass of sqlite3_file.  The sqlite3_file object for the underlying
    105 ** VFS is appended to this structure.
    106 */
    107 struct quotaConn {
    108   sqlite3_file base;              /* Base class - must be first */
    109   quotaFile *pFile;               /* The underlying file */
    110   /* The underlying VFS sqlite3_file is appended to this object */
    111 };
    112 
    113 /************************* Global Variables **********************************/
    114 /*
    115 ** All global variables used by this file are containing within the following
    116 ** gQuota structure.
    117 */
    118 static struct {
    119   /* The pOrigVfs is the real, original underlying VFS implementation.
    120   ** Most operations pass-through to the real VFS.  This value is read-only
    121   ** during operation.  It is only modified at start-time and thus does not
    122   ** require a mutex.
    123   */
    124   sqlite3_vfs *pOrigVfs;
    125 
    126   /* The sThisVfs is the VFS structure used by this shim.  It is initialized
    127   ** at start-time and thus does not require a mutex
    128   */
    129   sqlite3_vfs sThisVfs;
    130 
    131   /* The sIoMethods defines the methods used by sqlite3_file objects
    132   ** associated with this shim.  It is initialized at start-time and does
    133   ** not require a mutex.
    134   **
    135   ** When the underlying VFS is called to open a file, it might return
    136   ** either a version 1 or a version 2 sqlite3_file object.  This shim
    137   ** has to create a wrapper sqlite3_file of the same version.  Hence
    138   ** there are two I/O method structures, one for version 1 and the other
    139   ** for version 2.
    140   */
    141   sqlite3_io_methods sIoMethodsV1;
    142   sqlite3_io_methods sIoMethodsV2;
    143 
    144   /* True when this shim as been initialized.
    145   */
    146   int isInitialized;
    147 
    148   /* For run-time access any of the other global data structures in this
    149   ** shim, the following mutex must be held.
    150   */
    151   sqlite3_mutex *pMutex;
    152 
    153   /* List of quotaGroup objects.
    154   */
    155   quotaGroup *pGroup;
    156 
    157 } gQuota;
    158 
    159 /************************* Utility Routines *********************************/
    160 /*
    161 ** Acquire and release the mutex used to serialize access to the
    162 ** list of quotaGroups.
    163 */
    164 static void quotaEnter(void){ sqlite3_mutex_enter(gQuota.pMutex); }
    165 static void quotaLeave(void){ sqlite3_mutex_leave(gQuota.pMutex); }
    166 
    167 
    168 /* If the reference count and threshold for a quotaGroup are both
    169 ** zero, then destroy the quotaGroup.
    170 */
    171 static void quotaGroupDeref(quotaGroup *pGroup){
    172   if( pGroup->pFiles==0 && pGroup->iLimit==0 ){
    173     *pGroup->ppPrev = pGroup->pNext;
    174     if( pGroup->pNext ) pGroup->pNext->ppPrev = pGroup->ppPrev;
    175     if( pGroup->xDestroy ) pGroup->xDestroy(pGroup->pArg);
    176     sqlite3_free(pGroup);
    177   }
    178 }
    179 
    180 /*
    181 ** Return TRUE if string z matches glob pattern zGlob.
    182 **
    183 ** Globbing rules:
    184 **
    185 **      '*'       Matches any sequence of zero or more characters.
    186 **
    187 **      '?'       Matches exactly one character.
    188 **
    189 **     [...]      Matches one character from the enclosed list of
    190 **                characters.
    191 **
    192 **     [^...]     Matches one character not in the enclosed list.
    193 **
    194 */
    195 static int quotaStrglob(const char *zGlob, const char *z){
    196   int c, c2;
    197   int invert;
    198   int seen;
    199 
    200   while( (c = (*(zGlob++)))!=0 ){
    201     if( c=='*' ){
    202       while( (c=(*(zGlob++))) == '*' || c=='?' ){
    203         if( c=='?' && (*(z++))==0 ) return 0;
    204       }
    205       if( c==0 ){
    206         return 1;
    207       }else if( c=='[' ){
    208         while( *z && quotaStrglob(zGlob-1,z)==0 ){
    209           z++;
    210         }
    211         return (*z)!=0;
    212       }
    213       while( (c2 = (*(z++)))!=0 ){
    214         while( c2!=c ){
    215           c2 = *(z++);
    216           if( c2==0 ) return 0;
    217         }
    218         if( quotaStrglob(zGlob,z) ) return 1;
    219       }
    220       return 0;
    221     }else if( c=='?' ){
    222       if( (*(z++))==0 ) return 0;
    223     }else if( c=='[' ){
    224       int prior_c = 0;
    225       seen = 0;
    226       invert = 0;
    227       c = *(z++);
    228       if( c==0 ) return 0;
    229       c2 = *(zGlob++);
    230       if( c2=='^' ){
    231         invert = 1;
    232         c2 = *(zGlob++);
    233       }
    234       if( c2==']' ){
    235         if( c==']' ) seen = 1;
    236         c2 = *(zGlob++);
    237       }
    238       while( c2 && c2!=']' ){
    239         if( c2=='-' && zGlob[0]!=']' && zGlob[0]!=0 && prior_c>0 ){
    240           c2 = *(zGlob++);
    241           if( c>=prior_c && c<=c2 ) seen = 1;
    242           prior_c = 0;
    243         }else{
    244           if( c==c2 ){
    245             seen = 1;
    246           }
    247           prior_c = c2;
    248         }
    249         c2 = *(zGlob++);
    250       }
    251       if( c2==0 || (seen ^ invert)==0 ) return 0;
    252     }else{
    253       if( c!=(*(z++)) ) return 0;
    254     }
    255   }
    256   return *z==0;
    257 }
    258 
    259 
    260 /* Find a quotaGroup given the filename.
    261 **
    262 ** Return a pointer to the quotaGroup object. Return NULL if not found.
    263 */
    264 static quotaGroup *quotaGroupFind(const char *zFilename){
    265   quotaGroup *p;
    266   for(p=gQuota.pGroup; p && quotaStrglob(p->zPattern, zFilename)==0;
    267       p=p->pNext){}
    268   return p;
    269 }
    270 
    271 /* Translate an sqlite3_file* that is really a quotaConn* into
    272 ** the sqlite3_file* for the underlying original VFS.
    273 */
    274 static sqlite3_file *quotaSubOpen(sqlite3_file *pConn){
    275   quotaConn *p = (quotaConn*)pConn;
    276   return (sqlite3_file*)&p[1];
    277 }
    278 
    279 /************************* VFS Method Wrappers *****************************/
    280 /*
    281 ** This is the xOpen method used for the "quota" VFS.
    282 **
    283 ** Most of the work is done by the underlying original VFS.  This method
    284 ** simply links the new file into the appropriate quota group if it is a
    285 ** file that needs to be tracked.
    286 */
    287 static int quotaOpen(
    288   sqlite3_vfs *pVfs,          /* The quota VFS */
    289   const char *zName,          /* Name of file to be opened */
    290   sqlite3_file *pConn,        /* Fill in this file descriptor */
    291   int flags,                  /* Flags to control the opening */
    292   int *pOutFlags              /* Flags showing results of opening */
    293 ){
    294   int rc;                                    /* Result code */
    295   quotaConn *pQuotaOpen;                     /* The new quota file descriptor */
    296   quotaFile *pFile;                          /* Corresponding quotaFile obj */
    297   quotaGroup *pGroup;                        /* The group file belongs to */
    298   sqlite3_file *pSubOpen;                    /* Real file descriptor */
    299   sqlite3_vfs *pOrigVfs = gQuota.pOrigVfs;   /* Real VFS */
    300 
    301   /* If the file is not a main database file or a WAL, then use the
    302   ** normal xOpen method.
    303   */
    304   if( (flags & (SQLITE_OPEN_MAIN_DB|SQLITE_OPEN_WAL))==0 ){
    305     return pOrigVfs->xOpen(pOrigVfs, zName, pConn, flags, pOutFlags);
    306   }
    307 
    308   /* If the name of the file does not match any quota group, then
    309   ** use the normal xOpen method.
    310   */
    311   quotaEnter();
    312   pGroup = quotaGroupFind(zName);
    313   if( pGroup==0 ){
    314     rc = pOrigVfs->xOpen(pOrigVfs, zName, pConn, flags, pOutFlags);
    315   }else{
    316     /* If we get to this point, it means the file needs to be quota tracked.
    317     */
    318     pQuotaOpen = (quotaConn*)pConn;
    319     pSubOpen = quotaSubOpen(pConn);
    320     rc = pOrigVfs->xOpen(pOrigVfs, zName, pSubOpen, flags, pOutFlags);
    321     if( rc==SQLITE_OK ){
    322       for(pFile=pGroup->pFiles; pFile && strcmp(pFile->zFilename, zName);
    323           pFile=pFile->pNext){}
    324       if( pFile==0 ){
    325         int nName = strlen(zName);
    326         pFile = sqlite3_malloc( sizeof(*pFile) + nName + 1 );
    327         if( pFile==0 ){
    328           quotaLeave();
    329           pSubOpen->pMethods->xClose(pSubOpen);
    330           return SQLITE_NOMEM;
    331         }
    332         memset(pFile, 0, sizeof(*pFile));
    333         pFile->zFilename = (char*)&pFile[1];
    334         memcpy(pFile->zFilename, zName, nName+1);
    335         pFile->pNext = pGroup->pFiles;
    336         if( pGroup->pFiles ) pGroup->pFiles->ppPrev = &pFile->pNext;
    337         pFile->ppPrev = &pGroup->pFiles;
    338         pGroup->pFiles = pFile;
    339         pFile->pGroup = pGroup;
    340       }
    341       pFile->nRef++;
    342       pQuotaOpen->pFile = pFile;
    343       if( pSubOpen->pMethods->iVersion==1 ){
    344         pQuotaOpen->base.pMethods = &gQuota.sIoMethodsV1;
    345       }else{
    346         pQuotaOpen->base.pMethods = &gQuota.sIoMethodsV2;
    347       }
    348     }
    349   }
    350   quotaLeave();
    351   return rc;
    352 }
    353 
    354 /************************ I/O Method Wrappers *******************************/
    355 
    356 /* xClose requests get passed through to the original VFS.  But we
    357 ** also have to unlink the quotaConn from the quotaFile and quotaGroup.
    358 ** The quotaFile and/or quotaGroup are freed if they are no longer in use.
    359 */
    360 static int quotaClose(sqlite3_file *pConn){
    361   quotaConn *p = (quotaConn*)pConn;
    362   quotaFile *pFile = p->pFile;
    363   sqlite3_file *pSubOpen = quotaSubOpen(pConn);
    364   int rc;
    365   rc = pSubOpen->pMethods->xClose(pSubOpen);
    366   quotaEnter();
    367   pFile->nRef--;
    368   if( pFile->nRef==0 ){
    369     quotaGroup *pGroup = pFile->pGroup;
    370     pGroup->iSize -= pFile->iSize;
    371     if( pFile->pNext ) pFile->pNext->ppPrev = pFile->ppPrev;
    372     *pFile->ppPrev = pFile->pNext;
    373     quotaGroupDeref(pGroup);
    374     sqlite3_free(pFile);
    375   }
    376   quotaLeave();
    377   return rc;
    378 }
    379 
    380 /* Pass xRead requests directory thru to the original VFS without
    381 ** further processing.
    382 */
    383 static int quotaRead(
    384   sqlite3_file *pConn,
    385   void *pBuf,
    386   int iAmt,
    387   sqlite3_int64 iOfst
    388 ){
    389   sqlite3_file *pSubOpen = quotaSubOpen(pConn);
    390   return pSubOpen->pMethods->xRead(pSubOpen, pBuf, iAmt, iOfst);
    391 }
    392 
    393 /* Check xWrite requests to see if they expand the file.  If they do,
    394 ** the perform a quota check before passing them through to the
    395 ** original VFS.
    396 */
    397 static int quotaWrite(
    398   sqlite3_file *pConn,
    399   const void *pBuf,
    400   int iAmt,
    401   sqlite3_int64 iOfst
    402 ){
    403   quotaConn *p = (quotaConn*)pConn;
    404   sqlite3_file *pSubOpen = quotaSubOpen(pConn);
    405   sqlite3_int64 iEnd = iOfst+iAmt;
    406   quotaGroup *pGroup;
    407   quotaFile *pFile = p->pFile;
    408   sqlite3_int64 szNew;
    409 
    410   if( pFile->iSize<iEnd ){
    411     pGroup = pFile->pGroup;
    412     quotaEnter();
    413     szNew = pGroup->iSize - pFile->iSize + iEnd;
    414     if( szNew>pGroup->iLimit && pGroup->iLimit>0 ){
    415       if( pGroup->xCallback ){
    416         pGroup->xCallback(pFile->zFilename, &pGroup->iLimit, szNew,
    417                           pGroup->pArg);
    418       }
    419       if( szNew>pGroup->iLimit && pGroup->iLimit>0 ){
    420         quotaLeave();
    421         return SQLITE_FULL;
    422       }
    423     }
    424     pGroup->iSize = szNew;
    425     pFile->iSize = iEnd;
    426     quotaLeave();
    427   }
    428   return pSubOpen->pMethods->xWrite(pSubOpen, pBuf, iAmt, iOfst);
    429 }
    430 
    431 /* Pass xTruncate requests thru to the original VFS.  If the
    432 ** success, update the file size.
    433 */
    434 static int quotaTruncate(sqlite3_file *pConn, sqlite3_int64 size){
    435   quotaConn *p = (quotaConn*)pConn;
    436   sqlite3_file *pSubOpen = quotaSubOpen(pConn);
    437   int rc = pSubOpen->pMethods->xTruncate(pSubOpen, size);
    438   quotaFile *pFile = p->pFile;
    439   quotaGroup *pGroup;
    440   if( rc==SQLITE_OK ){
    441     quotaEnter();
    442     pGroup = pFile->pGroup;
    443     pGroup->iSize -= pFile->iSize;
    444     pFile->iSize = size;
    445     pGroup->iSize += size;
    446     quotaLeave();
    447   }
    448   return rc;
    449 }
    450 
    451 /* Pass xSync requests through to the original VFS without change
    452 */
    453 static int quotaSync(sqlite3_file *pConn, int flags){
    454   sqlite3_file *pSubOpen = quotaSubOpen(pConn);
    455   return pSubOpen->pMethods->xSync(pSubOpen, flags);
    456 }
    457 
    458 /* Pass xFileSize requests through to the original VFS but then
    459 ** update the quotaGroup with the new size before returning.
    460 */
    461 static int quotaFileSize(sqlite3_file *pConn, sqlite3_int64 *pSize){
    462   quotaConn *p = (quotaConn*)pConn;
    463   sqlite3_file *pSubOpen = quotaSubOpen(pConn);
    464   quotaFile *pFile = p->pFile;
    465   quotaGroup *pGroup;
    466   sqlite3_int64 sz;
    467   int rc;
    468 
    469   rc = pSubOpen->pMethods->xFileSize(pSubOpen, &sz);
    470   if( rc==SQLITE_OK ){
    471     quotaEnter();
    472     pGroup = pFile->pGroup;
    473     pGroup->iSize -= pFile->iSize;
    474     pFile->iSize = sz;
    475     pGroup->iSize += sz;
    476     quotaLeave();
    477     *pSize = sz;
    478   }
    479   return rc;
    480 }
    481 
    482 /* Pass xLock requests through to the original VFS unchanged.
    483 */
    484 static int quotaLock(sqlite3_file *pConn, int lock){
    485   sqlite3_file *pSubOpen = quotaSubOpen(pConn);
    486   return pSubOpen->pMethods->xLock(pSubOpen, lock);
    487 }
    488 
    489 /* Pass xUnlock requests through to the original VFS unchanged.
    490 */
    491 static int quotaUnlock(sqlite3_file *pConn, int lock){
    492   sqlite3_file *pSubOpen = quotaSubOpen(pConn);
    493   return pSubOpen->pMethods->xUnlock(pSubOpen, lock);
    494 }
    495 
    496 /* Pass xCheckReservedLock requests through to the original VFS unchanged.
    497 */
    498 static int quotaCheckReservedLock(sqlite3_file *pConn, int *pResOut){
    499   sqlite3_file *pSubOpen = quotaSubOpen(pConn);
    500   return pSubOpen->pMethods->xCheckReservedLock(pSubOpen, pResOut);
    501 }
    502 
    503 /* Pass xFileControl requests through to the original VFS unchanged.
    504 */
    505 static int quotaFileControl(sqlite3_file *pConn, int op, void *pArg){
    506   sqlite3_file *pSubOpen = quotaSubOpen(pConn);
    507   return pSubOpen->pMethods->xFileControl(pSubOpen, op, pArg);
    508 }
    509 
    510 /* Pass xSectorSize requests through to the original VFS unchanged.
    511 */
    512 static int quotaSectorSize(sqlite3_file *pConn){
    513   sqlite3_file *pSubOpen = quotaSubOpen(pConn);
    514   return pSubOpen->pMethods->xSectorSize(pSubOpen);
    515 }
    516 
    517 /* Pass xDeviceCharacteristics requests through to the original VFS unchanged.
    518 */
    519 static int quotaDeviceCharacteristics(sqlite3_file *pConn){
    520   sqlite3_file *pSubOpen = quotaSubOpen(pConn);
    521   return pSubOpen->pMethods->xDeviceCharacteristics(pSubOpen);
    522 }
    523 
    524 /* Pass xShmMap requests through to the original VFS unchanged.
    525 */
    526 static int quotaShmMap(
    527   sqlite3_file *pConn,            /* Handle open on database file */
    528   int iRegion,                    /* Region to retrieve */
    529   int szRegion,                   /* Size of regions */
    530   int bExtend,                    /* True to extend file if necessary */
    531   void volatile **pp              /* OUT: Mapped memory */
    532 ){
    533   sqlite3_file *pSubOpen = quotaSubOpen(pConn);
    534   return pSubOpen->pMethods->xShmMap(pSubOpen, iRegion, szRegion, bExtend, pp);
    535 }
    536 
    537 /* Pass xShmLock requests through to the original VFS unchanged.
    538 */
    539 static int quotaShmLock(
    540   sqlite3_file *pConn,       /* Database file holding the shared memory */
    541   int ofst,                  /* First lock to acquire or release */
    542   int n,                     /* Number of locks to acquire or release */
    543   int flags                  /* What to do with the lock */
    544 ){
    545   sqlite3_file *pSubOpen = quotaSubOpen(pConn);
    546   return pSubOpen->pMethods->xShmLock(pSubOpen, ofst, n, flags);
    547 }
    548 
    549 /* Pass xShmBarrier requests through to the original VFS unchanged.
    550 */
    551 static void quotaShmBarrier(sqlite3_file *pConn){
    552   sqlite3_file *pSubOpen = quotaSubOpen(pConn);
    553   pSubOpen->pMethods->xShmBarrier(pSubOpen);
    554 }
    555 
    556 /* Pass xShmUnmap requests through to the original VFS unchanged.
    557 */
    558 static int quotaShmUnmap(sqlite3_file *pConn, int deleteFlag){
    559   sqlite3_file *pSubOpen = quotaSubOpen(pConn);
    560   return pSubOpen->pMethods->xShmUnmap(pSubOpen, deleteFlag);
    561 }
    562 
    563 /************************** Public Interfaces *****************************/
    564 /*
    565 ** Initialize the quota VFS shim.  Use the VFS named zOrigVfsName
    566 ** as the VFS that does the actual work.  Use the default if
    567 ** zOrigVfsName==NULL.
    568 **
    569 ** The quota VFS shim is named "quota".  It will become the default
    570 ** VFS if makeDefault is non-zero.
    571 **
    572 ** THIS ROUTINE IS NOT THREADSAFE.  Call this routine exactly once
    573 ** during start-up.
    574 */
    575 int sqlite3_quota_initialize(const char *zOrigVfsName, int makeDefault){
    576   sqlite3_vfs *pOrigVfs;
    577   if( gQuota.isInitialized ) return SQLITE_MISUSE;
    578   pOrigVfs = sqlite3_vfs_find(zOrigVfsName);
    579   if( pOrigVfs==0 ) return SQLITE_ERROR;
    580   assert( pOrigVfs!=&gQuota.sThisVfs );
    581   gQuota.pMutex = sqlite3_mutex_alloc(SQLITE_MUTEX_FAST);
    582   if( !gQuota.pMutex ){
    583     return SQLITE_NOMEM;
    584   }
    585   gQuota.isInitialized = 1;
    586   gQuota.pOrigVfs = pOrigVfs;
    587   gQuota.sThisVfs = *pOrigVfs;
    588   gQuota.sThisVfs.xOpen = quotaOpen;
    589   gQuota.sThisVfs.szOsFile += sizeof(quotaConn);
    590   gQuota.sThisVfs.zName = "quota";
    591   gQuota.sIoMethodsV1.iVersion = 1;
    592   gQuota.sIoMethodsV1.xClose = quotaClose;
    593   gQuota.sIoMethodsV1.xRead = quotaRead;
    594   gQuota.sIoMethodsV1.xWrite = quotaWrite;
    595   gQuota.sIoMethodsV1.xTruncate = quotaTruncate;
    596   gQuota.sIoMethodsV1.xSync = quotaSync;
    597   gQuota.sIoMethodsV1.xFileSize = quotaFileSize;
    598   gQuota.sIoMethodsV1.xLock = quotaLock;
    599   gQuota.sIoMethodsV1.xUnlock = quotaUnlock;
    600   gQuota.sIoMethodsV1.xCheckReservedLock = quotaCheckReservedLock;
    601   gQuota.sIoMethodsV1.xFileControl = quotaFileControl;
    602   gQuota.sIoMethodsV1.xSectorSize = quotaSectorSize;
    603   gQuota.sIoMethodsV1.xDeviceCharacteristics = quotaDeviceCharacteristics;
    604   gQuota.sIoMethodsV2 = gQuota.sIoMethodsV1;
    605   gQuota.sIoMethodsV2.iVersion = 2;
    606   gQuota.sIoMethodsV2.xShmMap = quotaShmMap;
    607   gQuota.sIoMethodsV2.xShmLock = quotaShmLock;
    608   gQuota.sIoMethodsV2.xShmBarrier = quotaShmBarrier;
    609   gQuota.sIoMethodsV2.xShmUnmap = quotaShmUnmap;
    610   sqlite3_vfs_register(&gQuota.sThisVfs, makeDefault);
    611   return SQLITE_OK;
    612 }
    613 
    614 /*
    615 ** Shutdown the quota system.
    616 **
    617 ** All SQLite database connections must be closed before calling this
    618 ** routine.
    619 **
    620 ** THIS ROUTINE IS NOT THREADSAFE.  Call this routine exactly one while
    621 ** shutting down in order to free all remaining quota groups.
    622 */
    623 int sqlite3_quota_shutdown(void){
    624   quotaGroup *pGroup;
    625   if( gQuota.isInitialized==0 ) return SQLITE_MISUSE;
    626   for(pGroup=gQuota.pGroup; pGroup; pGroup=pGroup->pNext){
    627     if( pGroup->pFiles ) return SQLITE_MISUSE;
    628   }
    629   while( gQuota.pGroup ){
    630     pGroup = gQuota.pGroup;
    631     gQuota.pGroup = pGroup->pNext;
    632     pGroup->iLimit = 0;
    633     quotaGroupDeref(pGroup);
    634   }
    635   gQuota.isInitialized = 0;
    636   sqlite3_mutex_free(gQuota.pMutex);
    637   sqlite3_vfs_unregister(&gQuota.sThisVfs);
    638   memset(&gQuota, 0, sizeof(gQuota));
    639   return SQLITE_OK;
    640 }
    641 
    642 /*
    643 ** Create or destroy a quota group.
    644 **
    645 ** The quota group is defined by the zPattern.  When calling this routine
    646 ** with a zPattern for a quota group that already exists, this routine
    647 ** merely updates the iLimit, xCallback, and pArg values for that quota
    648 ** group.  If zPattern is new, then a new quota group is created.
    649 **
    650 ** If the iLimit for a quota group is set to zero, then the quota group
    651 ** is disabled and will be deleted when the last database connection using
    652 ** the quota group is closed.
    653 **
    654 ** Calling this routine on a zPattern that does not exist and with a
    655 ** zero iLimit is a no-op.
    656 **
    657 ** A quota group must exist with a non-zero iLimit prior to opening
    658 ** database connections if those connections are to participate in the
    659 ** quota group.  Creating a quota group does not affect database connections
    660 ** that are already open.
    661 */
    662 int sqlite3_quota_set(
    663   const char *zPattern,           /* The filename pattern */
    664   sqlite3_int64 iLimit,           /* New quota to set for this quota group */
    665   void (*xCallback)(              /* Callback invoked when going over quota */
    666      const char *zFilename,         /* Name of file whose size increases */
    667      sqlite3_int64 *piLimit,        /* IN/OUT: The current limit */
    668      sqlite3_int64 iSize,           /* Total size of all files in the group */
    669      void *pArg                     /* Client data */
    670   ),
    671   void *pArg,                     /* client data passed thru to callback */
    672   void (*xDestroy)(void*)         /* Optional destructor for pArg */
    673 ){
    674   quotaGroup *pGroup;
    675   quotaEnter();
    676   pGroup = gQuota.pGroup;
    677   while( pGroup && strcmp(pGroup->zPattern, zPattern)!=0 ){
    678     pGroup = pGroup->pNext;
    679   }
    680   if( pGroup==0 ){
    681     int nPattern = strlen(zPattern);
    682     if( iLimit<=0 ){
    683       quotaLeave();
    684       return SQLITE_OK;
    685     }
    686     pGroup = sqlite3_malloc( sizeof(*pGroup) + nPattern + 1 );
    687     if( pGroup==0 ){
    688       quotaLeave();
    689       return SQLITE_NOMEM;
    690     }
    691     memset(pGroup, 0, sizeof(*pGroup));
    692     pGroup->zPattern = (char*)&pGroup[1];
    693     memcpy((char *)pGroup->zPattern, zPattern, nPattern+1);
    694     if( gQuota.pGroup ) gQuota.pGroup->ppPrev = &pGroup->pNext;
    695     pGroup->pNext = gQuota.pGroup;
    696     pGroup->ppPrev = &gQuota.pGroup;
    697     gQuota.pGroup = pGroup;
    698   }
    699   pGroup->iLimit = iLimit;
    700   pGroup->xCallback = xCallback;
    701   if( pGroup->xDestroy && pGroup->pArg!=pArg ){
    702     pGroup->xDestroy(pGroup->pArg);
    703   }
    704   pGroup->pArg = pArg;
    705   pGroup->xDestroy = xDestroy;
    706   quotaGroupDeref(pGroup);
    707   quotaLeave();
    708   return SQLITE_OK;
    709 }
    710 
    711 
    712 /***************************** Test Code ***********************************/
    713 #ifdef SQLITE_TEST
    714 #include <tcl.h>
    715 
    716 /*
    717 ** Argument passed to a TCL quota-over-limit callback.
    718 */
    719 typedef struct TclQuotaCallback TclQuotaCallback;
    720 struct TclQuotaCallback {
    721   Tcl_Interp *interp;    /* Interpreter in which to run the script */
    722   Tcl_Obj *pScript;      /* Script to be run */
    723 };
    724 
    725 extern const char *sqlite3TestErrorName(int);
    726 
    727 
    728 /*
    729 ** This is the callback from a quota-over-limit.
    730 */
    731 static void tclQuotaCallback(
    732   const char *zFilename,          /* Name of file whose size increases */
    733   sqlite3_int64 *piLimit,         /* IN/OUT: The current limit */
    734   sqlite3_int64 iSize,            /* Total size of all files in the group */
    735   void *pArg                      /* Client data */
    736 ){
    737   TclQuotaCallback *p;            /* Callback script object */
    738   Tcl_Obj *pEval;                 /* Script to evaluate */
    739   Tcl_Obj *pVarname;              /* Name of variable to pass as 2nd arg */
    740   unsigned int rnd;               /* Random part of pVarname */
    741   int rc;                         /* Tcl error code */
    742 
    743   p = (TclQuotaCallback *)pArg;
    744   if( p==0 ) return;
    745 
    746   pVarname = Tcl_NewStringObj("::piLimit_", -1);
    747   Tcl_IncrRefCount(pVarname);
    748   sqlite3_randomness(sizeof(rnd), (void *)&rnd);
    749   Tcl_AppendObjToObj(pVarname, Tcl_NewIntObj((int)(rnd&0x7FFFFFFF)));
    750   Tcl_ObjSetVar2(p->interp, pVarname, 0, Tcl_NewWideIntObj(*piLimit), 0);
    751 
    752   pEval = Tcl_DuplicateObj(p->pScript);
    753   Tcl_IncrRefCount(pEval);
    754   Tcl_ListObjAppendElement(0, pEval, Tcl_NewStringObj(zFilename, -1));
    755   Tcl_ListObjAppendElement(0, pEval, pVarname);
    756   Tcl_ListObjAppendElement(0, pEval, Tcl_NewWideIntObj(iSize));
    757   rc = Tcl_EvalObjEx(p->interp, pEval, TCL_EVAL_GLOBAL);
    758 
    759   if( rc==TCL_OK ){
    760     Tcl_Obj *pLimit = Tcl_ObjGetVar2(p->interp, pVarname, 0, 0);
    761     rc = Tcl_GetWideIntFromObj(p->interp, pLimit, piLimit);
    762     Tcl_UnsetVar(p->interp, Tcl_GetString(pVarname), 0);
    763   }
    764 
    765   Tcl_DecrRefCount(pEval);
    766   Tcl_DecrRefCount(pVarname);
    767   if( rc!=TCL_OK ) Tcl_BackgroundError(p->interp);
    768 }
    769 
    770 /*
    771 ** Destructor for a TCL quota-over-limit callback.
    772 */
    773 static void tclCallbackDestructor(void *pObj){
    774   TclQuotaCallback *p = (TclQuotaCallback*)pObj;
    775   if( p ){
    776     Tcl_DecrRefCount(p->pScript);
    777     sqlite3_free((char *)p);
    778   }
    779 }
    780 
    781 /*
    782 ** tclcmd: sqlite3_quota_initialize NAME MAKEDEFAULT
    783 */
    784 static int test_quota_initialize(
    785   void * clientData,
    786   Tcl_Interp *interp,
    787   int objc,
    788   Tcl_Obj *CONST objv[]
    789 ){
    790   const char *zName;              /* Name of new quota VFS */
    791   int makeDefault;                /* True to make the new VFS the default */
    792   int rc;                         /* Value returned by quota_initialize() */
    793 
    794   /* Process arguments */
    795   if( objc!=3 ){
    796     Tcl_WrongNumArgs(interp, 1, objv, "NAME MAKEDEFAULT");
    797     return TCL_ERROR;
    798   }
    799   zName = Tcl_GetString(objv[1]);
    800   if( Tcl_GetBooleanFromObj(interp, objv[2], &makeDefault) ) return TCL_ERROR;
    801   if( zName[0]=='\0' ) zName = 0;
    802 
    803   /* Call sqlite3_quota_initialize() */
    804   rc = sqlite3_quota_initialize(zName, makeDefault);
    805   Tcl_SetResult(interp, (char *)sqlite3TestErrorName(rc), TCL_STATIC);
    806 
    807   return TCL_OK;
    808 }
    809 
    810 /*
    811 ** tclcmd: sqlite3_quota_shutdown
    812 */
    813 static int test_quota_shutdown(
    814   void * clientData,
    815   Tcl_Interp *interp,
    816   int objc,
    817   Tcl_Obj *CONST objv[]
    818 ){
    819   int rc;                         /* Value returned by quota_shutdown() */
    820 
    821   if( objc!=1 ){
    822     Tcl_WrongNumArgs(interp, 1, objv, "");
    823     return TCL_ERROR;
    824   }
    825 
    826   /* Call sqlite3_quota_shutdown() */
    827   rc = sqlite3_quota_shutdown();
    828   Tcl_SetResult(interp, (char *)sqlite3TestErrorName(rc), TCL_STATIC);
    829 
    830   return TCL_OK;
    831 }
    832 
    833 /*
    834 ** tclcmd: sqlite3_quota_set PATTERN LIMIT SCRIPT
    835 */
    836 static int test_quota_set(
    837   void * clientData,
    838   Tcl_Interp *interp,
    839   int objc,
    840   Tcl_Obj *CONST objv[]
    841 ){
    842   const char *zPattern;           /* File pattern to configure */
    843   sqlite3_int64 iLimit;           /* Initial quota in bytes */
    844   Tcl_Obj *pScript;               /* Tcl script to invoke to increase quota */
    845   int rc;                         /* Value returned by quota_set() */
    846   TclQuotaCallback *p;            /* Callback object */
    847   int nScript;                    /* Length of callback script */
    848   void (*xDestroy)(void*);        /* Optional destructor for pArg */
    849   void (*xCallback)(const char *, sqlite3_int64 *, sqlite3_int64, void *);
    850 
    851   /* Process arguments */
    852   if( objc!=4 ){
    853     Tcl_WrongNumArgs(interp, 1, objv, "PATTERN LIMIT SCRIPT");
    854     return TCL_ERROR;
    855   }
    856   zPattern = Tcl_GetString(objv[1]);
    857   if( Tcl_GetWideIntFromObj(interp, objv[2], &iLimit) ) return TCL_ERROR;
    858   pScript = objv[3];
    859   Tcl_GetStringFromObj(pScript, &nScript);
    860 
    861   if( nScript>0 ){
    862     /* Allocate a TclQuotaCallback object */
    863     p = (TclQuotaCallback *)sqlite3_malloc(sizeof(TclQuotaCallback));
    864     if( !p ){
    865       Tcl_SetResult(interp, (char *)"SQLITE_NOMEM", TCL_STATIC);
    866       return TCL_OK;
    867     }
    868     memset(p, 0, sizeof(TclQuotaCallback));
    869     p->interp = interp;
    870     Tcl_IncrRefCount(pScript);
    871     p->pScript = pScript;
    872     xDestroy = tclCallbackDestructor;
    873     xCallback = tclQuotaCallback;
    874   }else{
    875     p = 0;
    876     xDestroy = 0;
    877     xCallback = 0;
    878   }
    879 
    880   /* Invoke sqlite3_quota_set() */
    881   rc = sqlite3_quota_set(zPattern, iLimit, xCallback, (void*)p, xDestroy);
    882 
    883   Tcl_SetResult(interp, (char *)sqlite3TestErrorName(rc), TCL_STATIC);
    884   return TCL_OK;
    885 }
    886 
    887 /*
    888 ** tclcmd:  sqlite3_quota_dump
    889 */
    890 static int test_quota_dump(
    891   void * clientData,
    892   Tcl_Interp *interp,
    893   int objc,
    894   Tcl_Obj *CONST objv[]
    895 ){
    896   Tcl_Obj *pResult;
    897   Tcl_Obj *pGroupTerm;
    898   Tcl_Obj *pFileTerm;
    899   quotaGroup *pGroup;
    900   quotaFile *pFile;
    901 
    902   pResult = Tcl_NewObj();
    903   quotaEnter();
    904   for(pGroup=gQuota.pGroup; pGroup; pGroup=pGroup->pNext){
    905     pGroupTerm = Tcl_NewObj();
    906     Tcl_ListObjAppendElement(interp, pGroupTerm,
    907           Tcl_NewStringObj(pGroup->zPattern, -1));
    908     Tcl_ListObjAppendElement(interp, pGroupTerm,
    909           Tcl_NewWideIntObj(pGroup->iLimit));
    910     Tcl_ListObjAppendElement(interp, pGroupTerm,
    911           Tcl_NewWideIntObj(pGroup->iSize));
    912     for(pFile=pGroup->pFiles; pFile; pFile=pFile->pNext){
    913       pFileTerm = Tcl_NewObj();
    914       Tcl_ListObjAppendElement(interp, pFileTerm,
    915             Tcl_NewStringObj(pFile->zFilename, -1));
    916       Tcl_ListObjAppendElement(interp, pFileTerm,
    917             Tcl_NewWideIntObj(pFile->iSize));
    918       Tcl_ListObjAppendElement(interp, pFileTerm,
    919             Tcl_NewWideIntObj(pFile->nRef));
    920       Tcl_ListObjAppendElement(interp, pGroupTerm, pFileTerm);
    921     }
    922     Tcl_ListObjAppendElement(interp, pResult, pGroupTerm);
    923   }
    924   quotaLeave();
    925   Tcl_SetObjResult(interp, pResult);
    926   return TCL_OK;
    927 }
    928 
    929 /*
    930 ** This routine registers the custom TCL commands defined in this
    931 ** module.  This should be the only procedure visible from outside
    932 ** of this module.
    933 */
    934 int Sqlitequota_Init(Tcl_Interp *interp){
    935   static struct {
    936      char *zName;
    937      Tcl_ObjCmdProc *xProc;
    938   } aCmd[] = {
    939     { "sqlite3_quota_initialize", test_quota_initialize },
    940     { "sqlite3_quota_shutdown", test_quota_shutdown },
    941     { "sqlite3_quota_set", test_quota_set },
    942     { "sqlite3_quota_dump", test_quota_dump },
    943   };
    944   int i;
    945 
    946   for(i=0; i<sizeof(aCmd)/sizeof(aCmd[0]); i++){
    947     Tcl_CreateObjCommand(interp, aCmd[i].zName, aCmd[i].xProc, 0, 0);
    948   }
    949 
    950   return TCL_OK;
    951 }
    952 #endif
    953