Skip to content

Instantly share code, notes, and snippets.

View NagariaHussain's full-sized avatar
🏠
Working from home

Md Hussain Nagaria NagariaHussain

🏠
Working from home
View GitHub Profile
import mysql.connector
con = mysql.connector.connect(
host="localhost",
user="root",
passwd="1234",
database="tdb"
)
cursor = con.cursor()
@NagariaHussain
NagariaHussain / commands.sql
Last active January 4, 2024 09:49
#BuildWithHussain SQL Essentials DB setup
-- Create Customer table
CREATE TABLE Customer (
ID INT PRIMARY KEY,
first_name VARCHAR(50),
last_name VARCHAR(50),
PAN VARCHAR(10),
DOB DATE
);
-- Create Branch table
@NagariaHussain
NagariaHussain / bwh_ep_14_source.md
Created September 3, 2023 16:07
Build With Hussain, Episode 14 Client/Server Scripts

Intro Client Script

frappe.ui.form.on('Project', {
	refresh(frm) {
	    if(frm.doc.expected_end_date == frappe.datetime.now_date())
		    frm.set_intro("<b>End date has arrived</b>","red")
		else
		    frm.set_intro("Take it east","green")
	}
---
export interface Props {
title: string;
}
const { title } = Astro.props;
---
<!DOCTYPE html>
<html lang="en">
# Copyright (c) 2022, Hussain and contributors
# For license information, please see license.txt
from my_awesome_app.my_awesome_app.doctype.car.car import MongoDBDocument, get_mongodb_client
class Person(MongoDBDocument):
@staticmethod
def get_collection():
client = get_mongodb_client()
# Copyright (c) 2022, Hussain and contributors
# For license information, please see license.txt
from pymongo import MongoClient
from abc import ABC, abstractstaticmethod
from frappe.model.document import Document
class MongoDBDocument(Document, ABC):
@abstractstaticmethod
# Copyright (c) 2022, Hussain and contributors
# For license information, please see license.txt
from frappe.model.document import Document
from pymongo import MongoClient
CONNECTION_STRING = "<YOUR-CONNECTION-STRING>"
@NagariaHussain
NagariaHussain / hints.py
Created November 8, 2022 08:43
Hints for implementing deploy on all required checks passed
# Check apps/press/press/press/doctype/app_source/app_source.py
# branch = get branch from github API while creating app release
required_checks = branch.get["protection"]["required_status_checks"]["checks"]
if len(required_checks) == 0:
# No required checks, continue as it is now
else:
# for check in required_checks
# populate a child table?
import React, { useEffect, useState } from "react";
import { TouchableOpacity } from "react-native";
import styled from "styled-components";
import { CardContainer } from "../utils/Card";
import { Icons } from "../icons";
import { playSoundFromUri } from "../../lib/audio";
import { ProgressBar } from "../utils/ProgressBar";
const PlayerControlContainer = styled(CardContainer)`