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"