sommer1991 / svnplot Goto Github PK

> python /usr/local/lib/python2.6/site-packages/svnplot/svnlog2sqlite.py
http://unusefulscripts.googlecode.com/svn SQLITEDB
Updating the subversion log
Repository : http://unusefulscripts.googlecode.com/svn
Log database filepath : SQLITEDB
Update Changed Line Count : False
ERROR:root:Error You must not use 8-bit bytestrings unless you use a
text_factory that can interpret 8-bit bytestrings (like text_factory =
str). It is highly recommended that you instead just switch your
application to Unicode strings.
Error You must not use 8-bit bytestrings unless you use a text_factory that
can interpret 8-bit bytestrings (like text_factory = str). It is highly
recommended that you instead just switch your application to Unicode strings.
Trying again (1)
ERROR:root:Error You must not use 8-bit bytestrings unless you use a
text_factory that can interpret 8-bit bytestrings (like text_factory =
str). It is highly recommended that you instead just switch your
application to Unicode strings.
Error You must not use 8-bit bytestrings unless you use a text_factory that
can interpret 8-bit bytestrings (like text_factory = str). It is highly
recommended that you instead just switch your application to Unicode strings.
Trying again (2)
ERROR:root:Error You must not use 8-bit bytestrings unless you use a
text_factory that can interpret 8-bit bytestrings (like text_factory =
str). It is highly recommended that you instead just switch your
application to Unicode strings.
Error You must not use 8-bit bytestrings unless you use a text_factory that
can interpret 8-bit bytestrings (like text_factory = str). It is highly
recommended that you instead just switch your application to Unicode strings.
Trying again (3)
>

I don't know whether this is by design or by omission, but I've noticed
that when a given repository doesn't have any commits for a particular hour
of the day those hours will not be included in the "Commit Activity By Hour
of Day" chart.

I've modified the getActivityByTimeOfDay function to account for any
missing hours. I'm a Python newbie, so apologies if this is not an
efficient way to do it:

    def getActivityByTimeOfDay(self):
        '''
        returns two lists (commit counts and time of day)
        '''
        self.cur.execute("select strftime('%H',
SVNLog.commitdate,'localtime') as hourofday, count(SVNLog.revno) from
SVNLog, search_view \
                          where search_view.revno=SVNLog.revno group by
hourofday")

        hourcommits =[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0]
        for hourofday, commitcount in self.cur:
           hourcommits[int(hourofday)] = commitcount

        commits =[]
        hrofdaylist = []
        for index, commitcount in enumerate(hourcommits):
           commits.append(commitcount)
           hrofdaylist.append(index)

        return(commits, hrofdaylist)

What steps will reproduce the problem?
1. I have installed Python3.0.1 but i could not install the numpy here.
2. how do you install matplotlib ?
3.  Could you please explain in detail step to install the SVN PLOT i tried
so many times i could not able to install the SVN PLot completely 

What is the expected output? What do you see instead?

I m getting SYNTAX ERROR 
What version of the product are you using? On what operating system?
SVNPLOT 0.5.8

Please provide any additional information below.

What steps will reproduce the problem?
1. Install svnplot
2. run "python /usr/local/lib/python2.6/dist-packages/svnplot/svnlog2sqlite.py 
-l http://svnplot.googlecode.com/svn/ stat.db"
3.

What is the expected output? What do you see instead?

I left svnlog2sqlite.py for 2 hours. After 2 hours it doesn't seem to work at 
all.

What version of the product are you using? On what operating system?

Debian Squeeze, svnplot 0.6.1

Please provide any additional information below.

I've built and installed svnplot as follows:

http://pastebin.org/395350

It would be nice if graphs could be directly included in the html report,
so it can be easily printed as a single report.

For my personal project I have adapted the plot
code to output SVG format. With recent browsers
supporting the SVG tag inline in HTML code it is
possible to create a plot without images at all.

From my modified code:
"""
from matplotlib.backends.backend_svg import FigureCanvasSVG as FigureCanvas
from matplotlib.figure import Figure

    def fileTypes(self):
        SQL = """SELECT ext, count(*)'num'
             FROM (SELECT DISTINCT path, substr(path, length(path) - 
3)'ext'
                   FROM details
                   WHERE path REGEXP '.*[.]\w+$')
             GROUP BY ext
             ORDER BY num DESC
        """
        data = tuple(self.execute(SQL))

        exts = tuple(row[0] for row in data)
        nums = tuple(row[1] for row in data)

        ind = range(len(exts))

        fig = Figure(facecolor='white', edgecolor='white')
        canvas = FigureCanvas(fig)

        ax = fig.add_subplot(111)

        ax.bar(ind, nums, width = .5, align='center')
        ax.set_xticks(ind)
        ax.set_xticklabels(exts)

        ax.set_ylabel('Count')
        ax.set_xlabel('Type')
        ax.set_title('Filetypes')

        fh = cStringIO.StringIO()
        canvas.print_svg(fh)

        return fh.getvalue()
"""

Also note the use of the REGEXP operator which must be
added manual to Sqlite.

"""
def regexp(expr, item):
    r = re.compile(expr)
    return r.match(item) is not None

# create regex function
con.create_function("regexp", 2, regexp)
"""

RuTe

What steps will reproduce the problem?
1. python svnlog2sqlite2.py <svnrepo url> <sqlitedbpath>
2. python svnplot-js.py <svnsqlitedbpath> <output directory>

What is the expected output? What do you see instead?
- LOC seems to be wrong, especially average file loc is shown to be zero. 


What version of the product are you using? On what operating system?
- svnplot 0.7.0, ubunt


Please provide any additional information below.
- I attach two image files, each of which is generated by svnplot and statsvn. 
surely with a same svn repository.

