> sqlite3 .svn/wc.db "select * from work_queue" 3|(file-install 59 DBBuild/Wordlists/Belarusian/BelarusianForceFreq.txt[MOVED] 1 0 1 1)
> sqlite3 .svn/wc.db "select * from nodes where local_relpath='DBBuild/Wordlists/Belarusian/BelarusianForceFreq.txt[MOVED]'" 1|DBBuild/Wordlists/Belarusian/BelarusianForceFreq.txt[MOVED]|0|DBBuild/Wordlists/Belarusian|1|Trunk/DBBuild/Wordlists/Belarusian/BelarusianForceFreq.txt[MOVED]|3936|normal|||file||infinity|||3323|1294867663142001|Erik.Larsson|504|1294985508149158|| So there's no checksum (according to other entries, it would be the field just after "infinity"). On Tue, Nov 15, 2011 at 9:33 AM, Philip Martin <philip.mar...@wandisco.com>wrote: > Ethan Bradford <ethan.bradf...@swype.com> writes: > > >> Do you have the sqlite3 tool available to query the 1.7 working copy? > >> > >> sqlite3 .svn/wc.db "select count(*) from nodes where op_depth > 0" > >> > > > > I installed sqlite3 to check this. The answer it gets is 0. > > Fine. Next: > > sqlite3 .svn/wc.db "select * from work_queue" > > There may be multiple lines. You should see something like: > 6|(file-install A/f 1 0 1 1) > > "A/f" is just an example, in your case it will be the path of a file in > your wc. So > > sqlite3 .svn/wc.db "select * from nodes where local_relpath='A/f'" > > You may see a checksum like: > > $sha1$7ab6a41b5d9bc8fad70cc0314c142c91feab4686 > > or it may be missing. If present: > > sqlite3 .svn/wc.db "select * from pristine where checksum like > '%ab6a41b5d9bc8fad70cc0314c142c91feab4686" > > or > > sqlite3 .svn/wc.db "select * from pristine where > checksum='\$sha1\$ab6a41b5d9bc8fad70cc0314c142c91feab4686" > > they should be the same (one escapes the '$' characters, the other drops > them). > > -- > Philip >