Lhassan Baazzi jbinfo

## oracle_hierarchical_queries.md

      
              1 file
            
          
              0 forks
            
          
              2 comments
            
          
              0 stars
            
          
                jbinfo
                / oracle_hierarchical_queries.md
            
            
              Last active
              March 27, 2021 02:33
            
              
                Oracle hierarchical queries: How to find parents of a list of child, tree 
              
          
    In this Gist will show you how to get parents of a list of child from an Oracle database.
Let's start with the table below:


Child
Parent


1
NULL


2
1


3
2


4
3


## instagram-auto-follow-activity.js
var buttons = $('div[role=dialog]').find('button:contains(Follow)').filter(function() {
    return $(this).text().toLowerCase() === 'follow';
});

$.each(buttons, function(idx, itm) {
    var secondes = Math.floor((Math.random() * 10) + 3);

    setTimeout(function() {
        $(itm).trigger('click');
    }, duration = secondes * 1000);

## unique_lines_between_two_files
fgrep -vf /path/to/file1 /path/to/file2

## instagram-scraper-sample-output.csv
id,username,fullname,emails,fbPage,externalUrl,biography,followedBy,follows,isPrivate,isVerified,isBusinessAccount,businessCategory,businessEmail,businessPhone,businessAddressStreet,businessAddressZipcode,businessAddressCity,businessAddressRegion,businessAddressCountryCode,hashtags
5734709815,tasteititalian,Taste IT,,,https://m.facebook.com/TasteItitaliantakeaway/,"‼️The first independent Italian Gelateria in Greater Manchester ‼️
Stonebaked pizza 🍕 artisan gelato 🍦 baked pasta 🍝 tasty arancini.",430,146,0,0,1,Restaurants,tasteitsalford@gmail.com,441616980410,69 BLACKFRIARS ROAD,M3 7DB,City of Salford,,GB,pizzauk
3667203339,mobipizzeria,🇮🇹Mobile Wood Fired Pizza🇬🇧,,,https://www.facebook.com/mobipizzeria/,"Mobile pop-up wood fired pizza UK-wide.
We cater for weddings, corporate events, private parties, birthdays, festivals, concerts, fetes, and many more",7486,3492,0,0,1,Restaurants,info@mobipizzeria.co.uk,443300100270,,SG191RB,St Neots,,GB,pizzauk
2986836082,zialuciapizza,Zia Lucia,,,http://www.zialucia.com/,

## sqlite_full_text_search_example.sql
-- Table that store hotels reviews
CREATE TABLE hotels_reviews (
  id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  review TEXT NOT NULL
);

-- As SQLite index content on a virtual table,
-- We need to create a virtual table for hotels_reviews
-- I use the last extension fts5 for full text searching https://www.sqlite.org/fts5.html
-- I use the "porter" tokenizer, check this link for definition: https://www.sqlite.org/fts3.html#tokenizer

## twitter-auto-follow-activity
var secondes = Math.floor((Math.random() * 10) + 3);
var duration = secondes;
$('#activity-popup-dialog-body').find('.not-following').find('button.follow-button').each(function() {
    var _this = this;

    setTimeout(function() {
    $(_this).trigger('click');
    }, duration * 1000);

    duration += secondes;

## margin and padding for add space between blocks
.mar-left-5 {
  margin-left: 5px;
}

.mar-left-10 {
  margin-left: 10px;
}

.mar-left-15 {
  margin-left: 15px;

## LoginSuccessHandler.php
<?php

namespace AppBundle\Security\Authentication\Handler;

use Symfony\Component\HttpFoundation\RedirectResponse;
use Symfony\Component\DependencyInjection\ContainerInterface;
use Symfony\Component\Security\Core\Authentication\Token\TokenInterface;
use Symfony\Component\Security\Http\Authentication\AuthenticationSuccessHandlerInterface;

class LoginSuccessHandler implements AuthenticationSuccessHandlerInterface

## closespider.py
# -*- coding: utf-8 -*-
# MIT License (c) Lhassan Baazzi <baazzilhassan@gmail.com>

from collections import defaultdict
from twisted.internet import reactor
from scrapy import signals

class CloseSpider(object):

    def __init__(self, crawler):

## gist:ce5600eb7ea276dc194c
SomeRoute:
    pattern: /someroute
    defaults:
        _controller: SomeBundle:Controller:action

AnotherRoute:
    pattern: /anotherroute
    defaults:
        _controller: FrameworkBundle:Redirect:redirect
        route: SomeRoute
	var buttons = $('div[role=dialog]').find('button:contains(Follow)').filter(function() {
	return $(this).text().toLowerCase() === 'follow';
	});

	$.each(buttons, function(idx, itm) {
	var secondes = Math.floor((Math.random() * 10) + 3);

	setTimeout(function() {
	$(itm).trigger('click');
	}, duration = secondes * 1000);
	id,username,fullname,emails,fbPage,externalUrl,biography,followedBy,follows,isPrivate,isVerified,isBusinessAccount,businessCategory,businessEmail,businessPhone,businessAddressStreet,businessAddressZipcode,businessAddressCity,businessAddressRegion,businessAddressCountryCode,hashtags
	5734709815,tasteititalian,Taste IT,,,https://m.facebook.com/TasteItitaliantakeaway/,"‼️The first independent Italian Gelateria in Greater Manchester ‼️
	Stonebaked pizza 🍕 artisan gelato 🍦 baked pasta 🍝 tasty arancini.",430,146,0,0,1,Restaurants,tasteitsalford@gmail.com,441616980410,69 BLACKFRIARS ROAD,M3 7DB,City of Salford,,GB,pizzauk
	3667203339,mobipizzeria,🇮🇹Mobile Wood Fired Pizza🇬🇧,,,https://www.facebook.com/mobipizzeria/,"Mobile pop-up wood fired pizza UK-wide.
	We cater for weddings, corporate events, private parties, birthdays, festivals, concerts, fetes, and many more",7486,3492,0,0,1,Restaurants,info@mobipizzeria.co.uk,443300100270,,SG191RB,St Neots,,GB,pizzauk
	2986836082,zialuciapizza,Zia Lucia,,,http://www.zialucia.com/,
	-- Table that store hotels reviews
	CREATE TABLE hotels_reviews (
	id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
	review TEXT NOT NULL
	);

	-- As SQLite index content on a virtual table,
	-- We need to create a virtual table for hotels_reviews
	-- I use the last extension fts5 for full text searching https://www.sqlite.org/fts5.html
	-- I use the "porter" tokenizer, check this link for definition: https://www.sqlite.org/fts3.html#tokenizer
	var secondes = Math.floor((Math.random() * 10) + 3);
	var duration = secondes;
	$('#activity-popup-dialog-body').find('.not-following').find('button.follow-button').each(function() {
	var _this = this;

	setTimeout(function() {
	$(_this).trigger('click');
	}, duration * 1000);

	duration += secondes;
	.mar-left-5 {
	margin-left: 5px;
	}

	.mar-left-10 {
	margin-left: 10px;
	}

	.mar-left-15 {
	margin-left: 15px;
	<?php

	namespace AppBundle\Security\Authentication\Handler;

	use Symfony\Component\HttpFoundation\RedirectResponse;
	use Symfony\Component\DependencyInjection\ContainerInterface;
	use Symfony\Component\Security\Core\Authentication\Token\TokenInterface;
	use Symfony\Component\Security\Http\Authentication\AuthenticationSuccessHandlerInterface;

	class LoginSuccessHandler implements AuthenticationSuccessHandlerInterface
	# -- coding: utf-8 --
	# MIT License (c) Lhassan Baazzi <baazzilhassan@gmail.com>

	from collections import defaultdict
	from twisted.internet import reactor
	from scrapy import signals

	class CloseSpider(object):

	def __init__(self, crawler):
	SomeRoute:
	pattern: /someroute
	defaults:
	_controller: SomeBundle:Controller:action

	AnotherRoute:
	pattern: /anotherroute
	defaults:
	_controller: FrameworkBundle:Redirect:redirect
	route: SomeRoute