安装前提条件：
1、已经安装了docker运行环境
2、以下命令执行记录发生在MackBook环境
3、已经安装了PostgreSQL（我使用的是11版本）
4、Node开发运行环境可以正常工作
 
首先需要通过Node包管理器安装Prisma工具：
 
npm install -g prisma
 
然后，创建并初始化prisma项目：
 
prisma init prisma-study
 
? Set up a new Prisma server or deploy to an existing server? (Use arrow keys)
                        
  You can set up Prisma for local development (based on docker-compose)
❯ Use existing database      Connect to existing database
  Create new database        Set up a local database using Docker
                        
  Or deploy to an existing Prisma server:
  Demo server                Hosted demo environment incl. database (requires login)
  Use other server           Manually provide endpoint of a running Prisma server
 
选择使用已存在的数据库（Use existing database）后，回车确认选择。
 
? Set up a new Prisma server or deploy to an existing server? Use existing database
? What kind of database do you want to deploy to?
  MySQL             MySQL compliant databases like MySQL or MariaDB
❯ PostgreSQL        PostgreSQL database
 
移动上下箭头键盘按键，选择PostgreSQL后，再次回车确认选择。
 
? Set up a new Prisma server or deploy to an existing server? Use existing database
? What kind of database do you want to deploy to? PostgreSQL
? Does your database contain existing data? (Use arrow keys)
❯ No
  Yes (experimental - Prisma migrations not yet supported)
  
Warning: Introspecting databases with existing data is currently an experimental feature. If you find any issues, please report them here: https://github.co
m/prisma/prisma/issues
 
提示是否在选择的数据库中包含已存在数据。因为是一个新库，所以默认选择No，然后回车确认。
 
? Set up a new Prisma server or deploy to an existing server? Use existing database
? What kind of database do you want to deploy to? PostgreSQL
? Does your database contain existing data? No
? Enter database host (localhost)
 
输入数据库的主机地址（注意，因为prisma会运行在docker中，所以，这儿需要配置宿主机IP，在类Linux系统上可以通过ifconfig命令来获取IP）。
 
? Set up a new Prisma server or deploy to an existing server? Use existing database
? What kind of database do you want to deploy to? PostgreSQL
? Does your database contain existing data? No
? Enter database host 10.111.152.242
? Enter database port (5432)
 
回车确认使用默认的Postgres数据库的端口。
 
? Set up a new Prisma server or deploy to an existing server? Use existing database
? What kind of database do you want to deploy to? PostgreSQL
? Does your database contain existing data? No
? Enter database host 10.xxx.xxx.xxx（此处为你的docker宿主机IP）
? Enter database port 5432
? Enter database user
 
输入数据库的用户名后回车确认。
 
? Set up a new Prisma server or deploy to an existing server? Use existing database
? What kind of database do you want to deploy to? PostgreSQL
? Does your database contain existing data? No
? Enter database host 10.xxx.xxx.xxx（此处为你的docker宿主机IP）
? Enter database port 5432
? Enter database user postgres
? Enter database password
 
输入数据库用户对应的密码后回车确认。
 
? Set up a new Prisma server or deploy to an existing server? Use existing database
? What kind of database do you want to deploy to? PostgreSQL
? Does your database contain existing data? No
? Enter database host 10.xxx.xxx.xxx（此处为你的docker宿主机IP）
? Enter database port 5432
? Enter database user postgres
? Enter database password study
? Enter database name
 
输入使用的数据库名称后回车。
 
? Set up a new Prisma server or deploy to an existing server? Use existing database
? What kind of database do you want to deploy to? PostgreSQL
? Does your database contain existing data? No
? Enter database host 10.xxx.xxx.xxx（此处为你的docker宿主机IP）
? Enter database port 5432
? Enter database user postgres
? Enter database password study
? Enter database name study
? Use SSL? (Y/n)
 
提示是否使用安全的网络协议，这里选择不使用（输入n后回车）。
 
? Set up a new Prisma server or deploy to an existing server? Use existing database
? What kind of database do you want to deploy to? PostgreSQL
? Does your database contain existing data? No
? Enter database host 10.xxx.xxx.xxx（此处为你的docker宿主机IP）
? Enter database port 5432
? Enter database user postgres
? Enter database password study
? Enter database name study
? Use SSL? No
Connecting to database 18ms
? Select the programming language for the generated Prisma client
  Prisma TypeScript Client
  Prisma Flow Client
