from dotenv import load_dotenv
load_dotenv()

from app import app, db
from app.models.models import (
    User, Calendar, Trip,
    Amenity, Necessity, Location, Review)

with app.app_context():
    db.drop_all()
    db.create_all()

    # 5 users
    # 26 locations
    # 31 reviews

    user1 = User(
        first_name='Tony',
        last_name='Stark',
        # password is 'password'
        hashed_password='pbkdf2:sha256:150000$7FTGE2c3$1ea0371496f82b298ae582f944120a614cb3e60974c4124bf7ef142fe6a1da90',
        email='theonlyone@stark.com',
        domicile_type='rv',
        phone_number='678-136-7092',
        user_info='I\'m a wealthy American business magnate, playboy, and ingenious scientist. I suffered a severe chest injury during a kidnapping but survived that and kicking @$$ now.',
        createdAt='2021-07-01'
    )

    user2 = User(
        first_name='Bruce',
        last_name='Wayne',
        # password is 'password'
        hashed_password='pbkdf2:sha256:150000$7FTGE2c3$1ea0371496f82b298ae582f944120a614cb3e60974c4124bf7ef142fe6a1da90',
        email='bruce@wayneenterprises.com',
        domicile_type='camper',
        phone_number='221-516-6944',
        user_info='My favorite song goes like: na na na na na na na na na na BATMAN!!!.',
        createdAt='2021-06-21'
    )

    user3 = User(
        first_name='Natasha',
        last_name='Romanoff',
        # password is 'password'
        hashed_password='pbkdf2:sha256:150000$7FTGE2c3$1ea0371496f82b298ae582f944120a614cb3e60974c4124bf7ef142fe6a1da90',
        email='black.widow@avengers.com',
        domicile_type='car',
        phone_number='484-841-6537',
        user_info='I love watching Lost In Translation in the rain.',
        createdAt='2021-05-14'
    )

    user4 = User(
        first_name='Elvis',
        last_name='Presley',
        # password is 'password'
        hashed_password='pbkdf2:sha256:150000$7FTGE2c3$1ea0371496f82b298ae582f944120a614cb3e60974c4124bf7ef142fe6a1da90',
        email='elvis@lives.com',
        domicile_type='car',
        phone_number='373-611-7335',
        user_info='I ain\'t nothin\' but a hound dog.',
        createdAt='2021-02-15'
    )

    demo_user = User(
        first_name='Demo',
        last_name='User',
        hashed_password='pbkdf2:sha256:150000$7FTGE2c3$1ea0371496f82b298ae582f944120a614cb3e60974c4124bf7ef142fe6a1da90',
        email="demo@email.com",
        domicile_type='car',
        phone_number='555-555-5555',
        user_info='I\'m a demo user...take a look around.',
        createdAt='2021-02-15'
    )

    location1_amenity = Amenity(
        electric_hookup=True,
        water_hookup=True,
        septic_hookup=False,
        assigned_parking=False,
        tow_vehicle_parking=True,
        trash_removal=False,
        water_front=True,
        pets_allowed=True,
        internet_access=False
    )

    location2_amenity = Amenity(
        electric_hookup=True,
        water_hookup=True,
        septic_hookup=False,
        assigned_parking=False,
        tow_vehicle_parking=False,
        trash_removal=True,
        water_front=False,
        pets_allowed=True,
        internet_access=True
    )

    location1_neces = Necessity(
        rv_compatible=True,
        generators_allowed=True,
        fires_allowed=True,
        max_days=2,
        pad_type='grass'
    )

    location2_neces = Necessity(
        rv_compatible=True,
        generators_allowed=True,
        fires_allowed=True,
        max_days=5,
        pad_type='dirt'
    )

    location1 = Location(
        address='10880 Malibu Point',
        city='Malibu',
        state='CA',
        gps_coords='34.000872,-118.806839',
        description='It overlooks the Pacific Ocean with an amazing view. It was once destroyed from a very unfortunate happening, but now rebuilt like it never happened. Might find some interesting things down the basement.',
        host_notes='Have fun and then get out. Also, don\'t touch things without permission.',
        image_urls=[
         "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fzibik-A6OHsnGYd18-unsplash.jpg?alt=media&token=664286fb-0285-41b0-8c8c-2ab511f17d09",
         "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fblake-wisz-TcgASSD5G04-unsplash.jpg?alt=media&token=3edb60be-b096-4c2f-87e9-68df6eec20a5"],
        title="Home away from home."
    )

    location2 = Location(
        address='25218 Eu St.',
        city='Banjarmasin',
        state='ZE',
        gps_coords='-3.66105, 144.52694',
        description='Has world class museums, and gardens. It has an well developed walkable river front on the edge of downtown where various events are held.',
        host_notes='I\'m sad, so sad',
        image_urls=[
          "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fbrooks-rice-8-jqqr-rpo0-unsplash.jpg?alt=media&token=4ffe2679-eaff-41ac-b890-bd585bb8573d",
          "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fcameron-vaughan-0AV7XLABuZk-unsplash.jpg?alt=media&token=a181c0d6-2426-4e31-8843-2c54473b8461"],
        title="Stay Happy Place"
    )

    location3 = Location(
        address='25218 Eu St.',
        city='Banjarmasin',
        state='WA',
        gps_coords='47.959, -120.539',
        description='Has world class museums, and gardens. It has an well developed walkable river front on the edge of downtown where various events are held.',
        host_notes='',
        image_urls=[
         "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fcameron-vaughan-0AV7XLABuZk-unsplash.jpg?alt=media&token=a181c0d6-2426-4e31-8843-2c54473b8461blake-wisz-TcgASSD5G04-unsplash.jpg",
         "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fdino-reichmuth-5Rhl-kSRydQ-unsplash.jpg?alt=media&token=907439e7-055f-46e4-9124-aa99d6b950f4"],
        title="Silver Falls Group Site"
    )

    location4 = Location(
        address='25218 Eu St.',
        city='Banjarmasin',
        state='WA',
        gps_coords='48.0937, -120.313',
        description='Has world class museums, and gardens. It has an well developed walkable river front on the edge of downtown where various events are held.',
        host_notes='',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fdino-reichmuth-pl1mhwMctJc-unsplash.jpg?alt=media&token=0a5b0aa0-1c89-4372-9731-cb1f765b3433",
             "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fdominik-jirovsky-re2LZOB2XvY-unsplash.jpg?alt=media&token=b456d772-c4cf-4f5b-b8eb-4a903e4928ba"],
        title="Okanogan-Wenatchee Forest"
    )

    location5 = Location(
        address='25218 Eu St.',
        city='Banjarmasin',
        state='WA',
        gps_coords='47.7586, -120.425',
        description='Has world class museums, and gardens. It has an well developed walkable river front on the edge of downtown where various events are held.',
        host_notes='',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fedho-fitrah-ELevCx8PX4o-unsplash.jpg?alt=media&token=34726190-865e-48c0-b5a6-2db7eb8b756c", 
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Feric-muhr-ZPsJW-OLZQM-unsplash.jpg?alt=media&token=b808f44d-1b63-4bf3-aa0b-43fc7d975d63"],
        title="Pine Flats Group Campground"
    )

    location6 = Location(
        address='25218 Eu St.',
        city='Banjarmasin',
        state='WA',
        gps_coords='48.02095, -120.641',
        description='Has world class museums, and gardens. It has an well developed walkable river front on the edge of downtown where various events are held.',
        host_notes='',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fjonathan-forage-1azAjl8FTnU-unsplash.jpg?alt=media&token=c91ee4c3-b653-4ece-9009-1c8433af9232",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fjosh-hild-8f_VQ3EFbTg-unsplash.jpg?alt=media&token=4910bf97-62c2-45cc-80aa-bf3e58049e93"],
        title="Cottonwood Cabin"
    )

    location7 = Location(
        address='25218 Eu St.',
        city='Banjarmasin',
        state='WA',
        gps_coords='47.896667, -120.698',
        description='Has world class museums, and gardens. It has an well developed walkable river front on the edge of downtown where various events are held.',
        host_notes='',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Flaura-pluth-RMicIhNOOIg-unsplash.jpg?alt=media&token=d81563cc-d6f3-44c5-9883-b350cc6ccbf9", 
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fmike-erskine-S_VbdMTsdiA-unsplash.jpg?alt=media&token=f9fc0db1-6ac8-4f18-acfc-130ec8ba4f4d"],
        title="Grouse Creek Group Site"
    )

    location8 = Location(
        address='25218 Eu St.',
        city='Banjarmasin',
        state='WA',
        gps_coords='47.799, -120.716',
        description='Has world class museums, and gardens. It has an well developed walkable river front on the edge of downtown where various events are held.',
        host_notes='',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fpatrick-hendry-euaPfbR6nC0-unsplash.jpg?alt=media&token=dcc8e005-dd14-4e87-a4ca-43ddbdb27d6d", 
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fscott-goodwill-y8Ngwq34_Ak-unsplash.jpg?alt=media&token=48d927cb-6de6-4e4b-b6a5-9f0de7873ea5"],
        title="Nason Creek Campground"
    )

    glacier_campground = Location(
        address='12070 US-2',
        city='West Glacier',
        state='MT',
        gps_coords='48.481785, -113.996492',
        description='Comfy camping area featuring rental cabins, a camp store, laundry facilities & a recreation room.',
        host_notes='Contact this property for rates and availability',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fglacier-1.png?alt=media&token=4f904f8b-1023-4a40-8102-7993a98d7430",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fglacier-2.png?alt=media&token=1c065441-c55c-4fa6-80e8-c5330e15bf51"],
        title="Glacier Campground"
    )

    glacier_campground_nec = Necessity(
        rv_compatible=True,
        generators_allowed=True,
        fires_allowed=False,
        max_days=5,
        pad_type='asphalt'
    )

    glacier_campground_amen = Amenity(
        electric_hookup=True,
        water_hookup=True,
        septic_hookup=True,
        assigned_parking=True,
        tow_vehicle_parking=True,
        trash_removal=True,
        water_front=True,
        pets_allowed=True,
        internet_access=True
    )

    glacier_campground.amenity = glacier_campground_amen
    glacier_campground.necessity = glacier_campground_nec
    glacier_campground.user = demo_user
    db.session.add(glacier_campground)

    glacier_review1 = Review(
        overall_rating=3,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments='Hosts were welcoming and generous. Their little spot in the heart of this upscale area of Portland gave me and Journey (my dog) a walkable neighborhood to enjoy. I also relished the porch chats with our hosts, which were full of local history and politics, and a long walking tour of the neighborhood.'
    )

    glacier_review2 = Review(
        overall_rating=5,
        noise=3,
        safety=3,
        cleanliness=4,
        access=3,
        site_quality=3,
        comments="We knew we would have fun, but it was beyond our expectations. Highly recommend!"
    )

    glacier_review3 = Review(
        overall_rating=5,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments='Hosts were welcoming and generous. Their little spot in the heart of this upscale area of Portland gave me and Journey (my dog) a walkable neighborhood to enjoy. I also relished the porch chats with our hosts, which were full of local history and politics, and a long walking tour of the neighborhood.'
    )

    glacier_review1.location = glacier_campground
    glacier_review1.user = user1
    glacier_review2.location = glacier_campground
    glacier_review2.user = user2
    glacier_review3.location = glacier_campground
    glacier_review3.user = user3

    stillwater = Location(
        address='8590 US-34',
        city='Granby',
        state='CO',
        gps_coords='40.179674, -105.888878',
        description='Comfy camping area featuring rental cabins, a camp store, laundry facilities & a recreation room.',
        host_notes='Great for kayaking and fishing!',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fstillwater1.png?alt=media&token=22313690-1647-4f6c-8ab2-9ae9e2c372a1",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fstillwater2.png?alt=media&token=bd6fbdc3-fdfe-407f-9c68-453c9f85de70", "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fstillwater3.png?alt=media&token=5c7e8b3b-67ad-4dd2-93c5-ee41b76deab9"],
        title="Stillwater RV and Campground"
    )

    stillwater_nec = Necessity(
        rv_compatible=True,
        generators_allowed=True,
        fires_allowed=True,
        max_days=5,
        pad_type='grass & dirt'
    )

    stillwater_amen = Amenity(
        electric_hookup=False,
        water_hookup=True,
        septic_hookup=True,
        assigned_parking=True,
        tow_vehicle_parking=False,
        trash_removal=False,
        water_front=True,
        pets_allowed=True,
        internet_access=False
    )

    stillwater.amenity = stillwater_amen
    stillwater.necessity = stillwater_nec
    stillwater.user = demo_user
    db.session.add(stillwater)

    stillwater_review1 = Review(
        overall_rating=5,
        noise=4,
        safety=4,
        cleanliness=4,
        access=3,
        site_quality=3,
        comments='WOW! We were initially drawn to the novelty of staying overnight in a tree house but left with an experience that touches the soul! Scott exceeded all expectations! His childlike enthusiasm for the tree house and Emerald Forest is truly infectious! You will find yourselves transported back to your youth. No expense was spared, nor detail overlooked. The "surprise" is truly magical and added an element that is indescribable! I now consider this the "8th Wonder of the World" and we cannot wait to go again!!!'
    )

    stillwater_review2 = Review(
        overall_rating=5,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments='10/10 recommend! Found it on tiktoc and we knew we had to go there! Did not disappoint!'
    )

    stillwater_review3 = Review(
        overall_rating=5,
        noise=4,
        safety=4,
        cleanliness=4,
        access=4,
        site_quality=4,
        comments="This place is an absolute must for couples. Its cosy, its got all the conveniences you need (which is really something when you're staying in a treehouse. The host and property manager are very responsive and go to great lengths to make sure you get privacy, and an immediate response if you need them. This place is a gem. Even though its rustic, don't assume technology is sparse - quite the opposite. I'm in IT and even I was amazed at what was there. It wasn't cheap ,but it was worth every penny. We're going back...."
    )

    stillwater_review4 = Review(
        overall_rating=5,
        noise=5,
        safety=5,
        cleanliness=5,
        access=5,
        site_quality=5,
        comments='Beautiful and outstanding place! Definitely recommend this stay!'
    )

    stillwater_review1.location = stillwater
    stillwater_review1.user = user1
    stillwater_review2.location = stillwater
    stillwater_review2.user = user2
    stillwater_review4.location = stillwater
    stillwater_review4.user = user3



    west_omaha = Location(
        address='14601 US-6',
        city='Gretna',
        state='NE',
        gps_coords='41.094690, -96.264102',
        description='We are happy to host you through the winter. Our nightly sites will be ELECTRIC ONLY from OCT 28th, 2020 through Apr 1, 2021. We are pleased to announce that as of 1/July/2020 we will be opening our pool and other amenities.',
        host_notes='Contact this property for rates and availability',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fwest_omaha1.png?alt=media&token=6602a9a6-46f1-4ac4-9c78-0e44ec4fe781",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fwest_omaha2.png?alt=media&token=3816ea43-19b3-44dc-a451-ac907dd172c4", "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fwest_omaha3.png?alt=media&token=600656f1-8623-43bf-bcab-a0f34c70cfdf"],
        title="West Omaha"
    )

    west_omaha_nec = Necessity(
        rv_compatible=True,
        generators_allowed=True,
        fires_allowed=True,
        max_days=5,
        pad_type='dirt'
    )

    west_omaha_amen = Amenity(
        electric_hookup=False,
        water_hookup=True,
        septic_hookup=True,
        assigned_parking=True,
        tow_vehicle_parking=False,
        trash_removal=False,
        water_front=True,
        pets_allowed=True,
        internet_access=True
    )

    west_omaha.amenity = west_omaha_amen
    west_omaha.necessity = west_omaha_nec
    west_omaha.user = demo_user
    db.session.add(west_omaha)

    west_omaha_review1 = Review(
        overall_rating=5,
        noise=4,
        safety=4,
        cleanliness=4,
        access=3,
        site_quality=3,
        comments='WOW! We were initially drawn to the novelty of staying overnight in a tree house but left with an experience that touches the soul! Scott exceeded all expectations! His childlike enthusiasm for the tree house and Emerald Forest is truly infectious! You will find yourselves transported back to your youth. No expense was spared, nor detail overlooked. The "surprise" is truly magical and added an element that is indescribable! I now consider this the "8th Wonder of the World" and we cannot wait to go again!!!'
    )

    west_omaha_review2 = Review(
        overall_rating=2,
        noise=2,
        safety=2,
        cleanliness=2,
        access=2,
        site_quality=2,
        comments='Was disappoint! Will not come back'
    )

    west_omaha_review3 = Review(
        overall_rating=3,
        noise=4,
        safety=4,
        cleanliness=4,
        access=4,
        site_quality=4,
        comments="Would not comeback"
    )

    west_omaha_review4 = Review(
        overall_rating=3,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments='Did not like it as much as i would have liked!'
    )

    west_omaha_review1.location =  west_omaha
    west_omaha_review1.user = user1
    west_omaha_review2.location =  west_omaha
    west_omaha_review2.user = user2
    west_omaha_review4.location =  west_omaha
    west_omaha_review4.user = user3



    pokegama = Location(
        address='34385 US-2',
        city='Grand Rapids',
        state='MN',
        gps_coords='47.249644, -93.583363',
        description='Mostly RV sites, minimal privacy, lake side with showers and a playground.',
        host_notes='Contact this property for rates and availability',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fpokegama1.png?alt=media&token=b9830c0c-491c-40fe-ba2f-d399b2375126",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fpokegama2.png?alt=media&token=e529f4ee-5d22-44d7-97e1-cefc31cdeca5"],
        title="Pokegama Dam Campground"
    )

    pokegama_nec = Necessity(
        rv_compatible=True,
        generators_allowed=False,
        fires_allowed=False,
        max_days=2,
        pad_type='grass'
    )

    pokegama_amen = Amenity(
        electric_hookup=False,
        water_hookup=False,
        septic_hookup=False,
        assigned_parking=True,
        tow_vehicle_parking=False,
        trash_removal=False,
        water_front=True,
        pets_allowed=True,
        internet_access=False
    )

    pokegama.amenity = pokegama_amen
    pokegama.necessity = pokegama_nec
    pokegama.user = demo_user
    db.session.add(pokegama)

    pokegama_review1 = Review(
        overall_rating=3,
        noise=4,
        safety=4,
        cleanliness=4,
        access=3,
        site_quality=3,
        comments="Not my favorite Place"
    )

    pokegama_review2 = Review(
        overall_rating=2,
        noise=2,
        safety=2,
        cleanliness=2,
        access=2,
        site_quality=2,
        comments='Was disappoint! Will not come back'
    )

    pokegama_review3 = Review(
        overall_rating=3,
        noise=4,
        safety=4,
        cleanliness=4,
        access=4,
        site_quality=4,
        comments="Would not comeback"
    )

    pokegama_review4 = Review(
        overall_rating=3,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments='Did not like it as much as i would have liked!'
    )

    pokegama_review1.location =  pokegama
    pokegama_review1.user = user1
    pokegama_review2.location =  pokegama
    pokegama_review2.user = user2
    pokegama_review3.location =  pokegama
    pokegama_review3.user = user3
    pokegama_review4.location =  pokegama
    pokegama_review4.user = user4

    fredericksburg = Location(
        address='5681 East US-290',
        city='Fredericksburg',
        state='TX',
        gps_coords='30.224618, -98.803147',
        description='Located in the heart of the Hill Country, this beautiful KOA is within a few short miles of the area\'s best attractions. Located in the heart of the Hill Country, this beautiful KOA is within a few short miles of the area\'s best attractions. Exclusive shopping, art galleries, elegant dining and the famous National Museum of the Pacific War await you in Fredericksburg. The town has been featured in national magazines for its historic architecture, German culture and heritage, and renowned festivals. Luckenbach, famous for its live country music, is 4 miles away. The Wildseed Farms and Fredericksburg Trade Days, a 350-vendor monthly flea market/collectibles shopping experience, are both within 2 miles.',
        host_notes='We have premium sites with plenty of space for picnics or walking the dogs.',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Ffredericksburg1.png?alt=media&token=ebd20416-880f-434e-83d5-884c4ddeed13",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Ffredericksburg2.png?alt=media&token=7b0546e6-399a-4d8f-8435-03cbb57ed70d"],
        title="Fredericksburg"
    )

    fredericksburg_nec = Necessity(
        rv_compatible=True,
        generators_allowed=False,
        fires_allowed=True,
        max_days=4,
        pad_type='grass & dirt'
    )

    fredericksburg_amen = Amenity(
        electric_hookup=False,
        water_hookup=True,
        septic_hookup=False,
        assigned_parking=True,
        tow_vehicle_parking=False,
        trash_removal=True,
        water_front=True,
        pets_allowed=True,
        internet_access=True
    )

    fredericksburg.amenity = fredericksburg_amen
    fredericksburg.necessity = fredericksburg_nec
    fredericksburg.user = demo_user
    db.session.add(fredericksburg)

    fredericksburg_review1 = Review(
        overall_rating=5,
        noise=3,
        safety=3,
        cleanliness=4,
        access=3,
        site_quality=3,
        comments="We knew we would have fun, but it was beyond our expectations. Highly recommend!"
    )

    fredericksburg_review2 = Review(
        overall_rating=5,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments='Hosts were welcoming and generous. Their little spot in the heart of this upscale area of Portland gave me and Journey (my dog) a walkable neighborhood to enjoy. I also relished the porch chats with our hosts, which were full of local history and politics, and a long walking tour of the neighborhood.'
    )

    fredericksburg_review3 = Review(
        overall_rating=4,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments="We had a great time. Pictures do not do this location justice! I highly recommend this to anybody. Thank you!"
    )

    fredericksburg_review1.location =  fredericksburg
    fredericksburg_review1.user = user1
    fredericksburg_review2.location =  fredericksburg
    fredericksburg_review2.user = user2
    fredericksburg_review3.location =  fredericksburg
    fredericksburg_review3.user = user3

    livingston = Location(
        address='15152 US Hwy 190 West',
        city='Onalaska',
        state='TX',
        gps_coords='30.812122, -95.128445',
        description='Welcome to the Lake Livingston/Onalaska KOA! Eddie, the local bald eagle, soars overhead here, and that\'s just one of the many delights at this KOA tucked away in the Piney Woods region of East Texas. The campground wraps along the shore of Lake Livingston, the state\'s second largest lake. It\'s an ideal setting for boating, swimming, fishing for bass and catfish, relaxing and even enjoying a lakefront RV Site. Lakefront amenities include the beautiful beach, a marina(with three ramps, covered slips, transient docks and a fishing pier), a hot tub and a pool. The club-house with a full kitchen is great for reunions, parties and rallies. Enjoy themed weekends(seasonal), planned activities and concessions. Fido will have fun at Kamp K9.',
        host_notes='Contact this property for rates and availability',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Flivingston1.png?alt=media&token=8d869a67-c313-4f63-aae0-a69666c36f83",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Flivingston2.png?alt=media&token=0939dc2b-23b3-4b31-a68a-b8b94951d7a2", "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Flivingston3.png?alt=media&token=3e5f5b33-1544-4a03-9f80-1165b23682ff"],
        title="Lake Livingston"
    )

    livingston_nec = Necessity(
        rv_compatible=True,
        generators_allowed=True,
        fires_allowed=True,
        max_days=4,
        pad_type='asphalt'
    )

    livingston_amen = Amenity(
        electric_hookup=True,
        water_hookup=True,
        septic_hookup=True,
        assigned_parking=True,
        tow_vehicle_parking=True,
        trash_removal=True,
        water_front=True,
        pets_allowed=True,
        internet_access=True
    )

    livingston.amenity = livingston_amen
    livingston.necessity = livingston_nec
    livingston.user = demo_user
    db.session.add(livingston)

    
    livingston_review1 = Review(
        overall_rating=5,
        noise=3,
        safety=3,
        cleanliness=4,
        access=3,
        site_quality=3,
        comments="We knew we would have fun, but it was beyond our expectations. Highly recommend!"
    )

    livingston_review2 = Review(
        overall_rating=5,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments='Hosts were welcoming and generous. Their little spot in the heart of this upscale area of Portland gave me and Journey (my dog) a walkable neighborhood to enjoy. I also relished the porch chats with our hosts, which were full of local history and politics, and a long walking tour of the neighborhood.'
    )

    livingston_review3 = Review(
        overall_rating=4,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments="We had a great time. Pictures do not do this location justice! I highly recommend this to anybody. Thank you!"
    )

    livingston_review1.location =  livingston
    livingston_review1.user = user1
    livingston_review2.location =  livingston
    livingston_review2.user = user2
    livingston_review3.location =  livingston
    livingston_review3.user = user3

    zephyr = Location(
        address='760 US-50',
        city='Zephyr Cove',
        state='NV',
        gps_coords='39.006345, -1119.946524',
        description="Zephyr Cove RV and Campground is just a short walk from the Zephyr Cove Restaurant, Zephyr Cove Resort, beach access, the M.S. Dixie ll paddlewheeler, marina activities, horseback riding, and general store. Whether you're pitching a tent or enjoying the comfort of your RV, you'll love this family-friendly destination",
        host_notes='Contact this property for rates and availability',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fzephyr1.png?alt=media&token=95b6500b-3980-4a21-85f1-b3863bfcc4ad",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fzephyr2.png?alt=media&token=0653a8bc-ed3f-475b-8cdd-fb464c5f0dd4", "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fzephyr3.png?alt=media&token=af62b4d2-2583-42e9-a6f5-c8b8465bec41"],
        title="Zephyr Cove"
    )

    zephyr_nec = Necessity(
        rv_compatible=True,
        generators_allowed=True,
        fires_allowed=True,
        max_days=4,
        pad_type='dirt'
    )

    zephyr_amen = Amenity(
        electric_hookup=False,
        water_hookup=True,
        septic_hookup=False,
        assigned_parking=True,
        tow_vehicle_parking=False,
        trash_removal=True,
        water_front=True,
        pets_allowed=True,
        internet_access=False
    )

    zephyr.amenity = zephyr_amen
    zephyr.necessity = zephyr_nec
    zephyr.user = demo_user
    db.session.add(zephyr)

       
    zephyr_review1 = Review(
        overall_rating=5,
        noise=3,
        safety=3,
        cleanliness=4,
        access=3,
        site_quality=3,
        comments="We knew we would have fun, but it was beyond our expectations. Highly recommend!"
    )

    zephyr_review2 = Review(
        overall_rating=5,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments='Hosts were welcoming and generous. Their little spot in the heart of this upscale area of Portland gave me and Journey (my dog) a walkable neighborhood to enjoy. I also relished the porch chats with our hosts, which were full of local history and politics, and a long walking tour of the neighborhood.'
    )

    zephyr_review3 = Review(
        overall_rating=4,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments="We had a great time. Pictures do not do this location justice! I highly recommend this to anybody. Thank you!"
    )

    zephyr_review1.location =  zephyr
    zephyr_review1.user = user1
    zephyr_review2.location =  zephyr
    zephyr_review2.user = user2
    zephyr_review3.location =  zephyr
    zephyr_review3.user = user3

    

    wapiti = Location(
        address='2225 US-14',
        city='Cody',
        state='WY',
        gps_coords='53.833815, -118.061969',
        description="Wapiti Campground hosts 41 campsites on the North Fork of the Shoshone River, next to the historic Wapiti Ranger Station",
        host_notes='Contact this property for rates and availability',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fwapiti1.png?alt=media&token=6d0861df-d267-4be2-860c-b874012b1a42",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fwapiti2.png?alt=media&token=566e7aea-d1da-4e7c-8481-2fd0b99dce4d", "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fwapiti3.png?alt=media&token=4e281818-251c-4959-b8d7-19980b24ed78"],
        title="Wapiti Campground"
    )

    wapiti_nec = Necessity(
        rv_compatible=True,
        generators_allowed=False,
        fires_allowed=False,
        max_days=5,
        pad_type='grass & dirt'
    )

    wapiti_amen = Amenity(
        electric_hookup=False,
        water_hookup=False,
        septic_hookup=False,
        assigned_parking=True,
        tow_vehicle_parking=True,
        trash_removal=False,
        water_front=True,
        pets_allowed=True,
        internet_access=False
    )

    wapiti.amenity = wapiti_amen
    wapiti.necessity = wapiti_nec
    wapiti.user = user1
    db.session.add(wapiti)

    wapiti_review1 = Review(
        overall_rating=5,
        noise=3,
        safety=3,
        cleanliness=4,
        access=3,
        site_quality=3,
        comments="We knew we would have fun, but it was beyond our expectations. Highly recommend!"
    )

    wapiti_review2 = Review(
        overall_rating=5,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments='Hosts were welcoming and generous. Their little spot in the heart of this upscale area of Portland gave me and Journey (my dog) a walkable neighborhood to enjoy. I also relished the porch chats with our hosts, which were full of local history and politics, and a long walking tour of the neighborhood.'
    )

    wapiti_review3 = Review(
        overall_rating=4,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments="We had a great time. Pictures do not do this location justice! I highly recommend this to anybody. Thank you!"
    )

    wapiti_review1.location =  wapiti
    wapiti_review1.user = user1
    wapiti_review2.location =  wapiti
    wapiti_review2.user = user2
    wapiti_review3.location =  wapiti
    wapiti_review3.user = user3

    falls = Location(
        address='U.S. 26',
        city='Irwin',
        state='ID',
        gps_coords='43.432695, -111.362554',
        description="Falls Campground is located next to the Snake River in beautiful Swan Valley at an elevation of 5,100 feet.",
        host_notes='Contact this property for rates and availability',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Ffalls1.png?alt=media&token=8a10e4a9-3647-4313-aaf3-4ab7fac9b927",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Ffalls2.png?alt=media&token=7054b898-f66f-4a06-be53-1165bff50d7b", 
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Ffalls3.png?alt=media&token=bc6b138c-94e9-4faa-b34a-b13df70158f2",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Ffalls4.png?alt=media&token=52b4ce5b-914e-4e8b-a606-762aaf113890", ],
        title="Falls Campground"
    )

    falls_nec = Necessity(
        rv_compatible=True,
        generators_allowed=True,
        fires_allowed=True,
        max_days=4,
        pad_type='grass & dirt'
    )

    falls_amen = Amenity(
        electric_hookup=False,
        water_hookup=False,
        septic_hookup=False,
        assigned_parking=True,
        tow_vehicle_parking=True,
        trash_removal=False,
        water_front=True,
        pets_allowed=True,
        internet_access=False
    )

    falls.amenity = falls_amen
    falls.necessity = falls_nec
    falls.user = user1
    db.session.add(falls)

    custer = Location(
        address='12503 US Highway 16A',
        city='Custer',
        state='SD',
        gps_coords='43.768783, -103.558967',
        description="Custer Mountain Cabins and Campground is conveniently located in the beautiful Black Hills of South Dakota 1.5 miles east of the City of Custer and   2 miles west of  Custer State Park on Highway 16A.",
        host_notes='Explore the beauty of the Black Hills from the quiet tranquility of Custer Mountain Cabins & Campground.',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fcuster1.png?alt=media&token=c0401bea-1c7e-4196-9829-4bc9c4156dde",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fcuster2.png?alt=media&token=04d03be8-cf8a-4d3c-886f-5bd32ed97968",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fcuster3.png?alt=media&token=6019456a-d221-4511-87e0-3cc851a193b0"],
        title="Custer Mountain Cabins"
    )

    custer_nec = Necessity(
        rv_compatible=False,
        generators_allowed=False,
        fires_allowed=False,
        max_days=5,
        pad_type='dirt'
    )

    custer_amen = Amenity(
        electric_hookup=True,
        water_hookup=False,
        septic_hookup=False,
        assigned_parking=True,
        tow_vehicle_parking=True,
        trash_removal=True,
        water_front=False,
        pets_allowed=True,
        internet_access=True
    )

    custer.amenity = custer_amen
    custer.necessity = custer_nec
    custer.user = demo_user
    db.session.add(custer)
 
    custer_review1 = Review(
        overall_rating=5,
        noise=3,
        safety=3,
        cleanliness=4,
        access=3,
        site_quality=3,
        comments="We knew we would have fun, but it was beyond our expectations. Highly recommend!"
    )

    custer_review2 = Review(
        overall_rating=5,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments='Hosts were welcoming and generous. Their little spot in the heart of this upscale area of Portland gave me and Journey (my dog) a walkable neighborhood to enjoy. I also relished the porch chats with our hosts, which were full of local history and politics, and a long walking tour of the neighborhood.'
    )

    custer_review3 = Review(
        overall_rating=4,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments="We had a great time. Pictures do not do this location justice! I highly recommend this to anybody. Thank you!"
    )

    custer_review1.location =  custer
    custer_review1.user = user1
    custer_review2.location =  custer
    custer_review2.user = user2
    custer_review3.location =  custer
    custer_review3.user = user3


    kansas_city_west = Location(
        address='1473 US-40',
        city='Lawrence',
        state='KS',
        gps_coords='38.996994, -95.229647',
        description="We are open for RV camping at the Kansas City West/Lawrence KOA and are continuing to follow county and state-issued Covid-19 guidelines, which have some of our recreation and other amenities temporarily closed. We have introduced additional cleaning standards, beyond our normal procedures, in order to provide any guests still wishing to enjoy the outdoors to have a safe and enjoyable stay. Please check back here for updates and we hope to see you soon!",
        host_notes='Contact this property for rates and availability',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fkansas_city_west1.png?alt=media&token=bb17d72f-0175-41fb-bf4c-09fceaf679ab",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fkansas_city_west2.png?alt=media&token=26425666-cd5a-4316-a4cf-a9a2cc0b6623",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fkansas_city_west3.png?alt=media&token=810fcb4e-81bb-462f-a8bd-6079ca413fd7"],
        title="Kansas City West"
    )

    kansas_city_west_nec = Necessity(
        rv_compatible=True,
        generators_allowed=False,
        fires_allowed=False,
        max_days=4,
        pad_type='asphalt'
    )

    kansas_city_west_amen = Amenity(
        electric_hookup=True,
        water_hookup=True,
        septic_hookup=True,
        assigned_parking=True,
        tow_vehicle_parking=True,
        trash_removal=True,
        water_front=False,
        pets_allowed=False,
        internet_access=True
    )

    kansas_city_west.amenity = kansas_city_west_amen
    kansas_city_west.necessity = kansas_city_west_nec
    kansas_city_west.user = user1
    db.session.add(kansas_city_west)

    evening_star = Location(
        address='23049 US Hwy 136',
        city='Topeka',
        state='IL',
        gps_coords='40.295911, -89.920807',
        description="Established in fall of 1969 by Bill Walker, Evening Star Camping Resort is located on 35 acres of pristine land 6 miles outside the town of Havana, Illinois. It is a great place to enjoy family camping the way you like it. We offer lots of events, themed weekends and excitement or complete relaxation by the campfire, if you choose.",
        host_notes='Contact this property for rates and availability',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fevening_star1.png?alt=media&token=7be90f22-5e14-4beb-966d-14576a009df9",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fevening_star2.png?alt=media&token=d4d20bf0-9cd7-41a1-bd62-5af33e5a8480",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fevening_star3.png?alt=media&token=98f7cc14-7ed0-43f9-95c2-d44b4667aeac"],
        title="Evening Star Camping Resort"
    )

    evening_star_nec = Necessity(
        rv_compatible=True,
        generators_allowed=True,
        fires_allowed=True,
        max_days=4,
        pad_type='asphalt'
    )

    evening_star_amen = Amenity(
        electric_hookup=True,
        water_hookup=True,
        septic_hookup=True,
        assigned_parking=True,
        tow_vehicle_parking=True,
        trash_removal=True,
        water_front=True,
        pets_allowed=True,
        internet_access=True
    )

    evening_star.amenity = evening_star_amen
    evening_star.necessity = evening_star_nec
    evening_star.user = user1
    db.session.add(evening_star)

    lucas_kentucky = Location(
        address='1880 Narrows Rd',
        city='Lucas',
        state='KY',
        gps_coords='36.902552, -86.067483',
        description="Surrounded by water, just a nice place to relax",
        host_notes='Contact this property for rates and availability',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Flucas_kentucky1.png?alt=media&token=ff240db0-195b-48ab-9ad0-7797b4fe32c0",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Flucas_kentucky2.png?alt=media&token=816cf03c-b0a6-4c17-a1fd-eb6c392c3bef",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Flucas_kentucky3.png?alt=media&token=5c186fc5-7341-4547-ad34-78b820b28d53"],
        title="US Campgrounds"
    )

    lucas_kentucky_nec = Necessity(
        rv_compatible=False,
        generators_allowed=True,
        fires_allowed=False,
        max_days=4,
        pad_type='grass'
    )

    lucas_kentucky_amen = Amenity(
        electric_hookup=False,
        water_hookup=False,
        septic_hookup=False,
        assigned_parking=False,
        tow_vehicle_parking=False,
        trash_removal=False,
        water_front=True,
        pets_allowed=True,
        internet_access=False
    )

    lucas_kentucky.amenity = lucas_kentucky_amen
    lucas_kentucky.necessity = lucas_kentucky_nec
    lucas_kentucky.user = user1
    db.session.add(lucas_kentucky)

    adventure_bound = Location(
        address='4609 US-321',
        city='Gatlinburg',
        state='TN',
        gps_coords='35.762647, -83.314409',
        description="Welcome to Adventure Bound Gatlinburg, our family-owned Gatlinburg, Tennessee campground. Camping in the Smokies has never been more enjoyable than this; a secluded mountain hideaway that is only a short trip from the hustle-bustle of Gatlinburg and Pigeon Forge attractions, shopping, and restaurants. Here, we like to stretch the traditional idea of a Gatlinburg campground to put our guests in a true resort that will have you coming back, season after season.",
        host_notes='Contact this property for rates and availability',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fadventure_bound1.png?alt=media&token=caa07fa6-29ce-48b3-940d-0f2074353716",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fadventure_bound2.png?alt=media&token=ca6003a3-14d5-4fea-84ec-a1a7effcde1a",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fadventure_bound3.png?alt=media&token=7990b62b-87a8-43c5-a153-6764ba76a2d5"],
        title="Adventure Bound Camping Resort"
    )

    adventure_bound_nec = Necessity(
        rv_compatible=True,
        generators_allowed=True,
        fires_allowed=True,
        max_days=4,
        pad_type='dirt'
    )

    adventure_bound_amen = Amenity(
        electric_hookup=True,
        water_hookup=True,
        septic_hookup=True,
        assigned_parking=True,
        tow_vehicle_parking=True,
        trash_removal=True,
        water_front=True,
        pets_allowed=True,
        internet_access=True
    )

    adventure_bound.amenity = adventure_bound_amen
    adventure_bound.necessity = adventure_bound_nec
    adventure_bound.user = user1
    db.session.add(adventure_bound)

    palm_harbor = Location(
        address='US-19',
        city='Palm Harbor',
        state='FL',
        gps_coords='28.108982, -82.739346',
        description="Park your RV here and enjoy!",
        host_notes='Contact this property for rates and availability',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fpalm_harbor1.png?alt=media&token=de9622d5-45a6-4567-a717-adf22d3c7f7a",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fpalm_harbor2.png?alt=media&token=88d19903-5c48-4e56-b97d-0b88cfa49935",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fpalm_harbor3.png?alt=media&token=7441f6f6-9cc2-4beb-9cf6-e1c358e06d2c"],
        title="RV Campground"
    )

    palm_harbor_nec = Necessity(
        rv_compatible=True,
        generators_allowed=False,
        fires_allowed=False,
        max_days=4,
        pad_type='asphalt'
    )

    palm_harbor_amen = Amenity(
        electric_hookup=False,
        water_hookup=False,
        septic_hookup=False,
        assigned_parking=True,
        tow_vehicle_parking=True,
        trash_removal=False,
        water_front=False,
        pets_allowed=False,
        internet_access=False
    )

    palm_harbor.amenity = palm_harbor_amen
    palm_harbor.necessity = palm_harbor_nec
    palm_harbor.user = user1
    db.session.add(palm_harbor)

    yogi = Location(
        address='2250 US Highway 211 E',
        city='Luray',
        state='VA',
        gps_coords='38.673467, -78.391394',
        description="Campground & recreation area offering water slides, mini-golf, laser tag & adventures for kids.",
        host_notes='Contact this property for rates and availability',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fyogi1.png?alt=media&token=4267062d-7b32-4ba4-a280-31d36be96894",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fyogi2.png?alt=media&token=f1ec400e-41ba-4b35-9f54-005e7b3e41c0",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fyogi3.png?alt=media&token=4d4a74ff-4349-4669-ae53-671e3e3ff566"],
        title="Yogi Bear's Jellystone Park"
    )

    yogi_nec = Necessity(
        rv_compatible=True,
        generators_allowed=False,
        fires_allowed=False,
        max_days=4,
        pad_type='asphalt'
    )

    yogi_amen = Amenity(
        electric_hookup=False,
        water_hookup=False,
        septic_hookup=False,
        assigned_parking=True,
        tow_vehicle_parking=True,
        trash_removal=True,
        water_front=False,
        pets_allowed=False,
        internet_access=True
    )

    yogi.amenity = yogi_amen
    yogi.necessity = yogi_nec
    yogi.user = user1
    db.session.add(yogi)

    holly_shores = Location(
        address='491 U.S. 9',
        city='Cape May',
        state='NJ',
        gps_coords='39.001128, -78.887446',
        description="Gated campground featuring RV sites & cabins, plus a heated pool, fishing lakes, games & free Wi-Fi.",
        host_notes='Contact this property for rates and availability',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fholly_shores1.png?alt=media&token=6fcce172-3a03-4839-ac8b-088642dd4488",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fholly_shores2.png?alt=media&token=45f67ee6-1897-4c42-b343-1859bef5fa1b",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fholly_shores3.png?alt=media&token=dc0a83f9-41d3-4545-9de0-b1d961fd5ac2"],
        title="Holly Shores"
    )

    holly_shores_nec = Necessity(
        rv_compatible=True,
        generators_allowed=False,
        fires_allowed=False,
        max_days=4,
        pad_type='asphalt'
    )

    holly_shores_amen = Amenity(
        electric_hookup=True,
        water_hookup=True,
        septic_hookup=True,
        assigned_parking=True,
        tow_vehicle_parking=True,
        trash_removal=True,
        water_front=False,
        pets_allowed=False,
        internet_access=True
    )

    holly_shores.amenity = holly_shores_amen
    holly_shores.necessity = holly_shores_nec
    holly_shores.user = user1
    db.session.add(holly_shores)

    dingmans = Location(
        address='1006 US-209',
        city='Dingmans Ferry',
        state='PA',
        gps_coords='41.211648, -74.873661',
        description="A couple hours of drive from NY where you can relax with nature",
        host_notes='Contact this property for rates and availability',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fdingmans1.png?alt=media&token=4ba0daa2-a5b1-4437-a1bd-b4aee6df013b",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fdingmans2.png?alt=media&token=84185be6-a987-4995-a5e3-f5aca140bc08",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Fdingmans3.png?alt=media&token=10ab0ab0-f63a-4a55-8133-15c7452a4e64"],
        title="Dingmans Campground"
    )

    dingmans_nec = Necessity(
        rv_compatible=True,
        generators_allowed=True,
        fires_allowed=True,
        max_days=4,
        pad_type='asphalt'
    )

    dingmans_amen = Amenity(
        electric_hookup=False,
        water_hookup=False,
        septic_hookup=False,
        assigned_parking=True,
        tow_vehicle_parking=True,
        trash_removal=False,
        water_front=False,
        pets_allowed=True,
        internet_access=False
    )

    dingmans.amenity = dingmans_amen
    dingmans.necessity = dingmans_nec
    dingmans.user = user1
    db.session.add(dingmans)

    lake_george = Location(
        address='1053 U.S. 9',
        city='Queensbury',
        state='NY',
        gps_coords='43.351008, -73.688271',
        description="Situated in Queensbury in the New York State region, with Six Flags Great Escape and Splashwater Kingdom and Six Flags Great Escape Lodge nearby, Lake George Campsites features accommodation with free private parking.",
        host_notes='Contact this property for rates and availability',
        image_urls=[
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Flake_george1.png?alt=media&token=910b9a5f-7c67-4bd2-9094-3abe43bb3b76",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Flake_george2.png?alt=media&token=8474094e-8951-482a-af41-cd6385a0e00a",
            "https://firebasestorage.googleapis.com/v0/b/campy-810fc.appspot.com/o/location_images%2Flake_george3.png?alt=media&token=56a93f5e-0a78-47fd-af51-5e630661c559"],
        title="Lake George Campsite"
    )

    lake_george_nec = Necessity(
        rv_compatible=True,
        generators_allowed=True,
        fires_allowed=True,
        max_days=4,
        pad_type='asphalt'
    )

    lake_george_amen = Amenity(
        electric_hookup=True,
        water_hookup=True,
        septic_hookup=True,
        assigned_parking=True,
        tow_vehicle_parking=True,
        trash_removal=True,
        water_front=True,
        pets_allowed=True,
        internet_access=True
    )

    lake_george.amenity = lake_george_amen
    lake_george.necessity = lake_george_nec
    lake_george.user = user1
    db.session.add(lake_george)

    review1 = Review(
        overall_rating=4,
        noise=5,
        safety=4,
        cleanliness=5,
        access=1,
        site_quality=5,
        comments='Host is very lovely, the location was perfect and the parking easy.'
    )

    review2 = Review(
        overall_rating=3,
        noise=1,
        safety=4,
        cleanliness=3,
        access=4,
        site_quality=5,
        comments='This is a lovely spot, and a kind and generous host. The neighborhood is peaceful and beautiful, as well as easily walkable to shops and restaurants. A really terrific place to stay.'
    )

    review3 = Review(
        overall_rating=4,
        noise=4,
        safety=4,
        cleanliness=4,
        access=4,
        site_quality=4,
        comments="Much an amazing time! Highly recommend!"
        )

    review4 = Review(
        overall_rating=3,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments='Hosts were welcoming and generous. Their little spot in the heart of this upscale area of Portland gave me and Journey (my dog) a walkable neighborhood to enjoy. I also relished the porch chats with our hosts, which were full of local history and politics, and a long walking tour of the neighborhood.'
    )

    review5 = Review(
        overall_rating=5,
        noise=3,
        safety=3,
        cleanliness=4,
        access=3,
        site_quality=3,
        comments="We knew we would have fun, but it was beyond our expectations. Highly recommend!"
    )

    review6 = Review(
        overall_rating=5,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments='Hosts were welcoming and generous. Their little spot in the heart of this upscale area of Portland gave me and Journey (my dog) a walkable neighborhood to enjoy. I also relished the porch chats with our hosts, which were full of local history and politics, and a long walking tour of the neighborhood.'
    )

    review7 = Review(
        overall_rating=3,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments="We had a great time. Pictures do not do this location justice! I highly recommend this to anybody. Thank you!"
    )

    review8 = Review(
        overall_rating=4,
        noise=3,
        safety=3,
        cleanliness=5,
        access=3,
        site_quality=5,
        comments="There is so much to say but I feel the only way to understand is by having the experience at staying at this wonderful place. Recommend it to all interested in it."
    )

    review9 = Review(
        overall_rating=5,
        noise=4,
        safety=4,
        cleanliness=4,
        access=3,
        site_quality=3,
        comments='WOW! We were initially drawn to the novelty of staying overnight in a tree house but left with an experience that touches the soul! Scott exceeded all expectations! His childlike enthusiasm for the tree house and Emerald Forest is truly infectious! You will find yourselves transported back to your youth. No expense was spared, nor detail overlooked. The "surprise" is truly magical and added an element that is indescribable! I now consider this the "8th Wonder of the World" and we cannot wait to go again!!!'
    )

    review10 = Review(
        overall_rating=4,
        noise=3,
        safety=3,
        cleanliness=3,
        access=3,
        site_quality=3,
        comments='10/10 recommend! Found it on tiktoc and we knew we had to go there! Did not disappoint!'
    )

    review11 = Review(
        overall_rating=4,
        noise=4,
        safety=4,
        cleanliness=4,
        access=4,
        site_quality=4,
        comments="This place is an absolute must for couples. Its cosy, its got all the conveniences you need (which is really something when you're staying in a treehouse. The host and property manager are very responsive and go to great lengths to make sure you get privacy, and an immediate response if you need them. This place is a gem. Even though its rustic, don't assume technology is sparse - quite the opposite. I'm in IT and even I was amazed at what was there. It wasn't cheap ,but it was worth every penny. We're going back...."
    )

    review12 = Review(
        overall_rating=5,
        noise=5,
        safety=5,
        cleanliness=5,
        access=5,
        site_quality=5,
        comments='Beautiful and outstanding place! Definitely recommend this stay!'
    )



    location1.amenity = location1_amenity
    location1.necessity = location1_neces
    location1.user = user1

    location2.amenity = location2_amenity
    location2.necessity = location2_neces
    location2.user = user2

    location3.amenity = location2_amenity
    location3.necessity = location2_neces
    location3.user = user2

    location4.amenity = location2_amenity
    location4.necessity = location2_neces
    location4.user = user2

    location5.amenity = location2_amenity
    location5.necessity = location2_neces
    location5.user = user2

    location6.amenity = location2_amenity
    location6.necessity = location2_neces
    location6.user = user2

    location7.amenity = location2_amenity
    location7.necessity = location2_neces
    location7.user = user2

    review1.location = location1
    review1.user = user3
    review2.location = location1
    review2.user = user4
    review3.location = location2
    review3.user = user4

    db.session.add(demo_user)
    db.session.add(location1)
    db.session.add(location2)
    db.session.commit()
