change to postgres user and open psql prompt
sudo -u postgres psql postgres
list databases
postgres=# \l
list roles
""" | |
Find user/database entries within a km radius based on long/lat co-ords. | |
i.e. return all objects where longlat lies within 10km of my current long/lat. | |
Using with Django REST Framework but approach is same for any similar req. | |
""" | |
import math | |
def get_queryset(self): | |
user = self.request.user | |
lat = self.request.query_params.get('lat', None) |
# Simple version of Django queryset for objects within X long/lat radius | |
import math | |
def get_queryset(self): | |
user = self.request.user | |
lat = self.request.query_params.get('lat', None) | |
lon = self.request.query_params.get('long', None) | |
if lat and lon: | |
lat = float(lat) |
FIX CACHE ISSUES ON ANDROID – REACT NATIVE BUILD | |
cd android && cd app && rm -r build | |
cd android && ./gradlew clean | |
react-native bundle --platform android --dev false --entry-file index.js --bundle-output android/app/src/main/assets/index.android.bundle --assets-dest android/app/src/main/res | |
cd android &&chmod +x gradlew |
# Connect Multiple AWS Accounts | |
aws configure --profile <your-profile-name> | |
change to postgres user and open psql prompt
sudo -u postgres psql postgres
list databases
postgres=# \l
list roles
# Inline policy for aws-elasticbeanstalk-ec2-role | |
{ | |
"Version": "2012-10-17", | |
"Statement": [ | |
{ | |
"Sid": "Stmt1409855610000", | |
"Effect": "Allow", | |
"Action": [ | |
"autoscaling:DescribeAutoScalingGroups" |
### Virtualenv | |
venv/ | |
### PyCharm | |
.idea/ | |
### Python | |
__pycache__/ | |
*.py[cod] |
# test .encode() and str() | |
a_string = 'test éurope' | |
print('a_string normal: ', a_string) | |
a_string = 'test éurope' | |
print('a_string utf-8 encoded: ', a_string.encode('utf-8')) # utf-8 is default so .encode() is same result | |
print('a_string ascii encoded: ', a_string.encode('ascii', 'replace')) # with error, i.e. replace, ignore etc. | |
print('a_string str: ', str(a_string)) | |
company = 'éuropean company' | |
pro_comp_name = 'a løng campaigné name' |
# sometimes Ember builds break due to npm &/or bower cache, node changes etc. | |
# running below usually fixing any cache issues | |
rm -rf node_modules/ bower_components/ tmp/ dist/ | |
npm cache clear | |
bower cache clear | |
npm install && bower install | |
ember s |
# view container instances | |
docker container ls | |
# activate instance, i.e. nginx, django etc. | |
docker exec -i -t be821b60fa28 /bin/bash |