Turbogears 2.3 on Heroku

Turbogears 2.3 on Heroku

Step 1 : Install waitress
pip install waitress

---

Step 2 : Install turbogears app
gearbox quickstart myproturbo

---

Step 3 : Change to project
cd myproturbo

---

Step 4 : Create file requirements.txt  in project
pip freeze > requirements.txt
 *** Open file requirements.txt and delete your project which you setup in python environment ex:

myproturbo=0.1  [your project: setup.py develop]
or
-e git+https://github.com/xxxxxxxxx#egg=xxxx  [your project: from git or subversion]

---

Step 5 : Add -e . in last row in file  requirements.txt

alembic==0.9.5
babel==2.5.1
backlash==0.1.2
beaker==1.9.0
crank==0.8.1
decorator==4.1.2
formencode==2.0.0a1
funcsigs==1.0.2
gearbox==0.1.1
kajiki==0.7.1
mako==1.0.7
MarkupSafe==1.0
nine==1.0.0
PasteDeploy==1.5.2
Pygments==2.2.0
python-dateutil==2.6.1
python-editor==1.0.3
pytz==2017.2
repoze.lru==0.7
repoze.who==2.3
six==1.11.0
speaklater==1.3
sprox==0.10.2
sqlalchemy==1.2.0b2
Tempita==0.5.2
tg.devtools==2.3.11
tgext.admin==0.7.4
tgext.crud==0.8.2
tgext.debugbar==0.3.0
transaction==2.1.2
TurboGears2==2.3.11
tw2.core==2.2.4
tw2.forms==2.2.5
waitress==1.0.2
webhelpers2==2.0
WebOb==1.7.3
WebTest==1.4.3
zope.interface==4.4.2
zope.sqlalchemy==0.7.7
-e .

---

Step 6 : copy development.ini to production.ini
cp  development.ini production.ini

---

Step 7 : change  config file in production.ini
[server:main]
use = egg:gearbox#wsgiref
host = 0.0.0.0
port = 8080

Change to

[server:main]
use = egg:waitress#main
host = 0.0.0.0
get port = heroku_port

---

Step 8 :  Generate file Procfile to start app

echo "web: /app/.heroku/python/bin/gearbox serve --debug -c production.ini heroku_port=$PORT" > Procfile

*** file name is Case-sensitive

---

Step 9 : Prepaire and Setup git repo
wget -O .gitignore https://raw.github.com/github/gitignore/master/TurboGears2.gitignore
git init
git add .
git commit -m "initial commit"

---

Step 10 : Initialize keroku project
heroku create myproturbo

---

Step 11 : Deploy to heroku
git push heroku master

remote: Compressing source files... done.
remote: Building source:
remote:
remote: -----> Python app detected
remote: -----> Installing requirements with pip
remote:        Obtaining file:///tmp/build_c1da74e071cabdd181483ce0164e3a85 (from -r /tmp/build_c1da74e071cabdd181483ce0164e3a85/requirements.txt (line 40))
remote:        Installing collected packages: myproject
remote:          Running setup.py develop for myproject
remote:        Successfully installed myproject
remote:
remote: -----> Discovering process types
remote:        Procfile declares types -> web
remote:
remote: -----> Compressing...
remote:        Done: 55.7M
remote: -----> Launching...
remote:        Released v7
remote:        https://myproturbo.herokuapp.com/ deployed to Heroku
remote:
remote: Verifying deploy... done.
To https://git.heroku.com/myproturbo.git
   8b92553..d19a8fa  master -> master

---

Step 12 : Check status heroku
heroku logs -t

---

You can see : https://myproturbo.herokuapp.com/
My github :  https://github.com/tongpa/myproject.git

turbogear : http://turbogears.readthedocs.io/en/latest/cookbook/deploy/heroku.html

---

Turbogears2 Change The Way Your App Loads The Database Engines

Step by Step
1. In configuration file (development.ini). I change sqlalchemy

