seed script

import { getRepository } from 'typeorm';

import { User } from './models/User';
import { Category } from './models/Category';
import { Bump } from './models/Bump';
import { Comment } from './models/Comment';
import { Friendship } from './models/Friendship';
import { FollowUser } from './models/FollowUser';
import { Place } from './models/Place';
import { Hashtag } from './models/Hashtag';
import { BumpHashtag } from './models/BumpHashtag';
import { BumpMedia } from './models/BumpMedia';
import { Activity } from './models/Activity';
import { PlaceActivity } from './models/PlaceActivity';
import { Reaction } from './models/Reaction';
import { ReactionType } from './models/ReactionType';

const UserRepository = () => getRepository(User);
const CategoryRepository = () => getRepository(Category);
const BumpRepository = () => getRepository(Bump);
const CommentRepository = () => getRepository(Comment);
const FollowUserRepository = () => getRepository(FollowUser);
const BumpMediaRepository = () => getRepository(BumpMedia);
const FriendshipRepository = () => getRepository(Friendship);
const PlaceRepository = () => getRepository(Place);
const HashtagRepository = () => getRepository(Hashtag);
const BumpHashtagRepository = () => getRepository(BumpHashtag);
const ActivityRepository = () => getRepository(Activity);
const PlaceActivityRepository = () => getRepository(PlaceActivity);
const ReactionTypeRepository = () => getRepository(ReactionType);

