Skip to content

Instantly share code, notes, and snippets.

View parkerfoshay's full-sized avatar

Parker Faucher parkerfoshay

View GitHub Profile
import React, { useState } from "react";
import "./App.css";
function App() {
const [fibonacci, setFibonacci] = useState(null);
const [value, setValue] = useState(null);
const [initialNumber, setInitialNumber] = useState(null);
function fibonacciHelper(number) {
if (number < 2) {
import { useState } from 'react'
import { Navbar, Nav, Container, Row, Col } from 'react-bootstrap'
import dynamic from "next/dynamic";
const LinceIconsNoSSr = dynamic(() => import("react-lineicons"), {
ssr: false,
});
export default function Navigationbar() {
@parkerfoshay
parkerfoshay / Program.cs
Created July 28, 2022 21:29
C#-connection
using MongoDB.Driver;
var mongoURL = new MongoUrl("");
var client = new MongoClient(mongoURL);
var dbList = client.ListDatabases().ToList();
Console.WriteLine("The list of databases on this server is: ");
foreach (var db in dbList)
{
@parkerfoshay
parkerfoshay / document.js
Created November 22, 2022 17:58
L1-mapping-to-mongodb
{
_id: ObjectId("5b9d9b9b9b9b9b9b9b9b9b9b"),
first_name: "John",
last_name: "Doe",
phone: "123-456-7890",
age: 25,
start_date: ISODate("2018-09-01T00:00:00.000Z"),
settings: {
theme: "dark",
switch_controls: true,
@parkerfoshay
parkerfoshay / inserts.sql
Created November 22, 2022 19:08
L2-Inserting
INSERT INTO users (first_name, last_name, phone, age)
VALUES
('Nancy', 'Smith', "5234560987", 29);
INSERT INTO users (first_name, last_name, phone, age)
VALUES
('Douglas', 'Lowel', "5234768907", 23),
('Kai', 'Tran', "9198761234", 43),
('Linzey', 'Rivers', "7659023456", 54),
('Mira', 'Chan', "7650981234", 88);
@parkerfoshay
parkerfoshay / join.js
Created November 23, 2022 21:07
Joins
db.transfers.aggregate( [
{
$lookup:
{
from: "accounts",
localField: "transfer_id",
foreignField: "transfers_complete",
pipeline: [
{ $project: { _id: 0, account_id: 1, account_holder: 1 } }
@parkerfoshay
parkerfoshay / deletes.js
Last active December 1, 2022 23:30
updating & deleting
db.sales.deleteOne({_id: ObjectId("5bd761dcae323e45a93ccff1")})
db.sales.deleteMany({ storeLocation: {$in: [ 'Denver', 'New York' ]} });
db.sales.deleteMany({})
@parkerfoshay
parkerfoshay / L4.js
Created December 6, 2022 22:18
between order by and limit
db.zips.find(
{ state: "NY", pop: { $gte: 1000, $lte: 5000 }},
{_id: 0, state: 1, city: 1, pop: 1}
).sort({pop: -1})
.limit(10)
@parkerfoshay
parkerfoshay / queries.js
Last active December 6, 2022 22:22
queries
db.zips.findOne({})
db.zips.find({state: 'AZ', pop: {$lt: 500}}, {_id: 0, city: 1})
@parkerfoshay
parkerfoshay / demo.js
Last active December 15, 2022 16:45
mongoose example
const mongoose = require('mongoose');
main().catch(err => console.log(err));
async function main() {
await mongoose.connect(<Atlasconnection-string>);
const userSchema = new mongoose.Schema({
name: {
type: String,