def remove_profile_image(user):
S3_BUCKET = settings.S3_BUCKET
AWS_ACCESS_KEY_ID = settings.AWS_ACCESS_KEY_ID
AWS_SECRET_ACCESS_KEY = settings.AWS_SECRET_ACCESS_KEY
conn = S3Connection(AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY)
url_list1 = user.profile_image_url.split("/")
filename1 = url_list1[len(url_list1) - 1]
url_list2 = user.profile_image_crop.url.split("/")
filename2 = url_list2[len(url_list2) - 1]
b = Bucket(conn, S3_BUCKET)
k = Key(b)
k.key = 'profile_images/' + filename1
b.delete_key(k)
k.key = 'profile_images/crop/' + filename2
b.delete_key(k)
user.profile_image_url = None
user.profile_image_crop = None
user.save()
def delete():
#try:
songid = int(request.args.get('songid'))
song = Song.query.filter_by(id=songid).first()
votes = Vote.query.filter_by(songdata=song.songdata).all()
for x in votes:
db.session.delete(x)
db.session.commit()
db.session.delete(song)
db.session.commit()
try:
conn = S3Connection(AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY)
b = Bucket(conn, S3_BUCKET_NAME)
k = Key(b)
k.key = songdata.lower() + '.mp3'
b.delete_key(k)
except:
pass
return render_template('notice.html', message="Delete successful.", redirect="/")
def delete_from_S3(filename):
conn = S3Connection(settings.AWS_ACCESS_KEY_ID,
settings.AWS_SECRET_ACCESS_KEY)
bucket = Bucket(conn, settings.AWS_STORAGE_BUCKET_NAME)
k = Key(bucket)
k.key = settings.MEDIA_URL + filename
bucket.delete_key(k)
def delete_img_aws(instance, **kwargs):
conn = S3Connection(settings.AWS_ACCESS_KEY_ID, settings.AWS_SECRET_ACCESS_KEY)
b = Bucket(conn, settings.AWS_STORAGE_BUCKET_NAME)
img_k = Key(b)
img_thumb_k = Key(b)
img_k.key = instance.image.name
img_thumb_k.key = instance.image_thumb.name
b.delete_key(img_k)
b.delete_key(img_thumb_k)
def cleanupBucket(self, bucket_name):
try:
from boto.s3.connection import S3Connection, Bucket, Key
conn = S3Connection()
b = Bucket(conn, bucket_name)
for x in b.list():
b.delete_key(x.key)
b.delete()
except:
pass # bucket must already be removed
def user_thumbnail_delete(sender, instance, **kwargs):
logging.debug('Firing pre-delete signal...')
gif = get_object_or_404(Gif, pk=instance.id)
f = str(gif.thumbnail)
filename = f[f.rfind('/') + 1:]
s3conn = S3Connection(settings.AWS_ACCESS_KEY_ID, settings.AWS_SECRET_ACCESS_KEY)
bucket = Bucket(s3conn, settings.AWS_STORAGE_BUCKET_NAME)
key_obj = Key(bucket)
key_obj.key = 'thumbs/' + filename
bucket.delete_key(key_obj.key)
def delete_img_aws(instance, **kwargs):
conn = S3Connection(settings.AWS_ACCESS_KEY_ID,
settings.AWS_SECRET_ACCESS_KEY)
b = Bucket(conn, settings.AWS_STORAGE_BUCKET_NAME)
img_k = Key(b)
img_thumb_k = Key(b)
img_k.key = instance.image.name
img_thumb_k.key = instance.image_thumb.name
b.delete_key(img_k)
b.delete_key(img_thumb_k)
def delete_file_from_s3(filename):
conn = S3Connection(
settings.AWS_ACCESS_KEY_ID,
settings.AWS_SECRET_ACCESS_KEY,
)
b = Bucket(
conn,
settings.AWS_STORAGE_BUCKET_NAME,
)
k = Key(b)
k.key = filename
b.delete_key(k)
def s3_delete_image(data):
try:
from boto.s3.connection import S3Connection, Bucket, Key
conn = S3Connection(data['S3_KEY'], data['S3_SECRET'])
b = Bucket(conn, data['S3_BUCKET'])
k = Key(b)
k.key = data['S3_UPLOAD_DIRECTORY'] + '/' + data['destinationFileName']
b.delete_key(k)
except Exception as e:
return e
def perform_destroy(self, instance):
conn = S3Connection(settings.AWS_ACCESS_KEY_ID, settings.AWS_SECRET_ACCESS_KEY, host='s3.ap-northeast-2.amazonaws.com')
b = Bucket(conn, settings.AWS_STORAGE_BUCKET_NAME)
k = Key(b)
k.key = str(instance.left_footscan_stl)
b.delete_key(k)
k.key = str(instance.right_footscan_stl)
b.delete_key(k)
instance.delete()
def delete_s3_pic(user, image): conn = S3Connection(AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY) b = Bucket(conn, AWS_STORAGE_BUCKET_NAME) k = Key(b) k.key = 'media/%s' % (image.image) b.delete_key(k) return
def prop(request, prop_id):
if request.method == "GET":
domain = request.get_host()
# GET - READ
try:
prop = Prop.objects.get(id=prop_id)
response_data = {
"success": True,
"prop": {
"id": prop.id,
"name": prop.name,
"description": prop.description,
"url": prop.image.url
}
}
return HttpResponse(json.dumps(response_data),
content_type="application/json")
except ObjectDoesNotExist:
return HttpResponse(status=404)
elif request.method == "PUT":
# PUT - UPDATE - later
pass
elif request.method == "DELETE":
prop = Prop.objects.get(id=prop_id)
# Unset From all scenes and delete scene_prop
scene_props = SceneProp.objects.filter(prop_file=prop)
for scene_prop in scene_props:
scene = scene_prop.scene
scene_prop.delete()
scene.save()
# Delete File
if prop.image:
if not settings.USE_AWS and prop.image.path:
# Delete from MEDIA_ROOT
os.remove(prop.image.path)
elif settings.USE_AWS and prop.image.name:
# Delete from AWS S3
connection = S3Connection(settings.AWS_ACCESS_KEY_ID,
settings.AWS_SECRET_ACCESS_KEY)
bucket = Bucket(connection, settings.AWS_STORAGE_BUCKET_NAME)
fileKey = Key(bucket)
fileKey.key = prop.image.name
bucket.delete_key(fileKey)
# Delete From Database
prop.delete()
response_data = {"success": True}
return HttpResponse(json.dumps(response_data),
content_type="application/json")
else:
return HttpResponseNotAllowed(['GET', 'PUT', 'DELETE'])
return HttpResponse("API call for prop #" + prop_id)
def remove_file_from_bucket(self, kw, bucket_name=None):
if not bucket_name:
bucket_name = self.bucket_name
bucket = Bucket(self.conn, self.bucket_name)
keyword = Key(bucket)
keyword.key = kw
try:
bucket.delete_key(keyword)
except Exception as error:
current_app.logger.error(error)
return False
return True
def run(self):
s3 = boto3Conn()
s3content = s3.list_objects_v2(Bucket='rmsapi')['Contents']
s3files = [s['Key'] for s in s3content]
s3 = s3open()
s3read = s3.Bucket('rmsapi')
if len(s3files) > 59:
# Creates data frames and assigns columns
E_cols = ['id', 'etype', 'diff', 'lon', 'lat', 'bear', 'road', 'dat']
I_cols = ['id', 'lon', 'lat', 'itype', 'street', 'dat_str', 'dat_end', 'ended']
df_outE = pd.DataFrame(columns=E_cols)
df_outI = pd.DataFrame(columns=I_cols)
timelist = []
# Iterates over files and stores the timestamp of the file
for file in s3read.objects.all():
key = file.key
body = file.get()['Body'].read()
timestamp = re.findall('[^_]+', key)
timestamp = timestamp[1].replace('+', ':')
timelist.append(timestamp)
# Different methods for event and incident files
if key.startswith('event'):
df_outE = parseEvent(body, timestamp, df_outE)
if key.startswith('inciden'):
df_outI = parseIncident(body, timestamp, df_outI)
# Output to csv file
with self.output()[0].open('w') as csvfile:
df_outE['diff'] = df_outE['diff'].astype(int)
df_outE['id'] = pd.to_numeric(df_outE['id'])
df_outE.to_csv(csvfile, columns=E_cols, index=False)
with self.output()[1].open('w') as csvfile:
# Create an end time stamp for data that has not actually ended yet for Gantt file
df_outI = endIncidents(timelist, df_outI)
df_outI['id'] = df_outI['id'].astype(int)
df_outI.to_csv(csvfile, columns=I_cols, index=False)
s3del = Bucket(s3delete(),'rmsapi')
k = Key(s3del)
# Delete all files in S3 folder
for file in s3files:
k.key = file
s3del.delete_key(k)
def prop(request, prop_id):
if request.method == "GET":
domain = request.get_host()
# GET - READ
try:
prop = Prop.objects.get(id=prop_id)
response_data = {
"success" : True,
"prop" : {
"id" : prop.id,
"name" : prop.name,
"description" : prop.description,
"url" : prop.image.url
}
}
return HttpResponse(json.dumps(response_data), content_type="application/json")
except ObjectDoesNotExist:
return HttpResponse(status=404)
elif request.method == "PUT":
# PUT - UPDATE - later
pass
elif request.method == "DELETE":
prop = Prop.objects.get(id=prop_id)
# Unset From all scenes and delete scene_prop
scene_props = SceneProp.objects.filter(prop_file=prop)
for scene_prop in scene_props:
scene = scene_prop.scene
scene_prop.delete()
scene.save()
# Delete File
if prop.image:
if not settings.USE_AWS and prop.image.path:
# Delete from MEDIA_ROOT
os.remove(prop.image.path)
elif settings.USE_AWS and prop.image.name:
# Delete from AWS S3
connection = S3Connection(settings.AWS_ACCESS_KEY_ID, settings.AWS_SECRET_ACCESS_KEY)
bucket = Bucket(connection, settings.AWS_STORAGE_BUCKET_NAME)
fileKey = Key(bucket)
fileKey.key = prop.image.name
bucket.delete_key(fileKey)
# Delete From Database
prop.delete()
response_data = { "success" : True }
return HttpResponse(json.dumps(response_data), content_type="application/json")
else:
return HttpResponseNotAllowed(['GET', 'PUT', 'DELETE'])
return HttpResponse("API call for prop #" + prop_id)
def screenshot(request,val):
if val == 1 :
conn = S3Connection('##', '##')
bucket = conn.get_bucket('lheston-bucket')
k = Key(bucket)
k.key = '//lab3' + request + '_toS3.png'
driver = webdriver.PhantomJS() # or add to your PATH
driver.set_window_size(1024, 768) # optional
driver.get(request)
driver.save_screenshot('tempfile.png')
driver.quit
file1 = open('tempfile.png', 'rb')
os.remove('tempfile.png')
k.set_contents_from_file(file1)
driver.quit
return str(request + '_toS3.png')
elif val == 2:
text = '/lab3' + request
conn = S3Connection('##', '##')
S3_BUCKET_NAME = 'lheston-bucket'
bucket = Bucket(conn, S3_BUCKET_NAME)
bucket = bucket.delete_key(text)
#bucket.delete_key('/lab3/' + request.split(':')[1])
#k = Key(b)
#k.name = k.get_key(text)
#b.delete_key(k)
#k.name = k.get_key(text)
#b.delete_key(k)
#b.delete_key('//lab3' + request.split(':')[1] + '_toS3.png')
else:
return str('incorrect input')
def background(request, background_id):
domain = request.get_host()
if request.method == "GET":
# GET - READ
try:
background = Background.objects.get(id=background_id)
response_data = {
"success": True,
"background": {
"id": background.id,
"name": background.name,
"description": background.description,
"url": background.image.url
}
}
return HttpResponse(json.dumps(response_data),
content_type="application/json")
except ObjectDoesNotExist:
return HttpResponse(status=404)
elif request.method == "PUT":
# PUT - UPDATE - later
pass
elif request.method == "DELETE":
background = Background.objects.get(id=background_id)
# Unset From all scenes
background.scenes.clear()
# Delete File
if background.image:
if not settings.USE_AWS and background.image.path:
# Delete from MEDIA_ROOT
os.remove(background.image.path)
elif settings.USE_AWS and background.image.name:
# Delete from AWS S3
connection = S3Connection(settings.AWS_ACCESS_KEY_ID,
settings.AWS_SECRET_ACCESS_KEY)
bucket = Bucket(connection, settings.AWS_STORAGE_BUCKET_NAME)
fileKey = Key(bucket)
fileKey.key = background.image.name
bucket.delete_key(fileKey)
# Delete from database
background.delete()
response_data = {"success": True}
return HttpResponse(json.dumps(response_data),
content_type="application/json")
else:
return HttpResponseNotAllowed(['GET', 'PUT', 'DELETE'])
return HttpResponse("API call for background #" + background_id)
def delete_url(request):
if request.is_ajax():
req = eval(request.body)
if request.method == 'POST':
user = UserProfile.objects.get(user__username=request.user)
conn = S3Connection(AWS_ACCESS_KEY, AWS_SECRET_KEY)
b = Bucket(conn, AWS_BUCKET_NAME)
k = Key(b)
for x in req['url']:
x = str(x)
k.key = x[-8:]
b.delete_key(k)
url_list = Image.objects.get(author=user,url=x,album_name=req['album'])
album = Album.objects.get(author=user,name=req['album'])
album.images.remove(url_list)
album.save()
url_list.delete()
return HttpResponse( request )
def background(request, background_id):
domain = request.get_host()
if request.method == "GET":
# GET - READ
try:
background = Background.objects.get(id=background_id)
response_data = {
"success" : True,
"background" : {
"id" : background.id,
"name" : background.name,
"description" : background.description,
"url" : background.image.url
}
}
return HttpResponse(json.dumps(response_data), content_type="application/json")
except ObjectDoesNotExist:
return HttpResponse(status=404)
elif request.method == "PUT":
# PUT - UPDATE - later
pass
elif request.method == "DELETE":
background = Background.objects.get(id=background_id)
# Unset From all scenes
background.scenes.clear()
# Delete File
if background.image:
if not settings.USE_AWS and background.image.path:
# Delete from MEDIA_ROOT
os.remove(background.image.path)
elif settings.USE_AWS and background.image.name:
# Delete from AWS S3
connection = S3Connection(settings.AWS_ACCESS_KEY_ID, settings.AWS_SECRET_ACCESS_KEY)
bucket = Bucket(connection, settings.AWS_STORAGE_BUCKET_NAME)
fileKey = Key(bucket)
fileKey.key = background.image.name
bucket.delete_key(fileKey)
# Delete from database
background.delete()
response_data = { "success" : True }
return HttpResponse(json.dumps(response_data), content_type="application/json")
else:
return HttpResponseNotAllowed(['GET', 'PUT', 'DELETE'])
return HttpResponse("API call for background #" + background_id)
def download():
s3_conn = s3()
# bucket = s3_conn.create_bucket('distributed-web-crawler')
bucket = Bucket(s3_conn, 'distributed-web-crawler')
while True:
try:
k = Key(bucket)
k.key = 'list_links_a.txt'
k.get_contents_to_filename('input_links_a.txt')
bucket.delete_key(k)
break
except S3ResponseError:
pass
s3_conn.close()
def delete_scene(scene):
# Delete all scene props in the scene
scene_props = SceneProp.objects.filter(scene=scene)
for scene_prop in scene_props:
scene = scene_prop.scene
scene_prop.delete()
scene.save()
# Delete the scene thumbnail
if not settings.USE_AWS and hasattr(scene.thumbnail, "path"):
# Delete from MEDIA_ROOT
os.remove(scene.thumbnail.path)
elif settings.USE_AWS and hasattr(scene.thumbnail, "name"):
# Delete from AWS S3
connection = S3Connection(settings.AWS_ACCESS_KEY_ID, settings.AWS_SECRET_ACCESS_KEY)
bucket = Bucket(connection, settings.AWS_STORAGE_BUCKET_NAME)
fileKey = Key(bucket)
fileKey.key = scene.thumbnail.name
bucket.delete_key(fileKey)
# Delete the scene itself
scene.delete()
def delete_album(request):
if request.is_ajax():
req = eval(request.body)
if request.method == 'POST':
user = UserProfile.objects.get(user__username=request.user)
album_to_delete = Album.objects.get(author=user,name=req['album'])
imgs = list(album_to_delete.images.all().order_by('-created_date'))
conn = S3Connection(AWS_ACCESS_KEY, AWS_SECRET_KEY)
b = Bucket(conn, AWS_BUCKET_NAME)
k = Key(b)
for x in imgs:
k.key = x.url[-8:]
b.delete_key(k)
x.delete()
album_to_delete.delete()
user = str(request.user)
album_url_list = fill_albums(user,"a-z","")
return HttpResponse(
json.dumps(album_url_list)
)
def download():
s3_conn = s3()
# bucket = s3_conn.create_bucket('distributed-web-crawler')
bucket = Bucket(s3_conn, 'distributed-web-crawler')
while True:
try:
k = Key(bucket)
k.key = 'list_links_b.txt'
k.get_contents_to_filename('input_links_b.txt')
bucket.delete_key(k)
break
except S3ResponseError:
pass
s3_conn.close()
def prodcut_images_delete(request, product_id, image_id):
product = get_object_or_404(Product, pk=product_id)
if product.user != request.user:
redirect('honme')
image = get_object_or_404(ProductImages, pk=image_id)
s3conn = S3Connection(settings.AWS_ACCESS_KEY_ID,
settings.AWS_SECRET_ACCESS_KEY)
bucket = Bucket(s3conn, settings.AWS_STORAGE_BUCKET_NAME)
name_image = image.images.split('/')
try:
bucket.delete_key('upload/images/' + name_image[-1])
image.delete()
except Exception as e:
print(e)
return redirect('product_images', product_id)
def delete_scene(scene):
# Delete all scene props in the scene
scene_props = SceneProp.objects.filter(scene=scene)
for scene_prop in scene_props:
scene = scene_prop.scene
scene_prop.delete()
scene.save()
# Delete the scene thumbnail
if not settings.USE_AWS and hasattr(scene.thumbnail, 'path'):
# Delete from MEDIA_ROOT
os.remove(scene.thumbnail.path)
elif settings.USE_AWS and hasattr(scene.thumbnail, 'name'):
# Delete from AWS S3
connection = S3Connection(settings.AWS_ACCESS_KEY_ID,
settings.AWS_SECRET_ACCESS_KEY)
bucket = Bucket(connection, settings.AWS_STORAGE_BUCKET_NAME)
fileKey = Key(bucket)
fileKey.key = scene.thumbnail.name
bucket.delete_key(fileKey)
# Delete the scene itself
scene.delete()
def delete_product_image(product):
S3_BUCKET = settings.S3_BUCKET
AWS_ACCESS_KEY_ID = settings.AWS_ACCESS_KEY_ID
AWS_SECRET_ACCESS_KEY = settings.AWS_SECRET_ACCESS_KEY
conn = S3Connection(AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY)
url_list1 = product.image_url.split("/")
filename1 = url_list1[len(url_list1) - 1]
url_list2 = product.thumbnail.url.split("/")
filename2 = url_list2[len(url_list2) - 1]
url_list3 = product.watermark.url.split("/")
filename3 = url_list3[len(url_list3) - 1]
b = Bucket(conn, S3_BUCKET)
k = Key(b)
k.key = 'products/' + filename1
b.delete_key(k)
k.key = 'products/thumbnails/' + filename2
b.delete_key(k)
k.key = 'products/watermarked/' + filename3
b.delete_key(k)
local_img = '/Users/siyang/Desktop/siyang_test.jpg'
my_bucket.upload_file(local_img, 'public/label_images/siyang_test.jpg')
# list all files
for file in my_bucket.objects.all():
print(file.key)
# delete objects
from boto.s3.connection import S3Connection, Bucket, Key
conn = S3Connection(AWS_ACCESS_KEY, AWS_SECERET_KEY)
b = Bucket(conn, S3_BUCKET_NAME)
k = Key(b)
k.key = 'images/my-images/' + filename
b.delete_key(k)
def download_s3(s3folder, bucket="vama-sceneuds-images"):
"""download all data in a S3 folder"""
s3 = boto3.client('s3')
for obj in s3.list_objects_v2(Bucket=bucket, Prefix=s3folder)["Contents"]:
s3_file = obj["Key"]
s3_subfolder = s3_file.split("/")[-2]
s3_filename = s3_file.split("/")[-1]
local_subfolder_path = os.path.join("download", s3_subfolder)
local_subfolder_filepth = os.path.join(local_subfolder_path,
s3_filename)
if not os.path.exists(local_subfolder_path):
os.makedirs(local_subfolder_path)
