TestSQL3 Log

   Synopse mORMot Framework Automated tests
  ------------------------------------------


1. Synopse libraries

 1.1. Low level common:
  - System copy record: 83 assertions passed  92us
  - TRawUTF8List: 130,009 assertions passed  119.77ms
  - TDynArray: 1,082,723 assertions passed  377.82ms
  - TDynArrayHashed: 1,200,629 assertions passed  198.39ms
  - TObjectListHashed: 999,773 assertions passed  543.00ms
  - TObjectDynArrayWrapper: 167,501 assertions passed  48.30ms
  - TObjArray: 2,016 assertions passed  3.48ms
  - Fast string compare: 24 assertions passed  47us
  - IdemPropName: 197 assertions passed  104us
  - Url encoding: 150 assertions passed  1.03ms
  - GUID: 9,005 assertions passed  14.11ms
  - IsMatch: 599 assertions passed  839us
  - Soundex: 35 assertions passed  32us
  - Numerical conversions: 1,116,482 assertions passed  746.05ms
  - crc32c: 20,020 assertions passed  73.36ms
      pas 18.97ms 314.5 MB/s fast 3.61ms 1.6 GB/s
  - Curr 64: 20,053 assertions passed  2.47ms
  - CamelCase: 11 assertions passed  22us
  - Bits: 4,774 assertions passed  61us
  - Ini files: 7,004 assertions passed  58.78ms
  - UTF8: 100,131 assertions passed  811.93ms
  - Iso 8601 date and time: 48,017 assertions passed  10.32ms
  - Time zones: 407 assertions passed  10.30ms
  - Url decoding: 1,100 assertions passed  277us
  - Mime types: 27 assertions passed  117us
  - TSynTable: 875 assertions passed  13.06ms
  - TSynCache: 404 assertions passed  146us
  - TSynFilter: 804 assertions passed  2.77ms
  - TSynValidate: 677 assertions passed  995us
  - TSynLogFile: 42 assertions passed  885us
  - TSynUniqueIdentifier: 1,300,002 assertions passed  894.85ms
  Total failed: 0 / 6,213,574  - Low level common PASSED  3.93s

 1.2. Low level types:
  - RTTI: 410 assertions passed  347us
  - Url encoding: 200 assertions passed  722us
  - Encode decode JSON: 282,281 assertions passed  9.10s
  - Variants: 48 assertions passed  47us
  - Mustache renderer: 144 assertions passed  1.89s
  - TDocVariant: no assertion  22us
  - BSON: no assertion  13us
  - TSynTableStatement: 206 assertions passed  133us
  - TSynMonitorUsage: 1,202 assertions passed  177us
  Total failed: 0 / 284,491  - Low level types PASSED  11.00s

 1.3. Cryptographic routines:
  - Adler32: 1 assertion passed  25us
  - MD5: 86 assertions passed  392us
  - SHA1: 10 assertions passed  6.08ms
  - SHA256: 8 assertions passed  10.17ms
  - AES256: 12,178 assertions passed  622.55ms
  - RC4: 1 assertion passed  24us
!  - Base64: 3 / 11,994 FAILED  313.74ms
  - CompressShaAes: 1,683 assertions passed  4.72ms
  Total failed: 3 / 25,961  - Cryptographic routines FAILED  957.92ms

 1.4. Compression:
  - In memory compression: 12 assertions passed  475.60ms
!  - GZIP format: 1 / 19 FAILED  922.34ms
!  - ZIP format: 7 / 64 FAILED  3.56s
!  - SynLZO: 1,000 / 3,006 FAILED  227.87ms
!  - SynLZ: 989 / 32,221 FAILED  850.57ms
  Total failed: 1,997 / 35,322  - Compression FAILED  6.04s


2. mORMot

 2.1. File based:
  - Database direct access: 20,251 assertions passed  232.29ms
  - Virtual table direct access: 12 assertions passed  5.85ms
  - TSQLTableJSON: 144,070 assertions passed  167.43ms
!  - TSQLRestClientDB: 4 / 608,195 FAILED  7.53s
  - TRecordVersion: 20,060 assertions passed  181.06ms
  Total failed: 4 / 792,588  - File based FAILED  8.12s

 2.2. File based memory map:
  - Database direct access: 20,246 assertions passed  225.62ms
  - Virtual table direct access: 12 assertions passed  6.24ms
  - TSQLTableJSON: 144,070 assertions passed  257.62ms
