SQL public snippets


This code creates a database called "&[USER_INPUT:1:db_name]" and sets its character set to UTF-8.

create database


The DROP DATABASE statement deletes the database named &[USER_INPUT:1:db_name] from the server.

drop database


This code declares a variable called "&[USER_INPUT:1:var_name]" to hold an input value of 255 characters. The variable "&[USER_INPUT:2:255]" is then set to the input value.

declare variable


This code renames the table "USER_INPUT" to "NEW_NAME".

rename table


The code instructs MySQL to set the character set for the table to UTF-8, and the Collate column to UTF-8_UNICODE_CI.

alter table charset


The code changes the table's field type from varchar to text.

alter table


The code drops the index "&[USER_INPUT:3:index_name]" from the table "&[USER_INPUT:1:table]"

drop index from table


The preceding code will drop the foreign key `&[USER_INPUT:2:fk_${3:the_table]_&[USER_INPUT:4:far_table]}` from the table `$&[USER_INPUT:1]`.

alter table drop foreign key


This code removes the `&[USER_INPUT:2:col_name]` column from the User Input table.

drop column


This code changes the character set of the table named &[USER_INPUT:1:table] to UTF-8 and the collating sequence to UTF-8_UNICODE_CI.

change charset


This code will add a new column to the table named "User Input 2" that stores an integer and a not null column to store the value of that integer.

add column to table

# All recipes published for Python
oiwejf
weoiwejf
owiejf
woeifj
woeifj
woeifj


Python public recipes



The code replaces all of the metacharacters found in the string with the underscore character.

Convert camel case to snake case



The code above prints a message to the console every time the MYVARIABLE variable is accessed.

intellij variable test

Set of useful code recipes for Next in TypeScript

Next TypeScript recipes

NextJS page

To fetch this data on pre-render, `Next.js` allows you to export an async function called `getStaticProps` from the same file. This function gets called at build time and lets you pass fetched data to the page's props on pre-render.



Next getStaticProps

So your page paths that are pre-rendered depend on external data. To handle this, Next.js lets you export an async function called getStaticPaths from a dynamic page. This function gets called at build time and lets you specify which paths you want to pre-render.

Next getStaticPaths


If you export a function called `getServerSideProps` (Server-Side Rendering) from a page, Next.js will pre-render this page on each request using the data returned by `getServerSideProps`.

Next page with getServerSideProps

Next Link

Next useRouter hook to access route information

Next useRouter router

The `handler()` function exports a function that takes two arguments: `req` and `res`. The `handler()` function sets the `res.status()` function call to `200` and returns the result as a JSON object.



Next API handler

Next API with middleware

The React model allows us to deconstruct a page into a series of components. Many of these components are often reused between pages.

Next Layout

Defines the structure of a page with a custom nested layout, they should be replaced with existing layouts

Next page with layout

Creates an example `_app.tsx` with per-page layout capabilities

Next app with layout

Next Image

The React useState Hook allows us to track state in a function component.

Next useState

Accepts a context object (the value returned fromReact.createContext) and returns the current context value for that context. The current context value is determined by the value prop of the nearest above the calling component in the tree.

Next useContext

`useEffect` accepts a function that contains imperative, possibly effectful code.

Mutations, subscriptions, timers, logging, and other side effects are not allowed inside the main body of a function component (referred to as React’s render phase). Doing so will lead to confusing bugs and inconsistencies in the UI.

Instead, use `useEffect`. The function passed to `useEffect` will run after the render is committed to the screen. Think of effects as an escape hatch from React’s purely functional world into the imperative world.

Next useEffect hook

Returns a memoized callback.

Pass an inline callback and an array of dependencies. useCallback will return a memoized version of the callback that only changes if one of the dependencies has changed. This is useful when passing callbacks to optimized child components that rely on reference equality to prevent unnecessary renders (e.g. shouldComponentUpdate).

Next useCallback

Returns a memoized value.

Pass a “create” function and an array of dependencies. useMemo will only recompute the memoized value when one of the dependencies has changed. This optimization helps to avoid expensive calculations on every render

Next useMemo

register(form, "example"); handleSubmit(register); watch(register, "submit"); control(register, "submit", { message: "Your input has been submitted!" });

register stores the reference to the form object.

handleSubmit is called when the user submits the form. It registers a function to be called when the submit event is triggered.

watch is used to keep an eye on the register object and trigger the function registered when the submit event is triggered, based on the value of the register field.

control is used to bind the register field to a function that can be called to handle the submission of the form. In this case, the function will print out a message stating that the user's input has been submitted.

Next form useForm hook react-hook-form