svnplot.py -v --dpi 70 -p /home/ubuntu/svnplot-read-
only/src/svnplot/svnplot-long.tmpl -n "MyRepo" /home/ubuntu/svnplot 
/home/ubuntu/svnplotgraphs
Calculating subversion stat graphs
Subversion log database : /home/ubuntu/svnplot
Graphs will generated in : /home/ubuntu/svnplotgraphs
Repository Name : MyRepo
Search path inside repository : /%
Graph thumbnail size : 100
Maximum dir count: 10
using template : /home/ubuntu/svnplot-read-only/src/svnplot/svnplot-
long.tmpl
Set the search path to /
Calculating Activity by day of week graph
Calculating Activity by time of day graph
Calculating Author Activity graph
Traceback (most recent call last):
  File "svnplot.py", line 721, in <module>
    RunMain()
  File "svnplot.py", line 718, in RunMain
    svnplot.AllGraphs(graphdir, options.searchpath, options.thumbsize, 
options.maxdircount)
  File "svnplot.py", line 234, in AllGraphs
    self.AuthorActivityGraph(self._getGraphFileName(dirpath, 
"AuthActivity"))
  File "svnplot.py", line 383, in AuthorActivityGraph
    ax = self._drawStackedHBarGraph(dataList, authlabellist, legendlist, 
barwid)
  File "/usr/lib/python2.5/site-packages/svnplot/svnplotbase.py", line 117, 
in _drawStackedHBarGraph
    ax.set_color_cycle(self.clrlist)
AttributeError: Subplot instance has no attribute 'set_color_cycle'

It would be nice to be able to define a revision range for the charts.

I believe that another two arguments "dateStart" and "dateEnd" would be
enough for now.

What steps will reproduce the problem?
1. Run svnlog2sqlite.py on Apache Incubator repository URL [1]
2. Run svnlog2sqlite.py on individual Apache Incubator repository URL [2]
3. Run svnlog2sqlite.py on individual svn-checked-out Apache Incubator 
repository on 
filesystem

[1] https://svn.apache.org/repos/asf/incubator
[2] https://svn.apache.org/repos/asf/incubator/bluesky

What is the expected output? What do you see instead?

Expected output is coversion of revisions as shown below:

Number revisions converted : 1 (Rev no : 1)

Instead I see the following:

ERROR:root:Error list index out of range
ERROR:root:Error list index out of range
ERROR:root:Error list index out of range

for about 10 times and quit. The db file size remains at the default 5120 bytes

What version of the product are you using? On what operating system?

I checked out the most recent from svn, revision 157. I'm using Mac OS X 10.5.6

Please provide any additional information below.

Please let me know if more information will be useful. I will continue seeing 
how this can be 
resolved and if I find anything i'll try to submit a patch.

My email:
[email protected]

Thanks!
-oscar

If there are no commits int svn tree, svnplot gives this error:
Updating the subversion log
Repository : file:///var/svn/adi
Log database filepath : adi.db
Update Changed Line Count : True
ERROR:root:Error No such revision 1
Error No such revision 1
Traceback (most recent call last):
  File "svnlog2sqlite.py", line 45, in convert
    rootUrl = self.svnclient.getRootUrl()
  File "/home/alex/SVNPlot-0.6.1/svnplot/svnlogiter.py", line 399, in getRootUrl
    self.getRootUrl2()
  File "/home/alex/SVNPlot-0.6.1/svnplot/svnlogiter.py", line 366, in getRootUrl2
    revlog = self.svnclient.log(possibleroot, limit=1,discover_changed_paths=True)
ClientError: No such revision 1
Trying again (1)
ERROR:root:Error No such revision 1
Error No such revision 1
Traceback (most recent call last):
  File "svnlog2sqlite.py", line 45, in convert
    rootUrl = self.svnclient.getRootUrl()
  File "/home/alex/SVNPlot-0.6.1/svnplot/svnlogiter.py", line 399, in getRootUrl
    self.getRootUrl2()
  File "/home/alex/SVNPlot-0.6.1/svnplot/svnlogiter.py", line 366, in getRootUrl2
    revlog = self.svnclient.log(possibleroot, limit=1,discover_changed_paths=True)
ClientError: No such revision 1
Trying again (2)
ERROR:root:Error No such revision 1
Error No such revision 1
Traceback (most recent call last):
  File "svnlog2sqlite.py", line 45, in convert
    rootUrl = self.svnclient.getRootUrl()
  File "/home/alex/SVNPlot-0.6.1/svnplot/svnlogiter.py", line 399, in getRootUrl
    self.getRootUrl2()
  File "/home/alex/SVNPlot-0.6.1/svnplot/svnlogiter.py", line 366, in getRootUrl2
    revlog = self.svnclient.log(possibleroot, limit=1,discover_changed_paths=True)
ClientError: No such revision 1
Trying again (3)
Traceback (most recent call last):
  File "svnplot-js.py", line 941, in <module>
    RunMain()
  File "svnplot-js.py", line 934, in RunMain
    svnstats = SVNStats(svndbpath)     
  File "/home/alex/SVNPlot-0.6.1/svnplot/svnstats.py", line 184, in __init__
    self.initdb()
  File "/home/alex/SVNPlot-0.6.1/svnplot/svnstats.py", line 208, in initdb
    self.__startDate = (datetime.datetime.strptime(row[0], "%Y-%m-%d %H:%M:%S")-onedaydiff).date()
TypeError: strptime() argument 1 must be string, not None

here's a low priority idea..

If you used google chart api instead of matplotlib, it would be slightly
easier to deploy the package.

I can't see anywhere to set this to 'enhancement' instead of defect.. sorry

What steps will reproduce the problem?
1. Install svnplot on a serveur which has no X server
2. launch svnplot.py

What is the expected output? What do you see instead?
Cannot connect to DISPLAY

What version of the product are you using? On what operating system?
Trunk, R246
Linux Ubuntu Server

Thx
Changi

What steps will reproduce the problem?
1. install svnplot 1.7.2
2. try to run svnlog2sqlite.py on it

What is the expected output? What do you see instead?

expected conversion of SVN logs to sqlite3 db, got traceback:

Traceback (most recent call last):
  File "/usr/local/lib/python2.5/site-packages/svnplot/svnplot.py", line
47, in <module>
    from svnplotmatplotlib import *
  File
"/usr/local/lib/python2.5/site-packages/svnplot/svnplotmatplotlib.py", line
23, in <module>
    import svnstats
  File "/usr/local/lib/python2.5/site-packages/svnplot/svnstats.py", line 356
    weekdaylist.append(daynames[int(dayofweek)])
                                               ^
