-
Notifications
You must be signed in to change notification settings - Fork 0
/
isla.py
120 lines (95 loc) · 4.19 KB
/
isla.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
import telebot
import mysql.connector
import mytoken
import calendar
import ast
import time
from telebot import apihelper
from telebot import types
from functools import wraps
from datetime import date
from datetime import datetime
from time import sleep
# from datetime import time
TOKEN = mytoken.TOKEN
isla = telebot.TeleBot(TOKEN)
tanggakskrng = date.today()
tanggalsekarang = date.today().strftime("%d %B, %Y")
tanggalwaktusekarang = datetime.now()
# database
myDbSiswa = mysql.connector.connect(host='localhost', user='root', password='', database='db_belajarbot')
sql = myDbSiswa.cursor() # untuk mengeksekusi perintah SQL atau query
class Isla:
def __init__(self):
self.message
#=================================================UTAMA=================================================================
@isla.message_handler(commands=["start"])
def start(message):
teksStart = mytoken.START + "\nhari ini tanggal ("+str(tanggalsekarang)+")\n" \
"hari ini adalah hari ("+calendar.day_name[tanggakskrng.weekday()]+")"
isla.send_chat_action(message.from_user.id, action='typing')
time.sleep(0.3)
isla.reply_to(message, teksStart)
@isla.message_handler(commands=['help'])
def help(message):
keyboard = telebot.types.InlineKeyboardMarkup()
keyboard.add(
telebot.types.InlineKeyboardButton('Hubungi developer saya', url = 't.me/Bayu_kartiko')
)
teksHelp = mytoken.HELP
isla.send_chat_action(message.from_user.id, action='typing')
time.sleep(0.3)
isla.reply_to(message, teksHelp, reply_markup=keyboard)
#====================================================COBA-COBA==========================================================
@isla.message_handler(commands=['about'])
def about(message):
teksAbout = mytoken.ABOUT
isla.send_chat_action(message.from_user.id, action='typing')
time.sleep(0.3)
isla.reply_to(message, teksAbout)
@isla.message_handler(commands=['pp'])
def foto(message):
markup = types.InlineKeyboardMarkup()
textFoto = 'Isla harap kamu kamu suka dengan foto Isla 🥰'
textFoto2 = 'tunggu sebentar yaa... Isla lagi foto selfie dulu nih 🤳'
textFoto3 = 'itu foto Isla.. aku harap kamu suka ^_^'
isla.reply_to(message, textFoto)
isla.send_chat_action(message.from_user.id, action='typing')
time.sleep(0.3)
isla.send_message(message.from_user.id, textFoto2)
photo = open('img/fotoBot.jpg', 'rb')
isla.send_chat_action(message.from_user.id, action='upload_photo')
time.sleep(1)
isla.send_photo(message.from_user.id, photo)
isla.send_chat_action(message.from_user.id, action='typing')
time.sleep(0.3)
isla.send_message(message.from_user.id, textFoto3)
#===============================================TUGAS===================================================================
@isla.message_handler(commands=['datasiswa'])
def datasiswa(message):
query = "select nipd,nama,kelas from tabel_siswa"
sql.execute(query)
data = sql.fetchall() # mengambil semua baris di database
jumlahData = sql.rowcount
kumpulanData = ''
if(jumlahData>0):
# print(data)
no = 0
for x in data:
no += 1
kumpulanData = kumpulanData + str(x)
print(kumpulanData)
kumpulanData = kumpulanData.replace('(', str(no)+".} ")
kumpulanData = kumpulanData.replace(')', '\n')
kumpulanData = kumpulanData.replace("'", '')
kumpulanData = kumpulanData.replace(",", '')
else:
print('data kosong')
# isla.send_message()
kirimData = "data siswa kelas XI RPL ada dibawah ini 👇👇\n\n" + str(kumpulanData)
isla.send_chat_action(message.from_user.id, action='typing')
time.sleep(0.5)
isla.reply_to(message, kirimData)
print(myDbSiswa)
print("bot sedang berjalan")
isla.polling(none_stop=True)