def test_empty_with_query(self): input_file = six.StringIO() with stdin_as_string(input_file): output_file = six.StringIO() utility = CSVSQL(['--query', 'select 1'], output_file) utility.run() output_file.close() input_file.close()
def csvsql(self, csv_file, db=None): """ Load test data into the DB and return it as a string for comparison. """ if not db: db = 'sqlite:///' + self.db_file args = ['--db', db, '--table', 'foo', '--insert', csv_file] utility = CSVSQL(args) utility.run() with open(csv_file, 'r') as f: return f.read().strip()
def csvsql(self, csv_file, db=None): """ Load test data into the DB and return it as a string for comparison. """ if not db: db = 'sqlite:///' + self.db_file args = ['--db', db, '--tables', 'foo', '--insert', csv_file] utility = CSVSQL(args) utility.run() with open(csv_file, 'r') as f: text = f.read() return text.strip()