> 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.martin_at_wandisco.com>wrote:
> Ethan Bradford <ethan.bradford_at_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
>
Received on 2011-11-15 22:54:39 CET