Versions Compared

Old Version 74

changes.mady.by.user Dean Lane

Saved on

compared with

New Version 75

changes.mady.by.user Dean Lane

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Section
Column
width30%
Wiki Markup
h3. Rice Repository Groups
* [Campus Repositories]
* [IT Repositories]
* [HPC Repositories]

h3. Statistics

|Number of Repository groups| {sql:dataSource=wiki|output=wiki|table=false}select count(*) from owl_repository_group{sql} |
|Number of repositories| {sql:dataSource=wiki|output=wiki|table=false}select count(*) from owl_repository where repo_status <> 'deleted'{sql} |
|Number of private repositories | {sql:dataSource=wiki|output=wiki|table=false}select count(*) from owl_repository where repo_public = false and repo_status <> 'deleted'{sql} |
|Number of public repositories | {sql:dataSource=wiki|output=wiki|table=false}select count(*) from owl_repository where repo_public = true and repo_status <> 'deleted'{sql} |
|Largest repository| {sql:dataSource=wiki|output=wiki|table=false}select repo_group_code || '.' || repo_name as name from owl_repository where repo_status <> 'deleted' order by repo_size desc limit 1{sql}|
|Most active repository| {sql:dataSource=wiki|output=wiki|table=false}select distinct d.repo_group_code || '.' || d.repo_name as name from owl_repository_data d JOIN owl_repository r ON d.repo_group_code = r.repo_group_code and d.repo_name = r.repo_name where r.repo_status <> 'deleted' and (d.repo_group_code, d.repo_name, d.repo_revision) in (select repo_group_code, repo_name, max(repo_revision) from owl_repository_data where repo_name <> 'subversion' and repo_group_code <> 'it.svn' group by repo_group_code, repo_name order by max desc limit 1);{sql} |
|Number of Repositories missing an access_file| {sql:dataSource=wiki|output=wiki|table=false}select count(*) from owl_repository where repo_access_file_exists = false and repo_group_code <> 'it.svn' and repo_name <> 'subversion' and repo_status <> 'deleted'{sql} |
Column
width40%

What is Subversion?

Subversion is a free/open-source version control system. That is, Subversion manages files and directories, and the changes made to them, over time. This allows you to recover older versions of your data, or examine the history of how your data changed. In this regard, many people think of a version control system as a sort of "time machine".

– Version Control with Subversion by O'Reilly Media(c)

What is a Repository group?

A repository group is a collection of repositories that share common characteristics, like backup policy, retention policy, specialized hooks. Each repository group also has its own name space for repository names.

Can I have a Repository group for my group?

Good question. Generally, we'd like to restrict groups to only major entities who will have many repositories. This means that in most cases this will be limited to departments, if they have a need for it. Creating a repository group is a fairly major process and requires that the subversion servers be taken off line. Due to this requirement, groups will only be created at specific points in the year to avoid impacting those using the server.

Column
width30%

Subversion Maintenance Schedule

Regular maintenance
  • Monday mornings from 8am to 9am
Next Repository group creation
  • July 27th 8am - 8pm.

...

Deck of Cards
idChartDeck
Card
labelOverview

Overall Charts

Chart
3Dfalse
typepie
dataOrientationhorizontal
titleRepository Space Available
Wiki Markup

{sql:dataSource=wiki|output=wiki}
select 218000000000/1024/1024 as total, trunc((218000000000 - sum(d.repo_size)*2)/1024/1024) as free, trunc((sum(d.repo_size)*2)/1024/1024) as used from owl_repository_data d JOIN owl_repository r ON d.repo_group_code = r.repo_group_code and d.repo_name = r.repo_name where r.repo_status <> 'deleted'
{sql}
Card
labelsvn.rice.edu

svn.rice.edu Charts

Chart
3Dfalse
ylabelSize in Megabytes
timePeriodDay
categoryLabelPositiondown45
typebar
dataOrientationvertical
titleTop 10 Repository Sizes
colorsblue
Wiki Markup

{sql:dataSource=wiki|output=wiki}
select repo_name as name, repo_size/1024/1024 as size from owl_repository where repo_group_code = 'svn' and repo_status <> 'deleted' order by repo_size desc limit 10
{sql}
Chart
3Dfalse
ylabelNumber of Revisions
timePeriodDay
categoryLabelPositiondown45
typeline
dataOrientationvertical
titleTop 10 Repository Revisions
colorsgreen
Wiki Markup

{sql:dataSource=wiki|output=wiki}
select d.repo_name as name, max(d.repo_revision) as revision from owl_repository_data d JOIN owl_repository r ON d.repo_group_code = r.repo_group_code and d.repo_name = r.repo_name where r.repo_status <> 'deleted' and d.repo_group_code = 'svn' group by name order by revision desc limit 10
{sql}
Card
labelit.svn.rice.edu

it.svn.rice.edu Charts

Chart
3Dfalse
ylabelSize in Megabytes
timePeriodDay
categoryLabelPositiondown45
typebar
dataOrientationvertical
titleTop 10 Repository Sizes
colorsblue
Wiki Markup

{sql:dataSource=wiki|output=wiki}
select repo_name as name, repo_size/1024/1024 as size from owl_repository where repo_group_code = 'it.svn' and repo_name <> 'subversion' and repo_status <> 'deleted' order by repo_size desc limit 10
{sql}
Chart
3Dfalse
ylabelNumber of Revisions
timePeriodDay
categoryLabelPositiondown45
typeline
dataOrientationvertical
titleTop 10 Repository Revisions
colorsgreen
Wiki Markup

{sql:dataSource=wiki|output=wiki}
select d.repo_name as name, max(d.repo_revision) as revision from owl_repository_data d JOIN owl_repository r ON d.repo_group_code = r.repo_group_code and d.repo_name = r.repo_name where r.repo_status <> 'deleted' and d.repo_group_code = 'it.svn' and d.repo_name <> 'subversion' group by name order by revision desc limit 10
{sql}
Card
labelhpc.svn.rice.edu
Wiki Markup


h2. hpc.svn.rice.edu Charts

{chart:type=bar|3D=false|colors=blue|timePeriod=Day|ylabel=Size in Megabytes|categoryLabelPosition=down45|dataOrientation=vertical|title=Top 10 Repository Sizes}
{sql:dataSource=wiki|output=wiki}
select repo_name as name, repo_size/1024/1024 as size from owl_repository where repo_group_code = 'hpc.svn' and repo_name <> 'subversion' and repo_status <> 'deleted' order by repo_size desc limit 10
{sql}
{chart}

{chart:type=line|3D=false|colors=green|timePeriod=Day|ylabel=Number of Revisions|categoryLabelPosition=down45|dataOrientation=vertical|title=Top 10 Repository Revisions}
{sql:dataSource=wiki|output=wiki}
select d.repo_name as name, max(d.repo_revision) as revision from owl_repository_data d JOIN owl_repository r ON d.repo_group_code = r.repo_group_code and d.repo_name = r.repo_name where r.repo_status <> 'deleted' and d.repo_group_code = 'hpc.svn' and d.repo_name <> 'subversion' group by name order by revision desc limit 10
{sql}
{chart}

{card:label=Overview}

h2. Issues

{jiraissues:url=https://docs.rice.edu/jira/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?&pid=10071&resolution=-1&sorter/field=updated&sorter/order=DESC}