mysql.md 4.0 KB

MySQL 向 GraphQL 迁移

GraphQL 是一个开源的图形数据库(基于Node.js实现), 中文文档: https://graphql.js.cool/

sequelize-auto 将 MySQL 数据库转变成模型

[node] sequelize-auto -h <host> -d <database> -u <user> -x [password] -p [port]  --dialect [dialect] -c [/path/to/config] -o [/path/to/models] -t [tableName] -C

参数:
  -h, --host        主机地址 [必须]
  -d, --database    数据名 [必须]
  -u, --user        用户名
  -x, --pass        密码
  -p, --port        端口号
  -c, --config      配置文件,参考: https://sequelize.readthedocs.org/en/latest/api/sequelize/
  -o, --output      输出目录
  -e, --dialect     数据库引擎: postgres, mysql, sqlite
  -t, --tables      需要导入的表
  -T, --skip-tables 需要排除的表
  -C, --camel       使用用驼峰命名法
  -n, --no-write    不需要写入文件
  -s, --schema      数据库结构

使用数据模型

这里是生成的一个示例模型:

/* jshint indent: 2 */

module.exports = function(sequelize, DataTypes) {
  return sequelize.define('d_user', {
    uid: {
      type: DataTypes.INTEGER(11).UNSIGNED,
      allowNull: false,
      primaryKey: true
    },
    username: {
      type: DataTypes.STRING(16),
      allowNull: false,
      defaultValue: ''
    },
    mobile: {
      type: DataTypes.STRING(16),
      allowNull: false,
      defaultValue: ''
    },
    email: {
      type: DataTypes.STRING(32),
      allowNull: false,
      defaultValue: ''
    },
    password: {
      type: DataTypes.STRING(32),
      allowNull: false,
      defaultValue: ''
    },
    salt: {
      type: DataTypes.STRING(8),
      allowNull: false,
      defaultValue: ''
    },
    updatedAt: {
      type: DataTypes.INTEGER(10).UNSIGNED,
      allowNull: false
    }
  }, {
    tableName: 'user'
  });
};

创建数据库模型:

const Sequelize = require('sequelize');

const Db = new Sequelize('数据库名', '用户名', '密码', {
  host: 'localhost',
  dialect: 'mysql'
})

const User = Db.define('user', {
  uid: {
    type: Sequelize.INTEGER(11).UNSIGNED,
    allowNull: false,
    primaryKey: true
  },
  username: {
    type: Sequelize.STRING(16),
    allowNull: false,
    defaultValue: ''
  },
  mobile: {
    type: Sequelize.STRING(16),
    allowNull: false,
    defaultValue: ''
  },
  email: {
    type: Sequelize.STRING(32),
    allowNull: false,
    defaultValue: ''
  },
  password: {
    type: Sequelize.STRING(32),
    allowNull: false,
    defaultValue: ''
  },
  salt: {
    type: Sequelize.STRING(8),
    allowNull: false,
    defaultValue: ''
  }
}, {
    tableName: 'user',
    // 取消默认的时间戳, 否则会报 createdAt 不存在错误
    timestamps: false
});

Db.sync();

module.exports = {
  Db,
  User
};

graphql-sequelize 转换 MySQL -> GraphQL 结构

const { GraphQLObjectType,GraphQLSchema,GraphQLList,GraphQLInt,GraphQLString } = require('graphql');
const { attributeFields, resolver } = require('graphql-sequelize');
const { Db, User } = require('./db');

userType = new GraphQLObjectType({
  name: 'User',
  description: 'A user',
  fields: attributeFields(User)
});

const Query = new GraphQLObjectType({
  name: 'Query',
  description: 'Root query object',
  fields: () => {
    return {
      user: {
        type: new GraphQLList(userType),
        args: {
          uid: {
            type: GraphQLInt
          },
          email: {
            type: GraphQLString
          }
        },
        resolve(root, args) {
          return Db.models.user.findAll({ where: args });
        }
      }
    };
  }
});

const Schema = new GraphQLSchema({
  query: Query
});

module.exports = Schema;

启动服务器


const Express =require( 'express');
const GraphHTTP =require( 'express-graphql');
const Schema =require( './schema');

// Config
const APP_PORT = 3000;

// Start
const app = Express();

// GraphQL
app.use('/graphql', GraphHTTP({
  schema: Schema,
  pretty: true,
  graphiql: true
}));

app.listen(APP_PORT, ()=> {
  console.log(`App listening on port ${APP_PORT}`);
});