getting there

6 files changed, 441 insertions, 46 deletions

diff --git a/backend/src/generated/prisma.graphql b/backend/src/generated/prisma.graphql
index 6132328..402e097 100644
--- a/backend/src/generated/prisma.graphql
+++ b/backend/src/generated/prisma.graphql
@@ -9,15 +9,25 @@ type CartItem implements Node {
   id: ID!
   quantity: Int!
   item(where: ItemWhereInput): Item!
+  user(where: UserWhereInput): User!
 }
 
 type Item implements Node {
   id: ID!
   title: String!
   description: String!
+  image: String
   price: Int!
 }
 
+type Order implements Node {
+  id: ID!
+  items(where: ItemWhereInput, orderBy: ItemOrderByInput, skip: Int, after: String, before: String, first: Int, last: Int): [Item!]
+  total: Int!
+  user(where: UserWhereInput): User!
+  charge: String!
+}
+
 type Post implements Node {
   id: ID!
   createdAt: DateTime!
@@ -34,6 +44,7 @@ type User implements Node {
   password: String!
   name: String!
   posts(where: PostWhereInput, orderBy: PostOrderByInput, skip: Int, after: String, before: String, first: Int, last: Int): [Post!]
+  orders(where: OrderWhereInput, orderBy: OrderOrderByInput, skip: Int, after: String, before: String, first: Int, last: Int): [Order!]
   website: String
   age: Int
   resetToken: String
@@ -54,6 +65,10 @@ type AggregateItem {
   count: Int!
 }
 
+type AggregateOrder {
+  count: Int!
+}
+
 type AggregatePost {
   count: Int!
 }
@@ -75,13 +90,19 @@ type CartItemConnection {
 input CartItemCreateInput {
   quantity: Int
   item: ItemCreateOneInput!
+  user: UserCreateOneWithoutCartInput!
 }
 
-input CartItemCreateManyInput {
-  create: [CartItemCreateInput!]
+input CartItemCreateManyWithoutUserInput {
+  create: [CartItemCreateWithoutUserInput!]
   connect: [CartItemWhereUniqueInput!]
 }
 
+input CartItemCreateWithoutUserInput {
+  quantity: Int
+  item: ItemCreateOneInput!
+}
+
 type CartItemEdge {
   node: CartItem!
   cursor: String!
@@ -123,13 +144,32 @@ input CartItemSubscriptionWhereInput {
 input CartItemUpdateInput {
   quantity: Int
   item: ItemUpdateOneInput
+  user: UserUpdateOneWithoutCartInput
 }
 
-input CartItemUpdateManyInput {
-  create: [CartItemCreateInput!]
+input CartItemUpdateManyWithoutUserInput {
+  create: [CartItemCreateWithoutUserInput!]
   connect: [CartItemWhereUniqueInput!]
   disconnect: [CartItemWhereUniqueInput!]
   delete: [CartItemWhereUniqueInput!]
+  update: [CartItemUpdateWithoutUserInput!]
+  upsert: [CartItemUpsertWithoutUserInput!]
+}
+
+input CartItemUpdateWithoutUserDataInput {
+  quantity: Int
+  item: ItemUpdateOneInput
+}
+
+input CartItemUpdateWithoutUserInput {
+  where: CartItemWhereUniqueInput!
+  data: CartItemUpdateWithoutUserDataInput!
+}
+
+input CartItemUpsertWithoutUserInput {
+  where: CartItemWhereUniqueInput!
+  update: CartItemUpdateWithoutUserDataInput!
+  create: CartItemCreateWithoutUserInput!
 }
 
 input CartItemWhereInput {
@@ -158,6 +198,7 @@ input CartItemWhereInput {
   quantity_gt: Int
   quantity_gte: Int
   item: ItemWhereInput
+  user: UserWhereInput
 }
 
 input CartItemWhereUniqueInput {
@@ -175,9 +216,15 @@ type ItemConnection {
 input ItemCreateInput {
   title: String!
   description: String!
+  image: String
   price: Int!
 }
 
+input ItemCreateManyInput {
+  create: [ItemCreateInput!]
+  connect: [ItemWhereUniqueInput!]
+}
+
 input ItemCreateOneInput {
   create: ItemCreateInput
   connect: ItemWhereUniqueInput
@@ -195,6 +242,8 @@ enum ItemOrderByInput {
   title_DESC
   description_ASC
   description_DESC
+  image_ASC
+  image_DESC
   price_ASC
   price_DESC
   updatedAt_ASC
@@ -207,6 +256,7 @@ type ItemPreviousValues {
   id: ID!
   title: String!
   description: String!
+  image: String
   price: Int!
 }
 
@@ -230,9 +280,17 @@ input ItemSubscriptionWhereInput {
 input ItemUpdateInput {
   title: String
   description: String
+  image: String
   price: Int
 }
 
+input ItemUpdateManyInput {
+  create: [ItemCreateInput!]
+  connect: [ItemWhereUniqueInput!]
+  disconnect: [ItemWhereUniqueInput!]
+  delete: [ItemWhereUniqueInput!]
+}
+
 input ItemUpdateOneInput {
   create: ItemCreateInput
   connect: ItemWhereUniqueInput
@@ -285,6 +343,20 @@ input ItemWhereInput {
   description_not_starts_with: String
   description_ends_with: String
   description_not_ends_with: String
+  image: String
+  image_not: String
+  image_in: [String!]
+  image_not_in: [String!]
+  image_lt: String
+  image_lte: String
+  image_gt: String
+  image_gte: String
+  image_contains: String
+  image_not_contains: String
+  image_starts_with: String
+  image_not_starts_with: String
+  image_ends_with: String
+  image_not_ends_with: String
   price: Int
   price_not: Int
   price_in: [Int!]
@@ -306,26 +378,32 @@ type Mutation {
   createUser(data: UserCreateInput!): User!
   createCartItem(data: CartItemCreateInput!): CartItem!
   createItem(data: ItemCreateInput!): Item!
+  createOrder(data: OrderCreateInput!): Order!
   updatePost(data: PostUpdateInput!, where: PostWhereUniqueInput!): Post
   updateUser(data: UserUpdateInput!, where: UserWhereUniqueInput!): User
   updateCartItem(data: CartItemUpdateInput!, where: CartItemWhereUniqueInput!): CartItem
   updateItem(data: ItemUpdateInput!, where: ItemWhereUniqueInput!): Item
+  updateOrder(data: OrderUpdateInput!, where: OrderWhereUniqueInput!): Order
   deletePost(where: PostWhereUniqueInput!): Post
   deleteUser(where: UserWhereUniqueInput!): User
   deleteCartItem(where: CartItemWhereUniqueInput!): CartItem
   deleteItem(where: ItemWhereUniqueInput!): Item
+  deleteOrder(where: OrderWhereUniqueInput!): Order
   upsertPost(where: PostWhereUniqueInput!, create: PostCreateInput!, update: PostUpdateInput!): Post!
   upsertUser(where: UserWhereUniqueInput!, create: UserCreateInput!, update: UserUpdateInput!): User!
   upsertCartItem(where: CartItemWhereUniqueInput!, create: CartItemCreateInput!, update: CartItemUpdateInput!): CartItem!
   upsertItem(where: ItemWhereUniqueInput!, create: ItemCreateInput!, update: ItemUpdateInput!): Item!
+  upsertOrder(where: OrderWhereUniqueInput!, create: OrderCreateInput!, update: OrderUpdateInput!): Order!
   updateManyPosts(data: PostUpdateInput!, where: PostWhereInput!): BatchPayload!
   updateManyUsers(data: UserUpdateInput!, where: UserWhereInput!): BatchPayload!
   updateManyCartItems(data: CartItemUpdateInput!, where: CartItemWhereInput!): BatchPayload!
   updateManyItems(data: ItemUpdateInput!, where: ItemWhereInput!): BatchPayload!
+  updateManyOrders(data: OrderUpdateInput!, where: OrderWhereInput!): BatchPayload!
   deleteManyPosts(where: PostWhereInput!): BatchPayload!
   deleteManyUsers(where: UserWhereInput!): BatchPayload!
   deleteManyCartItems(where: CartItemWhereInput!): BatchPayload!
   deleteManyItems(where: ItemWhereInput!): BatchPayload!
+  deleteManyOrders(where: OrderWhereInput!): BatchPayload!
 }
 
 enum MutationType {
@@ -338,6 +416,153 @@ interface Node {
   id: ID!
 }
 
+type OrderConnection {
+  pageInfo: PageInfo!
+  edges: [OrderEdge]!
+  aggregate: AggregateOrder!
+}
+
+input OrderCreateInput {
+  total: Int!
+  charge: String!
+  items: ItemCreateManyInput
+  user: UserCreateOneWithoutOrdersInput!
+}
+
+input OrderCreateManyWithoutUserInput {
+  create: [OrderCreateWithoutUserInput!]
+  connect: [OrderWhereUniqueInput!]
+}
+
+input OrderCreateWithoutUserInput {
+  total: Int!
+  charge: String!
+  items: ItemCreateManyInput
+}
+
+type OrderEdge {
+  node: Order!
+  cursor: String!
+}
+
+enum OrderOrderByInput {
+  id_ASC
+  id_DESC
+  total_ASC
+  total_DESC
+  charge_ASC
+  charge_DESC
+  updatedAt_ASC
+  updatedAt_DESC
+  createdAt_ASC
+  createdAt_DESC
+}
+
+type OrderPreviousValues {
+  id: ID!
+  total: Int!
+  charge: String!
+}
+
+type OrderSubscriptionPayload {
+  mutation: MutationType!
+  node: Order
+  updatedFields: [String!]
+  previousValues: OrderPreviousValues
+}
+
+input OrderSubscriptionWhereInput {
+  AND: [OrderSubscriptionWhereInput!]
+  OR: [OrderSubscriptionWhereInput!]
+  mutation_in: [MutationType!]
+  updatedFields_contains: String
+  updatedFields_contains_every: [String!]
+  updatedFields_contains_some: [String!]
+  node: OrderWhereInput
+}
+
+input OrderUpdateInput {
+  total: Int
+  charge: String
+  items: ItemUpdateManyInput
+  user: UserUpdateOneWithoutOrdersInput
+}
+
+input OrderUpdateManyWithoutUserInput {
+  create: [OrderCreateWithoutUserInput!]
+  connect: [OrderWhereUniqueInput!]
+  disconnect: [OrderWhereUniqueInput!]
+  delete: [OrderWhereUniqueInput!]
+  update: [OrderUpdateWithoutUserInput!]
+  upsert: [OrderUpsertWithoutUserInput!]
+}
+
+input OrderUpdateWithoutUserDataInput {
+  total: Int
+  charge: String
+  items: ItemUpdateManyInput
+}
+
+input OrderUpdateWithoutUserInput {
+  where: OrderWhereUniqueInput!
+  data: OrderUpdateWithoutUserDataInput!
+}
+
+input OrderUpsertWithoutUserInput {
+  where: OrderWhereUniqueInput!
+  update: OrderUpdateWithoutUserDataInput!
+  create: OrderCreateWithoutUserInput!
+}
+
+input OrderWhereInput {
+  AND: [OrderWhereInput!]
+  OR: [OrderWhereInput!]
+  id: ID
+  id_not: ID
+  id_in: [ID!]
+  id_not_in: [ID!]
+  id_lt: ID
+  id_lte: ID
+  id_gt: ID
+  id_gte: ID
+  id_contains: ID
+  id_not_contains: ID
+  id_starts_with: ID
+  id_not_starts_with: ID
+  id_ends_with: ID
+  id_not_ends_with: ID
+  total: Int
+  total_not: Int
+  total_in: [Int!]
+  total_not_in: [Int!]
+  total_lt: Int
+  total_lte: Int
+  total_gt: Int
+  total_gte: Int
+  charge: String
+  charge_not: String
+  charge_in: [String!]
+  charge_not_in: [String!]
+  charge_lt: String
+  charge_lte: String
+  charge_gt: String
+  charge_gte: String
+  charge_contains: String
+  charge_not_contains: String
+  charge_starts_with: String
+  charge_not_starts_with: String
+  charge_ends_with: String
+  charge_not_ends_with: String
+  items_every: ItemWhereInput
+  items_some: ItemWhereInput
+  items_none: ItemWhereInput
+  user: UserWhereInput
+}
+
+input OrderWhereUniqueInput {
+  id: ID
+}
+
 type PageInfo {
   hasNextPage: Boolean!
   hasPreviousPage: Boolean!
@@ -523,14 +748,17 @@ type Query {
   users(where: UserWhereInput, orderBy: UserOrderByInput, skip: Int, after: String, before: String, first: Int, last: Int): [User]!
   cartItems(where: CartItemWhereInput, orderBy: CartItemOrderByInput, skip: Int, after: String, before: String, first: Int, last: Int): [CartItem]!
   items(where: ItemWhereInput, orderBy: ItemOrderByInput, skip: Int, after: String, before: String, first: Int, last: Int): [Item]!
+  orders(where: OrderWhereInput, orderBy: OrderOrderByInput, skip: Int, after: String, before: String, first: Int, last: Int): [Order]!
   post(where: PostWhereUniqueInput!): Post
   user(where: UserWhereUniqueInput!): User
   cartItem(where: CartItemWhereUniqueInput!): CartItem
   item(where: ItemWhereUniqueInput!): Item
+  order(where: OrderWhereUniqueInput!): Order
   postsConnection(where: PostWhereInput, orderBy: PostOrderByInput, skip: Int, after: String, before: String, first: Int, last: Int): PostConnection!
   usersConnection(where: UserWhereInput, orderBy: UserOrderByInput, skip: Int, after: String, before: String, first: Int, last: Int): UserConnection!
   cartItemsConnection(where: CartItemWhereInput, orderBy: CartItemOrderByInput, skip: Int, after: String, before: String, first: Int, last: Int): CartItemConnection!
   itemsConnection(where: ItemWhereInput, orderBy: ItemOrderByInput, skip: Int, after: String, before: String, first: Int, last: Int): ItemConnection!
+  ordersConnection(where: OrderWhereInput, orderBy: OrderOrderByInput, skip: Int, after: String, before: String, first: Int, last: Int): OrderConnection!
   node(id: ID!): Node
 }
 
@@ -539,6 +767,7 @@ type Subscription {
   user(where: UserSubscriptionWhereInput): UserSubscriptionPayload
   cartItem(where: CartItemSubscriptionWhereInput): CartItemSubscriptionPayload
   item(where: ItemSubscriptionWhereInput): ItemSubscriptionPayload
+  order(where: OrderSubscriptionWhereInput): OrderSubscriptionPayload
 }
 
 type UserConnection {
@@ -556,7 +785,18 @@ input UserCreateInput {
   resetToken: String
   resetTokenExpiry: String
   posts: PostCreateManyWithoutAuthorInput
-  cart: CartItemCreateManyInput
+  orders: OrderCreateManyWithoutUserInput
+  cart: CartItemCreateManyWithoutUserInput
+}
+
+input UserCreateOneWithoutCartInput {
+  create: UserCreateWithoutCartInput
+  connect: UserWhereUniqueInput
+}
+
+input UserCreateOneWithoutOrdersInput {
+  create: UserCreateWithoutOrdersInput
+  connect: UserWhereUniqueInput
 }
 
 input UserCreateOneWithoutPostsInput {
@@ -564,6 +804,30 @@ input UserCreateOneWithoutPostsInput {
   connect: UserWhereUniqueInput
 }
 
+input UserCreateWithoutCartInput {
+  email: String!
+  password: String!
+  name: String!
+  website: String
+  age: Int
+  resetToken: String
+  resetTokenExpiry: String
+  posts: PostCreateManyWithoutAuthorInput
+  orders: OrderCreateManyWithoutUserInput
+}
+
+input UserCreateWithoutOrdersInput {
+  email: String!
+  password: String!
+  name: String!
+  website: String
+  age: Int
+  resetToken: String
+  resetTokenExpiry: String
+  posts: PostCreateManyWithoutAuthorInput
+  cart: CartItemCreateManyWithoutUserInput
+}
+
 input UserCreateWithoutPostsInput {
   email: String!
   password: String!
@@ -572,7 +836,8 @@ input UserCreateWithoutPostsInput {
   age: Int
   resetToken: String
   resetTokenExpiry: String
-  cart: CartItemCreateManyInput
+  orders: OrderCreateManyWithoutUserInput
+  cart: CartItemCreateManyWithoutUserInput
 }
 
 type UserEdge {
@@ -640,7 +905,26 @@ input UserUpdateInput {
   resetToken: String
   resetTokenExpiry: String
   posts: PostUpdateManyWithoutAuthorInput
-  cart: CartItemUpdateManyInput
+  orders: OrderUpdateManyWithoutUserInput
+  cart: CartItemUpdateManyWithoutUserInput
+}
+
+input UserUpdateOneWithoutCartInput {
+  create: UserCreateWithoutCartInput
+  connect: UserWhereUniqueInput
+  disconnect: UserWhereUniqueInput
+  delete: UserWhereUniqueInput
+  update: UserUpdateWithoutCartInput
+  upsert: UserUpsertWithoutCartInput
+}
+
+input UserUpdateOneWithoutOrdersInput {
+  create: UserCreateWithoutOrdersInput
+  connect: UserWhereUniqueInput
+  disconnect: UserWhereUniqueInput
+  delete: UserWhereUniqueInput
+  update: UserUpdateWithoutOrdersInput
+  upsert: UserUpsertWithoutOrdersInput
 }
 
 input UserUpdateOneWithoutPostsInput {
@@ -652,6 +936,40 @@ input UserUpdateOneWithoutPostsInput {
   upsert: UserUpsertWithoutPostsInput
 }
 
+input UserUpdateWithoutCartDataInput {
+  email: String
+  password: String
+  name: String
+  website: String
+  age: Int
+  resetToken: String
+  resetTokenExpiry: String
+  posts: PostUpdateManyWithoutAuthorInput
+  orders: OrderUpdateManyWithoutUserInput
+}
+
+input UserUpdateWithoutCartInput {
+  where: UserWhereUniqueInput!
+  data: UserUpdateWithoutCartDataInput!
+}
+
+input UserUpdateWithoutOrdersDataInput {
+  email: String
+  password: String
+  name: String
+  website: String
+  age: Int
+  resetToken: String
+  resetTokenExpiry: String
+  posts: PostUpdateManyWithoutAuthorInput
+  cart: CartItemUpdateManyWithoutUserInput
+}
+
+input UserUpdateWithoutOrdersInput {
+  where: UserWhereUniqueInput!
+  data: UserUpdateWithoutOrdersDataInput!
+}
+
 input UserUpdateWithoutPostsDataInput {
   email: String
   password: String
@@ -660,7 +978,8 @@ input UserUpdateWithoutPostsDataInput {
   age: Int
   resetToken: String
   resetTokenExpiry: String
-  cart: CartItemUpdateManyInput
+  orders: OrderUpdateManyWithoutUserInput
+  cart: CartItemUpdateManyWithoutUserInput
 }
 
 input UserUpdateWithoutPostsInput {
@@ -668,6 +987,18 @@ input UserUpdateWithoutPostsInput {
   data: UserUpdateWithoutPostsDataInput!
 }
 
+input UserUpsertWithoutCartInput {
+  where: UserWhereUniqueInput!
+  update: UserUpdateWithoutCartDataInput!
+  create: UserCreateWithoutCartInput!
+}
+
+input UserUpsertWithoutOrdersInput {
+  where: UserWhereUniqueInput!
+  update: UserUpdateWithoutOrdersDataInput!
+  create: UserCreateWithoutOrdersInput!
+}
+
 input UserUpsertWithoutPostsInput {
   where: UserWhereUniqueInput!
   update: UserUpdateWithoutPostsDataInput!
@@ -786,6 +1117,9 @@ input UserWhereInput {
   posts_every: PostWhereInput
   posts_some: PostWhereInput
   posts_none: PostWhereInput
+  orders_every: OrderWhereInput
+  orders_some: OrderWhereInput
+  orders_none: OrderWhereInput
   cart_every: CartItemWhereInput
   cart_some: CartItemWhereInput
   cart_none: CartItemWhereInput
diff --git a/backend/src/index.js b/backend/src/index.js
index 359456f..22cc9ef 100644
--- a/backend/src/index.js
+++ b/backend/src/index.js
@@ -19,7 +19,7 @@ const server = new GraphQLServer({
       typeDefs: 'src/generated/prisma.graphql',
       endpoint: process.env.PRISMA_ENDPOINT, // the endpoint of the Prisma DB service (value is set in .env)
       secret: process.env.PRISMA_SECRET, // taken from database/prisma.yml (value is set in .env)
-      debug: true, // log all GraphQL queries & mutations
+      debug: false, // log all GraphQL queries & mutations
     }),
   }),
 });
diff --git a/backend/src/resolvers/Mutation.js b/backend/src/resolvers/Mutation.js
index 003a563..1c071fe 100644
--- a/backend/src/resolvers/Mutation.js
+++ b/backend/src/resolvers/Mutation.js
@@ -5,6 +5,7 @@ const { getUserId, Context } = require('../utils');
 const { randomBytes } = require('crypto');
 const { promisify } = require('util');
 const mail = require('../mail');
+const stripe = require('../stripe');
 
 const mutations = {
   // Signup Mutations
@@ -39,6 +40,8 @@ const mutations = {
 
   // Creation of Post Mutations
   async createItem(parent, args, ctx, info) {
+    // TODO - they should be signed in when creating an item for sale
+    // TODO: The user should be saved to the item so they can manage it
     return ctx.db.mutation.createItem({ data: { ...args } }, info);
   },
 
@@ -202,52 +205,49 @@ const mutations = {
     Add to cart
   */
   async addToCart(parent, args, ctx, info) {
-    console.l('Add to cart calle');
+    console.l('Add to cart called');
     const userId = getUserId(ctx);
-    // get the current user
-    const currentUser = await ctx.db.query.user(
-      {
-        where: { id: userId },
-      },
-      '{ cart { id, quantity item { id } }}'
-    );
+    if (!userId) {
+      throw new Error('You must be signed in to add to cart!');
+    }
 
-    // find out if the user currently has this item in their cart
-    const existingCartItemIndex = currentUser.cart.findIndex(cartItem => cartItem.item.id === args.id);
+    // 1. Check if there is a CartItem for this user and item already
+    const [existingCartItem] = await ctx.db.query.cartItems({
+      where: {
+        user: { id: userId },
+        item: { id: args.id },
+      },
+    });
 
-    if (existingCartItemIndex >= 0) {
-      console.l('======This item already exists in the cart============');
-      const cartItem = currentUser.cart[existingCartItemIndex];
-      return ctx.db.mutation.updateCartItem({
-        where: { id: cartItem.id },
-        data: {
-          quantity: cartItem.quantity + 1,
+    if (existingCartItem) {
+      return ctx.db.mutation.updateCartItem(
+        {
+          where: { id: existingCartItem.id },
+          data: { quantity: existingCartItem.quantity + 1 },
         },
-      });
+        info
+      );
     }
 
-    const res = await ctx.db.mutation.updateUser({
-      where: { id: userId },
-      data: {
-        cart: {
-          create: [
-            {
-              item: {
-                connect: {
-                  id: args.id,
-                },
-              },
-              quantity: 1,
+    // Otherwise create a new cartItem
+    return ctx.db.mutation.createCartItem(
+      {
+        data: {
+          user: {
+            connect: {
+              id: userId,
             },
-          ],
+          },
+          item: {
+            connect: { id: args.id },
+          },
         },
       },
-    });
-    console.log(res);
-    // return res;
+      info
+    );
   },
+  // delete that cart item
   async removeFromCart(parent, args, ctx, info) {
-    // delete that cart item
     return ctx.db.mutation.deleteCartItem({
       where: { id: args.id },
     });
@@ -260,6 +260,57 @@ const mutations = {
     // console.log(cartItem);
     // return cartItem;
   },
+  async createOrder(parent, args, ctx, info) {
+    const userId = getUserId(ctx);
+    const user = await ctx.db.query.user(
+      { where: { id: userId } },
+      '{ id, name, email, cart { id, quantity, item { price, id } }}'
+    );
+    console.log('-------USER-----');
+    console.log(user);
+    console.log('-------USER-----');
+    // 1. Recalculate the total for the price
+    const amount = user.cart.reduce((tally, cartItem) => tally + cartItem.item.price * cartItem.quantity, 0);
+    // TODO Error Handling
+    // 2.1 Create a Stripe Customer
+    const customer = await stripe.customers.create({
+      email: user.email,
+    });
+    console.log(customer);
+    // 2.3 Charge the stripe token
+    const charge = await stripe.charges.create({
+      amount,
+      currency: 'usd',
+      source: args.token,
+    });
+
+    // Save this order to the database
+    const items = user.cart.map(cartItem => ({ id: cartItem.item.id }));
+    console.l('---Gonna connect these items: ----');
+    console.log(items);
+    console.l('---Gonna connect these items: ----');
+    const order = await ctx.db.mutation.createOrder({
+      data: {
+        total: charge.amount,
+        charge: charge.id,
+        items: {
+          connect: items,
+        },
+        user: {
+          connect: {
+            id: user.id,
+          },
+        },
+      },
+    });
+    console.l('--------ORDER-------------');
+    console.log(order);
+    console.l('--------ORDER-------------');
+    return order;
+    // 4. Send an email with their order
+    // 5. Send the order back
+    // 6. Clean up, clear the users cart adn send back { user, order }
+  },
 };
 
 module.exports = mutations;
diff --git a/backend/src/resolvers/Query.js b/backend/src/resolvers/Query.js
index e6ea299..8649e43 100644
--- a/backend/src/resolvers/Query.js
+++ b/backend/src/resolvers/Query.js
@@ -31,6 +31,7 @@ const Query = {
   },
 
   me(parent, args, ctx, info) {
+    console.l('me!');
     const Authorization = ctx.request.get('Authorization');
     if (!Authorization || Authorization === 'null') {
       console.log('Authorization is null');
@@ -39,6 +40,12 @@ const Query = {
     const id = getUserId(ctx);
     return ctx.db.query.user({ where: { id } }, info);
   },
+  async orders(parent, args, ctx, info) {
+    console.l('--------------------FETCHING ORDERS---------------------');
+    console.log(args);
+    return ctx.db.query.orders({}, info);
+    console.l('--------------------FETCHING ORDERS---------------------');
+  },
 };
 
 module.exports = Query;
diff --git a/backend/src/schema.graphql b/backend/src/schema.graphql
index b30b096..84844c6 100644
--- a/backend/src/schema.graphql
+++ b/backend/src/schema.graphql
@@ -1,4 +1,4 @@
-# import CartItem, ItemWhereInput, ItemOrderByInput, allItems, Post, Item, ItemCreateInput, ItemOrderByInput, ItemWhereInput from './generated/prisma.graphql'
+# import Order, CartItem, ItemWhereInput, ItemOrderByInput, allItems, Post, Item, ItemCreateInput, ItemOrderByInput, ItemWhereInput, Query.order, Query.orders from './generated/prisma.graphql'
 
 type Query {
   feed: [Post!]!
@@ -33,11 +33,12 @@ type Mutation {
   publish(id: ID!): Post!
   deletePost(id: ID!): Post!
   updatePost(id: ID!, title: String, text: String): Post!
-  createItem(title: String, description: String, price: Int): Item!
+  createItem(title: String, description: String, price: Int, image: String): Item!
   deleteItem(id: ID!): Item!
   updateItem(id: ID!, title: String, description: String, price: Int): Item!
   addToCart(id: ID!): CartItem
   removeFromCart(id: ID!): CartItem
+  createOrder(token: String!): Order!
 }
 
 type AuthPayload {
@@ -52,5 +53,6 @@ type User {
   name: String!
   posts: [Post!]!
   age: Int
+  orders: [Order!]!
   cart: [CartItem!]!
 }
diff --git a/backend/src/stripe.js b/backend/src/stripe.js
new file mode 100644
index 0000000..c6be8ca
--- /dev/null
+++ b/backend/src/stripe.js
@@ -0,0 +1 @@
+module.exports = require('stripe')(process.env.STRIPE_SECRET);