Skip to content

Instantly share code, notes, and snippets.

View asharma327's full-sized avatar

Adhaar Sharma asharma327

3 followers · 1 following
View GitHub Profile
@asharma327
asharma327 / ImporterAPISpreadsheetsColumnMatch.html
Last active August 9, 2022 08:59
<!DOCTYPE html>
<html>
<head>
<script type="text/javascript" src="https://www.apispreadsheets.com/import.js"></script>
<script type="text/javascript">
function importComplete(success, data) {
console.log(success)
if (success){
console.log(data);
}
@asharma327
asharma327 / SubFormPostgresPublic.html
Created July 8, 2022 05:06
<script>
function SubForm (){
$.ajax({
url:'https://api.apispreadsheets.com/data/jMGwn06FaKODhaKy/',
type:'post',
data:$("#myForm").serializeArray(),
success: function(){
alert("Form Data Submitted :)")
},
error: function(e){
@asharma327
asharma327 / SubFormPostgresPrivate.html
Created July 8, 2022 05:06
<script>
function SubForm (){
$.ajax({
url:'https://api.apispreadsheets.com/data/jMGwn06FaKODhaKy/',
type:'post',
headers:{
accessKey: "3f7608848c6cb3c4fbf02649c59b7ba5",
secretKey: "255bb6cfdfca9f0cac3c7df9ebc74b3c"
},
data:$("#myForm").serializeArray(),
@asharma327
asharma327 / ContactFormPublic.HTML
Last active July 8, 2022 04:03
<!DOCTYPE html>
<html>
<head>
<title>Save Web Form Data to Postgres - Contact Form</title>
<script
src="https://code.jquery.com/jquery-3.4.1.js"
integrity="sha256-WpOohJOqMqqyKL9FccASB9O0KwACQJpFTUBLTYOVvVU="
crossorigin="anonymous"></script>
<script>
function SubForm (){
@asharma327
asharma327 / ContactForm.HTML
Last active July 8, 2022 04:02
<!DOCTYPE html>
<html>
<head>
<title>Save Web Form Data to Postgres - Contact Form</title>
<script
src="https://code.jquery.com/jquery-3.4.1.js"
integrity="sha256-WpOohJOqMqqyKL9FccASB9O0KwACQJpFTUBLTYOVvVU="
crossorigin="anonymous"></script>
<script>
function SubForm (){
@asharma327
asharma327 / time_request.py
Last active June 25, 2022 15:07
import time
import requests
def time_function(func):
start = time.time()
func()
end = time.time()
return (end-start)
@asharma327
asharma327 / add_data_db.py
Last active June 13, 2022 07:22
import requests
# pip install requests
import requests
r = requests.post("https://api.apispreadsheets.com/data/your_file_id/", json={"data": [{"title": "The Avengers", "genre": "Action", "director": "Joss Whedon","release_year": 2012},{"title": "Parasite", "genre": "Drama", "director": "Bong Joon-ho","release_year": 2019},{"title": "Knives Out", "genre": "Thriller", "director": "Rian Johnson","release_year": 2019}]})
if r.status_code == 201:
# SUCCESS
@asharma327
asharma327 / add_data_to_db.json
Last active June 13, 2022 07:07
{
"data": [
{
"title": "The Avengers",
"genre": "Action",
"director": "Joss Whedon",
"release_year": 2012
},
{
"title": "Parasite",
@asharma327
asharma327 / ImportAPISpreadsheets.html
Last active August 9, 2022 08:59
<!DOCTYPE html>
<html>
<head>
<script type="text/javascript" src="https://www.apispreadsheets.com/import.js"></script>
<script type="text/javascript">
function importComplete(success, data) {
console.log(success)
if (success){
console.log(data);
// close the importer if you wish
@asharma327
asharma327 / split.py
Created February 4, 2021 14:19
import csv
import math
# Function to write the split file
def create_split_file(split_rows, header, split_file_name):
with open(split_file_name, 'w') as split_file:
output = csv.writer(split_file, delimiter=",")
# Add header to rows if you want
split_rows.insert(0, header)