Пример #1
0
    def to_table_data(self):
        from simplesqlite import SimpleSQLite
        from simplesqlite.query import AttrList

        con = SimpleSQLite(self._source_data, "r")

        for table in con.fetch_table_name_list():
            self.__table_name = table

            attr_name_list = con.fetch_attr_name_list(table)
            data_matrix = con.select(select=AttrList(attr_name_list),
                                     table_name=table).fetchall()

            yield TableData(table,
                            attr_name_list,
                            data_matrix,
                            dp_extractor=self._loader.dp_extractor)
Пример #2
0
#### fmz@84c5182edf5826492a308999d9d19667

from simplesqlite import SimpleSQLite
# from simplesqlite import Where


con = SimpleSQLite('bitmex','w')
table_name = 'bitmex_bar_1h'
print(con.fetch_table_name_list())