databaseMgr.py 文件源码

def checkSQL(self,symbol):
        self.cursor.execute("SELECT name FROM sqlite_master WHERE type='table';")
        res = self.cursor.fetchall()[0]

        if symbol in res:
            for i in range(self.delta.days + 1):
                if (self.startDate + timedelta(days=i)).weekday() in [6, 7]:
                    continue
                self.cursor.execute("SELECT * FROM %s WHERE Date = %s" % (symbol, datetime.strftime(self.startDate + timedelta(days=i),"%Y-%m-%d")))
                r = self.cursor.fetchall()

                if r == []:
                    self.missing_data.append(symbol)
                    break
            self.included_data.append(symbol)
        else:
            self.missing_data.append(symbol)