poseidon.py 文件源码

def on_insert_bookmarks(self, title, url):

        with bookmarks_con:    
            cur = bookmarks_con.cursor()
            cur.execute("SELECT * FROM bookmarks;")
            urls = cur.fetchall()

            if len(urls) != 0:
                for i in urls:
                    if url == i[1]:
                        return True

            cur.execute("INSERT INTO bookmarks VALUES(?, ?, ?);",\
            (title.replace("\n","").strip(), url, time.strftime("%Y-%m-%d %H:%M")))

            self.refresh_liststore(1)

            return True