def tekIndexGoster(id):
database = Db()
sql = """ select * from "BlogYazisi" where "Id" = %s """
data = database.read_data(sql, (id,))
sql2 = """ select * from "Yorum" where "BlogId" = %s """
data2 = database.read_data(sql2,(id,))
return render_template("anasayfa/indexDetay.html", data=data, iki=data2)
def save():
blogId = request.form.get("BlogId")
ekleyen = request.form.get("Ekleyen")
yorum = request.form.get("Yorum")
database = Db()
sql = """ insert into "Yorum" ("BlogId","Yorum","Ekleyen") values (%s,%s,%s) """
database.execute(sql, (blogId, yorum, ekleyen))
#return render_template("anasayfa/indexDetay.html")
return redirect("/anasayfa")
def login():
email = request.form.get("email")
sifre = request.form.get("sifre")
#sifre_hash = hashlib.md5(sifre.encode()).hexdigest()
databse = Db()
sql = """ select * from "User" where "Email"=%s and "Password"=%s """
find = databse.read_first_data(sql, (email, sifre))
if find is None:
return render_template("admin/giris/index.html", hata=True)
print(find)
session["FullName"] = find[3]
session["isLogin"] = True
session["Image"] = find[4]
return redirect("/anasayfa")
def index():
databse = Db()
sql = """ select * from "BlogYazisi" """
data = databse.read_data(sql)
data.sort(key = sort, reverse = True)
return render_template("anasayfa/index.html", data=data)
def __init__(self):
self.logger = logging.getLogger("DeleteDelete")
db = Db()
self.conn = db.getMySqlConnection()
def __init__(self):
self.logger = logging.getLogger("PostCheckpoint")
db = Db()
self.conn = db.getMySqlConnection()
def __init__(self):
self.logger = logging.getLogger("Authentication")
db = Db()
self.conn = db.getMySqlConnection()
def __init__(self):
#self.repository = Repository.Repository("chats")
self.logger = logging.getLogger("GetContent")
db = Db()
self.conn = db.getMySqlConnection()
