log2sql.py #5

  • //
  • guest/
  • perforce_software/
  • utils/
  • log_analyzer/
  • log2sql.py
  • Commits
# Change User Description Committed
#5 23765 Robert Cowham Moved things down one level to psla dir to make it easier to see what belongs
#4 23719 Robert Cowham Log warnings for insert exceptions
#3 23683 Robert Cowham Bring in latest changes - performance improvements
#2 23636 Robert Cowham Merge in latests changes to log2sql.py
- much faster
- better at detecting completed commands and out of order vtrack
- full test harness
#1 22465 Robert Cowham Added tests for r99.2 created depot (no filesize/digest stored)
Fixed problem with preview failing comparison
Add --p4d option to tests to use different p4d version
//guest/robert_cowham/perforce/utils/log_analysis/log2sql.py
#22 21796 Robert Cowham Handle rmt-FileFetch records which may be duplicates as they don't have 'completed' entries.
#21 21780 Robert Cowham Don't drop tables when creating sqlite db
Performance tweaks after profiling - particularly date parsing.
#20 21713 Robert Cowham Ignore temporary error inserting into trackuse table
#19 21712 Robert Cowham Check for correct line number when looking to update for track entries
#18 21708 Robert Cowham Tweak parameters to improve error messages.
Make output to stdout optional
#17 21705 Robert Cowham Minor refactoring for clarity.
Process all completed records as we go.
#16 21702 Robert Cowham Rework algorithm to process blocks at a time, and to avoid the SQL update statements.
Risk of increased memory vs improved speed.
#15 21697 Robert Cowham Parse rcpSnd/rpcRcv and add to database.
#14 21694 Robert Cowham Handle null values properly
#13 21672 Robert Cowham Improve performance when inserting rows
#12 21660 Robert Cowham Handle utf8 in python2 strings
#11 21656 Robert Cowham Avoid SQL quoting issues with alternative insert statement.
#10 21643 Robert Cowham Handle git-fusion entries (strip the json) - for --sql option
#9 21402 Robert Cowham Filter out swarm commands
Test for db content in a basic fashion.
#8 21393 Robert Cowham Add a swarm test - large record.
Improve performance by skipping easy matches early.
#7 21378 Robert Cowham Batch updates and make SQL date arithmetic work with SQLite
#6 21374 Robert Cowham Write to sqllite db
#5 21368 Robert Cowham Make tests work under python3
#4 21367 Robert Cowham Restructured for unit tests, and first unit tests.
#3 21366 Robert Cowham Fix problems with NULL values and int
#2 21365 Robert Cowham Equivalent of Ruby version on smaller sets
#1 21361 Robert Cowham Sort of works...