IndentationError: unindent does not match any outer indentation level



What version of the product are you using? On what operating system?

svnlog-1.7.2, python2.5 on CentOS 4

Please provide any additional information below.

Indendation broken in lines 356:

        for dayofweek in range(0,7):
            commitcount = commits.get(dayofweek, 0)
            commits_list.append(commitcount)
           weekdaylist.append(daynames[int(dayofweek)])

and 375:

        for hourofday in range(0,24):
            commitcount = commits.get(hourofday, 0)
            commitlist.append(commitcount)
           hrofdaylist.append(int(hourofday))

What steps will reproduce the problem?
python svnlog2sqlite.py http://192.168.0.100/dummy/repo dummy.db

We get following error :
ERROR:root:Error callback_get_login required

Consider a repository called MyRepository that contains no trunk, branch or
tag directories. When I try to access said repository using something like
this:

svnlog2sqlite.py -l svn://localhost/MyRepository C:\REPODB.SQL

I get an error that looks like this:

--- begin error excerpt ---
ERROR:root:Error No repository found in 'svn://localhost'
Error No repository found in 'svn://localhost'
Traceback (most recent call last):
  File "C:\Python26\Lib\site-packages\svnplot\svnlog2sqlite.py", line 47,
in convert
    (startrevno, endrevno) = self.svnclient.findStartEndRev()
  File "C:\Python26\Lib\site-packages\svnplot\svnlogiter.py", line 168, in
findStartEndRev
    headrev = self._getHeadRev()
  File "C:\Python26\Lib\site-packages\svnplot\svnlogiter.py", line 156, in
_getHeadRev
    revision_start=headrev, revision_end=headrev, discover_changed_paths=False)
ClientError: No repository found in 'svn://localhost'
Trying again (1)
...
--- end error excerpt ---

I can avoid the error by issuing the following command instead:

svnlog2sqlite.py -l svn://localhost/MyRepository/. C:\REPODB.SQL

It seems to me it should work either way: with or without the extra /.
after MyRepository.

Does the "average file size (lines)" chart exclude binary / deleted files ?
Because I have 3,6 lines per file in average (in a repository of 80000 LoC
with only 260 files)...

The weekdays were incorrect and you did not consider timezones. Here are 
the small fixes required in svnstats.py

 1. basically all your strftime etc should use 'localtime' modifier
 2. weekdaylist.append(calendar.day_abbr[int(dayofweek)-1]) (sunday is 0 
not monday)

Hi,
I find a very good thing being able to generate stats without having to
checkout the whole working copy.

I have a problem: my production servers where I want to run the statistics
are running RedHat 5, which comes with Python 2.4. Do you think it will be
possible to somehow "backport" svnplot to use python 2.4 ? I can install
the other dependencies without problems, but I cannot afford upgrading to 2.5.

Thanks,
giacomo

What steps will reproduce the problem?
I tried to build an sqlite-DB for our internal repository. 

What is the expected output? What do you see instead?
Several hundret of the following messages flooded the log before svnplot 
crashed (probably because of another problem):
ERROR Error diff() expecting revision object for keyword revision1
ERROR Error diff() expecting revision object for keyword revision1
(...)

What version of the product are you using? On what operating system?
r451 snapshot (2010-11-30)

Please provide any additional information below.

DEBUG Using file level revision diff
DEBUG Binary file check for file </XXX/YYY.java> revision:3287
DEBUG Getting filelevel revision diffs
DEBUG revision : 3287, url=file:///AAA/svnrepos_svn16/XXX/YYY.java
DEBUG prev url=file:///AAA/svnrepos_svn16/XXX/YYY.java
ERROR Error diff() expecting revision object for keyword revision1
DEBUG Binary file check for file </XXX/YYY.java> revision:3287
DEBUG 3287 : /XXX/YYY.java : M : 0 : 0

"svn diff" only lists text changes for this file in changeset 3287. The only 
SVN properties it has set is svn:keywords.

What steps will reproduce the problem?

python svnlog2sqlite.py -l file:///var/lib/svn/repositories/myrepo/
/root/svnplot.sl3

Updating the subversion log

                                           Repository :
file:///var/lib/svn/repositories/myrepo/                                  

Log database filepath : /root/svnplot.sl3
Update Changed Line Count : True
ERROR:root:Error list index out of range
Error list index out of range
Traceback (most recent call last):
  File "svnlog2sqlite.py", line 40, in convert
    (startrevno, endrevno) = self.svnclient.findStartEndRev()
  File "/root/SVNPlot-0.5.6/svnplot/svnlogiter.py", line 158, in
findStartEndRev
    if( startrev != None and len(startrev[0]) > 0):
IndexError: list index out of range

If I point to
file:///var/lib/svn/repositories/myrepo/trunk 

it works (but I am mostly interested in the modified lines graph)

What version of the product are you using? On what operating system?
svnplot 0.5.6

There doesn't seem to be any better way to contribute patches/forks.  So I'm 
filing this.

I've attached versions of svnstats.py and svnplot-js.py that I've been working 
on.  They have a few bug fixes like date search handling but most of the change 
you'll seen is simply due to the files having been processed through pythontidy 
to conform to python naming conventions and pylint to clean it up a bit.  I'm 
not using the matlib version of svnplot.py so I'm sure I broke compatibility 
with that.

You might investigate combining this project with viewvc.  It's a python and db 
based query tool for svn repositories.

I'm including svnlog2sqlite because there were a few fixes there too.  I 
haven't cleaned that file up though.

What steps will reproduce the problem?
1. While creating the Sqlite file for a repository 

What is the expected output? What do you see instead?
“file svnlogiter.py”, line 401, in getUrl
>
> Path=path.encode(‘utf8’)
>
> UnicodeDecodeError:’ascii’ codec cant decode byte 0Xe5 in position 47.
> Ordinal not in range <128>.”


What version of the product are you using? On what operating system?
0.5.14

Please provide any additional information below.
I resolved this by commenting out the "Path=path.encode('utf8')" line in
SVNlogiter.py

-NT

It would be nice if the author activity report key didn't cover up one of
the author bar lines.  I've attached a screen shot of what the issue. 
Note: I removed the author names from the screen shot.

