def Data(self):
mysql = connectToMySQL("friendsdb")
fname = request.form['first_name']
lname = request.form['last_name']
occ = request.form['occupation']
query = "INSERT INTO friends (first_name, last_name, occupation, created_at, updated_at) VALUES (%(first_name)s, %(last_name)s, %(occupation)s, NOW(), NOW());"
data = {'first_name': fname, 'last_name': lname, 'occupation': occ}
new_friend_id = mysql.query_db(query, data)
return new_friend_id
def addFriend(self):
mysql = connectToMySQL('crfriends')
query = "INSERT INTO friends (first_name, last_name, occupation, created_at, updated_at) VALUES (%(first_name)s, %(last_name)s, %(occupation)s, NOW(), NOW());"
data = {
'first_name': request.form['first_name'],
'last_name': request.form['last_name'],
'occupation': request.form['occupation']
}
new_friend_id = mysql.query_db(query, data)
return new_friend_id
def create(self):
mysql = connectToMySQL('friends')
query = 'INSERT INTO friends (first_name, last_name, occupation, created_at, updated_at) VALUES (%(first_name)s, %(last_name)s, %(occupation)s, NOW(), NOW());'
data = {
"first_name" : request.form['first_name'],
"last_name" : request.form['last_name'],
"occupation" : request.form['occupation']
}
result = mysql.query_db(query, data)
return result
def index(self):
mysql = connectToMySQL("friendsdb")
all_friends = mysql.query_db("SELECT * FROM friends")
return all_friends
def index(self):
mysql = connectToMySQL('crfriends')
query = "SELECT * FROM friends"
result = mysql.query_db(query)
return result
def Form(self):
mysql = connectToMySQL("friendsdb")
friends = mysql.query_db("SELECT * FROM friends")
return friends
def index(self):
mysql = connectToMySQL('friends')
result = mysql.query_db('select * from friends')
return result
