[Discuss] Any Subversion geniuses out there?

[gate at ilive4code.net (Greg Sidelinger)]

Subversion 1.8 is suppose to add features to manage local config
settings centrally at the repository level. ?Granted it will not be
out till early next year according to the road map,
http://subversion.apache.org/roadmap.html.  It sounds like this may
solve your issue as you can override the local mime settings there
instead of using a hook script.

Greg
On Fri, Dec 2, 2011 at 9:40 AM, Matt Shields <matt at mattshields.org> wrote:
> On Fri, Dec 2, 2011 at 8:11 AM, Edward Ned Harvey <blu at nedharvey.com> wrote:
>
>> > From: discuss-bounces+blu=nedharvey.com at blu.org [mailto:discuss-
>> > bounces+blu=nedharvey.com at blu.org] On Behalf Of Matt Shields
>> >
>> > ?What I was wondering is it possible in Subversion when a changeset is
>> > being committed that a hook could be used to change the mime-type. ?So if
>> > the file being committed is a *.sql, then it would override whatever
>> > mime-type the client is saying and apply text/x-sql.
>>
>> This question will be best answered by the subversion-users mailing list,
>> http://subversion.apache.org/mailing-lists.html
>> but let's see what we can say about it here.
>>
>> The mime type, I believe, is determined by the svn client, and it's
>> determined by file contents. ?What do you get, if you run linux "file" on
>> the file? ?What do you see if you try to open the file in vim or emacs?
>>
>> I'm sure you can change the mime-type as a precommit or postcommit hook
>> (probably best precommit) but I'm almost equally sure that it's not what
>> you
>> want to do. ?When they detect the contents and select a mime type, the
>> reason they're doing it is because svn internally employs all sorts of diff
>> and compression algorithms, to optimize both the network traffic and disk
>> storage. ?If you go overriding the mime types against its natural wishes,
>> you run the risk of ... ?Suboptimizing performance. ?Is probably the
>> diplomatic way of saying effing everything up.
>>
>> Another option you might consider, I believe, is that they have a mechanism
>> of some kind to allow you to inject a custom client-side diff utility for
>> certain files or mime types or something like that. ?You might configure it
>> so that your client doing the diff might run something like the SQL
>> equivalent of "dos2unix" to convert a file format and then diff it, or
>> something like that. ?Of course the odds of success doing this are
>> diminished by trac. ?You might just have to use something like tortoisesvn
>> or whatever to perform these diffs.
>>
>> In fact, tortoisesvn does some pretty excellent diffing. ?What happens if
>> you try diffing with tortoise?
>>
>>
> Yes, I'm aware of that, and I can put something in each client's svnconfig
> to override this behavior for specific filetypes. ?I don't want to have to
> do that since everytime we get a new developer it's one more step I have to
> remember to do to their dev machine.
>
> The issue is SQL Server Management Studio is encoding it weird and
> TortoiseSVN is then taking that as it being a binary and not a text file.
> ?See the two outputs of file. ?The first has been fixed by me forcing it to
> be proper encoding and the proper mime-type. ?The second was created in
> SSMS and committed.
>
> dbo.Proc_xxxx.sql: ? ? ? ? Little-endian UTF-16 Unicode c program text,
> with CRLF, CR line terminators
> dbo.Proc_yyyy.sql: ? ? ? ? ? ? ? ? ASCII c program text, with CRLF line
> terminators
>
> Yes, diff's in TortoiseSVN are great, same with Unix command line. ?The
> issue is the Dir of Tech prefer's to use Trac to review all changes, and
> because it's encoded wrong, that means svn is applying the wrong mime-type
> which causes Trac's diff feature not to work.
>
> In this case I don't believe there is any harm forcing svn to use a
> specific mime-type since they are both text. I'll check out the
> check-mime-type.pl that Greg mentioned.
>
> Matthew Shields
> Owner
> BeanTown Host - Web Hosting, Domain Names, Dedicated Servers, Colocation,
> Managed Services
> www.beantownhost.com
> www.sysadminvalley.com
> www.jeeprally.com
> Like us on Facebook <http://www.facebook.com/beantownhost>
> Follow us on Twitter <https://twitter.com/#!/beantownhost>
> _______________________________________________
> Discuss mailing list
> Discuss at blu.org
> http://lists.blu.org/mailman/listinfo/discuss