What steps will reproduce the problem?
1. Repository contains folder named 'test folder' (please consider space in
folder name)
2. Execute command - svnlog2sqlite.py -l
http://servername/reponame/repo/trunk/test folder f:\sqliteDB\test_db

Error - Error Unable to find repository location for
"http://servername/reponame/trunk/test folder" in revision 1

What is the expected output? What do you see instead?
Expected output -  DB should be created.
Current output -  Error - (as above)


What version of the product are you using? On what operating system?
1. Product verison - SVNPlot-0.6.0.win32.exe
2. OS - Windows XP


Please provide any additional information below.

Currently, repository has folders viz /trunk/test1 & /trunk/test folder
svnlog2sqlite.py -l is 
working correctly for '/trunk/test1' (folder name without space), but
Error for '/trunk/test folder' (folder name with space)

I have tried 'svnlog2sqlite' cmd with "" also
i.e. svnlog2sqlite.py -l "http://servername/reponame/repo/trunk/test
folder" f:\sqlite\test2_db

In this case, getting error as
ERROR:root:Error URL 'http://servername/reponame/repo/trunk/test f
older' is malformed or the scheme or host or path is missing

What steps will reproduce the problem?
1. python svnplot.py -v -r 300 /root/svnplot.sl3 /var/www/html/svnplot/

What is the expected output? What do you see instead?
Calculating subversion stat graphs                                        

Subversion log database : /root/svnplot.sl3                               

Graphs will generated in : /var/www/html/svnplot/                         

Repository Name : None                                                    

Search path inside repository : /%                                        

Graph thumbnail size : 100                                                

using default html template                                               

Set the search path to /                                                  

Calculating Activity by day of week graph                                 

/usr/lib/python2.6/site-packages/matplotlib/backends/backend_gtk.py:640:
DeprecationWarning: Use the new widget gtk.Tooltip    
  self.tooltips = gtk.Tooltips()                                          

Calculating Activity by time of day graph
Calculating Author Activity graph
Calculating Commit activity graph
Calculating Commit Activity Index by time of day graph
Calculating LoC graph
Calculating LoC and Churn graph
Calculating Developer Contribution graph
Calculating Average File Size graph
Calculating File Count graph
Calculating File Types graph
Calculating current Directory size pie graph
Calculating Directory size line graph
Calculating current Directory File Count pie graph
Calculating tag cloud for log messages
Calculating Author Tag Cloud
Traceback (most recent call last):
  File "svnplot.py", line 657, in <module>
    RunMain()
  File "svnplot.py", line 654, in RunMain
    svnplot.AllGraphs(graphdir, options.searchpath, options.thumbsize)
  File "svnplot.py", line 244, in AllGraphs
    graphParamDict = self._getGraphParamDict( thumbsize)
  File "svnplot.py", line 589, in _getGraphParamDict
    graphParamDict["AuthCloud"] = self.AuthorCloud()
  File "svnplot.py", line 555, in AuthorCloud
    for auth, freq, actIdx in authTagList])
  File "svnplot.py", line 191, in getTagFontSize
    scalingFactor = fontsizevariation/(maxFreqLog-minFreqLog)
ZeroDivisionError: float division


What version of the product are you using? On what operating system?
SVNPlot 0.5.6 on Mandriva Linux Cooker

What steps will reproduce the problem?
1. run svnlog2sqlite to extract data

What is the expected output? What do you see instead?

should finish, but instead, in my case, fails:

Traceback (most recent call last):
  File "svnlog2sqlite.py", line 42, in convert
    self.ConvertRevs(startrevno, endrevno, bUpdLineCount, maxtrycount)
  File "svnlog2sqlite.py", line 87, in ConvertRevs
    addedfiles, changedfiles, deletedfiles = revlog.changedFileCount(bChkIfDir)
  File "/home/bkc/src/SVNPlot-0.5.5/svnplot/svnlogiter.py", line 415, in
changedFileCount
    isdir = self.isDirectory(change)
  File "/home/bkc/src/SVNPlot-0.5.5/svnplot/svnlogiter.py", line 435, in
isDirectory
    isDir = self.logclient.isDirectory(revno, path, action)
  File "/home/bkc/src/SVNPlot-0.5.5/svnplot/svnlogiter.py", line 274, in
isDirectory
    entry = self.getInfo(changepath, revno)
  File "/home/bkc/src/SVNPlot-0.5.5/svnplot/svnlogiter.py", line 223, in
getInfo
    entry_list = self.svnclient.info2( url,revision=rev,recurse=False)
ClientError: URL
'http://svn.strader-ferris.com:3080/svn/trunk/trunk/Python/MurkWorks/scripts/CCX
LoadSICCodes.py'
non-existent in revision 624
Trying again (3)


What version of the product are you using? On what operating system?

0.5.5 on Ubuntu intrepid with system python 2.6

Please provide any additional information below.

This repository contains, perhaps 800 files and 8900 revs.

right now I am going to try changing ConvertRevs to skip an svn rev if an
exception is raised, not pretty but hopefully a missing rev won't break
plot generation.

What steps will reproduce the problem?
Run svnlog2sqlite.py on a repository where a directory has been deleted.
It goes into an infinite loop trying to find files in this directory at the
latest revision, which is obviously not possible. 

What is the expected output? What do you see instead?
The DB was created but is empty.

What version of the product are you using? On what operating system?
SVNPlot 0.5.2 on Windows XP.  SVN 1.5.

Please provide any additional information below.

Error from svnlog2sqlite.py:

  Number revisions converted : 400 (Rev no : 1175)
  Found Error expected a character buffer object

After re-trying this aborts the run.

The change in question doesn't look too interesting. It was some adds, some 
deletes, and changes of files without anything out of the ordinary. There was a 
mixture of source (shell script) and data files (.tar.gz) I suppose.

From the log file:

