Skip to content

Instantly share code, notes, and snippets.

@obukhov
obukhov / drop_column_if_exist.sql
Created April 5, 2016 12:35
Drop column stored procedure for mysql
DROP PROCEDURE IF EXISTS drop_column_if_exist;
DELIMITER ';;'
CREATE PROCEDURE drop_column_if_exist(IN schemaName CHAR(255), IN tableName CHAR(255), IN columnName CHAR(255)) BEGIN
IF exists(
SELECT *
FROM information_schema.columns
WHERE table_schema = schemaName AND table_name = tableName AND column_name = columnName)
THEN
SET @query = CONCAT('ALTER TABLE ', tableName, ' DROP COLUMN ', columnName, ';');
# top log oneliner
# outputs first 6 lines of top command every second
while :; do top -b -n 1 | head -n6; sleep 1; done
@obukhov
obukhov / top_to_log.sh
Created September 10, 2014 15:19
Log top memory status to log every second
while true; do echo `date` `top -b -n 1 | grep Mem` >> top.log; sleep 1; done&
<?php
/**
* Created by JetBrains PhpStorm.
* User: aobukhov
* Date: 1/15/13
* Time: 7:40 PM
*/
class CurlRequest implements CurlInterface
{
private $curlResource = null;
@obukhov
obukhov / Combination.php
Created December 25, 2012 20:52
Выводит комбинации n по k. Использование: php -f Combination.php k n
<?php
if ($argc < 3) {
throw new Exception('Wrong params count');
}
$k = intval($_SERVER['argv'][1]);
$n = intval($_SERVER['argv'][2]);
if ($n <= 0 || $k <= 0 || $n > $k) {
@obukhov
obukhov / moduleLink.sh
Created September 17, 2012 21:08
Relink bitrix modules