11 LOG_DB = "database/analytics_dat"
12 CACHE_DB = "database/urlcache_dat"
14 def login(otp, uname=""):
17 uname = raw_input("user: ")
18 except KeyboardInterrupt:
21 passwd = getpass.getpass("login password:")
22 except KeyboardInterrupt:
24 if not otp.login(uname, passwd):
25 sys.exit("login error!")
28 def prepare_database():
29 if os.path.exists(CACHE_DB):
31 con = sqlite3.connect(CACHE_DB)
35 create table sid_cache (
53 def get_story_info(otp, sid):
54 con = sqlite3.connect(CACHE_DB)
56 cur.execute("""select title from sid_cache where sid=?;""", (sid,) )
59 result = cur.fetchone()
61 tags = otp.get_tags("/magazine.sourceforge.jp/article.pl?sid=" + sid)
62 title = otp.get_title("/magazine.sourceforge.jp/article.pl?sid=" + sid)
63 cur.execute("""insert into sid_cache (sid, title) values (?, ?);""",
66 cur.execute("""insert into topics (sid, topic) values (?, ?);""",
71 cur.execute("""select topic from topics where sid=?""", (sid,))
80 usage = "%s [-c]" % sys.argv[0]
81 (optlist, args) = getopt.getopt(sys.argv[1:], "c")
83 if ('-c', '') in optlist:
88 otp = otptools2.otptools("./cookies.txt")
92 sys.stderr.write("cannot use cookie file. create.\n")
94 if otp.get_cookie() == "":
99 #test = "10/04/22/1028220"
100 #(title, tags) = get_story_info(otp, test)
104 if __name__ == '__main__':