!  - TSQLRestClientDB: 4 / 608,194 FAILED  7.54s
  - TRecordVersion: 20,060 assertions passed  184.18ms
  Total failed: 4 / 792,582  - File based memory map FAILED  8.22s

 2.3. File based WAL:
  - Database direct access: 20,251 assertions passed  272.04ms
  - Virtual table direct access: 12 assertions passed  6.00ms
  - TSQLTableJSON: 144,070 assertions passed  281.47ms
!  - TSQLRestClientDB: 4 / 608,195 FAILED  7.32s
  - TRecordVersion: 20,060 assertions passed  167.60ms
  Total failed: 4 / 792,588  - File based WAL FAILED  8.04s

 2.4. Memory based:
  - Database direct access: 20,246 assertions passed  391.55ms
  - Virtual table direct access: 12 assertions passed  5.40ms
  - TSQLTableJSON: 144,070 assertions passed  173.95ms
!  - TSQLRestClientDB: 4 / 676,502 FAILED  7.21s
  - TRecordVersion: 20,060 assertions passed  172.25ms
  - RTree: 140,000 assertions passed  1.39s
  Total failed: 4 / 1,000,890  - Memory based FAILED  9.35s

 2.5. Basic classes:
!  - TSQLRecord: 5 / 88 FAILED  714us
  - TSQLRecordSigned: 200 assertions passed  3.62ms
  - TSQLModel: 16 assertions passed  76us
!  - TSQLRestServerFullMemory: 370,119 / 640,135 FAILED  8.44s
  Total failed: 370,124 / 640,439  - Basic classes FAILED  8.44s

 2.6. Client server access:
  - TSQLHttpServer: 2 assertions passed  15.87ms
     using HTTP API 2.0
  - TSQLHttpClient: 3 assertions passed  26.33ms
     using TSQLHttpClientWinHTTP
  - HTTP client keep alive: 3,087 assertions passed  493.44ms
     4818 B, first 2.66ms, done 472.37ms i.e. 2116/s, aver. 472us, 9.9 MB/s
  - HTTP client multi connect: 3,087 assertions passed  453.12ms
     4818 B, first 499us, done 435.91ms i.e. 2294/s, aver. 435us, 10.7 MB/s
  - HTTP client encrypted: 3,087 assertions passed  564.57ms
     4818 B, first 552us, done 548.74ms i.e. 1822/s, aver. 548us, 8.5 MB/s
  - Named pipe access: 3,089 assertions passed  684.14ms
     4818 B, first 258.60ms, done 214.11ms i.e. 4670/s, aver. 214us, 21.8 MB/s
!  - Local window messages: 1 / 2 FAILED  2.77ms
  - Direct in process access: 3,056 assertions passed  61.27ms
     4818 B, first 104us, done 50.77ms i.e. 19695/s, aver. 50us, 92 MB/s
  - HTTP several DB servers: 9,604 assertions passed  1.66s
     4818 B, first 582us, done 457.89ms i.e. 2183/s, aver. 457us, 10.2 MB/s
     4818 B, first 942us, done 503.94ms i.e. 1984/s, aver. 503us, 9.2 MB/s
     4818 B, first 538us, done 491.73ms i.e. 2033/s, aver. 491us, 9.5 MB/s
  Total failed: 1 / 25,017  - Client server access FAILED  3.96s

 2.7. Service oriented architecture:
  - Weak interfaces: 56 assertions passed  73us
  - Service initialization: 267 assertions passed  6.64ms
  - Direct call: 537,186 assertions passed  47.63ms
  - Server side: 537,206 assertions passed  48.93ms
  - Client side REST: 716,274 assertions passed  1.39s
  - Client side REST as JSON object: 716,268 assertions passed  1.36s
  - Client side REST sessions stats: 716,268 assertions passed  1.33s
  - Client side REST locked: 716,272 assertions passed  1.42s
  - Client side REST main thread: 716,272 assertions passed  3.53s
  - Client side REST background thread: 716,272 assertions passed  2.55s
  - Client side REST weak authentication: 716,268 assertions passed  1.18s
