You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@subversion.apache.org by "Naumenko, Roman" <ro...@rbccm.com> on 2014/04/25 21:52:28 UTC
Flatten out svnaccess
Hello SVN users,
We're looking to integrate svn access info into some reporting systems, but its almost impossible to use information from svnaccess to join with other sources.
The reason is that there are no structured relation between groups, users, repositories and permissions.
So I'm looking how to get it flattened, to have something like this:
user1 | group1 | repo | path | permissions
user2 | group1 | repo | path | permissions
and so on...
So far I managed to get first two cols, after massaging svnaccess file with combination of sed, grep and awk.
Then it become obvious that getting last three will be a problem.
Does anybody know if its possible to get this file transformed into something more sql friendly?
Thanks,
--Roman Naumenko
_______________________________________________________________________
This email is intended only for the use of the individual(s) to whom it is addressed and may be privileged and confidential.
Unauthorised use or disclosure is prohibited. If you receive This e-mail in error, please advise immediately and delete the original message.
This message may have been altered without your or our knowledge and the sender does not accept any liability for any errors or omissions in the message.
Ce courriel est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent.
Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite.
Si vous recevez ce courriel par erreur, veuillez m'en aviser immédiatement, par retour de courriel ou par un autre moyen.
Re: Flatten out svnaccess
Posted by Branko Čibej <br...@wandisco.com>.
On 25.04.2014 21:52, Naumenko, Roman wrote:
> Hello SVN users,
>
> We're looking to integrate svn access info into some reporting
> systems, but its almost impossible to use information from svnaccess
> to join with other sources.
> The reason is that there are no structured relation between groups,
> users, repositories and permissions.
>
> So I'm looking how to get it flattened, to have something like this:
>
> user1 | group1 | repo | path | permissions
> user2 | group1 | repo | path | permissions
> and so on...
>
> So far I managed to get first two cols, after massaging svnaccess file
> with combination of sed, grep and awk.
> Then it become obvious that getting last three will be a problem.
>
> Does anybody know if its possible to get this file transformed into
> something more sql friendly?
Of course it is, but you really should begin by parsing the file, not
fiddling around with sed, grep and awk.
The file format is compatible with Python's ConfigParser module; you'll
have no trouble loading it there, then massaging the data in any way you
like.
-- Brane
--
Branko Čibej | Director of Subversion
WANdisco // Non-Stop Data
e. brane@wandisco.com