| [Unit] | |
| Description=mitron gunicorn daemon | |
| After=network.target | |
| [Service] | |
| PIDFile=/run/gunicorn/pid | |
| User={{ user }} | |
| Group={{ user }} | |
| RuntimeDirectory=gunicorn | |
| WorkingDirectory={{ project_root }} |
| server { | |
| listen 80; | |
| server_name {{ ip address }}; | |
| access_log /var/log/nginx/access.log; | |
| location = /favicon.ico { access_log off; log_not_found off; } | |
| location /static/ { | |
| root /home/ubuntu/projectName/; | |
| } |
| To get the number of value in the each column with the count | |
| # =========================================================================================================== # | |
| ModelName.objects.filter(id=model.id).all().values('fieldName').annotate(count=Count('fieldName')).order_by() | |
| class ModelNameSerializers(serializers.ModelSerializer): | |
| column_count = serializers.SerializerMethodField() | |
| class Meta: | |
| model = models.ModelName |
| home brew - /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" | |
| git brew instal git | |
| ffmpeg git clone https://git.ffmpeg.org/ffmpeg.git ffmpeg | |
| libv brew install libav | |
| youtubedl brew install youtube-dl |
| # Setting PATH for Python 3.7 | |
| # The original version is saved in .bash_profile.pysave | |
| PATH="/Library/Frameworks/Python.framework/Versions/3.7/bin:${PATH}" | |
| export PATH | |
| if [ -f $(brew --prefix)/etc/bash_completion ]; then | |
| . $(brew --prefix)/etc/bash_completion | |
| fi |
Refer https://www.codementor.io/engineerapart/getting-started-with-postgresql-on-mac-osx-are8jcopb
http://suite.opengeo.org/docs/latest/dataadmin/pgGettingStarted/firstconnect.html
Psql console
psql
\c database_name (selects db)
\l - lists all the database