Skip to content

Instantly share code, notes, and snippets.

View ahmetkakici's full-sized avatar
💪

Ahmet Kakıcı ahmetkakici

💪
View GitHub Profile
@ahmetkakici
ahmetkakici / google-taxonmy.sql
Created October 9, 2017 19:45
Google Product Taxonomy - SQL script
INSERT INTO categories (parent_id, name, id) VALUES (null, 'Bavullar ve Çantalar', 5181);
INSERT INTO categories (parent_id, name, id) VALUES (5181, 'Alışveriş Çantaları', 5608);
INSERT INTO categories (parent_id, name, id) VALUES (5181, 'Bavul Aksesuarları', 110);
INSERT INTO categories (parent_id, name, id) VALUES (110, 'Bagaj Rafları ve Sehpaları', 499691);
INSERT INTO categories (parent_id, name, id) VALUES (110, 'Bavul Düzenleyicileri', 5620);
INSERT INTO categories (parent_id, name, id) VALUES (110, 'Bavul Etiketleri', 5651);
INSERT INTO categories (parent_id, name, id) VALUES (110, 'Bavul Kayışları', 5652);
INSERT INTO categories (parent_id, name, id) VALUES (110, 'Bavul Örtüleri', 7521);
INSERT INTO categories (parent_id, name, id) VALUES (110, 'Korumalı Kap Düzenleyicileri ve Bölme Ekleri', 503014);
INSERT INTO categories (parent_id, name, id) VALUES (110, 'Seyahat Keseleri', 5650);
@ahmetkakici
ahmetkakici / gist:4ab1b851c744f0718943ff2682c2aa94
Created September 29, 2017 10:12
fix git commit history - change user and email
#!/bin/sh
git filter-branch --env-filter '
OLD_EMAIL="______"
CORRECT_NAME="___"
CORRECT_EMAIL="_______"
if [ "$GIT_COMMITTER_EMAIL" = "$OLD_EMAIL" ]
then
export GIT_COMMITTER_NAME="$CORRECT_NAME"
export GIT_COMMITTER_EMAIL="$CORRECT_EMAIL"
var nameProperty = user.GetType().GetProperty("Name");
@ahmetkakici
ahmetkakici / Impersonation.cs
Last active November 5, 2015 14:31
Impersonation
[PermissionSet(SecurityAction.Demand, Name = "FullTrust")]
public class Impersonation : IDisposable
{
private readonly SafeTokenHandle _handle;
private readonly WindowsImpersonationContext _context;
const int LOGON32_LOGON_NEW_CREDENTIALS = 9;
public Impersonation(string domain, string username, string password)
{
### Keybase proof
I hereby claim:
* I am ahmetkakici on github.
* I am ahmetkakici (https://keybase.io/ahmetkakici) on keybase.
* I have a public key whose fingerprint is FAB6 88E2 F594 A761 28E8 9199 FB33 3DCD D5DA E75B
To claim this, I am signing this object:
@ahmetkakici
ahmetkakici / javascript lambda
Last active August 29, 2015 14:10
query js arrays with lambda expressions. i love them.
Array.prototype.where =
function (f) {
var fn = f;
if (typeof f == "string")
if (( fn = lambda(fn) ) == null)
throw "Syntax error in lambda string: " + f;
var res = [];
var l = this.length;
var p = [0, 0, res];
for (var i = 1; i < arguments.length; i++) p.push(arguments[i]);
/**
*
* @author Ahmet
*/
import java.io.*;
import java.net.*;
import java.util.*;
public class clientMsgHandler extends Thread {
@ahmetkakici
ahmetkakici / BACKUP_ROW.sql
Last active December 17, 2015 10:49
Oracle is my girl.
CREATE OR REPLACE PROCEDURE BACKUP_ROW_RECURSIVE(SCHEMA_NAME VARCHAR2,
TABLE_NAME VARCHAR2,
COLUMN_NAME VARCHAR2,
COLUMN_VALUE NUMBER,
USER_ID NUMBER,
VERSION NUMBER,
PROJECT_ID NUMBER) AUTHID CURRENT_USER IS
TABLE_ID NUMBER;
SQL_QUERY VARCHAR2(500);
PROJECT_CONDITION VARCHAR2(100);
@ahmetkakici
ahmetkakici / il_ilce_enlem_boylam.sql
Created May 2, 2012 14:45 — forked from ismailbaskin/il_ilce_enlem_boylam.sql
Türkiye İl ve İlçelerin enlem boylam bilgileri
/*
Türkiye İl ve İlçelerin enlem boylam bilgileri (dörtgen olarak sınır pozisyonlarıyla birlikte) kaynak : google maps (başarsoft)
twitter : http://twitter.com/tserpico
*/
DROP TABLE IF EXISTS `pk_il`;
CREATE TABLE `pk_il` (
`il_id` int(2) NOT NULL COMMENT 'plaka kodu',
`il_adi` varchar(255) NOT NULL,
`lat` double(20,8) DEFAULT NULL COMMENT 'enlem',