The code creates a context and a function that takes a context as an argument. The context defines the global scope for the function. The function uses the context to access the value of the val variable.

Next create context with hook

GitHub Actions

Template for a GitHub action that check merge requests and run tests

Template node integration

Step NPM build



CI is a Continuous Integration tool. It uses branches to track changes. The branch for the main branch is called "main". Jobs are run on the "ubuntu-latest" version of Ubuntu. Steps in the build step use the actions/checkout@v2 action.

Template on push

The code will sync the contents of the specified S3 bucket with the current user's account. If the account does not have access to the bucket, the code will delete the bucket and contents before syncing.

Upload to S3



This code invokes the &[USER_INPUT:2:command] command with the name of the step as the parameter.

Execute custom command



The code will configure AWS credentials for the current user. The aws-access-key-id and aws-secret-access-key variables will be set to the user's AWS access key ID and secret access key, respectively. The aws-region variable will be set to the user's AWS region.

set up AWS credentials

 -D

The code installs dependencies using the npm command-line tool.

Install dependencies with npm



This code tells Puppet to use the actions/setup-node action with the node-version setting of 16.x.

Use NodeJs



This code references the actions/checkout@v2 module. This module provides functionality for managing checkout processes.

Checkout repository

Generic testsuite

generic test

Build a NodeJs/NextJs website and upload it to S3

Build nodejs site and upload in S3

Useful set of recipes for `Nextjs` in JavaScript

NextJS Javascript Recipes

Returns a memoized value.

Pass a “create” function and an array of dependencies. `useMemo` will only recompute the memoized value when one of the dependencies has changed. This optimization helps to avoid expensive calculations on every render

Name	Language	Author	Uses
create database	SQL	l lucycodes42	1
drop database	SQL	l lucycodes42	1
declare variable	SQL	l lucycodes42	0
rename table	SQL	l lucycodes42	0
alter table charset	SQL	l lucycodes42	1
alter table	SQL	l lucycodes42	0
drop index from table	SQL	l lucycodes42	1
alter table drop foreign key	SQL	l lucycodes42	1
drop column	SQL	l lucycodes42	3
change charset	SQL	l lucycodes42	1
add column to table	SQL	l lucycodes42	3
Convert camel case to snake case	Python	JD Julien Delange	0
intellij variable test	Java	JD Julien Delange	59
NextJS page	TypeScript	JR Jose Romero	1
Next getStaticProps	TypeScript	JR Jose Romero	4
Next getStaticPaths	TypeScript	JR Jose Romero	0
Next page with getServerSideProps	TypeScript	JR Jose Romero	4
Next Link	TypeScript	JR Jose Romero	4
Next useRouter router	TypeScript	JR Jose Romero	3
Next API handler	TypeScript	JR Jose Romero	3
Next API with middleware	TypeScript	JR Jose Romero	0
Next Layout	TypeScript	JR Jose Romero	0
Next page with layout	TypeScript	JR Jose Romero	0
Next app with layout	TypeScript	JR Jose Romero	0
Next Image	TypeScript	JR Jose Romero	3
Next useState	TypeScript	JR Jose Romero	3
Next useContext	TypeScript	JR Jose Romero	1
Next useEffect hook	TypeScript	JR Jose Romero	0
Next useCallback	TypeScript	JR Jose Romero	3
Next useMemo	TypeScript	JR Jose Romero	0
Next form useForm hook react-hook-form	TypeScript	JR Jose Romero	1
Next create context with hook	TypeScript	JR Jose Romero	0
Template node integration	YAML	JD Julien Delange	9
Step NPM build	YAML	JD Julien Delange	3
Template on push	YAML	JD Julien Delange	6
Upload to S3	YAML	JD Julien Delange	4
Execute custom command	YAML	JD Julien Delange	1
set up AWS credentials	YAML	JD Julien Delange	5
Install dependencies with npm	YAML	JD Julien Delange	6
Use NodeJs	YAML	JD Julien Delange	10
Checkout repository	YAML	JD Julien Delange	16
Generic testsuite	TypeScript	JD Julien Delange	3
generic test	TypeScript	JD Julien Delange	1
Build nodejs site and upload in S3	YAML	JD Julien Delange	15
Next create context with hook	JavaScript	JR Jose Romero	3
Next form useForm hook react-hook-form	JavaScript	JR Jose Romero	1
Next useMemo	JavaScript	JR Jose Romero	1
Next useCallback	JavaScript	JR Jose Romero	0
Next useEffect hook	JavaScript	JR Jose Romero	1
Next useContext	JavaScript	JR Jose Romero	1

Codiga Snippets, page 67