sl@0: /*
sl@0: **
sl@0: ** Portions Copyright (c) 2008 Nokia Corporation and/or its subsidiaries. All rights reserved.
sl@0: **
sl@0: ** SQLite uses this code for testing only.  It is not a part of
sl@0: ** the SQLite library.  This file implements two new TCL commands
sl@0: ** "md5" and "md5file" that compute md5 checksums on arbitrary text
sl@0: ** and on complete files.  These commands are used by the "testfixture"
sl@0: ** program to help verify the correct operation of the SQLite library.
sl@0: **
sl@0: ** The original use of these TCL commands was to test the ROLLBACK
sl@0: ** feature of SQLite.  First compute the MD5-checksum of the database.
sl@0: ** Then make some changes but rollback the changes rather than commit
sl@0: ** them.  Compute a second MD5-checksum of the file and verify that the
sl@0: ** two checksums are the same.  Such is the original use of this code.
sl@0: ** New uses may have been added since this comment was written.
sl@0: **
sl@0: ** $Id: test_md5.c,v 1.8 2008/05/16 04:51:55 danielk1977 Exp $
sl@0: */
sl@0: /*
sl@0:  * This code implements the MD5 message-digest algorithm.
sl@0:  * The algorithm is due to Ron Rivest.  This code was
sl@0:  * written by Colin Plumb in 1993, no copyright is claimed.
sl@0:  * This code is in the public domain; do with it what you wish.
sl@0:  *
sl@0:  * Equivalent code is available from RSA Data Security, Inc.
sl@0:  * This code has been tested against that, and is equivalent,
sl@0:  * except that you don't need to include two pages of legalese
sl@0:  * with every copy.
sl@0:  *
sl@0:  * To compute the message digest of a chunk of bytes, declare an
sl@0:  * MD5Context structure, pass it to MD5Init, call MD5Update as
sl@0:  * needed on buffers full of bytes, and then call MD5Final, which
sl@0:  * will fill a supplied 16-byte array with the digest.
sl@0:  */
sl@0: #include "tcl.h"
sl@0: #include <string.h>
sl@0: #include "sqlite3.h"
sl@0: #include <sys/param.h>
sl@0: 
sl@0: /* Symbian OS */
sl@0: extern char* GetFullFilePath(char* aPath, const char* aFileName);
sl@0: 
sl@0: /*
sl@0:  * If compiled on a machine that doesn't have a 32-bit integer,
sl@0:  * you just set "uint32" to the appropriate datatype for an
sl@0:  * unsigned 32-bit integer.  For example:
sl@0:  *
sl@0:  *       cc -Duint32='unsigned long' md5.c
sl@0:  *
sl@0:  */
sl@0: #ifndef uint32
sl@0: #  define uint32 unsigned int
sl@0: #endif
sl@0: 
sl@0: struct Context {
sl@0:   int isInit;
sl@0:   uint32 buf[4];
sl@0:   uint32 bits[2];
sl@0:   unsigned char in[64];
sl@0: };
sl@0: typedef struct Context MD5Context;
sl@0: 
sl@0: /*
sl@0:  * Note: this code is harmless on little-endian machines.
sl@0:  */
sl@0: static void byteReverse (unsigned char *buf, unsigned longs){
sl@0:         uint32 t;
sl@0:         do {
sl@0:                 t = (uint32)((unsigned)buf[3]<<8 | buf[2]) << 16 |
sl@0:                             ((unsigned)buf[1]<<8 | buf[0]);
sl@0:                 *(uint32 *)buf = t;
sl@0:                 buf += 4;
sl@0:         } while (--longs);
sl@0: }
sl@0: /* The four core functions - F1 is optimized somewhat */
sl@0: 
sl@0: /* #define F1(x, y, z) (x & y | ~x & z) */
sl@0: #define F1(x, y, z) (z ^ (x & (y ^ z)))
sl@0: #define F2(x, y, z) F1(z, x, y)
sl@0: #define F3(x, y, z) (x ^ y ^ z)
sl@0: #define F4(x, y, z) (y ^ (x | ~z))
sl@0: 
sl@0: /* This is the central step in the MD5 algorithm. */
sl@0: #define MD5STEP(f, w, x, y, z, data, s) \
sl@0:         ( w += f(x, y, z) + data,  w = w<<s | w>>(32-s),  w += x )
sl@0: 
sl@0: /*
sl@0:  * The core of the MD5 algorithm, this alters an existing MD5 hash to
sl@0:  * reflect the addition of 16 longwords of new data.  MD5Update blocks
sl@0:  * the data and converts bytes into longwords for this routine.
sl@0:  */
sl@0: static void MD5Transform(uint32 buf[4], const uint32 in[16]){
sl@0:         register uint32 a, b, c, d;
sl@0: 
sl@0:         a = buf[0];
sl@0:         b = buf[1];
sl@0:         c = buf[2];
sl@0:         d = buf[3];
sl@0: 
sl@0:         MD5STEP(F1, a, b, c, d, in[ 0]+0xd76aa478,  7);
sl@0:         MD5STEP(F1, d, a, b, c, in[ 1]+0xe8c7b756, 12);
sl@0:         MD5STEP(F1, c, d, a, b, in[ 2]+0x242070db, 17);
sl@0:         MD5STEP(F1, b, c, d, a, in[ 3]+0xc1bdceee, 22);
sl@0:         MD5STEP(F1, a, b, c, d, in[ 4]+0xf57c0faf,  7);
sl@0:         MD5STEP(F1, d, a, b, c, in[ 5]+0x4787c62a, 12);
sl@0:         MD5STEP(F1, c, d, a, b, in[ 6]+0xa8304613, 17);
sl@0:         MD5STEP(F1, b, c, d, a, in[ 7]+0xfd469501, 22);
sl@0:         MD5STEP(F1, a, b, c, d, in[ 8]+0x698098d8,  7);
sl@0:         MD5STEP(F1, d, a, b, c, in[ 9]+0x8b44f7af, 12);
sl@0:         MD5STEP(F1, c, d, a, b, in[10]+0xffff5bb1, 17);
sl@0:         MD5STEP(F1, b, c, d, a, in[11]+0x895cd7be, 22);
sl@0:         MD5STEP(F1, a, b, c, d, in[12]+0x6b901122,  7);
sl@0:         MD5STEP(F1, d, a, b, c, in[13]+0xfd987193, 12);
sl@0:         MD5STEP(F1, c, d, a, b, in[14]+0xa679438e, 17);
sl@0:         MD5STEP(F1, b, c, d, a, in[15]+0x49b40821, 22);
sl@0: 
sl@0:         MD5STEP(F2, a, b, c, d, in[ 1]+0xf61e2562,  5);
sl@0:         MD5STEP(F2, d, a, b, c, in[ 6]+0xc040b340,  9);
sl@0:         MD5STEP(F2, c, d, a, b, in[11]+0x265e5a51, 14);
sl@0:         MD5STEP(F2, b, c, d, a, in[ 0]+0xe9b6c7aa, 20);
sl@0:         MD5STEP(F2, a, b, c, d, in[ 5]+0xd62f105d,  5);
sl@0:         MD5STEP(F2, d, a, b, c, in[10]+0x02441453,  9);
sl@0:         MD5STEP(F2, c, d, a, b, in[15]+0xd8a1e681, 14);
sl@0:         MD5STEP(F2, b, c, d, a, in[ 4]+0xe7d3fbc8, 20);
sl@0:         MD5STEP(F2, a, b, c, d, in[ 9]+0x21e1cde6,  5);
sl@0:         MD5STEP(F2, d, a, b, c, in[14]+0xc33707d6,  9);
sl@0:         MD5STEP(F2, c, d, a, b, in[ 3]+0xf4d50d87, 14);
sl@0:         MD5STEP(F2, b, c, d, a, in[ 8]+0x455a14ed, 20);
sl@0:         MD5STEP(F2, a, b, c, d, in[13]+0xa9e3e905,  5);
sl@0:         MD5STEP(F2, d, a, b, c, in[ 2]+0xfcefa3f8,  9);
sl@0:         MD5STEP(F2, c, d, a, b, in[ 7]+0x676f02d9, 14);
sl@0:         MD5STEP(F2, b, c, d, a, in[12]+0x8d2a4c8a, 20);
sl@0: 
sl@0:         MD5STEP(F3, a, b, c, d, in[ 5]+0xfffa3942,  4);
sl@0:         MD5STEP(F3, d, a, b, c, in[ 8]+0x8771f681, 11);
sl@0:         MD5STEP(F3, c, d, a, b, in[11]+0x6d9d6122, 16);
sl@0:         MD5STEP(F3, b, c, d, a, in[14]+0xfde5380c, 23);
sl@0:         MD5STEP(F3, a, b, c, d, in[ 1]+0xa4beea44,  4);
sl@0:         MD5STEP(F3, d, a, b, c, in[ 4]+0x4bdecfa9, 11);
sl@0:         MD5STEP(F3, c, d, a, b, in[ 7]+0xf6bb4b60, 16);
sl@0:         MD5STEP(F3, b, c, d, a, in[10]+0xbebfbc70, 23);
sl@0:         MD5STEP(F3, a, b, c, d, in[13]+0x289b7ec6,  4);
sl@0:         MD5STEP(F3, d, a, b, c, in[ 0]+0xeaa127fa, 11);
sl@0:         MD5STEP(F3, c, d, a, b, in[ 3]+0xd4ef3085, 16);
sl@0:         MD5STEP(F3, b, c, d, a, in[ 6]+0x04881d05, 23);
sl@0:         MD5STEP(F3, a, b, c, d, in[ 9]+0xd9d4d039,  4);
sl@0:         MD5STEP(F3, d, a, b, c, in[12]+0xe6db99e5, 11);
sl@0:         MD5STEP(F3, c, d, a, b, in[15]+0x1fa27cf8, 16);
sl@0:         MD5STEP(F3, b, c, d, a, in[ 2]+0xc4ac5665, 23);
sl@0: 
sl@0:         MD5STEP(F4, a, b, c, d, in[ 0]+0xf4292244,  6);
sl@0:         MD5STEP(F4, d, a, b, c, in[ 7]+0x432aff97, 10);
sl@0:         MD5STEP(F4, c, d, a, b, in[14]+0xab9423a7, 15);
sl@0:         MD5STEP(F4, b, c, d, a, in[ 5]+0xfc93a039, 21);
sl@0:         MD5STEP(F4, a, b, c, d, in[12]+0x655b59c3,  6);
sl@0:         MD5STEP(F4, d, a, b, c, in[ 3]+0x8f0ccc92, 10);
sl@0:         MD5STEP(F4, c, d, a, b, in[10]+0xffeff47d, 15);
sl@0:         MD5STEP(F4, b, c, d, a, in[ 1]+0x85845dd1, 21);
sl@0:         MD5STEP(F4, a, b, c, d, in[ 8]+0x6fa87e4f,  6);
sl@0:         MD5STEP(F4, d, a, b, c, in[15]+0xfe2ce6e0, 10);
sl@0:         MD5STEP(F4, c, d, a, b, in[ 6]+0xa3014314, 15);
sl@0:         MD5STEP(F4, b, c, d, a, in[13]+0x4e0811a1, 21);
sl@0:         MD5STEP(F4, a, b, c, d, in[ 4]+0xf7537e82,  6);
sl@0:         MD5STEP(F4, d, a, b, c, in[11]+0xbd3af235, 10);
sl@0:         MD5STEP(F4, c, d, a, b, in[ 2]+0x2ad7d2bb, 15);
sl@0:         MD5STEP(F4, b, c, d, a, in[ 9]+0xeb86d391, 21);
sl@0: 
sl@0:         buf[0] += a;
sl@0:         buf[1] += b;
sl@0:         buf[2] += c;
sl@0:         buf[3] += d;
sl@0: }
sl@0: 
sl@0: /*
sl@0:  * Start MD5 accumulation.  Set bit count to 0 and buffer to mysterious
sl@0:  * initialization constants.
sl@0:  */
sl@0: static void MD5Init(MD5Context *ctx){
sl@0:         ctx->isInit = 1;
sl@0:         ctx->buf[0] = 0x67452301;
sl@0:         ctx->buf[1] = 0xefcdab89;
sl@0:         ctx->buf[2] = 0x98badcfe;
sl@0:         ctx->buf[3] = 0x10325476;
sl@0:         ctx->bits[0] = 0;
sl@0:         ctx->bits[1] = 0;
sl@0: }
sl@0: 
sl@0: /*
sl@0:  * Update context to reflect the concatenation of another buffer full
sl@0:  * of bytes.
sl@0:  */
sl@0: static 
sl@0: void MD5Update(MD5Context *pCtx, const unsigned char *buf, unsigned int len){
sl@0:         struct Context *ctx = (struct Context *)pCtx;
sl@0:         uint32 t;
sl@0: 
sl@0:         /* Update bitcount */
sl@0: 
sl@0:         t = ctx->bits[0];
sl@0:         if ((ctx->bits[0] = t + ((uint32)len << 3)) < t)
sl@0:                 ctx->bits[1]++; /* Carry from low to high */
sl@0:         ctx->bits[1] += len >> 29;
sl@0: 
sl@0:         t = (t >> 3) & 0x3f;    /* Bytes already in shsInfo->data */
sl@0: 
sl@0:         /* Handle any leading odd-sized chunks */
sl@0: 
sl@0:         if ( t ) {
sl@0:                 unsigned char *p = (unsigned char *)ctx->in + t;
sl@0: 
sl@0:                 t = 64-t;
sl@0:                 if (len < t) {
sl@0:                         memcpy(p, buf, len);
sl@0:                         return;
sl@0:                 }
sl@0:                 memcpy(p, buf, t);
sl@0:                 byteReverse(ctx->in, 16);
sl@0:                 MD5Transform(ctx->buf, (uint32 *)ctx->in);
sl@0:                 buf += t;
sl@0:                 len -= t;
sl@0:         }
sl@0: 
sl@0:         /* Process data in 64-byte chunks */
sl@0: 
sl@0:         while (len >= 64) {
sl@0:                 memcpy(ctx->in, buf, 64);
sl@0:                 byteReverse(ctx->in, 16);
sl@0:                 MD5Transform(ctx->buf, (uint32 *)ctx->in);
sl@0:                 buf += 64;
sl@0:                 len -= 64;
sl@0:         }
sl@0: 
sl@0:         /* Handle any remaining bytes of data. */
sl@0: 
sl@0:         memcpy(ctx->in, buf, len);
sl@0: }
sl@0: 
sl@0: /*
sl@0:  * Final wrapup - pad to 64-byte boundary with the bit pattern 
sl@0:  * 1 0* (64-bit count of bits processed, MSB-first)
sl@0:  */
sl@0: static void MD5Final(unsigned char digest[16], MD5Context *pCtx){
sl@0:         struct Context *ctx = (struct Context *)pCtx;
sl@0:         unsigned count;
sl@0:         unsigned char *p;
sl@0: 
sl@0:         /* Compute number of bytes mod 64 */
sl@0:         count = (ctx->bits[0] >> 3) & 0x3F;
sl@0: 
sl@0:         /* Set the first char of padding to 0x80.  This is safe since there is
sl@0:            always at least one byte free */
sl@0:         p = ctx->in + count;
sl@0:         *p++ = 0x80;
sl@0: 
sl@0:         /* Bytes of padding needed to make 64 bytes */
sl@0:         count = 64 - 1 - count;
sl@0: 
sl@0:         /* Pad out to 56 mod 64 */
sl@0:         if (count < 8) {
sl@0:                 /* Two lots of padding:  Pad the first block to 64 bytes */
sl@0:                 memset(p, 0, count);
sl@0:                 byteReverse(ctx->in, 16);
sl@0:                 MD5Transform(ctx->buf, (uint32 *)ctx->in);
sl@0: 
sl@0:                 /* Now fill the next block with 56 bytes */
sl@0:                 memset(ctx->in, 0, 56);
sl@0:         } else {
sl@0:                 /* Pad block to 56 bytes */
sl@0:                 memset(p, 0, count-8);
sl@0:         }
sl@0:         byteReverse(ctx->in, 14);
sl@0: 
sl@0:         /* Append length in bits and transform */
sl@0:         ((uint32 *)ctx->in)[ 14 ] = ctx->bits[0];
sl@0:         ((uint32 *)ctx->in)[ 15 ] = ctx->bits[1];
sl@0: 
sl@0:         MD5Transform(ctx->buf, (uint32 *)ctx->in);
sl@0:         byteReverse((unsigned char *)ctx->buf, 4);
sl@0:         memcpy(digest, ctx->buf, 16);
sl@0:         memset(ctx, 0, sizeof(ctx));    /* In case it is sensitive */
sl@0: }
sl@0: 
sl@0: /*
sl@0: ** Convert a digest into base-16.  digest should be declared as
sl@0: ** "unsigned char digest[16]" in the calling function.  The MD5
sl@0: ** digest is stored in the first 16 bytes.  zBuf should
sl@0: ** be "char zBuf[33]".
sl@0: */
sl@0: static void DigestToBase16(unsigned char *digest, char *zBuf){
sl@0:   static char const zEncode[] = "0123456789abcdef";
sl@0:   int i, j;
sl@0: 
sl@0:   for(j=i=0; i<16; i++){
sl@0:     int a = digest[i];
sl@0:     zBuf[j++] = zEncode[(a>>4)&0xf];
sl@0:     zBuf[j++] = zEncode[a & 0xf];
sl@0:   }
sl@0:   zBuf[j] = 0;
sl@0: }
sl@0: 
sl@0: /*
sl@0: ** A TCL command for md5.  The argument is the text to be hashed.  The
sl@0: ** Result is the hash in base64.  
sl@0: */
sl@0: static int md5_cmd(void*cd, Tcl_Interp *interp, int argc, const char **argv){
sl@0:   MD5Context ctx;
sl@0:   unsigned char digest[16];
sl@0: 
sl@0:   if( argc!=2 ){
sl@0:     Tcl_AppendResult(interp,"wrong # args: should be \"", argv[0], 
sl@0:         " TEXT\"", 0);
sl@0:     return TCL_ERROR;
sl@0:   }
sl@0:   MD5Init(&ctx);
sl@0:   MD5Update(&ctx, (unsigned char*)argv[1], (unsigned)strlen(argv[1]));
sl@0:   MD5Final(digest, &ctx);
sl@0:   DigestToBase16(digest, interp->result);
sl@0:   return TCL_OK;
sl@0: }
sl@0: 
sl@0: /*
sl@0: ** A TCL command to take the md5 hash of a file.  The argument is the
sl@0: ** name of the file.
sl@0: */
sl@0: static int md5file_cmd(void*cd, Tcl_Interp*interp, int argc, const char **argv){
sl@0:   FILE *in;
sl@0:   MD5Context ctx;
sl@0:   unsigned char digest[16];
sl@0:   char zBuf[10240];
sl@0:   char fnamebuf[MAXPATHLEN + 1];
sl@0: 
sl@0:   if( argc!=2 ){
sl@0:     Tcl_AppendResult(interp,"wrong # args: should be \"", argv[0], 
sl@0:         " FILENAME\"", 0);
sl@0:     return TCL_ERROR;
sl@0:   }
sl@0:   if(GetFullFilePath(fnamebuf, argv[1]) == 0)
sl@0:     return TCL_ERROR;
sl@0:   in = fopen(fnamebuf,"rb");
sl@0:   if( in==0 ){
sl@0:     Tcl_AppendResult(interp,"unable to open file \"", fnamebuf, "\" for reading", 0);
sl@0:     return TCL_ERROR;
sl@0:   }
sl@0:   MD5Init(&ctx);
sl@0:   for(;;){
sl@0:     int n;
sl@0:     n = fread(zBuf, 1, sizeof(zBuf), in);
sl@0:     if( n<=0 ) break;
sl@0:     MD5Update(&ctx, (unsigned char*)zBuf, (unsigned)n);
sl@0:   }
sl@0:   fclose(in);
sl@0:   MD5Final(digest, &ctx);
sl@0:   DigestToBase16(digest, interp->result);
sl@0:   return TCL_OK;
sl@0: }
sl@0: 
sl@0: /*
sl@0: ** Register the two TCL commands above with the TCL interpreter.
sl@0: */
sl@0: int Md5_Init(Tcl_Interp *interp){
sl@0:   Tcl_CreateCommand(interp, "md5", (Tcl_CmdProc*)md5_cmd, 0, 0);
sl@0:   Tcl_CreateCommand(interp, "md5file", (Tcl_CmdProc*)md5file_cmd, 0, 0);
sl@0:   return TCL_OK;
sl@0: }
sl@0: 
sl@0: /*
sl@0: ** During testing, the special md5sum() aggregate function is available.
sl@0: ** inside SQLite.  The following routines implement that function.
sl@0: */
sl@0: static void md5step(sqlite3_context *context, int argc, sqlite3_value **argv){
sl@0:   MD5Context *p;
sl@0:   int i;
sl@0:   if( argc<1 ) return;
sl@0:   p = sqlite3_aggregate_context(context, sizeof(*p));
sl@0:   if( p==0 ) return;
sl@0:   if( !p->isInit ){
sl@0:     MD5Init(p);
sl@0:   }
sl@0:   for(i=0; i<argc; i++){
sl@0:     const char *zData = (char*)sqlite3_value_text(argv[i]);
sl@0:     if( zData ){
sl@0:       MD5Update(p, (unsigned char*)zData, strlen(zData));
sl@0:     }
sl@0:   }
sl@0: }
sl@0: static void md5finalize(sqlite3_context *context){
sl@0:   MD5Context *p;
sl@0:   unsigned char digest[16];
sl@0:   char zBuf[33];
sl@0:   p = sqlite3_aggregate_context(context, sizeof(*p));
sl@0:   MD5Final(digest,p);
sl@0:   DigestToBase16(digest, zBuf);
sl@0:   sqlite3_result_text(context, zBuf, -1, SQLITE_TRANSIENT);
sl@0: }
sl@0: int Md5_Register(sqlite3 *db){
sl@0:   int rc = sqlite3_create_function(db, "md5sum", -1, SQLITE_UTF8, 0, 0, 
sl@0:                                  md5step, md5finalize);
sl@0:   sqlite3_overload_function(db, "md5sum", -1);  /* To exercise this API */
sl@0:   return rc;
sl@0: }