Mac Code Monkey

from sqlalchemy import func

session.query(func.count(User.name), User.name).group_by(User.name).all()

'dynamic' is special and can be useful if you have many items and always want to apply additional SQL filters to them. Instead of loading the items SQLAlchemy will return another query object which you can further refine before loading the items. Note that this cannot be turned into a different loading strategy when querying so it’s often a good idea to avoid using this in favor of lazy=True. A query object equivalent to a dynamic user.addresses relationship can be created using Address.query.with_parent(user) while still being able to use lazy or eager loading on the relationship itself as necessary.

Some example code using the with_parent()

I always have to look this up, so I’m going to put this on my Tumblr blog so I can easily find it...

As of 2017:

Illinois Tax Rate: 6.25%

Kane County Tax Rate: 0.75%

A Python WSGI Utility Library - makes making a WSGI Web Application easier.

Other implementations:

http://gunicorn.org

https://uwsgi-docs.readthedocs.io/en/latest/#

https://github.com/cherrypy/cherrypy

CherryPy, the last link, is a pure Python web server that also functions as a WSGI server!!

Python Reference Implementations

2.x: https://docs.python.org/2/library/wsgiref.html

3.x: https://docs.python.org/3.4/library/wsgiref.html

Using a WSGI compliant web server

An article showing how to serve a simple web applications with various WSGI compliant web servers.

http://agiliq.com/blog/2013/07/basics-wsgi/

A WSGI tutorial

A tutorial that uses the python reference implementation to serve up web application content.

http://wsgi.tutorial.codepoint.net/#

Deploying Python-powered web application

What is it?

Web Server Gateway Interface: An implementation of WSGI (PEP-3333), for the Apache Web Sever, which enables the web server to host any web application which complies with the specification. These web applications can be, and usually are, written in Python.

Useful links:

https://github.com/GrahamDumpleton/mod_wsgi

http://modwsgi.readthedocs.io/en/develop/index.html

See Also

If you use npm start to launch http-server you can pass in an optional url to proxy request not found on the local server... 

npm start -- -P http://jsonplaceholder.typicode.com

Alternatively:

This is a continuation from my previous post about how to configure a MySQL server to enable connecting to it from a different computer.

In this post I’ll address what I had to do for a Vagrant VM running Ubuntu Server Trusty Tahr using Virtual Box.

If using port forwarding, you will have to configure the Vagrantfile to forward a port to the VM’s port 3306 (the default mysql port), I picked port 33060. Set the host IP address to the address of your host machine (not sure if local host or 127.0.0.1 will work as I haven’t tried it).

config.vm.network "forwarded_port", guest: 3306, host: 33060, host_ip: "192.168.xxx.xxx", auto_correct: true

Obviously I had to install MySQL as the hashicorp atlas box I was using (config.vm.box = "ubuntu/trusty64") didn’t have it installed. This was pretty simple:

sudo apt-get install mysql-server

after installation, we need to start the MySQL server up with:

sudo service mysql start

Test that you can connect to the server using root with the pw that was set when installing with apt-get. 

Next edit the config file (as instructed in my previous post). The my.cnf file is actually located where expected:

/etc/mysql/my.cnf

just edit the bind-address config line, I set mine to 0.0.0.0, then restart the server:

sudo service mysql restart

Now add db, user and grant privileges (as instructed in my previous post), except when adding the user, use the IP address that you specified in the Vagrantfile port forwarding. E.g.:

This links gives you all the instructions to configure a MySQL server so that you can connect to it from another computer.

Essentially you need to:

1) edit the my.cnf configuration file and add a line under the [mysqld] section to set the bind-address, then restart the server.

2) Connect locally to the mysql server using the root user and add a user that can connect from the ‘localhost’ and ‘%’

3) Next, grant that user all privileges for both ‘localhost’ and ‘%’

4) flush the privileges

Note this will not gran the user DBA privileges...

You may need to hunt around to find the my.cnf file. On my Ubuntu server VM it was located in the /etc/mysql/mysql.conf.d directory and was called mysql.cnf -- also in the /etc/mysql directory there was a symbolic link named my.cnf that pointed to /etc/alternatives/my.cnf which included all files in the /etc/mysql/mysql.conf.d directory. So it was a little bit of a hunt...

On macOS (aka OS X) Sierra there is not my.cnf file of any sort. Instead there is a lanunchd plist that starts up MySQL (at least in the official install package from the MySQL website). Instead of using a config file it passes all of the configuration parameters on the command line when starting up the mysql server (mysqld). What I ended up doing was to create my own my.cnf file in the /etc/mysql directory (had to create the mysql directory in the etc directory first). I took all the parameters that the launchd script was using and put them in the my.cnf file, adding the needed configuration to enable remote connections. Then I edited the launchd plist file, com.oracle.oss.mysql.mysqld.plist, located in the /Library/LaunchDaemons directory and removed all the existing parameters. I then added a single parameter of --defaults-file=/etc/mysql/my.cnf