2010-11-27 15:58:38,303 ERROR Found Error expected a character buffer object
Traceback (most recent call last):
  File "svnlog2sqlite.py", line 56, in convert
    self.ConvertRevs(startrevno, endrevno, bUpdLineCount, maxtrycount)
  File "svnlog2sqlite.py", line 115, in ConvertRevs
    for revlog in svnloglist:
  File "/root/svnplot-read-only/src/svnplot/svnlogiter.py", line 540, in next
    svnrevlog = SVNRevLog(self.logclient, revlog)
  File "/root/svnplot-read-only/src/svnplot/svnlogiter.py", line 710, in __init__
    self.__updateCopyFromPaths()
  File "/root/svnplot-read-only/src/svnplot/svnlogiter.py", line 756, in __updateCopyFromPaths
    change['copyfrom_path'] = curfilepath.replace(curpath, copyfrompath,1)

Version is from SVN, updated a couple of days ago.

The executable for Windows requires MSVCR71.DLL.  This DLL is not a
standard Windows DLL, and must be installed along with the application. 
This is a Visual Studio 2003 DLL which has gone out of official support,
and there is no longer any official place to download an end-user
redistributable package containing that DLL.  The only options are to copy
the DLL from a machine that has it (I have no such machine) or grab it from
one of a number of untrustworthy DLL download archives (no thanks).

The .exe should either be distributed as an installer than includes the
redistributable DLL you have in your copy of VS 2003 (Inno Setup makes
building such installers incredibly easy), or you should rebuild with a
newer version of Visual Studio (VS 2008 Express is free) for which the
runtime DLLs can be downloaded from Microsoft directly.  As a last resort,
put the Windows executable in a ZIP file containing the DLL so it can be
unpacked and run.

Some missing charts would be very useful:

- LoC per Commits (not only per date)
- Churn (not only commit) per Hour of Day
- Churn (not only commit) per Day of Week
- Churn per Date (without LoC because the appropriate line count scale is
not necessarily the same for LoC and Churn --> Churn becomes unreadable
because of smallness)
- Churn per Commits

What steps will reproduce the problem?
1. i had installed all the required softwares.
2. then when i type "python svnlog2sqlite.py http://192.168.1.105/test
/usr/local/svn.db" 
3.

What is the expected output? What do you see instead?
ERROR:root:Error
Error
Traceback (most recent call last):
  File "svnlog2sqlite.py", line 37, in convert
    rootUrl = self.svnclient.getRootUrl()
  File "/usr/lib/python2.5/site-packages/svnplot/svnlogiter.py", line 352,
in getRootUrl
    self.getRootUrl2()
  File "/usr/lib/python2.5/site-packages/svnplot/svnlogiter.py", line 326,
in getRootUrl2
    assert(len(changepathlist) > 0)
AssertionError


What version of the product are you using? On what operating system?
svnplot-0.5.11  on debian5.0 python2.5 svn1.5.1

Please provide any additional information below.

What steps will reproduce the problem?
When I read that the ubiquitous "unknown node"-problem had been fixed, I 
thought I'd give svnplot another try - unfortunately to no avail. :-(

The problem occured while building the sqlite DB for our internal repository.

What is the expected output? What do you see instead?
"Found Error expected a character buffer object"

What version of the product are you using? On what operating system?
Snapshot r451 (2010-11-30)

Please provide any additional information below.

The offending path /XXX/YYY is a directory which seems to have been deleted in 
this revision, while its contents have been moved into another, new directory.

console:
********
Found Error Unknown node kind for 'file:///XXX/svnrepos_svn16/XXX/ZZZ22'
Trying again (1)
Found Error expected a character buffer object
Trying again (2)
Found Error expected a character buffer object
Trying again (3)


svnlog2sqlite.log:
******************

DEBUG Found file deletion for </XXX/YYY>
DEBUG Binary file check for file </XXX/YYY> revision:5493
DEBUG 5494 : /XXX/YYY : D : 0 : 0
DEBUG Number revisions converted : 1 (Rev no : 5494)
INFO Number revisions converted : 1 (Rev no : 5494)
ERROR Found Error expected a character buffer object
Traceback (most recent call last):
  File "C:\XXX\Python 2.6.5\Lib\site-packages\svnplot\svnlog2sqlite.py", line 56, in convert
    self.ConvertRevs(startrevno, endrevno, bUpdLineCount, maxtrycount)
  File "C:\XXX\Python 2.6.5\Lib\site-packages\svnplot\svnlog2sqlite.py", line 115, in ConvertRevs
    for revlog in svnloglist:
  File "C:\XXX\Python 2.6.5\Lib\site-packages\svnplot\svnlogiter.py", line 540, in next
    svnrevlog = SVNRevLog(self.logclient, revlog)
  File "C:\XXX\Python 2.6.5\Lib\site-packages\svnplot\svnlogiter.py", line 710, in __init__
    self.__updateCopyFromPaths()
  File "C:\XXX\Python 2.6.5\Lib\site-packages\svnplot\svnlogiter.py", line 756, in __updateCopyFromPaths
    change['copyfrom_path'] = curfilepath.replace(curpath, copyfrompath,1)
TypeError: expected a character buffer object
INFO Root url found : file:///XXX/svnrepos_svn16
DEBUG Trying to get head revision rooturl:file:///XXX/svnrepos_svn16
DEBUG Found head revision 26762
DEBUG Trying to get revision log. revno:1, url=file:///XXX/svnrepos_svn16
INFO Start-End Rev no : 1-26762
INFO Converting revisions 5495 to 26762
INFO Updating revision from 5495 to 26762
INFO updating logs 5495 to 26762
DEBUG Trying to get revision logs [5495:26762]
ERROR Found Error expected a character buffer object
Traceback (most recent call last):
  File "C:\XXX\Python 2.6.5\Lib\site-packages\svnplot\svnlog2sqlite.py", line 56, in convert
    self.ConvertRevs(startrevno, endrevno, bUpdLineCount, maxtrycount)
  File "C:\XXX\Python 2.6.5\Lib\site-packages\svnplot\svnlog2sqlite.py", line 115, in ConvertRevs
    for revlog in svnloglist:
  File "C:\XXX\Python 2.6.5\Lib\site-packages\svnplot\svnlogiter.py", line 540, in next
    svnrevlog = SVNRevLog(self.logclient, revlog)
  File "C:\XXX\Python 2.6.5\Lib\site-packages\svnplot\svnlogiter.py", line 710, in __init__
    self.__updateCopyFromPaths()
  File "C:\XXX\Python 2.6.5\Lib\site-packages\svnplot\svnlogiter.py", line 756, in __updateCopyFromPaths
    change['copyfrom_path'] = curfilepath.replace(curpath, copyfrompath,1)
