TYPO3: Extbase-Backend Module -> Copy DB-Table and Data -

i'm working on first typo3-project (typo3 6.1). developed csv-import works well, want backup table before import new data. thus, want copy table data.

my question, how can in right way? mentioned write method in repository-class (which extends extbase/perstistance/repository).

is good? how can access db-object there call custom sql-query?

thanks help!

you can use raw query

$query = $this->createquery(); $query->getquerysettings()->setreturnrawqueryresult(true); $query->statement(     'select order_id,product_name,qty     orders     outfile '/tmp/orders.csv'     fields terminated ','     enclosed '"'     lines terminated '\n'' ); return $query->execute();