export const populate = async (): Promise<any> => {
  try {
    const user1 = {
      id: 1,
      name: 'Brad Pit',
      level: null,
      countryCode: '234',
      phoneNumber: '12345',
      cognitoId: 1,
      profileImgUrl:
        'https://i.pinimg.com/736x/f7/bd/a4/f7bda45258b9fcb16e181e3e4a792a51--best-batman-costume-batman-costumes.jpg',
      avatarImgUrl:
        'https://i0.wp.com/www.reliableroofingphilly.com/wp-content/uploads/2015/04/male-placeholder-image.png',
      email: 'user@email.com',
    };

    const user2 = {
      id: 2,
      name: 'Cornor Kings',
      level: null,
      countryCode: '235',
      phoneNumber: '12346',
      cognitoId: 2,
      profileImgUrl:
        'https://images-na.ssl-images-amazon.com/images/I/41KJTbe8waL._SX425_.jpg',
      avatarImgUrl:
        'https://i0.wp.com/www.reliableroofingphilly.com/wp-content/uploads/2015/04/male-placeholder-image.png',
      email: 'user2@email.com',
    };

    const user3 = {
      id: 3,
      name: 'Ray Jay',
      level: null,
      countryCode: '236',
      phoneNumber: '12347',
      cognitoId: 3,
      profileImgUrl:
        'https://images-na.ssl-images-amazon.com/images/I/41KJTbe8waL._SX425_.jpg',
      avatarImgUrl:
        'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTODqAdWu3uKChb1fbN27_p_9ey61G4ZiE7b1FL2owTPRvy2cPo',
      email: 'user3@email.com',
    };

    const user4 = {
      id: 4,
      name: 'User4',
      level: null,
      countryCode: '237',
      phoneNumber: '12348',
      cognitoId: 4,
      profileImgUrl: null,
      avatarImgUrl: null,
      email: 'user4@email.com',
    };

    const category1: Category = {
      id: 1,
      parentCategoryId: 1,
      name: 'Cat1',
      imageUrl: null,
      kols: [],
    };

    const category2: Category = {
      id: 2,
      parentCategoryId: 1,
      name: 'Cat2',
      imageUrl: null,
      kols: [],
    };

    await CategoryRepository()
      .createQueryBuilder('category')
      .insert()
      .into(Category)
      .values([category1, category2])
      .execute();

    const categories = await CategoryRepository()
      .createQueryBuilder('category')
      .getMany();

    const place1 = {
      id: 1,
      name: 'Maryland',
      latitude: '0.5471811',
      longitude: '-76.1319953',
      locationHierarchy: null,
    };

    const place2 = {
      id: 2,
      name: 'Maryland',
      latitude: '51.463',
      longitude: '-0.112',
      locationHierarchy: null,
    };

    await PlaceRepository()
      .createQueryBuilder('place')
      .insert()
      .into(Place)
      .values([place1, place2])
      .execute();

    const places = await PlaceRepository()
      .createQueryBuilder('place')
      .getMany();

    const friendship1 = {
      id: 1,
      friendshipType: 'FOLLOW',
      requesterId: user1.id,
      followedUserId: user2.id,
    };

    const friendship2 = {
      id: 2,
      friendshipType: 'FOLLOW',
      requesterId: 1,
      followedUserId: 3,
    };

    const friendship3 = {
      friendshipType: 'FOLLOW',
      requesterId: 1,
      followedUserId: 4,
    };

    console.log(`Populating db...`);

    console.log('creating users..');
    await UserRepository()
      .createQueryBuilder('user')
      .insert()
      .into(User)
      .values([user1])
      .execute();

    await UserRepository()
      .createQueryBuilder('user')
      .insert()
      .into(User)
      .values([user2])
      .execute();

    await UserRepository()
      .createQueryBuilder('user')
      .insert()
      .into(User)
      .values([user3])
      .execute();

    const users = await UserRepository()
      .createQueryBuilder('user')
      .getMany();

    const bump1 = {
      id: 1,
      user: users[0],
      name: 'Simon dune',
      text: 'Must go to place.',
      createdDateTime: new Date(),
      latitude: '22.28522212',
      longitude: '114.15736256',
      rank: 100,
      place: places[1],
      category: categories[0],
      profileImgUrl:
        'https://www.tasteofhome.com/wp-content/uploads/2017/10/exps28800_UG143377D12_18_1b_RMS-696x696.jpg',
    };

    const bump2 = {
      id: 2,
      name: 'Henryetta Fairlie',
      text: `Best food ever`,
      createdDateTime: new Date(),
      latitude: '22.28648027',
      longitude: '114.16194046',
      user: users[1],
      category: categories[0],
      place: places[0],
      profileImgUrl:
        'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQiO1--Zl36o8BsQ-Pkj5vtqTMRfBdytnirl0ZByTjJOfwAqe4A',
    };

    const bump3 = {
      id: 3,
      user: users[1],
      name: 'Richard Gary',
      text: 'This is the best place to visit.',
      createdDateTime: new Date(),
      placeId: null,
      latitude: '22.285159',
      longitude: '114.158841',
      rank: 300,
      place: places[1],
      category: categories[0],
      profileImgUrl:
        'https://www.tasteofhome.com/wp-content/uploads/2017/10/exps28800_UG143377D12_18_1b_RMS-696x696.jpg',
    };

    const bump4 = {
      id: 4,
      name: 'Malissia Rebillard',
      user: users[1],
      text: 'We get positive vibes here.',
      createdDateTime: new Date(),
      latitude: '22.28670131',
      longitude: '114.16105491',
      placeId: null,
      category: categories[1],
      place: places[0],
      profileImgUrl:
        'https://cstoredecisions.com/wp-content/uploads/2018/09/Salty-Snacks-696x464.jpg',
    };

    const bump5 = {
      id: 5,
      name: 'Anthe Gionettitti',
      user: users[1],
      text: 'Great place for great food.',
      createdDateTime: new Date(),
      latitude: '22.28363197',
      longitude: '114.15716307',
      category: categories[1],
      place: places[1],
      profileImgUrl:
        'https://www.tasteofhome.com/wp-content/uploads/2017/10/exps28800_UG143377D12_18_1b_RMS-696x696.jpg',
    };

    const bump6 = {
      id: 6,
      name: 'Dru Drought',
      user: users[2],
      text: 'Fabulous pleace to have lunch',
      createdDateTime: new Date(),
      latitude: '22.28325472',
      longitude: '114.15855782',
      category: categories[1],
      place: places[0],
      profileImgUrl:
        'https://cstoredecisions.com/wp-content/uploads/2018/09/Salty-Snacks-696x464.jpg',
    };

    const bump7 = {
      id: 7,
      name: 'Manon Canwell',
      user: users[2],
      text: 'Best place to have dinner date',
      createdDateTime: new Date(),
      latitude: '22.28527907',
      longitude: '114.15507197',
      category: categories[1],
      place: places[1],
      profileImgUrl:
        'https://cstoredecisions.com/wp-content/uploads/2018/09/Salty-Snacks-696x464.jpg',
    };

    const bump8 = {
      id: 8,
      name: 'Chris Cheung',
      user: users[2],
      text: 'Timeless fashion',
      createdDateTime: new Date(),
      latitude: '22.28382469',
      longitude: '114.15471792',
      category: categories[0],
      place: places[1],
      profileImgUrl:
        'https://cstoredecisions.com/wp-content/uploads/2018/09/Salty-Snacks-696x464.jpg',
    };

    const bump9 = {
      id: 9,
      name: 'Chris Cheung',
      user: users[2],
      text: 'Timeless rabbits',
      createdDateTime: new Date(),
      latitude: '22.2826472',
      longitude: '114.15584024',
      category: categories[0],
      place: places[1],
      profileImgUrl:
        'https://cstoredecisions.com/wp-content/uploads/2018/09/Salty-Snacks-696x464.jpg',
    };

    const bump10 = {
      id: 10,
      name: 'Chris Cheung',
      user: users[2],
      text: 'Timeless penguins',
      createdDateTime: new Date(),
      latitude: '22.28613517',
      longitude: '114.15357178',
      category: categories[1],
      place: places[0],
      profileImgUrl:
        'https://cstoredecisions.com/wp-content/uploads/2018/09/Salty-Snacks-696x464.jpg',
    };

    const bump11 = {
      id: 11,
      name: 'Chris Cheung',
      user: users[2],
      text: 'Timeless squirrels',
      createdDateTime: new Date(),
      latitude: '22.283607190928965',
      longitude: '114.16058853608373',
      category: categories[1],
      place: places[0],
      profileImgUrl:
        'https://cstoredecisions.com/wp-content/uploads/2018/09/Salty-Snacks-696x464.jpg',
    };

    const bump12 = {
      id: 12,
      name: 'Chris Cheung',
      user: users[2],
      text: 'Timeless racoons',
      createdDateTime: new Date(),
      latitude: '22.2837',
      longitude: '114.1604',
      category: categories[0],
      place: places[0],
      profileImgUrl:
        'https://cstoredecisions.com/wp-content/uploads/2018/09/Salty-Snacks-696x464.jpg',
    };

    const bump13 = {
      id: 13,
      name: 'Chris Cheung',
      user: users[2],
      text: 'Timeless dinos',
      createdDateTime: new Date(),
      latitude: '22.2845',
      longitude: '114.161',
      category: categories[0],
      place: places[0],
      profileImgUrl:
        'https://cstoredecisions.com/wp-content/uploads/2018/09/Salty-Snacks-696x464.jpg',
    };

    const bump14 = {
      id: 14,
      name: 'Chris Cheung',
      user: users[2],
      text: 'Timeless pandas',
      createdDateTime: new Date(),
      latitude: '22.282',
      longitude: '114.159',
      category: categories[1],
      place: places[1],
      profileImgUrl:
        'https://cstoredecisions.com/wp-content/uploads/2018/09/Salty-Snacks-696x464.jpg',
    };

    const bump15 = {
      id: 15,
      name: 'Chris Cheung',
      user: users[2],
      text: 'Timeless kangaroos',
      createdDateTime: new Date(),
      latitude: '22.287',
      longitude: '114.162',
      category: categories[1],
      place: places[1],
      profileImgUrl:
        'https://cstoredecisions.com/wp-content/uploads/2018/09/Salty-Snacks-696x464.jpg',
    };

    // console.log('creating categories..');
    // await CategoryRepository()
    //   .createQueryBuilder('category')
    //   .insert()
    //   .into(Category)
    //   .values([category1, category2])
    //   .execute();

    console.log('creating bump..');
    await BumpRepository()
      .createQueryBuilder('bump')
      .insert()
      .into(Bump)
      .values([bump1])
      .execute();

    await BumpRepository()
      .createQueryBuilder('bump')
      .insert()
      .into(Bump)
      .values([bump2])
      .execute();

    await BumpRepository()
      .createQueryBuilder('bump')
      .insert()
      .into(Bump)
      .values([bump3])
      .execute();

    await BumpRepository()
      .createQueryBuilder('bump')
      .insert()
      .into(Bump)
      .values([bump4])
      .execute();

    await BumpRepository()
      .createQueryBuilder('bump')
      .insert()
      .into(Bump)
      .values([bump5])
      .execute();

    await BumpRepository()
      .createQueryBuilder('bump')
      .insert()
      .into(Bump)
      .values([bump6])
      .execute();

    await BumpRepository()
      .createQueryBuilder('bump')
      .insert()
      .into(Bump)
      .values([bump7])
      .execute();

    await BumpRepository()
      .createQueryBuilder('bump')
      .insert()
      .into(Bump)
      .values([bump8])
      .execute();

    await BumpRepository()
      .createQueryBuilder('bump')
      .insert()
      .into(Bump)
      .values([bump9])
      .execute();

    await BumpRepository()
      .createQueryBuilder('bump')
      .insert()
      .into(Bump)
      .values([bump10])
      .execute();

    await BumpRepository()
      .createQueryBuilder('bump')
      .insert()
      .into(Bump)
      .values([bump11])
      .execute();

    await BumpRepository()
      .createQueryBuilder('bump')
      .insert()
      .into(Bump)
      .values([bump12])
      .execute();

    await BumpRepository()
      .createQueryBuilder('bump')
      .insert()
      .into(Bump)
      .values([bump13])
      .execute();

    await BumpRepository()
      .createQueryBuilder('bump')
      .insert()
      .into(Bump)
      .values([bump14])
      .execute();

    await BumpRepository()
      .createQueryBuilder('bump')
      .insert()
      .into(Bump)
      .values([bump15])
      .execute();

    const followUser1 = {
      id: 1,
      followsUser: users[1],
      user: users[0],
    };

    const followUser2 = {
      id: 2,
      followsUser: users[2],
      user: users[0],
    };

    const bumps: any = await BumpRepository()
      .createQueryBuilder('bump')
      .getMany();

    const comment1 = {
      id: 1,
      user: users[1],
      bump: bumps[0],
      comment: 'You have got to love it here',
    };

    const comment2 = {
      id: 2,
      user: users[0],
      bump: bumps[1],
      comment: 'Great customer service and zero waiting time.',
    };

    const comment3 = {
      id: 3,
      user: users[1],
      bump: bumps[0],
      comment: 'They have great chicken wings.',
    };

    const comment4 = {
      id: 4,
      user: users[2],
      bump: bumps[1],
      comment: 'You should try their parfait, awesome!',
    };

    const comment5 = {
      id: 5,
      user: users[1],
      bump: bumps[2],
      comment: "This place sucks, i'm never going back again",
    };

    const comment6 = {
      id: 6,
      user: users[1],
      bump: bumps[3],
      comment: 'I think they should improve their customer service.',
    };

    const comment7 = {
      id: 7,
      user: users[2],
      bump: bumps[4],
      comment: "It'd be nice if they had a kid's menu",
    };

    console.log('creating comment..');
    await CommentRepository()
      .createQueryBuilder('comment')
      .insert()
      .into(Comment)
      .values([
        comment1,
        comment2,
        comment3,
        comment4,
        comment5,
        comment6,
        comment7,
      ])
      .execute();

    const activity1 = {
      id: 1,
      name: 'Chilling',
      activityImgUrl: 'https://picsum.photos/200/300/?random',
    };

    const activity2 = {
      id: 2,
      name: 'Partying',
      activityImgUrl: 'https://picsum.photos/200/300/?random',
    };

    const activity3 = {
      id: 3,
      name: 'Shopping',
      activityImgUrl: 'https://picsum.photos/200/300/?random',
    };

    await ActivityRepository()
      .createQueryBuilder('activity')
      .insert()
      .into(Activity)
      .values([activity1, activity2, activity3])
      .execute();

    const activities = await ActivityRepository()
      .createQueryBuilder('activities')
      .getMany();

    const placeActivity1 = {
      id: 1,
      activity: activities[0],
      bump: bumps[0],
    };

    const placeActivity2 = {
      id: 2,
      activity: activities[0],
      bump: bumps[1],
    };

    const placeActivity3 = {
      id: 3,
      activity: activities[3],
      bump: bumps[3],
    };

    const placeActivity4 = {
      id: 4,
      activity: activities[1],
      bump: bumps[2],
    };

    await PlaceActivityRepository()
      .createQueryBuilder('placeactivity')
      .insert()
      .into(PlaceActivity)
      .values([placeActivity1, placeActivity2, placeActivity3, placeActivity4])
      .execute();

    const bumpMedia1 = {
      bump: bumps[0],
      url:
        'https://s3-ap-southeast-1.amazonaws.com/bumppub/HongkongDisneyland1_x512.png',
    };

    const bumpMedia2 = {
      bump: bumps[1],
      url:
        'https://s3-ap-southeast-1.amazonaws.com/bumppub/hong-kong-markets_banner.jpg',
    };

    const bumpMedia3 = {
      bump: bumps[2],
      url: 'https://s3-ap-southeast-1.amazonaws.com/bumppub/LKF_x512.png',
    };

    const bumpMedia4 = {
      bump: bumps[3],
      url: 'https://s3-ap-southeast-1.amazonaws.com/bumppub/glasses.jpg',
    };

    const bumpMedia5 = {
      bump: bumps[4],
      url: 'https://s3-ap-southeast-1.amazonaws.com/bumppub/grassy.png',
    };

    const bumpMedia6 = {
      bump: bumps[5],
      url:
        'https://s3-ap-southeast-1.amazonaws.com/bumppub/sam-s-tailor-custom-suits.jpg',
    };

    const bumpMedia7 = {
      bump: bumps[6],
      url: 'https://s3-ap-southeast-1.amazonaws.com/bumppub/dimsum_x512.png',
    };

    const bumpMedia8 = {
      bump: bumps[7],
      url:
        'https://s3-ap-southeast-1.amazonaws.com/bumppub/starferryart_x512.png',
    };

    const bumpMedia9 = {
      bump: bumps[8],
      url:
        'https://s3-ap-southeast-1.amazonaws.com/bumppub/sweetsourpork_x512.png',
    };

    const bumpMedia10 = {
      bump: bumps[9],
      url: 'https://s3-ap-southeast-1.amazonaws.com/bumppub/bigbuddha_x512.png',
    };

    const bumpMedia11 = {
      bump: bumps[10],
      url: 'https://s3-ap-southeast-1.amazonaws.com/bumppub/shakeshack.jpg',
    };

    const bumpMedia12 = {
      bump: bumps[11],
      url: 'https://s3-ap-southeast-1.amazonaws.com/bumppub/puppy.png',
    };

    const bumpMedia13 = {
      bump: bumps[12],
      url:
        'https://s3-ap-southeast-1.amazonaws.com/bumppub/burger-emoji-png-1.png',
    };

    const bumpMedia14 = {
      bump: bumps[13],
      url:
        'https://s3-ap-southeast-1.amazonaws.com/bumppub/Pacific-Place-Jim-Lambie-2_x512.png',
    };

    const bumpMedia15 = {
      bump: bumps[14],
      url: 'https://s3-ap-southeast-1.amazonaws.com/bumppub/art1_x512.png',
    };

    console.log('creating Media..');
    await BumpMediaRepository()
      .createQueryBuilder('bumpMedia')
      .insert()
      .into(BumpMedia)
      .values([
        bumpMedia1,
        bumpMedia2,
        bumpMedia3,
        bumpMedia4,
        bumpMedia5,
        bumpMedia6,
        bumpMedia7,
        bumpMedia8,
        bumpMedia9,
        bumpMedia10,
        bumpMedia11,
        bumpMedia12,
        bumpMedia13,
        bumpMedia14,
        bumpMedia15,
      ])
      .execute();

    const bumpReactions = {
      id: 1,
      bump: bumps[0],
      user: users[1],
      // reactionType: reactionTypes[0]
    };
    console.log('creating followUser..');
    await FollowUserRepository()
      .createQueryBuilder('followUser')
      .insert()
      .into(FollowUser)
      .values([followUser1, followUser2])
      .execute();

    const Hashtag1 = {
      id: 1,
      tag: 'delicious',
    };

    const Hashtag2 = {
      id: 2,
      tag: 'coolspot',
    };

    const Hashtag3 = {
      id: 3,
      tag: 'chickenwings',
    };

    const Hashtag4 = {
      id: 4,
      tag: 'burgers',
    };

    const Hashtag5 = {
      id: 5,
      tag: 'churros',
    };

    console.log('creating hashtags');
    await HashtagRepository()
      .createQueryBuilder('hashtag')
      .insert()
      .into(Hashtag)
      .values([Hashtag1])
      .execute();

    await HashtagRepository()
      .createQueryBuilder('hashtag')
      .insert()
      .into(Hashtag)
      .values([Hashtag2])
      .execute();

    const hashtags = await HashtagRepository()
      .createQueryBuilder('hashtag')
      .getMany();

    const BumpHashtag1 = {
      id: 1,
      hashtag: hashtags[0],
      bump: bumps[0],
    };

    const BumpHashtag2 = {
      id: 2,
      hashtag: hashtags[0],
      bump: bumps[1],
    };

    const BumpHashtag3 = {
      id: 3,
      hashtag: hashtags[0],
      bump: bumps[2],
    };

    const BumpHashtag4 = {
      id: 4,
      hashtag: hashtags[1],
      bump: bumps[3],
    };

    const BumpHashtag5 = {
      id: 5,
      hashtag: hashtags[1],
      bump: bumps[4],
    };

    const BumpHashtag6 = {
      id: 6,
      hashtag: hashtags[1],
      bump: bumps[5],
    };

    console.log('creating bumphashtags');
    await BumpHashtagRepository()
      .createQueryBuilder('bumphashtag')
      .insert()
      .into(BumpHashtag)
      .values([
        BumpHashtag1,
        BumpHashtag2,
        BumpHashtag3,
        BumpHashtag4,
        BumpHashtag5,
        BumpHashtag6,
      ])
      .execute();

    // console.log('updating bump..');
    // await BumpRepository()
    //     .createQueryBuilder('bump')
    //     .update(Bump)
    //     .set({ text: "Timber" })
    //     .where("id = :id", { id: 1 })

    const reactionType1 = {
      id: 1,
      name: 'smile',
    };

    const reactionType2 = {
      id: 2,
      name: 'hate',
    };

    const reactionType3 = {
      id: 3,
      name: 'haha',
    };

    await ReactionTypeRepository()
      .createQueryBuilder('reactionType')
      .insert()
      .into(ReactionType)
      .values([reactionType1, reactionType2])
      .execute();

    console.log(`Data populated!`);

    return { success: true };
  } catch (err) {
    console.log(err);
    return Promise.reject(err.message);
  }
};