Skip to content

Instantly share code, notes, and snippets.

View Pavelyev's full-sized avatar

Pavelyev Anton Pavelyev

  • Moscow
View GitHub Profile
@Pavelyev
Pavelyev / timebomb.ps1
Created March 24, 2019 18:41
$Path = "."
Get-ChildItem -path $Path -recurse |
Where {!$_.PSIsContainer -and $_.LastWriteTime -lt (get-date).addHours(-24)} |
Remove-Item
# removing empty folders
Get-ChildItem -path $Path -recurse |
Where {$_.PSIsContainer -and @(Get-ChildItem -Lit $_.Fullname -r |
Where {!$_.PSIsContainer}).Length -eq 0} |
@Pavelyev
Pavelyev / DateExt.cs
Last active March 13, 2019 19:54
DateExt
public static class DateExtensions
{
public static string ToText(this DateTime date)
{
var hour = (DateField)date.Hour;
bool zy = false, zm = false, zd = false;
if ((hour & DateField.Year) > 0)
zy = true;
if ((hour & DateField.Month) > 0)
zm = true;
@Pavelyev
Pavelyev / code.cs
Last active September 4, 2017 10:01
C# parallel string processing example
// ABb46un7i865bvbbr => A_B_b_4_6_u_n_7_i_8_6_5_b_v_b_b_r
string Process(string input)
{
var sbCapacity = input.Length * 2 - 1;
var sb = new StringBuilder(sbCapacity);
sb.Length = sbCapacity;
Parallel.For(0, input.Length - 1, i =>
{
sb[i * 2] = input[i];
@Pavelyev
Pavelyev / syncFolders.cs
Last active December 16, 2015 15:46
.NET Sample of mirroring one folder to another using FileSystemWatcher from System.IO
//using System;
//using System.IO;
var initDir = @"H:\1";
var destDir = @"H:\2";
var watcher = new FileSystemWatcher(initDir);
Func<string, string> destPath = path => path.Replace(initDir, destDir);
watcher.Changed += (sender, eventArgs) => File.Copy(eventArgs.FullPath, destPath(eventArgs.FullPath), overwrite: true);
watcher.Deleted += (sender, eventArgs) => File.Delete(destPath(eventArgs.FullPath));
watcher.Renamed += (sender, eventArgs) =>
@Pavelyev
Pavelyev / LAMP
Last active August 29, 2015 14:21
LAMP
https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu
sudo apt-get update
sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y dist-upgrade && sudo apt-get -y autoremove
sudo apt-get install apache2
sudo a2enmod rewrite
service apache2 restart
@Pavelyev
Pavelyev / Oracle field int to varchar
Last active August 29, 2015 14:20
Oracle field int to varchar
alter table $TABLE_NAME$ add tmp_string varchar(10);
update $TABLE_NAME$ set tmp_string = cast($FIELD_NAME$ as varchar(10));
alter table $TABLE_NAME$ drop column $FIELD_NAME$;
alter table $TABLE_NAME$ rename column tmp_string to $FIELD_NAME$;
@Pavelyev
Pavelyev / Color animation
Last active August 29, 2015 14:20
Color animation
<html>
<head>
<script type="text/javascript" src="http://code.jquery.com/jquery-2.1.1.min.js"></script>
<script type="text/javascript" src="http://www.bitstorm.org/jquery/color-animation/jquery.animate-colors-min.js"></script>
<script>
$(document).ready(function() {
var $el = $("body > div");
var colors = ["#fc0", "#d00", "#42aaff"];
var dur = 3000;
var count = 0;
@Pavelyev
Pavelyev / Oracle delete dublicates
Created April 29, 2015 09:18
DELETE FROM
TABLE_NAME A
WHERE
a.rowid >
ANY (
SELECT
B.rowid
FROM
TABLE_NAME B
WHERE
@Pavelyev
Pavelyev / Oracle AI
Last active August 24, 2016 11:29
CREATE SEQUENCE $TABLE_NAME$_SEQ;
create or replace trigger $TABLE_NAME$_AI before insert on $TABLE_NAME$
for each row begin
if :new.id is null then
SELECT $TABLE_NAME$_seq.NEXTVAL
INTO :new.id
FROM dual;
end if;
end $TABLE_NAME$_AI;