def show_msg(self):
limit_no = "90" # limit of msg
code1 = """SELECT time,msg FROM chatroom WHERE dbid = '{0}' Limit {1}""".format(
self.me, limit_no)
user_dir_single = user_single(self.other)
os.chdir(user_dir_single)
record1 = sql.sqlite_run("chatroom", code1)
user_dir_single = user_single(self.me)
os.chdir(user_dir_single)
code2 = """SELECT time,msg FROM chatroom WHERE dbid = '{0}' Limit {1}""".format(
self.other, limit_no)
record2 = sql.sqlite_run("chatroom", code2)
total = []
for i in record1:
date = datetime.datetime.strptime(i[0], '%Y-%m-%d %H:%M:%S.%f')
msg = i[1]
mark = "U"
to_d = [date, msg, mark]
total.append(to_d)
for i in record2:
date = datetime.datetime.strptime(i[0], '%Y-%m-%d %H:%M:%S.%f')
msg = i[1]
mark = "O"
to_d = [date, msg, mark]
total.append(to_d)
total.sort()
return total
def input_data(self, about, time):
self.time = time
self.about = about
dt = datetime.datetime.strptime(self.time, "%Y-%m-%dT%H:%M")
get_year = str(dt.year)
get_month = str(dt.month)
get_day = str(dt.day)
get_hour = str(dt.hour)
get_minutes = str(dt.minute)
get_second = "00"
time = "{0}/{1}/{2} {3}:{4}:{5}".format(get_month, get_day, get_year, get_hour, get_minutes, get_second)
print(time)
user_dir_single = user_single(self.database)
os.chdir(user_dir_single)
code = "SELECT no FROM reminder ORDER BY no DESC LIMIT 1;"
no = sql.sqlite_run("reminder", code)
if (len(no) == 0):
no = "1"
else:
no = str(no[0][0] + 1)
try:
sql.db_insert("reminder", "reminder", [["about", self.about], ["time", time], ["no", no]])
except Exception as a:
print(a)
def get_table_name(self, table_id):
user_dir_single = user_single(self.database)
os.chdir(user_dir_single)
table = sql.sqlite_run(
"money",
"""SELECT name FROM datas WHERE id={0};""".format(table_id))[0][0]
return table
def input_data(self, table_name, about, time, amount, status):
self.time = time
self.about = about
self.amount = amount
self.status = status
self.today = str(datetime.date.today())
dt = datetime.datetime.strptime(self.time, "%Y-%m-%dT%H:%M")
get_year = str(dt.month)
get_month = str(dt.year)
get_day = str(dt.day)
get_hour = str(dt.hour)
get_minutes = str(dt.minute)
get_second = "00"
time = "{0}/{1}/{2} {3}:{4}:{5}".format(get_month, get_day, get_year,
get_hour, get_minutes,
get_second)
user_dir_single = user_single(self.database)
os.chdir(user_dir_single)
code = "SELECT no FROM '{0}' ORDER BY no DESC LIMIT 1;".format(
table_name)
no = sql.sqlite_run("money", code)
if (len(no) == 0):
no = "1"
else:
no = str(no[0][0] + 1)
previous_hash = sql.sqlite_run(
"money",
"""SELECT hash FROM '{0}' order by no desc limit 1;""".format(
table_name))[0][0]
blo = Block()
blo.data = {
"about": self.about,
"time": time,
"status": self.status,
"amount": self.amount
}
blo.ts = self.today
blo.ph = previous_hash
try:
sql.db_insert(
"money", table_name,
[["about", self.about], ["entery_date", self.today],
["event_date", time], ["status", self.status],
["amount", self.amount], ["no", no],
["hash", blo.mh()], ["previous_hash", previous_hash]])
return "true"
except Exception as a:
return "false"
def show_databases_data(self):
data = []
user_dir_single = user_single(self.database)
os.chdir(user_dir_single)
code = """Select no,id,name from datas;"""
record = sql.sqlite_run("money", code)
record.reverse()
for i in record:
data.append([i[0], i[1], i[2]])
return data
def show_signature(self, table_name):
code = """
Select hash FROM '{0}' Order By no DESC LIMIT 1;
""".format(table_name)
user_dir_single = user_single(self.database)
os.chdir(user_dir_single)
record = sql.sqlite_run("money", code)
data = record[0][0]
return data[0:20]
def show_single_data(self, table_name):
data = []
user_dir_single = user_single(self.database)
os.chdir(user_dir_single)
code = """Select about,entery_date,event_date,status,amount,previous_hash,hash from '{0}';""".format(
table_name)
record = sql.sqlite_run("money", code)
record.reverse()
for i in record:
data.append([i[0], i[1], i[2], i[3], i[4], i[5], i[6]])
return data
def show_data(self):
data = []
user_dir_single = user_single(self.database)
os.chdir(user_dir_single)
code = """
Select * from reminder;
"""
record = sql.sqlite_run("reminder", code)
record.reverse()
for i in record:
data.append([i[0], i[1], str(i[2])])
return data
def show_data(self):
data = []
user_dir_single = user_single(self.database)
os.chdir(user_dir_single)
code = """Select url,img_name,no from certificate;"""
record = sql.sqlite_run("certificate", code)
record.reverse()
for i in record:
data.append([i[0], i[1], i[2]])
return data
# obj=Certificate("158624666524")
# obj.input_data("hello.png","http//5869.889;png")
# obj.delete(2)
def add_table(self, table_name):
user_dir_single = user_single(self.database)
os.chdir(user_dir_single)
code = """SELECT no FROM "datas" ORDER BY no DESC LIMIT 1;"""
no = sql.sqlite_run("money", code)
if (len(no) == 0):
no = "1"
else:
no = str(no[0][0] + 1)
try:
id = str(random.randrange(6887)) + str(
random.randrange(6887)) + str(random.randrange(6887))
sql.db_insert("money", "datas",
[["id", id], ["name", table_name], ["no", no]])
code = """ CREATE TABLE "{0}" (
"no" INTEGER NOT NULL UNIQUE,
"about" TEXT NOT NULL,
"entery_date" TEXT NOT NULL,
"event_date" TEXT NOT NULL,
"status" INTEGER,
"hash" TEXT NOT NULL,
"previous_hash" TEXT NOT NULL,
"amount" INTEGER NOT NULL,
PRIMARY KEY("no" AUTOINCREMENT)); """.format(id)
sql.sqlite_run("money", code)
sql.db_insert("money", id, [
["about", "AAAAAAAA"], ["entery_date", "2021-01-10"
], ["event_date", "1000/1/1 12:0:00"],
["status", 0], ["amount", 0], ["no", 1],
[
"hash",
"7e51e0a656a0805298ddf453ea1a2a714a2ba5362df89ad9f498a670a4ab1911"
], ["previous_hash", "AAAAAAA"]
])
return "true"
except Exception as a:
return "false"
def send_msg(self, msg):
code = """SELECT no FROM chatroom ORDER BY no DESC LIMIT 1;"""
user_dir_single = user_single(self.other)
os.chdir(user_dir_single)
no = sql.sqlite_run("chatroom", code)
if (len(no) == 0):
no = "1"
else:
no = str(no[0][0] + 1)
try:
time = str(datetime.datetime.now())
sql.db_insert(
"chatroom", "chatroom",
[["no", no], ["msg", msg], ["dbid", self.me], ["time", time]])
return "true"
except Exception as a:
return "false"
def delete(self, no):
self.no = tuple([int(no)])
code = "SELECT no FROM certificate;"
user_dir_single = user_single(self.database)
os.chdir(user_dir_single)
record = sql.sqlite_run("certificate", code)
if (self.no in record):
sql.row_delet("certificate", "certificate", "no", str(
(self.no)[0]))
return "true"
else:
return "false"
def delete(self, no):
self.no = tuple([int(no)])
user_dir_single = user_single(self.database)
os.chdir(user_dir_single)
code = "SELECT no FROM reminder;"
record = sql.sqlite_run("reminder", code)
if (self.no in record):
print(str((self.no)[0]))
sql.row_delet("reminder", "reminder", "no", str((self.no)[0]))
else:
pass
def input_data(self, img_name, url):
self.img_name = img_name
self.url = r"""{0}""".format(url)
user_dir_single = user_single(self.database)
os.chdir(user_dir_single)
code = "SELECT no FROM certificate ORDER BY no DESC LIMIT 1;"
no = sql.sqlite_run("certificate", code)
if (len(no) == 0):
no = "1"
else:
no = str(no[0][0] + 1)
try:
sql.db_insert(
"certificate", "certificate",
[["url", self.url], ["img_name", self.img_name], ["no", no]])
return "true"
except Exception as a:
return "false"
def delete_table_name(self, table_id):
user_dir_single = user_single(self.database)
os.chdir(user_dir_single)
sql.sqlite_run("money", """DROP TABLE "{0}";""".format(table_id))
sql.row_delet("money", "datas", "id", table_id)
return "true"