❯ Prisma JavaScript Client
  Prisma Go Client
  Don't generate
 
这里选择产生JavaScript客户端脚本（Prisma JavaScript Client）。
 
? Set up a new Prisma server or deploy to an existing server? Use existing database
? What kind of database do you want to deploy to? PostgreSQL
? Does your database contain existing data? No
? Enter database host 10.xxx.xxx.xxx（此处为你的docker宿主机IP）
? Enter database port 5432
? Enter database user postgres
? Enter database password study
? Enter database name study
? Use SSL? No
Connecting to database 18ms
? Select the programming language for the generated Prisma client Prisma JavaScript Client
Created 3 new files:                                                                          
  prisma.yml          Prisma service definition
  datamodel.prisma    GraphQL SDL-based datamodel (foundation for database)
  docker-compose.yml  Docker configuration file
Next steps:
  1. Open folder: cd prisma-study
  2. Start your Prisma server: docker-compose up -d
  3. Deploy your Prisma service: prisma deploy
  4. Read more about Prisma server:
     http://bit.ly/prisma-server-overview
Generating schema... 20ms
Saving Prisma Client (JavaScript) at /Users/chunrong.liu/dev/study/prisma-study/generated/prisma-client/
 
至此，Prisma项目创建并初始化完毕。
 
接下来按昭Next steps下面的步骤提示执行后续操作。
 
通过以下命令切换当前目录至刚创建的项目目录（prisma-study）中。
cd prisma-study/
 
通过docker编排命令在docker中运行prisma服务器。
docker-compose up -d
执行后命令行提示如下：
Creating prisma-study_prisma_1 … done
此时服务运行成功。
 
通过以下命令部署prisma服务。
$ prisma deploy
Creating stage default for service default ✔
Deploying service `default` to stage `default` to server `local` 476ms
Changes:
  User (Type)
  + Created type `User`
  + Created field `id` of type `GraphQLID!`
  + Created field `name` of type `String!`
  + Created field `updatedAt` of type `DateTime!`
  + Created field `createdAt` of type `DateTime!`
Applying changes 1.2s
Your Prisma GraphQL database endpoint is live:
  HTTP:  http://localhost:4466
  WS:    ws://localhost:4466
 
用流程器打开http://localhost:4466/链接地址，可以看到如下的UI界面。
 
运行如下命令可以看到演练数据：
$ prisma playground
Serving playground at http://localhost:3000/playground
 
此时会自动打开浏览器，并显示如下界面：
 
 
关于数据库无法连接的问题：
 
官方参考资料地址：

最新文章

  1. Xcode报错：“Your build settings specify a provisioning profile with the UUID..... however, no such provisioning profile was found”
  2. 鼠标选择文字事件js代码，增加层问题
  3. Java的访问控制
  4. bootstrap学习笔记<八>（bootstrap核心布局风格——栅格系统）
  5. opencl gauss filter优化(一)
  6. AssetBundle机制相关资料收集
  7. HDU 2516 取石子游戏(FIB博弈)
  8. 【转】Android:Animation的简单学习--不错
  9. MySQL生僻字(不常用字)的完整解决方案
  10. ntopng-一款流量审计框架的安装以及应用
  11. java四则运算
  12. javascript中原型链与instanceof 原理
  13. Python中的注释和解注释
  14. Egg入门学习(一)
  15. Linux内核中Makefile、Kconfig和.config的关系（转）
  16. HTML 【表单】
  17. bzoj 1036: [ZJOI2008]树的统计Count （树链剖分+线段树 点权）
  18. Swift-setValuesForKeysWithDictionary
  19. Juice账号
  20. C/C++中0xcccccccc...

热门文章

  1. EF Core 实现读写分离的最佳方案
  2. Java基础学习笔记(四) - 认识final关键字、权限修饰符和内部类
  3. 编程杂谈——使用emplace_back取代push_back
  4. 【网络安全】CSRF攻击详解
  5. Java 语言特点
  6. 推荐一款超好用的工具cmder
  7. css中em单位详解，说明
  8. django-drf框架自带的路由以及最简化的视图
  9. Ubuntu Qt5.13 无法输入中文和中文显示乱码问题
  10. iOS开发请您把握现在 — 面向未来学习