TypeError: expected a character buffer object

SVNplot considers some folder name as file (for files type counting) if the
folder name contains a '.'.

SVNplot should not take into account dot in path if that path is a
directory (a folder cannot have extension).

=>What is the expected output? What do you see instead?
It would be highly useful if SVNPlot outputs a small log file (specific to
the repository) at the end of creating graphs and HTML file. Things like:
-Total commits in last week
-Total file count
-Total directory size
-Total Line Count (I know its included in HTML)

=>Please provide any additional information below.
This would be highly useful for people having many repositories on their
SVN server, wanting to get information for the server as a whole (for use
in performance measurement, usage statistics etc.).
We're finding SVNPlot very promising indeed!

(after creating a sqlite db, see issue 3)

$ python /usr/local/lib/python2.6/site-packages/svnplot/svnplot.py SQLITEDB
. -v
Calculating subversion stat graphs
Subversion log database : SQLITEDB
Graphs will generated in : .
Repository Name : None
Search path inside repository : /%
Graph thumbnail size : 100
Set the search path to /
Calculating Activity by day of week graph
Calculating Activity by time of day graph
Calculating Author Activity graph
Calculating Commit activity graph
Calculating Commit Activity Index by time of day graph
Calculating LoC graph
Calculating LoC and Churn graph
Calculating Developer Contribution graph
Calculating Average File Size graph
Calculating File Count graph
Calculating File Types graph
Calculating current Directory size pie graph
Calculating Directory size line graph
Calculating current Directory File Count pie graph
Calculating tag cloud for log messages
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/site-packages/svnplot/svnplot.py", line
580, in <module>
    RunMain()
  File "/usr/local/lib/python2.6/site-packages/svnplot/svnplot.py", line
577, in RunMain
    svnplot.AllGraphs(graphdir, options.searchpath, options.thumbsize)
  File "/usr/local/lib/python2.6/site-packages/svnplot/svnplot.py", line
208, in AllGraphs
    graphParamDict = self._getGraphParamDict( thumbsize)
  File "/usr/local/lib/python2.6/site-packages/svnplot/svnplot.py", line
519, in _getGraphParamDict
    graphParamDict["TagCloud"] = self.TagCloud()
  File "/usr/local/lib/python2.6/site-packages/svnplot/svnplot.py", line
440, in TagCloud
    maxFreq = max(tagWordList, key=operator.itemgetter(1))[1]
ValueError: max() arg is an empty sequence
>

dump is below. looked at the log message on the revision in question and it 
looked okay, 
appears to have no weird UTF. was able to get the script to keep running if I 
added a catch for 
the KeyError exception around line 366 but I am not sure what the error is.

ERROR:root:Error u'\u221a'
Error u'\u221a'
Traceback (most recent call last):
  File "svnlog2sqlite.py", line 42, in convert
    self.ConvertRevs(startrevno, endrevno, bUpdLineCount, maxtrycount)
  File "svnlog2sqlite.py", line 87, in ConvertRevs
    addedfiles, changedfiles, deletedfiles = revlog.changedFileCount(bChkIfDir)
  File "/var/www/svnplot/SVNPlot-0.5.12/svnplot/svnlogiter.py", line 454, in changedFileCount
    isdir = self.isDirectory(change)
  File "/var/www/svnplot/SVNPlot-0.5.12/svnplot/svnlogiter.py", line 474, in isDirectory
    isDir = self.logclient.isDirectory(revno, path, action)
  File "/var/www/svnplot/SVNPlot-0.5.12/svnplot/svnlogiter.py", line 278, in isDirectory
    entry = self.getInfo(changepath, revno)
  File "/var/www/svnplot/SVNPlot-0.5.12/svnplot/svnlogiter.py", line 230, in getInfo
    url = self.getUrl(path)
  File "/var/www/svnplot/SVNPlot-0.5.12/svnplot/svnlogiter.py", line 366, in getUrl
    url = self.getRootUrl() + urllib.pathname2url(path)
  File "/usr/lib/python2.5/urllib.py", line 60, in pathname2url
    return quote(pathname)
  File "/usr/lib/python2.5/urllib.py", line 1205, in quote
    res = map(safe_map.__getitem__, s)
KeyError: u'\u221a'

What steps will reproduce the problem?
1. execute 
python  svnplot.py -v --dpi 70 -p svnplot-long.tmpl -n "irk" irk.sql ../svn
on Linux machine without X-server

What is the expected output? What do you see instead?
Expected: generated png and htm files in ../svn directory
Instead I see:
Calculating subversion stat graphs
Subversion log database : irk.sql
Graphs will generated in : ../svn
Repository Name : irk
Search path inside repository : /%
Graph thumbnail size : 100
Maximum dir count: 10
using template : svnplot-long.tmpl
Set the search path to /
Calculating Activity by day of week graph
Traceback (most recent call last):
  File "svnplot.py", line 723, in <module>
    RunMain()
  File "svnplot.py", line 720, in RunMain
    svnplot.AllGraphs(graphdir, options.searchpath, options.thumbsize,
options.maxdircount)
  File "svnplot.py", line 234, in AllGraphs
    self.ActivityByWeekday(self._getGraphFileName(dirpath, "ActByWeek"))
  File "svnplot.py", line 266, in ActivityByWeekday
    ax = self._drawBarGraph(data, labels,0.5)
  File "/var/www/intranet/htdocs/svnplot/svnplotbase.py", line 77, in
_drawBarGraph
    fig = plt.figure()
  File "/usr/lib64/python2.6/site-packages/matplotlib/pyplot.py", line 254,
in figure
    **kwargs)
  File
"/usr/lib64/python2.6/site-packages/matplotlib/backends/backend_tkagg.py",
line 90, in new_figure_manager
    window = Tk.Tk()
  File "/usr/lib64/python2.6/lib-tk/Tkinter.py", line 1643, in __init__
    self.tk = _tkinter.create(screenName, baseName, className, interactive,
wantobjects, useTk, sync, use)
_tkinter.TclError: no display name and no $DISPLAY environment variable