---

#sqlalchemy.url = sqlite:///%(here)s/devdata.db
sqlalchemy.first.url = sqlite:///%(here)s/database_1.db
sqlalchemy.second.url = sqlite:///%(here)s/database_2.db

---

2. In Application Configuration to load the multiple databases. In file ../config/app_cfg.py

---

# make sure these imports are added to the top
from tg.configuration import AppConfig, config
from myapp.model import init_model

# add this before base_config =
class MultiDBAppConfig(AppConfig): 

    def _setup_sqlalchemy(self, conf):

    #def setup_sqlalchemy(self):
        """Setup SQLAlchemy database engine(s)"""
        from sqlalchemy import engine_from_config
        engine1 = engine_from_config(config, 'sqlalchemy.first.')
        engine2 = engine_from_config(config, 'sqlalchemy.second.')
        # engine1 should be assigned to sa_engine as well as your first engine's name
        config['tg.app_globals'].sa_engine = engine1
        config['tg.app_globals'].sa_engine_first = engine1
        config['tg.app_globals'].sa_engine_second = engine2
        # Pass the engines to init_model, to be able to introspect tables
        init_model(engine1, engine2)

#base_config = AppConfig()
base_config = MultiDBAppConfig()

---

In document Turbogears2 it used def setup_sqlalchemy(self): , when server start will error.
change to def _setup_sqlalchemy(self, conf): ,  server start will not error.

3. Update your model's __init__ to handle multiple Sessions and Metadata. Add maker2, DBSession2, DeclarativeBase2 and metadata2. Change function init_model in file ../model/__init__.py

---

# after the first maker/DBSession assignment, add a 2nd one
maker2 = sessionmaker(autoflush=True, autocommit=False,
                     extension=ZopeTransactionExtension())
DBSession2 = scoped_session(maker2)

# after the first DeclarativeBase assignment, add a 2nd one
DeclarativeBase2 = declarative_base()

# uncomment the metadata2 line and assign it to DeclarativeBase2.metadata
metadata2 = DeclarativeBase2.metadata

# finally, modify the init_model method to allow both engines to be passed (see previous step)
# and assign the sessions and metadata to each engine
def init_model(engine1, engine2):
    """Call me before using any of the tables or classes in the model."""

    #DBSession.configure(bind=engine)
    DBSession.configure(bind=engine1)
    DBSession2.configure(bind=engine2)

    metadata.bind = engine1
    metadata2.bind = engine2

---

4. Tell Your Models Which Engine To Use
     4.1 use engine1. create file ../model/spam.py . when query data use DBSession for database_1.db.

---

from sqlalchemy import Table, ForeignKey, Column
from sqlalchemy.types import Integer, Unicode, Boolean
from myapp.model import DeclarativeBase, DBSession

class Spam(DeclarativeBase):
    __tablename__ = 'spam'

    def __init__(self, id, variety):
        self.id = id
        self.variety = variety

    id = Column(Integer, autoincrement=True, primary_key=True)
    variety = Column(Unicode(50), nullable=False)

    @classmethod
    def selectAll(cls):
        return DBSession.query(cls).all(); 

---

     4.2 use engine2. create file ../model/eggs.py. when query data use DBSession2 for database_2.db.

---

from sqlalchemy import Table, ForeignKey, Column
from sqlalchemy.types import Integer, Unicode, Boolean
from myapp.model import DeclarativeBase2, DBSession2

class Eggs(DeclarativeBase2):
    __tablename__ = 'eggs'

    def __init__(self, id, pkg_qty):
        self.id = id
        self.pkg_qty = pkg_qty

    id = Column(Integer, autoincrement=True, primary_key=True)
    pkg_qty = Column(Integer, default=12)

    @classmethod
    def selectAll(cls):
        return DBSession2.query(cls).all();  

---

I read at http://turbogears.readthedocs.io/en/latest/cookbook/multiple-databases.html#change-the-way-your-app-loads-the-database-engines

