Skip to content

Instantly share code, notes, and snippets.

@tomatohammado
Created January 18, 2019 22:19
Show Gist options
  • Save tomatohammado/8cb43a9f12ff40cc7e64b755de5bd04f to your computer and use it in GitHub Desktop.
Save tomatohammado/8cb43a9f12ff40cc7e64b755de5bd04f to your computer and use it in GitHub Desktop.
awwwww boy, I restored the database correctly!
Last login: Wed Jan 16 16:13:10 on ttys001
hammad at MacBoku-Pro-2018 in ~
$ cd dev/
hammad at MacBoku-Pro-2018 in ~/dev
$ cd work/calltime/
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime
$ ls
backendcalltime.dump calltime_twilio_study
backendcalltime.sql frontend-react-call-time
backendcalltime_january_15_2019.dump starter-node-express
browser-calls-node twilio-backend-service
call-time-app-strapi
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime
$ mkdir node-auth-with-tokens
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime
$ cd node-auth-with-tokens/
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens
$ git init
Initialized empty Git repository in /Users/hammad/dev/work/calltime/node-auth-with-tokens/.git/
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master
$ git remote add origin git@github.com:tomatohammado/calltime-node-auth-with-tokens.git
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master
$ git push -u origin master
error: src refspec master does not match any.
error: failed to push some refs to 'git@github.com:tomatohammado/calltime-node-auth-with-tokens.git'
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master
$ git status
On branch master
No commits yet
nothing to commit (create/copy files and use "git add" to track)
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master
$ git status
On branch master
No commits yet
nothing to commit (create/copy files and use "git add" to track)
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master
$ npm init
This utility will walk you through creating a package.json file.
It only covers the most common items, and tries to guess sensible defaults.
See `npm help json` for definitive documentation on these fields
and exactly what they do.
Use `npm install <pkg>` afterwards to install a package and
save it as a dependency in the package.json file.
Press ^C at any time to quit.
package name: (auth-with-tokens) calltime-node-auth-with-tokens
version: (1.0.0)
description:
entry point: (index.js)
test command:
git repository: (https://github.com/tomatohammado/calltime-node-auth-with-tokens.git)
keywords:
author: Hammad Malik
license: (ISC)
About to write to /Users/hammad/dev/work/calltime/node-auth-with-tokens/package.json:
{
"name": "calltime-node-auth-with-tokens",
"version": "1.0.0",
"description": "",
"main": "index.js",
"scripts": {
"test": "echo \"Error: no test specified\" && exit 1"
},
"repository": {
"type": "git",
"url": "git+https://github.com/tomatohammado/calltime-node-auth-with-tokens.git"
},
"author": "Hammad Malik",
"license": "ISC",
"bugs": {
"url": "https://github.com/tomatohammado/calltime-node-auth-with-tokens/issues"
},
"homepage": "https://github.com/tomatohammado/calltime-node-auth-with-tokens#readme"
}
Is this OK? (yes) yes
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [?]
$ git status
On branch master
No commits yet
Untracked files:
(use "git add <file>..." to include in what will be committed)
package.json
nothing added to commit but untracked files present (use "git add" to track)
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [?]
$ git add .
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [+]
$ git commit
[master (root-commit) 24f7be8] Initialize project
Committer: tomatohammado <hammad@MacBoku-Pro-2018.local>
Your name and email address were configured automatically based
on your username and hostname. Please check that they are accurate.
You can suppress this message by setting them explicitly:
git config --global user.name "Your Name"
git config --global user.email you@example.com
After doing this, you may fix the identity used for this commit with:
git commit --amend --reset-author
1 file changed, 19 insertions(+)
create mode 100644 package.json
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master
$ git push -u origin master
Enumerating objects: 3, done.
Counting objects: 100% (3/3), done.
Delta compression using up to 8 threads
Compressing objects: 100% (2/2), done.
Writing objects: 100% (3/3), 484 bytes | 484.00 KiB/s, done.
Total 3 (delta 0), reused 0 (delta 0)
To github.com:tomatohammado/calltime-node-auth-with-tokens.git
* [new branch] master -> master
Branch 'master' set up to track remote branch 'master' from 'origin'.
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master
$ touch index.js
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [?]
$ npm i express
⸨░░░░░░░⸨░░░░░░░░░░░░░░░░░░⸩ ⠇ fetchMetadata: sill resolveWithNewModule raw-body@2.3.3 checking instnpm notice created a lockfile as package-lock.json. You should commit this file.
npm WARN calltime-node-auth-with-tokens@1.0.0 No description
+ express@4.16.4
added 48 packages from 36 contributors and audited 121 packages in 2.046s
found 0 vulnerabilities
╭───────────────────────────────────────────────────────────────╮
│ │
│ New minor version of npm available! 6.5.0 → 6.6.0 │
│ Changelog: https://github.com/npm/cli/releases/tag/v6.6.0 │
│ Run npm install -g npm to update! │
│ │
╰───────────────────────────────────────────────────────────────╯
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [!?]
$ npm install -g npm
npm WARN rm not removing /usr/local/bin/npx as it wasn't installed by /usr/local/lib/node_modules/npm
/usr/local/bin/npm -> /usr/local/lib/node_modules/npm/bin/npm-cli.js
/usr/local/bin/npx -> /usr/local/lib/node_modules/npm/bin/npx-cli.js
+ npm@6.6.0
added 53 packages from 8 contributors, removed 13 packages and updated 30 packages in 11.709s
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [!?]
$ git stauts
git: 'stauts' is not a git command. See 'git --help'.
The most similar command is
status
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [!?]
$ git status
On branch master
Your branch is up to date with 'origin/master'.
Changes not staged for commit:
(use "git add <file>..." to update what will be committed)
(use "git checkout -- <file>..." to discard changes in working directory)
modified: package.json
Untracked files:
(use "git add <file>..." to include in what will be committed)
index.js
package-lock.json
no changes added to commit (use "git add" and/or "git commit -a")
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [!?]
$ npm i
npm WARN calltime-node-auth-with-tokens@1.0.0 No description
audited 121 packages in 0.573s
found 0 vulnerabilities
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [!?]
$ git add package.json package-lock.json
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [+?]
$ git status
On branch master
Your branch is up to date with 'origin/master'.
Changes to be committed:
(use "git reset HEAD <file>..." to unstage)
new file: package-lock.json
modified: package.json
Untracked files:
(use "git add <file>..." to include in what will be committed)
index.js
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [+?]
$ git commit
[master a6cf90f] Install express, and run `npm i` for good measure
Committer: tomatohammado <hammad@MacBoku-Pro-2018.local>
Your name and email address were configured automatically based
on your username and hostname. Please check that they are accurate.
You can suppress this message by setting them explicitly:
git config --global user.name "Your Name"
git config --global user.email you@example.com
After doing this, you may fix the identity used for this commit with:
git commit --amend --reset-author
2 files changed, 362 insertions(+), 1 deletion(-)
create mode 100644 package-lock.json
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [?]
$ git add .
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [+]
$ git commit
[master 0269519] Create empty index.js
Committer: tomatohammado <hammad@MacBoku-Pro-2018.local>
Your name and email address were configured automatically based
on your username and hostname. Please check that they are accurate.
You can suppress this message by setting them explicitly:
git config --global user.name "Your Name"
git config --global user.email you@example.com
After doing this, you may fix the identity used for this commit with:
git commit --amend --reset-author
1 file changed, 0 insertions(+), 0 deletions(-)
create mode 100644 index.js
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master
$ git push
Enumerating objects: 9, done.
Counting objects: 100% (9/9), done.
Delta compression using up to 8 threads
Compressing objects: 100% (6/6), done.
Writing objects: 100% (7/7), 4.35 KiB | 4.35 MiB/s, done.
Total 7 (delta 1), reused 0 (delta 0)
remote: Resolving deltas: 100% (1/1), completed with 1 local object.
To github.com:tomatohammado/calltime-node-auth-with-tokens.git
24f7be8..0269519 master -> master
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master
$ git checkout -b mvp
Switched to a new branch 'mvp'
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ npm i express-generator -g
/usr/local/bin/express -> /usr/local/lib/node_modules/express-generator/bin/express-cli.js
+ express-generator@4.16.0
added 10 packages from 13 contributors in 0.676s
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ cd ..
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime
$ trash node-auth-with-tokens/
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime
$ express node-auth-with-tokens
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime
$ express -h
Usage: express [options] [dir]
Options:
--version output the version number
-e, --ejs add ejs engine support
--pug add pug engine support
--hbs add handlebars engine support
-H, --hogan add hogan.js engine support
-v, --view <engine> add view <engine> support (dust|ejs|hbs|hjs|jade|pug|twig|vash) (defaults to jade)
--no-view use static html instead of view engine
-c, --css <engine> add stylesheet <engine> support (less|stylus|compass|sass) (defaults to plain css)
--git add .gitignore
-f, --force force on non-empty directory
-h, --help output usage information
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime
$ express node-auth-with-tokens
warning: the default view engine will not be jade in future releases
warning: use `--view=jade' or `--help' for additional options
create : node-auth-with-tokens/
create : node-auth-with-tokens/public/
create : node-auth-with-tokens/public/javascripts/
create : node-auth-with-tokens/public/images/
create : node-auth-with-tokens/public/stylesheets/
create : node-auth-with-tokens/public/stylesheets/style.css
create : node-auth-with-tokens/routes/
create : node-auth-with-tokens/routes/index.js
create : node-auth-with-tokens/routes/users.js
create : node-auth-with-tokens/views/
create : node-auth-with-tokens/views/error.jade
create : node-auth-with-tokens/views/index.jade
create : node-auth-with-tokens/views/layout.jade
create : node-auth-with-tokens/app.js
create : node-auth-with-tokens/package.json
create : node-auth-with-tokens/bin/
create : node-auth-with-tokens/bin/www
change directory:
$ cd node-auth-with-tokens
install dependencies:
$ npm install
run the app:
$ DEBUG=node-auth-with-tokens:* npm start
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime
$ cd node-auth-with-tokens/
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens
$ code .
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens
$ npm i
npm WARN deprecated jade@1.11.0: Jade has been renamed to pug, please install the latest version of pug instead of jade
npm WARN deprecated transformers@2.1.0: Deprecated, use jstransformer
npm WARN deprecated constantinople@3.0.2: Please update to at least constantinople 3.1.1
npm notice created a lockfile as package-lock.json. You should commit this file.
added 99 packages from 139 contributors and audited 194 packages in 2.226s
found 2 low severity vulnerabilities
run `npm audit fix` to fix them, or `npm audit` for details
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens
$ git init
Initialized empty Git repository in /Users/hammad/dev/work/calltime/node-auth-with-tokens/.git/
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [?]
$ git remote add origin git@github.com:tomatohammado/calltime-node-auth-with-tokens.git
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [?]
$ git push -u orgin master --force
error: src refspec master does not match any.
error: failed to push some refs to 'orgin'
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [?]
$ git push -u origin master --force
error: src refspec master does not match any.
error: failed to push some refs to 'git@github.com:tomatohammado/calltime-node-auth-with-tokens.git'
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [?]
$ git status
On branch master
No commits yet
Untracked files:
(use "git add <file>..." to include in what will be committed)
app.js
bin/
package-lock.json
package.json
public/
routes/
views/
nothing added to commit but untracked files present (use "git add" to track)
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [?]
$ git add .
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [+]
$ git commit
[master (root-commit) 6aa916c] Initalize project (via express generator)
Committer: tomatohammado <hammad@MacBoku-Pro-2018.local>
Your name and email address were configured automatically based
on your username and hostname. Please check that they are accurate.
You can suppress this message by setting them explicitly:
git config --global user.name "Your Name"
git config --global user.email you@example.com
After doing this, you may fix the identity used for this commit with:
git commit --amend --reset-author
10 files changed, 934 insertions(+)
create mode 100644 app.js
create mode 100755 bin/www
create mode 100644 package-lock.json
create mode 100644 package.json
create mode 100644 public/stylesheets/style.css
create mode 100644 routes/index.js
create mode 100644 routes/users.js
create mode 100644 views/error.jade
create mode 100644 views/index.jade
create mode 100644 views/layout.jade
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master
$ git push - origin master
error: src refspec origin does not match any.
error: failed to push some refs to '-'
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master
$ git push -u origin master
To github.com:tomatohammado/calltime-node-auth-with-tokens.git
! [rejected] master -> master (fetch first)
error: failed to push some refs to 'git@github.com:tomatohammado/calltime-node-auth-with-tokens.git'
hint: Updates were rejected because the remote contains work that you do
hint: not have locally. This is usually caused by another repository pushing
hint: to the same ref. You may want to first integrate the remote changes
hint: (e.g., 'git pull ...') before pushing again.
hint: See the 'Note about fast-forwards' in 'git push --help' for details.
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master
$ git push -u origin master --force
Enumerating objects: 17, done.
Counting objects: 100% (17/17), done.
Delta compression using up to 8 threads
Compressing objects: 100% (14/14), done.
Writing objects: 100% (17/17), 9.34 KiB | 4.67 MiB/s, done.
Total 17 (delta 1), reused 0 (delta 0)
remote: Resolving deltas: 100% (1/1), done.
To github.com:tomatohammado/calltime-node-auth-with-tokens.git
+ 0269519...6aa916c master -> master (forced update)
Branch 'master' set up to track remote branch 'master' from 'origin'.
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master
$ git status
On branch master
Your branch is up to date with 'origin/master'.
Changes not staged for commit:
(use "git add <file>..." to update what will be committed)
(use "git checkout -- <file>..." to discard changes in working directory)
modified: app.js
modified: routes/index.js
modified: routes/users.js
no changes added to commit (use "git add" and/or "git commit -a")
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [!]
$ git add .
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master [+]
$ git commit
[master db91f3c] Auto-fix JS as per Standard conventions
Committer: tomatohammado <hammad@MacBoku-Pro-2018.local>
Your name and email address were configured automatically based
on your username and hostname. Please check that they are accurate.
You can suppress this message by setting them explicitly:
git config --global user.name "Your Name"
git config --global user.email you@example.com
After doing this, you may fix the identity used for this commit with:
git commit --amend --reset-author
3 files changed, 53 insertions(+), 53 deletions(-)
rewrite app.js (78%)
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master
$ git push
Enumerating objects: 11, done.
Counting objects: 100% (11/11), done.
Delta compression using up to 8 threads
Compressing objects: 100% (6/6), done.
Writing objects: 100% (6/6), 806 bytes | 806.00 KiB/s, done.
Total 6 (delta 4), reused 0 (delta 0)
remote: Resolving deltas: 100% (4/4), completed with 4 local objects.
To github.com:tomatohammado/calltime-node-auth-with-tokens.git
6aa916c..db91f3c master -> master
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on master
$ git checkout -b mvp
Switched to a new branch 'mvp'
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ express -h
Usage: express [options] [dir]
Options:
--version output the version number
-e, --ejs add ejs engine support
--pug add pug engine support
--hbs add handlebars engine support
-H, --hogan add hogan.js engine support
-v, --view <engine> add view <engine> support (dust|ejs|hbs|hjs|jade|pug|twig|vash) (defaults to jade)
--no-view use static html instead of view engine
-c, --css <engine> add stylesheet <engine> support (less|stylus|compass|sass) (defaults to plain css)
--git add .gitignore
-f, --force force on non-empty directory
-h, --help output usage information
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ code ../call-time-app-strapi/
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ npm i sequelize pg pg-hstore
+ pg@7.8.0
+ pg-hstore@2.3.2
+ sequelize@4.42.0
added 41 packages from 110 contributors and audited 241 packages in 2.802s
found 2 low severity vulnerabilities
run `npm audit fix` to fix them, or `npm audit` for details
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp [!]
$ npm audit
=== npm audit security report ===
┌──────────────────────────────────────────────────────────────────────────────┐
│ Manual Review │
│ Some vulnerabilities require your attention to resolve │
│ │
│ Visit https://go.npm.me/audit-guide for additional guidance │
└──────────────────────────────────────────────────────────────────────────────┘
┌───────────────┬──────────────────────────────────────────────────────────────┐
│ Low │ Incorrect Handling of Non-Boolean Comparisons During │
│ │ Minification │
├───────────────┼──────────────────────────────────────────────────────────────┤
│ Package │ uglify-js │
├───────────────┼──────────────────────────────────────────────────────────────┤
│ Patched in │ >= 2.4.24 │
├───────────────┼──────────────────────────────────────────────────────────────┤
│ Dependency of │ jade │
├───────────────┼──────────────────────────────────────────────────────────────┤
│ Path │ jade > transformers > uglify-js │
├───────────────┼──────────────────────────────────────────────────────────────┤
│ More info │ https://npmjs.com/advisories/39 │
└───────────────┴──────────────────────────────────────────────────────────────┘
┌───────────────┬──────────────────────────────────────────────────────────────┐
│ Low │ Regular Expression Denial of Service │
├───────────────┼──────────────────────────────────────────────────────────────┤
│ Package │ uglify-js │
├───────────────┼──────────────────────────────────────────────────────────────┤
│ Patched in │ >=2.6.0 │
├───────────────┼──────────────────────────────────────────────────────────────┤
│ Dependency of │ jade │
├───────────────┼──────────────────────────────────────────────────────────────┤
│ Path │ jade > transformers > uglify-js │
├───────────────┼──────────────────────────────────────────────────────────────┤
│ More info │ https://npmjs.com/advisories/48 │
└───────────────┴──────────────────────────────────────────────────────────────┘
found 2 low severity vulnerabilities in 241 scanned packages
2 vulnerabilities require manual review. See the full report for details.
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp [!]
$ npm audit fix
up to date in 0.534s
fixed 0 of 2 vulnerabilities in 241 scanned packages
2 vulnerabilities required manual review and could not be updated
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp [!]
$ git status
On branch mvp
Changes not staged for commit:
(use "git add <file>..." to update what will be committed)
(use "git checkout -- <file>..." to discard changes in working directory)
modified: package-lock.json
modified: package.json
no changes added to commit (use "git add" and/or "git commit -a")
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp [!]
$ git diff package.json
diff --git a/package.json b/package.json
index bf07881..43a55bc 100644
--- a/package.json
+++ b/package.json
@@ -21,6 +21,9 @@
"express": "~4.16.0",
"http-errors": "~1.6.2",
"jade": "~1.11.0",
- "morgan": "~1.9.0"
+ "morgan": "~1.9.0",
+ "pg": "^7.8.0",
+ "pg-hstore": "^2.3.2",
+ "sequelize": "^4.42.0"
}
}
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp [!]
$ git status
On branch mvp
Changes not staged for commit:
(use "git add <file>..." to update what will be committed)
(use "git checkout -- <file>..." to discard changes in working directory)
modified: package-lock.json
modified: package.json
no changes added to commit (use "git add" and/or "git commit -a")
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp [!]
$ git add .
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp [+]
$ git commit
[mvp dc32ab1] Install Sequelize and related PostgreSQL npm packages
Committer: tomatohammado <hammad@MacBoku-Pro-2018.local>
Your name and email address were configured automatically based
on your username and hostname. Please check that they are accurate.
You can suppress this message by setting them explicitly:
git config --global user.name "Your Name"
git config --global user.email you@example.com
After doing this, you may fix the identity used for this commit with:
git commit --amend --reset-author
2 files changed, 282 insertions(+), 1 deletion(-)
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ code ../
.DS_Store calltime_twilio_study/
backendcalltime.dump frontend-react-call-time/
backendcalltime.sql node-auth-with-tokens/
backendcalltime_january_15_2019.dump starter-node-express/
browser-calls-node/ twilio-backend-service/
call-time-app-strapi/
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ code ../backendcalltime.dump
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ pg_restore -d node-auth-study ../backendcalltime.dump
pg_restore: [archiver (db)] connection to database "node-auth-study" failed: FATAL: database "node-auth-study" does not exist
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ pg_restore -d -C node-auth-study ../backendcalltime.dump
pg_restore: too many command-line arguments (first is "../backendcalltime.dump")
Try "pg_restore --help" for more information.
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ pg_restore --help
pg_restore restores a PostgreSQL database from an archive created by pg_dump.
Usage:
pg_restore [OPTION]... [FILE]
General options:
-d, --dbname=NAME connect to database name
-f, --file=FILENAME output file name
-F, --format=c|d|t backup file format (should be automatic)
-l, --list print summarized TOC of the archive
-v, --verbose verbose mode
-V, --version output version information, then exit
-?, --help show this help, then exit
Options controlling the restore:
-a, --data-only restore only the data, no schema
-c, --clean clean (drop) database objects before recreating
-C, --create create the target database
-e, --exit-on-error exit on error, default is to continue
-I, --index=NAME restore named index
-j, --jobs=NUM use this many parallel jobs to restore
-L, --use-list=FILENAME use table of contents from this file for
selecting/ordering output
-n, --schema=NAME restore only objects in this schema
-N, --exclude-schema=NAME do not restore objects in this schema
-O, --no-owner skip restoration of object ownership
-P, --function=NAME(args) restore named function
-s, --schema-only restore only the schema, no data
-S, --superuser=NAME superuser user name to use for disabling triggers
-t, --table=NAME restore named relation (table, view, etc.)
-T, --trigger=NAME restore named trigger
-x, --no-privileges skip restoration of access privileges (grant/revoke)
-1, --single-transaction restore as a single transaction
--disable-triggers disable triggers during data-only restore
--enable-row-security enable row security
--if-exists use IF EXISTS when dropping objects
--no-comments do not restore comments
--no-data-for-failed-tables do not restore data of tables that could not be
created
--no-publications do not restore publications
--no-security-labels do not restore security labels
--no-subscriptions do not restore subscriptions
--no-tablespaces do not restore tablespace assignments
--section=SECTION restore named section (pre-data, data, or post-data)
--strict-names require table and/or schema include patterns to
match at least one entity each
--use-set-session-authorization
use SET SESSION AUTHORIZATION commands instead of
ALTER OWNER commands to set ownership
Connection options:
-h, --host=HOSTNAME database server host or socket directory
-p, --port=PORT database server port number
-U, --username=NAME connect as specified database user
-w, --no-password never prompt for password
-W, --password force password prompt (should happen automatically)
--role=ROLENAME do SET ROLE before restore
The options -I, -n, -P, -t, -T, and --section can be combined and specified
multiple times to select multiple objects.
If no input file name is supplied, then standard input is used.
Report bugs to <pgsql-bugs@postgresql.org>.
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ pg_restore -C -d node-auth-study ../backendcalltime.dump
pg_restore: [archiver (db)] connection to database "node-auth-study" failed: FATAL: database "node-auth-study" does not exist
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ pg_restore -d node-auth-study ../backendcalltime.dump
pg_restore: [archiver (db)] connection to database "node-auth-study" failed: FATAL: database "node-auth-study" does not exist
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ psql
psql (11.0)
Type "help" for help.
hammad=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-------------------+----------+----------+-------------+-------------+-----------------------
backendcalltime | hammad | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
hammad | hammad | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
strapitestproject | hammad | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
(6 rows)
hammad=# \q
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ pg_dump backendcalltime > backendcalltime_hammad.sql
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp [?]
$ mv backendcalltime_hammad.sql ../backendcalltime_hammad.sql
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ open ../
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ pg_restore -d node-auth-study ../backendcalltime_hammad.sql
pg_restore: [archiver] input file appears to be a text format dump. Please use psql.
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ trash ../backendcalltime_hammad.sql
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime/node-auth-with-tokens on mvp
$ cd ..
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime
$ pg_dump --format=c backendcalltime > backendcalltime_hammad.dump
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime
$ ls
backendcalltime.dump calltime_twilio_study
backendcalltime.sql frontend-react-call-time
backendcalltime_hammad.dump node-auth-with-tokens
backendcalltime_january_15_2019.dump starter-node-express
browser-calls-node twilio-backend-service
call-time-app-strapi
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime
$ pg_restore -v -d node-auth-study backendcalltime_hammad.dump
pg_restore: connecting to database for restore
pg_restore: [archiver (db)] connection to database "node-auth-study" failed: FATAL: database "node-auth-study" does not exist
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime
$ pg_restore -v -C -d node-auth-study backendcalltime_hammad.dump
pg_restore: connecting to database for restore
pg_restore: [archiver (db)] connection to database "node-auth-study" failed: FATAL: database "node-auth-study" does not exist
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime
$ psql node-auth-study < backendcalltime_hammad.sql
psql: FATAL: database "node-auth-study" does not exist
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime
$ createdb --help
createdb creates a PostgreSQL database.
Usage:
createdb [OPTION]... [DBNAME] [DESCRIPTION]
Options:
-D, --tablespace=TABLESPACE default tablespace for the database
-e, --echo show the commands being sent to the server
-E, --encoding=ENCODING encoding for the database
-l, --locale=LOCALE locale settings for the database
--lc-collate=LOCALE LC_COLLATE setting for the database
--lc-ctype=LOCALE LC_CTYPE setting for the database
-O, --owner=OWNER database user to own the new database
-T, --template=TEMPLATE template database to copy
-V, --version output version information, then exit
-?, --help show this help, then exit
Connection options:
-h, --host=HOSTNAME database server host or socket directory
-p, --port=PORT database server port
-U, --username=USERNAME user name to connect as
-w, --no-password never prompt for password
-W, --password force password prompt
--maintenance-db=DBNAME alternate maintenance database
By default, a database with the same name as the current user is created.
Report bugs to <pgsql-bugs@postgresql.org>.
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime
$ createdb node-auth-study
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime
$ psql node-auth-study < backendcalltime_hammad.sql
SET
SET
SET
SET
SET
set_config
------------
(1 row)
SET
SET
SET
SET
SET
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
COPY 29
COPY 0
COPY 0
COPY 14
COPY 7
COPY 22
COPY 35
COPY 3
COPY 5
COPY 2
COPY 1
COPY 0
COPY 387
COPY 3
COPY 1
setval
--------
39
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
15
(1 row)
setval
--------
7
(1 row)
setval
--------
22
(1 row)
setval
--------
38
(1 row)
setval
--------
4
(1 row)
setval
--------
8
(1 row)
setval
--------
2
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
522
(1 row)
setval
--------
3
(1 row)
setval
--------
1
(1 row)
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
hammad at MacBoku-Pro-2018 in ~/dev/work/calltime
$
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment