123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419 |
- const ObjectID = require("mongodb").ObjectID;
- const jwt = require('jsonwebtoken')
- const jwtSecret = 'CbymrfGfnB'
- const anonResolvers = ['login', 'createUser'];
- ;(async () => {
- const {Savable, slice, getModels} = await require('./models.js')()
- class User extends Savable {
- static get relations(){
- return {
- }
- }
- }
- Savable.addClass(User)
- const express = require('express');
- const express_graphql = require('express-graphql');
- const { buildSchema } = require('graphql');
- const schema = buildSchema(`
- type Query {
- login(login: String!, password: String!): String
- categories: [Category]
- category(_id: ID!): Category
- goods: [Good]
- good(_id: ID!): Good
- myOrders: [Order]
- orders: [Order]
- }
- type Mutation {
- createUser(login: String!, password: String!): User
- changePassword(password: String!): User
- setCategory(cat: CategoryInput!):Category
- setGood(good: GoodInput!):Good
- setOrder(order: OrderInput):Order
- setOrderGood(orderGood: OrderGoodInput):OrderGood
- }
- type User {
- _id: String
- login: String
- nick : String
- orders: [Order]
- }
- type Category {
- _id: ID,
- name: String!,
- goods: [Good]
- }
- type Good {
- _id: ID,
- name: String!,
- description: String
- price: Float
- orderGoods: [OrderGood]
- categories: [Category]
- }
- type OrderGood {
- _id: ID,
- price: Float,
- count: Float,
- good: Good,
- order: Order
- }
- type Order {
- _id: ID
- orderGoods: [OrderGood]
- }
- input UserInput {
- _id: String
- login: String
- nick : String
- }
- input CategoryInput {
- _id: ID,
- name: String!,
- goods: [ID]
- }
- input GoodInput {
- _id: ID,
- name: String!,
- description: String
- price: Float
- categories: [ID]
- }
- input OrderGoodInput {
- _id: ID,
- count: Int!,
- good: ID!,
- order: ID!
- }
- input OrderInput {
- _id: ID
- orderGoods: [ID]
- }
- `);
- var app = express();
- app.use(express.static('public'));
- const rootResolvers = {
- createUser:async function ({login, password}){
- let user = await Savable.m.User.findOne({login, password})
- if (user)
- return null;
- user = await (new User({login, password})).save()
- user.___owner = user._id.toString()
- user.___permissions = {
- read: ["owner", "user"]
- }
- return await user.save()
- },
- login: async function({login, password}){
- console.log(Savable.classes)
- const user = await Savable.m.User.findOne({login, password})
- if (!user)
- return null;
- const token = jwt.sign({ sub: {id: user._id, login}}, jwtSecret); //подписывам токен нашим ключем
- return token
- },
- changePassword:async function ({password}, {jwt: {id}, models: {SlicedSavable, User}} ){
- id = new ObjectID(id)
- const user = await SlicedSavable.m.User.findOne({_id: id})
- if (!user)
- return null;
- user.password = password;
- return await user.save()
- },
- async setCategory({cat}, {jwt: {id}, models: {SlicedSavable, Category}}){
- if ('_id' in cat){
- let entity = await SlicedSavable.m.Category.findOne({_id: ObjectID(cat._id)})
- console.log(entity)
- if (entity){
- entity.name = cat.name
- if (cat.goods){
- entity.goods = []
- for (goodId of cat.goods){
- let good = await SlicedSavable.m.Good.findOne({_id: ObjectID(goodId)});
- good && entity.goods.push(good)
- }
- }
- return await entity.save()
- }
- }
- return await (new Category(cat)).save()
- },
- async categories({}, {jwt: {id}, models: {SlicedSavable, Category}}){
- categories = []
- for (let category of SlicedSavable.m.Category.find({})){
- try {category = await category} catch (e) { break }
- categories.push(category)
- }
- return categories;
- },
- async category({_id}, {jwt: {id}, models: {SlicedSavable, Category}}){
- return await SlicedSavable.m.Category.findOne({_id: ObjectID(_id)});
- },
- async setGood({good}, {jwt: {id}, models: {SlicedSavable, Good}}){
- if ('_id' in good){
- let entity = await SlicedSavable.m.Good.findOne({_id: ObjectID(good._id)})
- if (entity){
- entity.name = good.name
- entity.description = good.description
- entity.price = good.price
- if (good.categories){
- console.log(good.categories)
- entity.categories = []
- for (catId of good.categories){
- let cat = await SlicedSavable.m.Category.findOne({_id: ObjectID(catId)});
- cat && entity.categories.push(cat)
- }
- }
- return await entity.save()
- }
- }
- return await (new Good(good)).save()
- },
- async goods({}, {jwt: {id}, models: {SlicedSavable, Good}}){
- goods = []
- for (let good of SlicedSavable.m.Good.find({})){
- try {good = await good} catch (e) { break }
- goods.push(good)
- }
- return goods;
- },
- async good({_id}, {jwt: {id}, models: {SlicedSavable, Good}}){
- return await SlicedSavable.m.Good.findOne({_id: ObjectID(_id)});
- },
- async setOrder({order}, {jwt: {id}, models: {SlicedSavable, Order, thisUser}}){
- if ('_id' in order){
- let entity = await SlicedSavable.m.Order.findOne({_id: ObjectID(good._id)})
- if (entity){
- //entity.name = good.name
- //entity.description = good.description
- if (order.orderGoods){
- entity.orderGoods = []
- for (orderGoodId of entity.orderGoods){
- let orderGood = await SlicedSavable.m.OrderGood.findOne({_id: ObjectID(orderGoodId)});
- orderGood && entity.orderGoods.push(orderGood)
- }
- }
- entity.user = thisUser
- return await entity.save()
- }
- }
- order.user = thisUser
- return await (new Order(order)).save()
- },
- async orders({}, {jwt: {id}, models: {SlicedSavable}}){
- orders = []
- for (let order of SlicedSavable.m.Order.find({})){
- try {order = await order} catch (e) { break }
- orders.push(order)
- }
- return order;
- },
- async myOrders({}, {jwt: {id}, models: {SlicedSavable}}){
- orders = []
- for (let order of SlicedSavable.m.Order.find({___owner: id.toString(id)})){
- try {order = await order} catch (e) { break }
- orders.push(order)
- }
- return orders;
- },
- async order({_id}, {jwt: {id}, models: {SlicedSavable, Good}}){
- return await SlicedSavable.m.Order.findOne({_id: ObjectID(_id)});
- },
- async setOrderGood({orderGood}, {jwt: {id}, models: {SlicedSavable, OrderGood, thisUser}}){
- console.log(orderGood)
- let order = await SlicedSavable.m.Order.findOne({'_id': ObjectID(orderGood.order)})
- let good = await SlicedSavable.m.Good.findOne ({'_id': ObjectID(orderGood.good)})
- if (order && good){
- let entity = await SlicedSavable.m.OrderGood.findOne({'order._id': order._id,
- 'good._id': good._id})
- if (!entity){
- entity = new OrderGood({})
- }
- entity.price = good.price
- entity.count = orderGood.count
- entity.order = order
- entity.good = good
- await entity.save()
- console.log(entity)
- return entity
- }
- return null;
- },
- async createEvent({name, total}, {jwt: {id}, models: {Event}}){
- return await (new Event({name, total})).save()
- },
- async changeEvent({eventId, name, total}, {jwt: {id}, models: {SlicedSavable}}){
- const event = await SlicedSavable.m.Event.findOne({_id: ObjectID(eventId)})
- if (!event)
- return null;
- event.name = name
- event.total = total
- return await event.save()
- },
- async events({}, {jwt: {id}, models: {SlicedSavable}}){
- let events = []
- for (let event of SlicedSavable.m.Event.find({})){
- event = await event
- //const {_id, name, owner, moneyEvents, usersSum, moneyDiff, total} = event
- //event = {_id, name, owner, moneyEvents, usersSum: await event.usersSum, total}
- //console.log(event)
- events.push(event)
- }
- return events;
- },
- async event({eventId}, {jwt: {id}, models: {SlicedSavable}}){
- return await SlicedSavable.m.Event.findOne({_id: ObjectID(eventId)});
- },
- async createEventMoney({eventId, amount}, {jwt: {id}, models: {SlicedSavable, EventMoney, thisUser}}){
- let eventMoney = await SlicedSavable.m.EventMoney.findOne({"user._id": ObjectID(id), "event._id": ObjectID(eventId)})
- if (eventMoney){
- eventMoney.amount = amount;
- return await eventMoney.save()
- }
- const event = await SlicedSavable.m.Event.findOne({_id: ObjectID(eventId)})
- if (!event)
- return null;
- if (!thisUser)
- return null;
- console.log(thisUser, event, amount)
- return await (new EventMoney({user: thisUser, event, amount})).save()
- },
- async eventMoneysByEvent({eventId}, {jwt: {id}, models: {SlicedSavable}}){
- const event = await SlicedSavable.m.Event.findOne({_id: ObjectID(eventId)});
- if (!event)
- return null
- const moneys = [];
- for (let money of event.moneyEvents){
- try {
- await money
- console.log(money)
- }
- catch (e){
- console.log('skip no access user' ,e)
- }
- moneys.push(money)
- console.log('in loop')
- }
- console.log('after loop')
- return moneys;
- },
- async eventMoneys({}, {jwt: {id}, models: {SlicedSavable}}){
- const me = await SlicedSavable.m.User.findOne({_id: ObjectID(id)});
- if (!me)
- return null
- const moneys = [];
- for (let money of me.moneyEvents){
- moneys.push(await money)
- }
- return moneys;
- },
- }
- app.use('/graphql', express_graphql(async (req, res, gql) => {
- if (gql.operationName === null || anonResolvers.includes(gql.operationName))
- return {
- schema: schema,
- rootValue: rootResolvers,
- graphiql: true,
- }
-
- const authorization = req.headers.authorization
- if (authorization && authorization.startsWith('Bearer ')){
- console.log('token provided')
- const token = authorization.substr("Bearer ".length)
- const decoded = jwt.verify(token, jwtSecret)
- if (decoded){
- console.log('token verified', decoded)
- let slicedModels = await getModels(decoded.sub.id)
- return {
- schema: schema,
- rootValue: rootResolvers,
- graphiql: true,
- context: {jwt: decoded.sub,
- models: slicedModels}
- }
- }
- }
- }))
- app.listen(4000, () => console.log('Express GraphQL Server Now Running On localhost:4000/graphql'));
- })()
|