def main():
try:
database = DatabaseConnector(config.USER, config.PASSWORD, config.HOST,
config.DATABASE)
mysql_connect = database.mysql_open_connection()
sql = (
'SELECT article_id, title, received_date FROM article WHERE received_date BETWEEN %s AND %s'
)
received_date_start = datetime.date(2008, 1, 4)
received_date_end = datetime.date(2008, 3, 5)
paremeters = (received_date_start, received_date_end)
cursor, data = database.mysql_execute_cursor_select(
mysql_connect, sql, paremeters)
if cursor.rowcount > 0:
for row in data:
print(row[ArticleColumn.article_id.value],
row[ArticleColumn.title.value],
row[ArticleColumn.received_date.value],
sep='\t')
except:
exception_message = sys.exc_info()[0]
print("An error occurred. {}".format(exception_message))
finally:
database.mysql_close_cursor(cursor)
database.mysql_close_connection(mysql_connect)
def main():
try:
database = DatabaseConnector(config.USER, config.PASSWORD, config.HOST,
config.DATABASE)
mysql_connect = database.mysql_open_connection()
sql = ('DELETE FROM magazine_type WHERE magazine_type_id = %s')
paremeters = (9, )
database.mysql_execute_cursor_update(mysql_connect, sql, paremeters)
except:
exception_message = sys.exc_info()[0]
print("An error occurred. {}".format(exception_message))
finally:
database.mysql_close_connection(mysql_connect)
def open_mysql_database( user = None, password = None, host = None, db = None):
db = None
db_connect = None
try:
db = DatabaseConnector(config.USER, config.PASSWORD, config.HOST, config.DATABASE)
db_connect = db.mysql_open_connection()
except Exception as ex:
_logger.error('Unable to open the ' + config.DATABASE + ' database: ')
_logger.error(str(ex))
db = None
db_connect = None
return (db, db_connect)
def main():
try:
database = DatabaseConnector(config.USER, config.PASSWORD, config.HOST,
config.DATABASE)
mysql_connect = database.mysql_open_connection()
sql = (
'INSERT INTO magazine_type (type, description, notes, update_id) VALUES (%s, %s, %s, %s)'
)
paremeters = ('Lunix', 'The Lunix Magazine', 'The Notes', 300)
database.mysql_execute_cursor_update(mysql_connect, sql, paremeters)
except:
exception_message = sys.exc_info()[0]
print("An error occurred. {}".format(exception_message))
finally:
database.mysql_close_connection(mysql_connect)
def main():
try:
database = DatabaseConnector(config.USER, config.PASSWORD, config.HOST,
config.DATABASE)
mysql_connect = database.mysql_open_connection()
sql = (
"UPDATE magazine_type SET type = %s , description = %s, notes = %s, update_id = %s WHERE magazine_type_id = %s"
)
paremeters = ('Windows', 'The Windows IT Magazine', 'The Notes', 300,
14)
database.mysql_execute_cursor_update(mysql_connect, sql, paremeters)
except:
exception_message = sys.exc_info()[0]
print("An error occurred. {}".format(exception_message))
finally:
database.mysql_close_connection(mysql_connect)
def main():
try:
database = DatabaseConnector(config.USER, config.PASSWORD, config.HOST,
config.DATABASE)
mysql_connect = database.mysql_open_connection()
sql = (
'SELECT author_id, first_name, last_name, middle_name FROM author WHERE last_name LIKE %s ORDER BY first_name'
)
paremeters = ('%w%', )
cursor, data = database.mysql_execute_cursor_select(
mysql_connect, sql, paremeters)
if cursor.rowcount > 0:
for row in data:
print(row[ArticleColumn.article_id.value],
row[ArticleColumn.title.value],
row[ArticleColumn.received_date.value],
sep='\t')
except:
exception_message = sys.exc_info()[0]
print("An error occurred. {}".format(exception_message))
finally:
database.mysql_close_cursor(cursor)
database.mysql_close_connection(mysql_connect)
def get_author_info(first_name_parameters):
try:
database = DatabaseConnector(config.USER, config.PASSWORD, config.HOST,
config.DATABASE)
mysql_connect = database.mysql_open_connection()
sql = (
"SELECT author_id, first_name, last_name, middle_name FROM author WHERE first_name = %s"
)
paremeters = ('John', )
cursor, data = database.mysql_execute_cursor_select(
mysql_connect, sql, paremeters)
if cursor.rowcount > 0:
for row in data:
print(row[AuthorContact.author_id.value],
row[AuthorContact.first_name.value],
row[AuthorContact.last_name.value],
row[AuthorContact.middle_name.value],
sep='\t')
except:
exception_message = sys.exc_info()[0]
print("An error occurred. {}".format(exception_message))
finally:
database.mysql_close_cursor(cursor)
database.mysql_close_connection(mysql_connect)
active = 18
updated_id = 19
updated_date = 20
# author_id, first_name, last_name, middle_name, title, job_description, street_1, street_2, city,
# state_province, zip_code, country, phone, fax, email, website, picture, notes, active, updated_id, updated_date
# class DataEnum:
# author_id, first_name, last_name, middle_name, title, job_description, street_1, street_2, city, state_province, zip_code, country, phone, fax, email, website, picture, notes, active, updated_id, updated_date = range(0, 21)
if __name__ == '__main__':
try:
database = DatabaseConnector(config.USER, config.PASSWORD, config.HOST,
config.DATABASE)
mysql_connect = database.mysql_open_connection()
dataset = database.mysql_call_procedure_select(mysql_connect,
"usp_author_select")
for row in dataset:
print(row[AuthorColumn.author_id.value],
row[AuthorColumn.first_name.value],
row[AuthorColumn.last_name.value],
row[AuthorColumn.middle_name.value],
row[AuthorColumn.title.value],
row[AuthorColumn.job_description.value],
row[AuthorColumn.street_1.value],
row[AuthorColumn.street_2.value],
row[AuthorColumn.city.value],
row[AuthorColumn.state_province.value],
row[AuthorColumn.zip_code.value],
row[AuthorColumn.country.value],