def status_krs(): status = 0 cursor = koneksi.cursor() query = """SELECT set_8 FROM tb_setting WHERE set_5=%s""" % (aktiv) cursor.execute(query) data = cursor.fetchall() for d in data: status = d[0] return status
def prodi_mhs(idd): prodi_id = 0 cursor = koneksi.cursor() query = """SELECT prodi_1 FROM tb_mhs WHERE mhs_1=%s""" % (idd) cursor.execute(query) data = cursor.fetchall() for d in data: prodi_id = d[0] return prodi_id
def logo(): image = "" cursor = koneksi.cursor() query = """SELECT set_7 FROM tb_setting WHERE set_5=%s""" % (aktiv) cursor.execute(query) data = cursor.fetchall() for d in data: image = d[0] return image
def nm_univ(): univ = "" cursor = koneksi.cursor() query = """SELECT set_2 FROM tb_setting WHERE set_5=%s""" % (aktiv) cursor.execute(query) data = cursor.fetchall() for d in data: univ = d[0] return univ
def get_id_abl_kls(id_mhs, id_kls, tahun_ajaran, semester): cursor = koneksi.cursor() query = """SELECT abl_kls_1 FROM tb_ambil_kls WHERE mhs_1=%s AND kls_1=%s AND abl_kls_2=%s AND abl_kls_3=%s""" cursor.execute(query, (id_mhs, id_kls, tahun_ajaran, semester)) temp = cursor.fetchall() for t in temp: data = t[0] break return data
def smstr(): sem = "" cursor = koneksi.cursor() query = """SELECT set_4 FROM tb_setting WHERE set_5=%s""" % (aktiv) cursor.execute(query) data = cursor.fetchall() for d in data: sem = d[0] return sem
def get_id_dsn(idd): cursor = koneksi.cursor() query = """SELECT dsn_1 from tb_dosen WHERE usr_1=%s""" % (idd) cursor.execute(query) temp = cursor.fetchall() for t in temp: data = t[0] break return data
def thn_ajaran(): thn = "" cursor = koneksi.cursor() query = """SELECT set_3 FROM tb_setting WHERE set_5=%s""" % (aktiv) cursor.execute(query) data = cursor.fetchall() for d in data: thn = d[0] return thn
def profil_dsn(idd): data = () cursor = koneksi.cursor() query = """SELECT * FROM tb_dosen WHERE dsn_1=%s""" % (idd) cursor.execute(query) temp = cursor.fetchall() for i in temp: data = data + i return data
def profil_mhs(idd): data = () cursor = koneksi.cursor() query = """SELECT * FROM profil_mhs WHERE mhs_1=%s""" % (idd) cursor.execute(query) temp = cursor.fetchall() for i in temp: data = data + i return data
def get_id_user(idd): cursor = koneksi.cursor() print "SELECT usr_1 from tb_user WHERE usr_2='%s'" % (str(idd)) query = "SELECT usr_1 from tb_user WHERE usr_2='%s'" % (str(idd)) cursor.execute(query) temp = cursor.fetchall() for d in temp: data = d[0] break return data
def info_pilih_kelas(idd): data = () cursor = koneksi.cursor() query = """SELECT * FROM pilih_kelas WHERE kls_1=%s""" % (idd) cursor.execute(query) temp = cursor.fetchall() for i in temp: data = data + i return data
def modelku(): try: cursor = koneksi.cursor() query = """DELIMITER // \n CREATE PROCEDURE delete_dsn_usr (IN id_dosen INT) BEGIN DECLARE id_user int; SELECT tb_user.usr_1 INTO id_user FROM tb_user WHERE usr_6=id_dosen AND usr_4=3; DELETE FROM tb_user WHERE usr_1=id_user; \n END; //""" cursor.execute(query) koneksi.commit() cursor.close() except Exception as e: return {'error': str(e)} print query return query
def get_info(nm_tabel, kolom_tgl): terbaru = () jumlah = () hasil = () cursor = koneksi.cursor() query = """SELECT COUNT(%s) FROM %s""" % (kolom_tgl, nm_tabel) cursor.execute(query) data1 = cursor.fetchall() query = """SELECT * FROM %s ORDER BY %s DESC""" % (nm_tabel, kolom_tgl) cursor.execute(query) data2 = cursor.fetchall() for i in data1: jumlah = jumlah + (i) break for i in data2: terbaru = jumlah + (i) break hasil = hasil + (terbaru) return hasil