Skip to content

Instantly share code, notes, and snippets.

View AjayKrP's full-sized avatar

Ajay Kumar AjayKrP

View GitHub Profile
@AjayKrP
AjayKrP / get_diffy.py
Created March 5, 2021 05:10
Get diff between two folders and stores diff files in separate directory
import os
import sys
import difflib
from shutil import copyfile
import pathlib
if len(sys.argv) < 3:
print('[ERR]: Not enough arguments passed. Usage: get_diff.py <firstFolder> <secondFolder>')
sys.exit()
@AjayKrP
AjayKrP / upload.py
Last active March 5, 2021 05:11
Upload Larger Table Rates In Magento 2 Using Python
import csv
import mysql.connector
import time
mydb = mysql.connector.connect(
host="your_db_host",
user="db_user",
password="*****",
database="db_name"
)
class IPv4:
@staticmethod
def dec_to_binary(address):
return list(map(lambda x: bin(x)[2:].zfill(8), address))
@staticmethod
def negation_mask(net_mask):
wild = list()
for i in net_mask:
import socket
import threading
import time
import json
import random
import hashlib
import os
sent_flag = [] # if timeout make sent_flag in window = 0;
ACK_num = []
import socket
import threading
import time
import json
import random
import hashlib
import os
threshold = 0.5
--Function
--compile first
SET SERVEROUTPUT ON;
CREATE OR REPLACE FUNCTION PROC_GRADE_FUN(MARKS IN NUMBER,NAME_ IN VARCHAR2, ROLL_ IN NUMBER)
RETURN VARCHAR2 IS
RESULT VARCHAR2(50);
BEGIN
IF(MARKS >= 990 AND MARKS <= 1500)THEN
RESULT := 'DISTINCTION';
SET SERVEROUTPUT ON;
DECLARE
NAME_OF_BOOK_ VARCHAR(50);
ROLL_NUMBER_ NUMBER;
CURRENT_DATE DATE;
DATE_OF_ISSUE_ DATE;
NUMBER_OF_DAY NUMBER;
STATUS_ VARCHAR2(1);
FINE_AMOUNT NUMBER := 0;
STATUS_CHECKUP EXCEPTION;
mysql> use students;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select * from EMPLOYEE;
+--------+------------+-----------+------------+--------+-----------+------------+---------+
| EMP_ID | FIRST_NAME | LAST_NAME | HIRE_DATE | SALARY | JOB_TITLE | MANAGER_ID | DEPT_ID |
+--------+------------+-----------+------------+--------+-----------+------------+---------+
| 1 | GANESH | SINGH | 2015-02-01 | 50000 | MANAGER | 4 | 1 |
mysql> CREATE DATABASE ASSIGNMENT3;
Query OK, 1 row affected (0.01 sec)
mysql> USE ASSIGNMENT3;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SELECT * FROM EMPLOYEE;
+--------+------------+-----------+--------+--------------+------------+
import java.net.UnknownHostException;
import java.util.Scanner;
import com.mongodb.*;
public class DatabaseConnectivity {
private static void choice_input(){
System.out.println("\n1.insert data into database\n2.update database documents\n3.delete database documents\n4.show database collections\n5.Exit");
}
public static void main(String[] args) {
String key, value;