Clever Code

Directory.EnumerateFiles(args[0], "*.cs", SearchOption.AllDirectories).AsParallel().Select(f => new { File = f, Bytes = File.ReadAllBytes(f) }).Select(f => new { File = f.File, Bytes = f.Bytes, Encoding = f.Bytes.Take(3).SequenceEqual(new byte[] { 239, 187, 191 }) ? Encoding.UTF8 : Encoding.Default }).ForAll(f => File.WriteAllText(f.File, f.Encoding.GetString(f.Bytes).Split(new string[] { Environment.NewLine }, StringSplitOptions.None).Select(l => new { Line = l, Index = l.Select((c, i) => new { Char = c, Index = i }).FirstOrDefault(c => c.Char != ' ' && c.Char != '\t') }).Select(l => l.Index == null ? l.Line : l.Line.Select((c, i) => (i < l.Index.Index && c == '\t') ? "    " : c.ToString()).Aggregate((s1, s2) => s1 + s2)).Aggregate((s1, s2) => s1 + Environment.NewLine + s2), f.Encoding));

static void Main(string[] args)
{
    Directory.EnumerateFiles(args[0], "*.cs", SearchOption.AllDirectories).
        AsParallel().
        Select(f => new {
            File = f,
            Bytes = File.ReadAllBytes(f)
        }).
        Select(f => new {
            File = f.File,
            Bytes = f.Bytes,
            Encoding = f.Bytes.Take(3).SequenceEqual(new byte[] { 239, 187, 191 })
                ? Encoding.UTF8 : Encoding.Default
        }).
        ForAll(f => File.WriteAllText(f.File,
            f.Encoding.GetString(f.Bytes).Split(
                new string[] { Environment.NewLine }, StringSplitOptions.None).
            Select(l => new { Line = l, Index = l.
                Select((c, i) => new { Char = c, Index = i }).
                FirstOrDefault(c => c.Char != ' ' && c.Char != '\t') }).
            Select(l => l.Index == null ? l.Line : l.Line.
                Select((c, i) => (i < l.Index.Index && c == '\t')
                    ? "    " : c.ToString()).Aggregate((s1, s2) => s1 + s2)).
                Aggregate((s1, s2) => s1 + Environment.NewLine + s2), f.Encoding));
}

BobJanova wrote:

each developer to set his tab size

BobJanova wrote:

Any decent text editor

Robert Rohde wrote:

Its nothing that will get checked in in production code or anything like that.

Robert Rohde wrote:

Directory.EnumerateFiles(args[0], "*.cs", SearchOption.AllDirectories).AsParallel().Select(f => new { File = f, Bytes = File.ReadAllBytes(f) }).Select(f => new { File = f.File, Bytes = f.Bytes, Encoding = f.Bytes.Take(3).SequenceEqual(new byte[] { 239, 187, 191 }) ? Encoding.UTF8 : Encoding.Default }).ForAll(f => File.WriteAllText(f.File, f.Encoding.GetString(f.Bytes).Split(new string[] { Environment.NewLine }, StringSplitOptions.None).Select(l => new { Line = l, Index = l.Select((c, i) => new { Char = c, Index = i }).FirstOrDefault(c => c.Char != ' ' && c.Char != '\t') }).Select(l => l.Index == null ? l.Line : l.Line.Select((c, i) => (i < l.Index.Index && c == '\t') ? "    " : c.ToString()).Aggregate((s1, s2) => s1 + s2)).Aggregate((s1, s2) => s1 + Environment.NewLine + s2), f.Encoding));

 

Quote:

The code was executed exactly one time (ignoring test runs) and will never be touched again. Its nothing that will get checked in in production code or anything like that.

:%s/<td>\(\w\+\)\s\(\d\+\)<\/td>/<td><a href="courses.php?course=\1%20\2">\1 \2<\/a><\/td>/i

create table trns.a(id int,name varchar(20))
insert into TRNS.a values(1,'A')
insert into TRNS.a values(2,'B')
insert into TRNS.a values(3,'C')
insert into TRNS.a values(4,'D')
insert into TRNS.a values(5,'E')
insert into TRNS.a values(6,'F')
 
select *from a
if you run select Query, you will get
id  name
-------------------
1   A
2   B
3   C
4   D
.   .
.   .
 
Q. I need to Update the above table in single update statement to get result like
select *from a
 
id  name
-------------------
1   B
2   A
3   D
4   C
.   .
.   .
 
Note: I know the solution, So I have put this question under "Clever Code".

UPDATE trns.a SET id=1+((id-1)^1)