Jason swnim

## getter_and_setter.py
class Table(Base):
    id = Column(Integer, primary_key=True)
    _name = Column('name', String(24))

    @property
    def name(self):
        return self._name;

    @name.setter
    def name(self, value):

## S3-Static-Sites.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                swnim
                / S3-Static-Sites.md
            
            
              Created
              January 30, 2020 04:28
                — forked from bradwestfall/S3-Static-Sites.md
            
              
                Use S3 and CloudFront to host Static Single Page Apps (SPAs) with HTTPs and www-redirects. Also covers deployments.
              
          
    S3 Static Sites

What this will cover

Host a static website at S3
Redirect www.website.com to website.com
Website can be an SPA (requiring all requests to return index.html)
Free AWS SSL certs
Deployment with CDN invalidation

Resources


## redshift_admin_queries.sql
# List all tables:
select db_id, id, name, sum(rows) as mysum
from stv_tbl_perm where db_id = 100546
group by db_id, id, name order by mysum desc;

# list all running processes:
select pid, query from stv_recents where status = 'Running';

# describe table
select * from PG_TABLE_DEF where tablename='audit_trail';

## 0_reuse_code.js
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

## install_pyenv.sh
#!/bin/zsh
# pyenv install for CentOS 6.5 x86_64

yum install -y gcc gcc-c++ make git patch openssl-devel zlib-devel readline-devel sqlite-devel bzip2-devel

git clone git://github.com/yyuu/pyenv.git ~/.pyenv

export PATH="$HOME/.pyenv/bin:$PATH"
eval "$(pyenv init -)"
	class Table(Base):
	id = Column(Integer, primary_key=True)
	_name = Column('name', String(24))

	@property
	def name(self):
	return self._name;

	@name.setter
	def name(self, value):
	# List all tables:
	select db_id, id, name, sum(rows) as mysum
	from stv_tbl_perm where db_id = 100546
	group by db_id, id, name order by mysum desc;

	# list all running processes:
	select pid, query from stv_recents where status = 'Running';

	# describe table
	select * from PG_TABLE_DEF where tablename='audit_trail';
	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console
	#!/bin/zsh
	# pyenv install for CentOS 6.5 x86_64

	yum install -y gcc gcc-c++ make git patch openssl-devel zlib-devel readline-devel sqlite-devel bzip2-devel

	git clone git://github.com/yyuu/pyenv.git ~/.pyenv

	export PATH="$HOME/.pyenv/bin:$PATH"
	eval "$(pyenv init -)"