def init(request):
query1 = query_create_table1("ex08_planets")
query2 = query_create_table2("ex08_people")
res1 = result_query_execute(query1)
res2 = result_query_execute(query2)
return render(request, "ex08.html", {'res1': res1, 'res2': res2})
def add_item(movie_id, text, table):
query = """UPDATE {} SET opening_crawl = '{}' WHERE episode_nb={}""".format(
table, text, movie_id)
res_up = result_query_execute(query)
return res_up
def init(request):
query = query_create_table("ex06_movies")
res = result_query_execute(query)
return HttpResponse(res)
def delete_item(movie_id, table):
query = """DELETE FROM {} WHERE episode_nb={}""".format(table, movie_id)
res_del = result_query_execute(query)
return res_del
def define_query(table):
query_post_list = [
(1, 'The Phantom Menace', 'George Lucas', 'Rick McCallum', '1999-05-19'),
(2, 'Attack of the Clones', 'George Lucas', 'Rick McCallum', '2002-05-16'),
(3, 'Revenge of the Sith', 'George Lucas', 'Rick McCallum', '2005-05-19'),
(4, 'A New Hope', 'George Lucas', 'Gary Kurtz, Rick McCallum', '1977-05-25'),
(5, 'The Empire Strikes Back', 'Irvin Kershner', 'Gary Kutz, Rick McCallum', '1980-05-17'),
(6, 'Return of the Jedi', 'Richard Marquand', 'Howard G. Kazanjian, Georges Lucas, Rick McCallum', '1983-05-25'),
(7, 'The Force Awakens', 'J. J Abrams', 'Kathleen Kennedy, J. J. Abrams, Bryan Burk', '2015-12-11')
]
string_results = ''
for query in query_post_list:
query_str = """
INSERT INTO {0}(episode_nb, title, director, producer, release_date) VALUES {1}
""".format(table, query)
res = str(result_query_execute(query_str))
if res == "OK":
string_results += "OK ----- {}<br>".format(query[1])
else:
string_results += "FAIL ---- {0:} : {1}<br>".format(query[1], res)
return string_results