What version of the product are you using? On what operating system?
from svn rev.256
Gentoo Linux kernel 2.6.30

Please provide any additional information below.
solve problem by patching
===================================================================
--- svnplotbase.py  (revision 256)
+++ svnplotbase.py  (working copy)
@@ -10,6 +10,9 @@
 __revision__ = '$Revision:$'
 __date__     = '$Date:$'

+#import matplotlib
+#matplotlib.use("Agg")
+
 import matplotlib.pyplot as plt
 from matplotlib.dates import YearLocator, MonthLocator, DateFormatter
 from matplotlib.ticker import FixedLocator, FormatStrFormatter
Index: svnplot.py
===================================================================
--- svnplot.py  (revision 256)
+++ svnplot.py  (working copy)
@@ -35,6 +35,8 @@
 __revision__ = '$Revision:$'
 __date__     = '$Date:$'

+#import matplotlib
+#matplotlib.use("Agg")

 import matplotlib.pyplot as plt
 import matplotlib.mpl as mpl

It would be useful to show last n log messages in generated stats. Also RSS 
feed for them will be great to track commits.

What steps will reproduce the problem?
1. Create index.htm file using svnplot-js.py file.
e.g. cmd - svnplot-js.py <svnsqlitedbpath> <output directory>

2. Open the index.htm file in IE7 or IE8. we can see the small images, but
GraphPopBox doesnot work correctly. Even the popBox does not contains
'close[X]' button.
3. It works correctly in FireFox

What is the expected output? What do you see instead?
Expected - When we click on small images, GraphPopBox should popup
correctly as in FireFox

Current O/p  - GraphPopBox open at a right top corner of browser. It does
not contains close button.

What version of the product are you using? On what operating system?
svnplot - 0.6.0
OS - Windows XP


Please provide any additional information below.
If we add following lines in generated index.htm, it works fine in IE7 & IE8.
lines- 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<script type="text/javascript" src="excanvas.compiled.js"></script>

The line 
<script type="text/javascript" src="excanvas.compiled.js"></script>
is already commented in svnplot-js.py

These (above mentioned)lines are present in svnplot-js.tmpl file, but
absent in svnplot-js.py --> html template.

You can see this issue in the "directory size" graph for example.

What steps will reproduce the problem?
1. python svnlog2sqlite.py -l $DEPOT/branches/$BRANCHE $BRANCHE.sqlite
2. python svnplot.py -n "$BRANCHES" $BRANCHE.sqlite $ROOT/www/branches/$i
3.

What is the expected output? What do you see instead?
1.http://stats.tikiwiki.org/branches/4.x/dirsizepie.png
2.I would like to see the size repartition between folder in the branche.

What version of the product are you using? On what operating system?
trunk -r 246 on Ubuntu server

Thx
Changi

What steps will reproduce the problem?
1. python svnlog2sqlite.py -g -v -l file:///home/two/stats/tikisvn/trunk
tw.sqlite
2.
3.

What is the expected output? What do you see instead?
Don't have diff between file. See below svnlog2sqlite.log.
-- Error not all arguments converted during string formatting --

What version of the product are you using? On what operating system?
trunk HEAD on Ubuntu Server

Please provide any additional information below.

2010-02-04 09:19:55,111 DEBUG found rooturl file:///home/two/stats/tikisvn
2010-02-04 09:19:55,111 DEBUG Root url found : file:///home/two/stats/tikisvn
2010-02-04 09:19:55,111 DEBUG Trying to get head revision
rooturl:file:///home/two/stats/tikisvn
2010-02-04 09:19:55,112 DEBUG Found head revision 24830
2010-02-04 09:19:55,112 DEBUG Trying to get revision log. revno:1,
url=file:///home/two/stats/tikisvn
2010-02-04 09:19:56,296 DEBUG Start-End Rev no : 13490-24830
2010-02-04 09:19:56,296 INFO updating logs 13490 to 24830
2010-02-04 09:19:56,296 DEBUG Trying to get revision logs [13490:24830]
2010-02-04 09:19:57,575 DEBUG converting revision 13490
2010-02-04 09:19:57,576 DEBUG Changed path count : 1
2010-02-04 09:19:57,576 DEBUG isDirectory: path /trunk change type A revno
13490
2010-02-04 09:19:57,576 DEBUG Trying to get file information for
file:///home/two/stats/tikisvn/trunk
2010-02-04 09:19:58,748 DEBUG Updating line count for revision 13490
2010-02-04 09:19:58,749 DEBUG Using file level revision diff
2010-02-04 09:19:58,749 DEBUG DiffLineCount 13490 : /trunk : A : 0 : 0
2010-02-04 09:19:58,749 DEBUG 13490 : /trunk : A : 0 : 0
2010-02-04 09:19:58,749 DEBUG Number revisions converted : 1 (Rev no : 13490)
2010-02-04 09:19:58,749 DEBUG converting revision 13618
2010-02-04 09:19:58,749 DEBUG Changed path count : 1
2010-02-04 09:19:58,749 DEBUG isDirectory: path
/trunk/templates/tiki-editpage.tpl change type M revno 13618
2010-02-04 09:19:58,749 DEBUG Trying to get file information for
file:///home/two/stats/tikisvn/trunk/templates/tiki-editpage.tpl
2010-02-04 09:19:59,963 DEBUG Updating line count for revision 13618
2010-02-04 09:19:59,964 DEBUG Using file level revision diff
2010-02-04 09:19:59,964 DEBUG Getting filelevel revision diffs
2010-02-04 09:19:59,964 DEBUG revision : 13618,
url=file:///home/two/stats/tikisvn/trunk/templates/tiki-editpage.tpl

2010-02-04 09:19:59,964 ERROR Error not all arguments converted during
string formatting