! Service oriented architecture - Client side REST basic authentication
! Exception EAccessViolation raised with messsage:
!  Access violation
! Service oriented architecture - Client side REST custom record layout
! Exception EAccessViolation raised with messsage:
!  Access violation
! Service oriented architecture - Client side REST service log to DB
! Exception EAccessViolation raised with messsage:
!  Access violation
! Service oriented architecture - Client side JSONRPC
! Exception EAccessViolation raised with messsage:
!  Access violation
! Service oriented architecture - Test over HTTP
! Exception EServiceException raised with messsage:
!  TServiceFactoryClient.Create(): ICalculator interface or TSQLRestRoutingREST routing not supported by server: {
"errorCode":403,
"errorText":"Forbidden"
}
!  - Security: 80 / 135 FAILED  3.16ms
  - Mocks and stubs: 30,030 assertions passed  102.91ms
  Total failed: 85 / 6,118,815  - Service oriented architecture FAILED  13.00s

 2.8. Bidirectional remote connection:
  - Websockets JSON protocol: 60 assertions passed  192us
  - Websockets binary protocol: 240 assertions passed  226us
  - Run http server: 2 assertions passed  731us
  - SOA callback on server side: 4,578 assertions passed  3.83ms
  - SOA callback via JSON websockets: 4,581 assertions passed  195.72ms
  - SOA callback via binary websockets: 4,581 assertions passed  171.46ms
  - TRecordVersion: 20,068 assertions passed  186.15ms
  Total failed: 0 / 34,110  - Bidirectional remote connection PASSED  558.51ms

 2.9. External database:
  - TQuery: 2,003 assertions passed  9.17ms
! External database - SynDBRemote
! Exception ESQLDBRemote raised with messsage:
!  You do not have the right to be here
  - DB properties persistence: 7 assertions passed  14.58ms
  - External records: 2 assertions passed  367us
  - Auto adapt SQL: 942 assertions passed  104.54ms
  - Crypted database: 253,275 assertions passed  430.01ms
  - External via REST: 170,354 assertions passed  1.71s
  - External via virtual table: 170,354 assertions passed  2.96s
  - External via REST with change tracking: 180,454 assertions passed  4.00s
  - JET database: 7,007 assertions passed  1.05s
  Total failed: 0 / 789,413  - External database PASSED  10.45s

 2.10. Multi thread process:
  - Create thread pool: 1 assertion passed  3.75ms
  - TSQLRestServerDB: 4,821 assertions passed  177.27ms
     1=16028/s  2=11895/s  5=14016/s  10=15307/s  30=16716/s  50=15051/s
  - TSQLRestClientDB: 4,822 assertions passed  236.45ms
     1=10702/s  2=14080/s  5=15699/s  10=13376/s  30=8508/s  50=7210/s
  - TSQLRestClientURINamedPipe: 2,412 assertions passed  1.64s
     1=1162/s  2=1059/s  5=560/s
!  - TSQLRestClientURIMessage: 18 / 40 FAILED  64.61ms
     1=113636/s  2=59347/s  5=20778/s  10=17526/s
  - Windows API: 4,818 assertions passed  659.24ms
     1=2118/s  2=3866/s  5=5558/s  10=4530/s  30=5347/s  50=3594/s
!  - Socket API: 150 / 2,330 FAILED  20.35s
     1
!  - Websockets: 79 / 3,396 FAILED  920.37s
     1=5898/s  2=5367/s  5=6455/s  10=6512/s  30=0/s  50=0/s
  - Locked: 4,820 assertions passed  213.90ms
     1=15663/s  2=17534/s  5=16544/s  10=13615/s  30=9317/s  50=6938/s
  - Unlocked: 4,822 assertions passed  143.37ms
     1=16433/s  2=19137/s  5=18118/s  10=18776/s  30=19674/s  50=17471/s
  - Main thread: 4,820 assertions passed  158.03ms
     1=13004/s  2=17485/s  5=18425/s  10=17918/s  30=18831/s  50=14362/s
  - Background thread: 4,822 assertions passed  157.81ms
     1=14049/s  2=17756/s  5=17292/s  10=15731/s  30=18843/s  50=15500/s
  Total failed: 247 / 41,924  - Multi thread process FAILED  944.19s

 2.11. DDD shared units:
  - User model: 3,276 assertions passed  722us
  - Authentication model: 20,006 assertions passed  238.73ms
!  - Email validation process: 3 / 55 FAILED  26.96ms
!  - User CQRS repository: 7,002 / 57,106 FAILED  1.03s
  Total failed: 7,005 / 80,443  - DDD shared units FAILED  1.30s

 2.12. DDD multi thread:
  - Delete old database: 1 assertion passed  106us
  - Start server: 1 assertion passed  116.96ms
  - Single client test: 1,002 assertions passed  417.06ms
  - Multi threaded clients test: 21 assertions passed  1.43s
  Total failed: 0 / 1,025  - DDD multi thread PASSED  1.96s


Using mORMot 1.18.2370 FTS3
Running on Windows 10 64bit (10.0.10586) with code page 1252
TSQLite3LibraryStatic 3.10.2 with internal MM
Generated with: Free Pascal 3.1.1 compiler

Time elapsed for all tests: 1039.63s
Tests performed at 12-02-2016 14:41:59

Total assertions failed for all test suits:  379,478 / 17,669,182
! Some tests FAILED: please correct the code.