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'))
# Get all te available tables for
# our database and print them out.
tables = db.get_available_tables()
print tables
columns = db.get_columns_for_table('articles')
print columns
if __name__ == "__main__":
"""
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'))
# Get all the available tables for
# our database annd print them out.
tables = db.get_available_tables()
print tables
# Get all the available columns for our
# articles table and print them out
columns = db.get_columns_for_table('people')
print columns
# Get all the records from
# the people table
results = db.select('people')
for row in results:
print row
import MySQLdb as _mysql
# To connect to we need to import the module and use it to create a connection instance
from database.mysql import MySQLDatabase
employees02_db = MySQLDatabase('employees02_db', 'root', '123root', 'localhost')
my_tables = employees02_db.get_available_tables()
print my_tables
my_select = employees02_db.select('employees')
print my_select
kwargs = {'where': "gender=M",
'order_by': 'emp_no'}
results = employees02_db.select('employees', columns=["concat('first_name', '' , 'last_name') as full_name"],
named_tuples=True, **kwargs)
print kwargs
'''
db = _mysql.connect(db='employees02_db',
host='localhost',
user='******',
passwd='123root')
from database.mysql import MySQLDatabase
my_db_connection = MySQLDatabase('employees_db',
'root',
'root')
my_tables = my_db_connection.get_available_tables()
my_col = my_db_connection.get_columns_for_table('dept_emp')
kwrgs = {'where': "emp_no-2"}
results = my_db_connection.select('dept_manager', columns=['em', 'first_name'], named_tuples=True, **kwrgs)
print results
print my_tables
print my_col
