# Conduit_NodeJS

**Repository Path**: sigcc/conduit-node-js

## Basic Information

- **Project Name**: Conduit_NodeJS
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2022-04-03
- **Last Updated**: 2023-12-20

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Conduit (Medium Clone based on [realworld.io](https://github.com/gothinkster/realworld))

### Link to API - https://conduit-api-realworld.herokuapp.com/

**Note**: _The website may take a minute to load sometimes, as the server may be in hibernate state_

**_An Express and NodeJS based backend implementation of the [RealWorldAPI](https://github.com/gothinkster/realworld/tree/master/api) Spec._**

_Also **approved** by realworld.io and listed on their [project's home page](https://codebase.show/projects/realworld?category=backend&language=javascript)_.

## Technologies Used

1. **_NodeJS_** - Platform
2. **_Express_** - Framework
3. **_JavaScript_** - Programming Language
4. MySQL/Sqlite3 - Database
5. **_Sequelize_** - ORM

## 说明

[demo](https://demo.realworld.io/#/) 网站

这里是nodejs express 后端，其他前端后端参考  [frontends](https://codebase.show/projects/realworld?category=frontend) and [backends](https://codebase.show/projects/realworld?category=backend).

https://github.com/gothinkster/realworld

## install 

```sh
#安装依赖库
npm install

#创建数据库
# config/config.json
npx sequelize-cli db:create

#运行服务
npx nodemon index.js
```

## 文件说明

| 文件               | 说明                  | 备注                |
| ------------------ | --------------------- | ------------------- |
| index.js           | 入口                  |                     |
| dbConnection.js    | sequelize 数据库连接 |                     |
| config/config.json | sequelize 创建数据库配置 |                     |
| models/*.js        | 数据模型定义          |                     |
| routes/*.js        | 路由定义              |                     |
| controllers/*.js   | 控制器定义            |                     |
| api.http           | Rest Client 请求文件  | 安装Rest Client插件 |
| package.json       | 包声明文件            |                     |
| app.db             | sqlite3 数据库文件    |                     |

## ~~node模块 sqlite3  bcrypt 手动安装 ~~

上面安装过程中，如报 sqlite3  bcrypt错误，可手动安装

```sh
# 安装 工具
npm install @mapbox/node-pre-gyp -g

# 分别进入 node_modules/sqlite3，bcrypt目录，运行

node-pre-gyp install

# node_module.zip 是 sqilite3  bcrypt  的 win10 /node14 的模块，包含二进制文件
```

## ~~node本地模块~~

也可直接下载依赖，注意版本号要匹配

https://github.com/TryGhost/node-sqlite3/releases

https://github.com/TryGhost/node-sqlite3/releases/download/v5.1.6/napi-v3-win32-unknown-x64.tar.gz

拷贝到 node_modules\sqlite3\lib\binding\napi-v3-win32-x64 目录

https://github.com/kelektiv/node.bcrypt.js/releases

[bcrypt_lib-v5.1.0-napi-v3-win32-x64-unknown.tar.gz](https://github.com/kelektiv/node.bcrypt.js/releases/download/v5.1.0/bcrypt_lib-v5.1.0-napi-v3-win32-x64-unknown.tar.gz)

node_modules\bcrypt\lib\binding\napi-v3

### 使用 Mysql 数据库

 config/config.json 文件里面配置好数据账号，端口

```
"development": {
    "username": "root",
    "password": "123456",
    "database": "app",
    "host": "127.0.0.1",
    "port": 3306,
    "dialect": "mysql"
  },
```

```
//dbConnection.js 修改为一下配置
const {Sequelize} = require('sequelize')

//LOCAL CONNECTION,指定连接 `app` 数据库
 const sequelize = new Sequelize('app','root','123456',{
    dialect: 'mysql',
    host:'localhost',
    logging: false
}); 

```

### Open API

#### vscode 安装 rest-client 扩展

- 查看 `api.http` 文件

#### https://hoppscotch.io/cn/

- hoppscotch

### mock server

- https://github.com/stoplightio/prism#-installation-and-usage

### task

- ORM 用 prisma https://www.freecodecamp.org/news/build-nodejs-database-using-prisma-orm/