from database.mysql import MySQLDatabase from settings import db_config """ Retrieve the settings from the `db_config` dictionary to connect to our database so we can instantiate our MySQLDatabase object """ db = MySQLDatabase(db_config.get('db_name'), db_config.get('user'), db_config.get('pass'), db_config.get('host')) # Select a person from the people table person = db.select('people', named_tuples=True, where="id=2")[0] print person # Select all orders for that person orders = db.select('orders', named_tuples=True, where="person_id=%s" % person.id) print orders # Iterate over each order for order in orders: print order # Update the amount of each order db.update('orders', where="id=%s" % order.id, amount="20.02")
from database.mysql import MySQLDatabase from settings import db_config """ Retrieve the settings from the `db_config` dictionary to connect to our database so we can instantiate our MySQLDatabase object """ db = MySQLDatabase(db_config.get('db_name'), db_config.get('user'), db_config.get('pass'), db_config.get('host')) # Retrieve the first_name column and get the average # amount spent where the person.id = 1 people = db.select('people', columns=["first_name", "AVG(amount)" " AS average_spent"], named_tuples=True, where="people.id=1", join="orders ON people.id=orders.person_id") # Print the results in a format that # looks like - "<first_name> spends <average_amount>" for person in people: print person.first_name, "spends", person.average_spent
# -*- coding: utf-8 -*- from settings import db_config mysql_db = { 'host': 'localhost', 'user': db_config.get('interets_parlementaires', 'user'), 'passwd': db_config.get('interets_parlementaires', 'passwd'), 'db': db_config.get('interets_parlementaires', 'db'), 'port': 3306, 'use_unicode': True, 'charset': 'utf8', }
# -*- coding: utf-8 -*- from settings import db_config mysql_db = { 'db': db_config.get('nosdeputes', 'db'), 'kwargs': { 'host': 'localhost', 'user': db_config.get('nosdeputes', 'user'), 'passwd': db_config.get('nosdeputes', 'passwd'), 'port': 3306, 'use_unicode': True, 'charset': 'utf8', } }
# -*- coding: utf-8 -*- from settings import db_config mysql_db = { 'db': db_config.get('nossenateurs', 'db'), 'kwargs': { 'host': 'localhost', 'user': db_config.get('nossenateurs', 'user'), 'passwd': db_config.get('nossenateurs', 'passwd'), 'port': 3306, 'use_unicode': True, 'charset': 'utf8', } }