Turbogears 2 used kajiki template (xhtml to html)

I used Turbogears 2.4 and update to Turbogears 2.8 (Default kajiki template). I want to change Genshi to Kajiki template. I found than I change html to xhtml for kajiki templates. So I don't change It. I search Turbogears Document, In development.ini file 

#config change default extension of kajiki(.xhtml) to .html
templating.kajiki.template_extension = .html

and change base_config.renderes in  app_cfg.py

# Set the default renderer
base_config.renderers.append('kajiki')
# Set the default renderer
base_config.default_renderer = 'kajiki'


But It's not easy, In HTML file I want to change kajiki format. I read it http://turbogears.readthedocs.io/en/latest/turbogears/kajiki-xml-templates.html 

Install Turbogear2

How to Install Turbogears2 (Python web framework)

1. install python 2.7
2. install visual env
3. create tg2env and use tg2env
4. install turbogears in tg2env
5. create project turbogears
6. setup project
7. run project

 Step 1 install python 2.7

download : https://www.python.org/downloads/release/python-2712/
for windows 64 bit: Windows x86-64 MSI installer


Download and Install python 2.7

Python Line Notify

1. go to https://notify-bot.line.me/my/ To Create Token with message

 
2. Create Toke, Click Generate Token

 

3. Enter Message to generate Token and Select group to notify and Click Generate Token

 

4. Click Copy Token key and close

5. Check in select group, please add LINE Notify into group.

6. Create python file and add code

# -*- coding: utf-8 -*-
import requests,json

LINE_ACCESS_TOKEN="Your Token" #token

url = "https://notify-api.line.me/api/notify"

msg = {"message":"Test Message"} #message

LINE_HEADERS = {'Content-Type':'application/x-www-form-urlencoded',"Authorization":"Bearer "+LINE_ACCESS_TOKEN}
session = requests.Session()

resp =session.post(url, headers=LINE_HEADERS, data=msg)
print(resp.text)

turbogears 2 Using Multiple Database

จาก multiple database
ลองมาเขียนเองดู สิ่งที่ต้องแก้ไข

1. ไฟล์ development.ini
2. ไฟล์ app_cfg.py [ myapp/config ]
3. ไฟล์ __init__.py [ myapp/model ]

1. ไฟล์ development.ini

#sqlalchemy.url = sqlite:///%(here)s/devdata.db sqlalchemy.first.url = sqlite:///%(here)s/database_1.db sqlalchemy.second.url = sqlite:///%(here)s/database_2.db

ติดตั้ง MySQL-python เพื่อ ติดต่อกับ Mysql

สำหรับการใช้งานฐานข้อมูล Mysql ร่วมกับ python ติดตั้ง บน CentOS 7 64 bit

ติดตั้ง พวก python-devel และ mysql-devel ก่อน
1. yum install python-devel mysql-devel

download MySQL-python version 1.2.5
2. wget https://pypi.python.org/packages/source/M/MySQL-python/MySQL-python-1.2.5.zip#md5=654f75b302db6ed8dc5a898c625e030c

เนื่องจากเป็นไฟล์ zip ต้องติดตั้ง unzip
3.  yum install unzip
4. unzip MySQL-python-1.2.5.zip
5. cd MySQL-python-1.2.5/

ทำการ build MySQL-python
6. python setup.py build

ทำการ install MySQL-python
7. python setup.py install


สำหรับติดตั้งไว้ใน virtualenv (tg2env)
ต้องเข้าคำสั่ง activate 
1. source tg2env/bin/activate

หลังจากทำการ build MySQL-python เสร็จแล้ว ทำการติดตั้งได้เลย
2. python setup.py install

จะทำการติดตั้ง library MySQL-python ไว้ใน tg2env


ที่มา:   https://pypi.python.org/pypi/MySQL-python/1.2.5
           http://sourceforge.net/projects/mysql-python/