PythonMvcMySQL/Book.py at master · iandygit/PythonMvcMySQL · GitHub

Repository navigation

26 lines (21 loc) · 807 Bytes

# -*- coding: utf-8 *-*

__author__ = 'Gonzalo Chacaltana Buleje'

from MySQLConnection import MySQLConnection

class Book:

def __init__(self):

self.id_book = 0

self.id_category = ''

self.title = ''

self.price = ''

self.date_created = 'NOW()'

self.db = MySQLConnection()

def create(self):

"""create a new record"""

query = "INSERT INTO books (id_book, id_category,name,price,date_created) values (null, %s, %s, %s, NOW())"

values = (self.id_category, self.title, self.price)

self.db.execute(query, values)

self.db.commit(query)

def read_all(self):

query = "SELECT id_book,id_category,name FROM books;"

self.db.execute(query)

return self.db.get_fetch_rows()