def get_data(self):
params = dict(row_renderer=self.__row_renderer,
start_row=self.__start_row,
row_limit=self.__row_limit)
if self.__skip_row_func is not None:
params['skip_row_func'] = self.__skip_row_func
reader = QuerysetsReader(self.__query_sets, self.__column_names,
**params)
data = reader.to_array()
return {self.__sheet_name: data}
def test_one_table(self):
mysession = Session()
writer = SQLTableWriter(mysession,
[Pyexcel, self.data[0], None, None])
writer.write_array(self.data[1:])
writer.close()
query_sets = mysession.query(Pyexcel).all()
reader = QuerysetsReader(query_sets, self.data[0])
results = reader.to_array()
assert list(results) == self.results
mysession.close()
def test_one_table(self):
mysession = Session()
writer = SQLTableWriter(mysession,
[Pyexcel, self.data[0], None, None])
writer.write_array(self.data[1:])
writer.close()
query_sets = mysession.query(Pyexcel).all()
reader = QuerysetsReader(query_sets, self.data[0])
results = reader.to_array()
assert list(results) == self.results
mysession.close()
def test_one_table(self):
mysession = Session()
importer = SQLTableImporter(mysession)
adapter = SQLTableImportAdapter(Pyexcel)
adapter.column_names = self.data[0]
writer = SQLTableWriter(importer, adapter)
writer.write_array(self.data[1:])
writer.close()
query_sets = mysession.query(Pyexcel).all()
reader = QuerysetsReader(query_sets, self.data[0])
results = reader.to_array()
assert list(results) == self.results
mysession.close()
def test_one_table(self):
mysession = Session()
importer = SQLTableImporter(mysession)
adapter = SQLTableImportAdapter(Pyexcel)
adapter.column_names = self.data[0]
writer = SQLTableWriter(importer, adapter)
writer.write_array(self.data[1:])
writer.close()
query_sets = mysession.query(Pyexcel).all()
reader = QuerysetsReader(query_sets, self.data[0])
results = reader.to_array()
assert list(results) == self.results
mysession.close()