2010-02-04 09:19:59,964 DEBUG 13618 : /trunk/templates/tiki-editpage.tpl :
M : 0 : 0
2010-02-04 09:19:59,964 DEBUG Number revisions converted : 2 (Rev no : 13618)
2010-02-04 09:19:59,964 DEBUG converting revision 13624
2010-02-04 09:19:59,964 DEBUG Changed path count : 1
2010-02-04 09:19:59,964 DEBUG isDirectory: path /trunk/get_strings.php
change type M revno 13624
2010-02-04 09:19:59,965 DEBUG Trying to get file information for
file:///home/two/stats/tikisvn/trunk/get_strings.php
2010-02-04 09:20:00,084 DEBUG Updating line count for revision 13624
2010-02-04 09:20:00,085 DEBUG Using file level revision diff
2010-02-04 09:20:00,085 DEBUG Getting filelevel revision diffs
2010-02-04 09:20:00,085 DEBUG revision : 13624,
url=file:///home/two/stats/tikisvn/trunk/get_strings.php
2010-02-04 09:20:00,085 ERROR Error not all arguments converted during
string formatting

My repository originally contained my project, and a 'lib' folder, which
contained various external libraries. 

At some point I removed the lib folder from the repository.

SVN Plot appears to be still counting lines of code in this folder, or for
some other reason it's count is way off.

SVNPlot shows 900,000+ lines of code, and more tellingly shows no drop in
the number of lines when I know that several hundred lines should have been
removed when I remover the 'lib' folder.

running cloc (a line of code counting app) on a freshly checked out copy of
my repository shows around 90,000 lines... so SVN Plot appears to be an
order of magnitude out!!

What steps will reproduce the problem?

1. Trying to call svnlog2sqlite on repositories containing national
characters in the commit log (file names)?

What is the expected output? What do you see instead?

Error You must not use 8-bit bytestrings unless you use a text_factory that
can interpret 8-bit bytestrings (like text_factory = str). It is highly
recommended that you instead just switch y
our application to Unicode strings.
Traceback (most recent call last):
  File "c:\Programme\Python\Lib\site-packages\svnplot\svnlog2sqlite.py",
line 42, in convert
    self.ConvertRevs(startrevno, endrevno, bUpdLineCount, maxtrycount)
  File "c:\Programme\Python\Lib\site-packages\svnplot\svnlog2sqlite.py",
line 94, in ConvertRevs
    values(?, ?, ?, ?,?,?)", (revlog.revno, filename, changetype,
linesadded, linesdeleted, lc_updated))
ProgrammingError: You must not use 8-bit bytestrings unless you use a
text_factory that can interpret 8-bit bytestrings (like text_factory =
str). It is highly recommended that you instead j
ust switch your application to Unicode strings.
Trying again (1)


What version of the product are you using? On what operating system?
- SVNPlot-0.5.10.win32.exe
- python-2.6.2.msi
- py26-pysvn-svn156-1.7.1-1233.exe
- numpy-1.3.0rc2-win32-superpack-python2.6.exe
- matplotlib-0.99.1.win32-py2.6.exe

We have an SVN system that we access directly via the svn protocol (tcp
port 3690).

I cannot run svnplot on the svn server itself because the system only has
python 2.4 on it (CentOS 5.3 X86_64) and it seems this app requires at
least 2.5.

I've tried to run the command: /opt/SVNPlot-0.5.6$ sudo python
./svnplot/svnlog2sqlite.py -l svn://subdomain.domain.com/var/svn
/opt/SVNPlot-0.5.6/sqlite3db/svn and get the error:

Updating the subversion log
Repository : svn://subdomain.domain.com/var/svn
Log database filepath : /opt/SVNPlot-0.5.6/sqlite3db/svn
Update Changed Line Count : True
ERROR:root:Error Repository Root not found
Error Repository Root not found
Traceback (most recent call last):
  File "./svnplot/svnlog2sqlite.py", line 39, in convert
    headrev = self.svnclient.getHeadRevNo()
  File "/opt/SVNPlot-0.5.6/svnplot/svnlogiter.py", line 116, in getHeadRevNo
    headrev = self._getHeadRev()
  File "/opt/SVNPlot-0.5.6/svnplot/svnlogiter.py", line 127, in _getHeadRev
    rooturl = self.getRootUrl()
  File "/opt/SVNPlot-0.5.6/svnplot/svnlogiter.py", line 340, in getRootUrl
    raise RuntimeError , "Repository Root not found"
RuntimeError: Repository Root not found

The system is also password protected.

Is there any way I can run svnplot against this configuration? The
quickstart guide says "<svnrepo url> can be any repository format supported
by Subverson" but I'm not having much luck.

SVNPlot-0.5.6 is installed on Ubuntu 9.04 server amd64, and the server is
on the same subnet as the SVN server.

Thanks in advance,

Alan

When a directory is deleted in the repository, the files that directory
contained is not taken into account for LoC/files counting (not deducted).

The "files type" chart should represent the repository at a given moment
(last rev by default) and should not take into account deleted files.

What steps will reproduce the problem?
1. Running the svnPlot.py script caused a divide by zero at line 191.  I
was using the source from the installer.  I just updated my source code
from the trunk and am currently re-generating the database.  I will try
again after re-generating the db.

I fixed the problem by change line 191 to the following:

    #now calculate the scaling factor for scaling the freq to fontsize.
    if( maxFreqLog-minFreqLog != 0):
        scalingFactor = fontsizevariation/(maxFreqLog-minFreqLog)
    else:
        scalingFactor = 1

From the Wiki:

"-l : Update the changed line count data also. By default line count data is 
NOT updated.
You can run this step multiple times. The new revisions added in the repository 
will get added to 
database
NOTE : for version 0.5.5 -l option works only if svnrepo_url is 'repository 
root'. It doesn't work if 
the URL is inside the repository. This a bug. It will be fixed in the next 
version."

I checked out the most recent version and tested this. I found it doesn't work 
on the newest 
0.5.9 version of SVNPlot. Where should I start to try and fix this?

Thanks.

-oscar

I've run svnlog2sqlite successfully on other parts of our repository. Trying to 
run it on the whole of our repository, however, resulted in a crash, in this 
case at revision 404 (displays: Error unknown node kind). svnlog2sqlite 
eventually restarts the process and skips(?) the offending revision.

Looking at the svn logs, revision 404 contained some modifications, additions 
and deletions (with copy). Revisions before revision 404 also includes the same 
type of actions.

I am running SVNplot 0.6.1 and python 2.6 under Windows XP.