Skip to content

Instantly share code, notes, and snippets.

Hafiz Shehbaz Ali hsali

Block or report user

Report or block hsali

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View download_pdf_books_from_springer
import os
from bs4 import BeautifulSoup
import requests
import wget
import pandas as pd
from requests.compat import urljoin
import tqdm
url = ""
folder = "D:/books/SpringerDataScience"
hsali /
Created Oct 29, 2019 — forked from zaloogarcia/
Script for converting Pandas DF to Spark's DF
from pyspark.sql.types import *
# Auxiliar functions
# Pandas Types -> Sparks Types
def equivalent_type(f):
if f == 'datetime64[ns]': return DateType()
elif f == 'int64': return LongType()
elif f == 'int32': return IntegerType()
elif f == 'float64': return FloatType()
else: return StringType()

SQL to MongoDB Mapping Chart

SQL to MongoDB Mapping Chart

In addition to the charts that follow, you might want to consider the Frequently Asked Questions section for a selection of common questions about MongoDB.


The following table presents the MySQL/Oracle executables and the corresponding MongoDB executables.

hsali / my.cong
Created Sep 29, 2018
erpnext maria db configuration
View my.cong
#at bottom of my.conf
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
default-character-set = utf8mb4
hsali / javascript_scapper.js
Created Jun 7, 2018
convert HTML select element key values to constant property of PHP Class with comments
View javascript_scapper.js
art = document.querySelectorAll("#your-select-element-id-here option");
function tag_g(tag_name, tag_value){
clean_name = tag_name.replace('-'," ");
clean_name = clean_name.replace('&',"AND");
clean_name = clean_name.replace(/\s\s+/g, ' ');
clean_name = clean_name.replace(/[^a-zA-Z ]/g, " ");
tag_slug = clean_name.toUpperCase().split(" ").join("_");
tag_str ="\
/** \n \
View background.js
function (details) {
for (var i = 0; i < details.responseHeaders.length; ++i) {
if (details.responseHeaders[i].name.toLowerCase() == 'x-frame-options') {
details.responseHeaders.splice(i, 1);
return {
responseHeaders: details.responseHeaders
hsali /
Created Dec 22, 2017
Python Hello World Application
def hello_function():
print "Hello World"
# This is comment.
# calling function
hsali / datatables.php
Created Jul 14, 2017
datables file which is located in config/datatables.php
View datatables.php
return [
* DataTables search options.
'search' => [
* Smart search will enclose search keyword with wildcard string "%keyword%".
* SQL: column LIKE "%keyword%"
hsali / create_subdomain_cpanel.php
Created Mar 24, 2017
PHP Script to create subdomain on cpanel .
View create_subdomain_cpanel.php
function create_subdomain($subDomain,$cPanelUser,$cPanelPass,$rootDomain) {
// $buildRequest = "/frontend/x3/subdomain/doadddomain.html?rootdomain=" . $rootDomain . "&domain=" . $subDomain;
$buildRequest = "/frontend/x3/subdomain/doadddomain.html?rootdomain=" . $rootDomain . "&domain=" . $subDomain . "&dir=public_html/subdomains/" . $subDomain;
$openSocket = fsockopen('localhost',2082);
if(!$openSocket) {
return "Socket error";
View Matlab
#Stop the Mouse event problem
Type in the matlab
!synclient HorizTwoFingerScroll=0
You can’t perform that action at this time.