hlmtre /
pybot
| @@ 79-94 (lines=16) @@ | ||
| 76 | except: |
|
| 77 | self._close() |
|
| 78 | return None |
|
| 79 | ||
| 80 | def e(self, sql): |
|
| 81 | try: |
|
| 82 | self._open() |
|
| 83 | self.cur.execute(sql) |
|
| 84 | if "INSERT" in sql or "REPLACE" in sql: |
|
| 85 | self.con.commit() |
|
| 86 | self._close() |
|
| 87 | elif "SELECT" in sql: |
|
| 88 | e = self.cur.fetchall() |
|
| 89 | self._close() |
|
| 90 | return e |
|
| 91 | except Exception, e: |
|
| 92 | print e |
|
| 93 | self.con.rollback() |
|
| 94 | self._close() |
|
| 95 | return None |
|
| 96 | ||
| 97 | def insert(self, where, which, what): |
|
| @@ 29-44 (lines=16) @@ | ||
| 26 | self.con = lite.connect(self.bot.conf.getNick(self.bot.network) + ".db", check_same_thread=False) |
|
| 27 | self.cur = self.con.cursor() |
|
| 28 | ||
| 29 | def e(self, sql): |
|
| 30 | try: |
|
| 31 | self._open() |
|
| 32 | self.cur.execute(sql) |
|
| 33 | if "INSERT" in sql or "REPLACE" in sql: |
|
| 34 | self.con.commit() |
|
| 35 | self.con.close() |
|
| 36 | elif "SELECT" in sql: |
|
| 37 | e = self.cur.fetchall() |
|
| 38 | self.con.close() |
|
| 39 | return e |
|
| 40 | except Exception, e: |
|
| 41 | print e |
|
| 42 | self.con.rollback() |
|
| 43 | self.con.close() |
|
| 44 | return None |
|
| 45 | ||
| 46 | def insertImg(self, user, url, channel): |
|
| 47 | self._open() |
|
