jsuryahyd’s gists

jsuryahyd / dbUtils.js

Created January 27, 2020 05:11

promisifying transaction related functions of node mysql library

	getPromisifiedConnection(pool) {
	return util.promisify(pool.getConnection).bind(pool);
	}

	getPromisifiedBeginTransaction(connection) {
	return util.promisify(connection.beginTransaction.bind(connection));
	}

	getPromisifiedQuery(connection) {
	util.promisify((sql, options, cb) =>

jsuryahyd / main.dart

Last active October 4, 2019 12:14

dart lists as practiced on dart pad[https://dartpad.dartlang.org/](https://dartpad.dartlang.org/)

	void main() {
	// //1
	// final List<dynamic> myNums = ["1", "whatever", {}];
	// // final List<dynamic> myNums = const ["1","whatever",{}];
	// myNums.add("lskf");
	// // myNums = [...myNums,"lskf"];
	// print(myNums);

	// //2
	// List<int> nums = List(5);

jsuryahyd / exif-data.html

Last active October 9, 2019 06:11

Extract metadata from image using exif-js; has drag-drop box to drop image into, and shows metadata if any exists.

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1.0" />
	<meta http-equiv="X-UA-Compatible" content="ie=edge" />
	<title>EXIF example with inline EXIF info</title>
	</head>
	<body>
	<br />

jsuryahyd / react.gradle

Created September 14, 2019 14:37

react-native : working react.gradle with hermes-engine for 0.60.x

	//0.60.x, enableHermes-true : replace hermesvm with hermes-engine(npm install hermes-engine)
	// and include this file in app folder change react.gradle path to this filepath
	// in app/build.gradle
	import org.apache.tools.ant.taskdefs.condition.Os

	def config = project.hasProperty("react") ? project.react : [];

	def cliPath = config.cliPath ?: "node_modules/react-native/cli.js"
	def composeSourceMapsPath = config.composeSourceMapsPath ?: "node_modules/react-native/scripts/compose-source-maps.js"
	def bundleAssetName = config.bundleAssetName ?: "index.android.bundle"

jsuryahyd / server.js

Last active November 27, 2019 06:45

node server for serving static files when using angular or react built in production mode

	const http = require("http");
	const fs = require("fs");

	const pathToStaticFilesFolder = "./dist";//or whererver

	http
	.createServer((req, res) => {
	console.log(req.url);
	let fileStream;
	//if no path or path doesnot contain a file extension

jsuryahyd / launch.json

Created August 14, 2019 10:15

typescript project vscode debugging inside .vscode folder

	{
	// Use IntelliSense to learn about possible attributes.
	// Hover to view descriptions of existing attributes.
	// For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387
	"version": "0.2.0",
	"configurations": [
	{
	"type": "node",
	"request": "launch",
	"name": "Launch Development",

jsuryahyd / README.md

Created July 9, 2019 11:27

react native project readme

Native code

android picker styling

<resources>
    <style name="AppTheme" parent="Theme.AppCompat.Light.NoActionBar">
        <item name="colorAccent">@color/colorAccent</item>
        <item name="android:colorControlNormal">#00000000</item>
        <item name="android:spinnerStyle">@style/SpinnerStyle</item>

jsuryahyd / writeLargeFile.js

Last active June 15, 2019 11:30

write large text to file using nodejs

	//writes a billion numbers to file. size: 9.3GB
	let writeStream = fs.createWriteStream("./output");
	writeStream.on('open',async ()=>{
	while (k<=10**9){
	let written = k%10 == 0 ? writeStream.write(k.toString()+"\n") : writeStream.write(k.toString()+" ");
	/**
	imp stuff..., without which out-of-memory error is thrown.
	[https://stackoverflow.com/a/40221132/7314900] stream.write() method returns false when stream has large enough data. so,
	*/
	if(!written){

jsuryahyd / db_debugging.sql

Created November 16, 2018 10:50

	--connection status
	show status like '%conn%';
	--full process list
	SHOW full processlist;
	--global variables
	show global variables like '%connect%';
	--session variables
	SHOW SESSION VARIABLES LIKE "%connect%";

jsuryahyd / selectText.js

Created October 24, 2018 14:04

Select text with javascript on the browser.


	//dont remember, where got this from, but,
	function selectText(id) {
	var node = document.getElementById(id);

	if (document.body.createTextRange) {
	const range = document.body.createTextRange();
	range.moveToElementText(node);
	range.select();
	} else if (window.getSelection) {