Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
Wiki Markup
{composition-setup}{composition-setup}

Section
h3.

Rice

Repository

Groups

* [

] * [ ] * [ Repositories] h3. Statistics |Number of Repository groups|

Statistics

Column
width30%
Wiki Markup

Number of Repository groups

Wiki Markup
{sql:dataSource=wiki|output=wiki|table=false}select count(*) from owl_repository_group{sql}

| |

Number

of

repositories|

repositories

Wiki Markup
{sql:dataSource=wiki|output=wiki|table=false}select count(*) from owl_repository where repo_status <> 'deleted'{sql}

| |

Number

of

private

repositories |

repositories

Wiki Markup
{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 |

repositories

Wiki Markup
{sql:dataSource=wiki|output=wiki|table=false}select count(*) from owl_repository where repo_public = true and repo_status <> 'deleted'{sql}

| |

Largest

repository|

repository

Wiki Markup
{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|

repository

Wiki Markup
{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

|

Wiki Markup
{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
  • Wednesday mornings from 6am to 7am
Next Repository group creation
  • July 27th 8am - 8pm.
Deck of Cards
idChartDeck

...

Wiki Markup
{deck:id=ChartDeck}
Overview
Wiki Markup
{card:label=Overview}
Card
label

Overall Charts

Chart
3Dfalse
typepie
dataOrientationhorizontal
titleRepository Space Available

unmigrated-inline-wiki-markup

{sql:dataSource=wiki|output=wiki}
select 161061273600/1024/1024 as total, trunc((161061273600 - sum(r.repo_size)*2)/1024/1024) as free, trunc((sum(r.repo_size)*2)/1024/1024) as used from owl_repository r where r.repo_status <> 'deleted'
{sql}

Wiki Markup
{card}
svn.rice.edu}
Wiki Markup
{card:label=
Card
label

svn.rice.edu Charts

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

unmigrated-inline-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

unmigrated-inline-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

Wiki Markup
{card}
it.svn.rice.edu}
Wiki Markup
{card:label=
label

it.svn.rice.edu Charts

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

unmigrated-inline-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

unmigrated-inline-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

Wiki Markup
{card}
hpc.svn.rice.edu}
Wiki Markup
{card:label=
label

hpc.svn.rice.edu Charts

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

unmigrated-inline-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 = 'hpc.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

unmigrated-inline-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 = 'hpc.svn' and d.repo_name <> 'subversion' group by name order by revision desc limit 10
{sql}

Wiki Markup
{card}
label
Wiki Markup
{card:label=Issues}
Card

Issues

unmigrated-inline-wiki-markup
{card}
Wiki Markup
{deck}
h2. Issues {jiraissues:url=https://docs.rice.edu/jira/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?&pid=10071&sorter/field=issuekey&sorter/order=DESC}