delete all documents in a particular database

[Jeff]

I am constantly need to clear a database and import record for testing. I am using smuggler.exe to do the import. however not sure how to delete all documents in a particular database in command line. 

Searched online and find this http://vpetroff.blogspot.com/2012/04/deleting-all-documents-in-ravendb.html. Not sure if this is just for a particular database? can how can I call deletebyindex from command line (dos batch file)?

Thanks. 

[Kijana Woodard]

For testing...can you just delete the data files.

[Kijana Woodard]

Meant ?, not .

[Oren Eini (Ayende Rahien)]

If you want to call it from the command line, you need to do it using curl, see the docs here:

http://ravendb.net/docs/http-api/http-api-multi

[Jeff]

there are other dbs there and I don't want to affect them.

in order to do this, need to stop the service, delete specific files(which files??), then restart the service.

[Jeff]

I see. so I need to define an index which return all docs in that database, then call the set delete method on that index. 

will try this out.

[Oren Eini (Ayende Rahien)]

DE:ETE /admin/datanases/db_name?hard-delete=true 

[Jeff]

I am still running stable build 888, is the 'hard-delete' in newer build?

[Oren Eini (Ayende Rahien)]

Yes, 1.2 

[Jeff]

what's the exactly syntax for the curl call?

I defined index "AllDocumentsByID", then tried following curl

curl -X DELETE http://localhost:85/databases/DBNAME/indexes/AllDocumentsByID

but this command deleted the index "AllDocumentsByID" iself, not the documents returned by the index.

[Kijana Woodard]

IIRC the data is in the tenants folder. So you can delete the unwanted db that way.

[Jeff]

Kijana,

that should works: stop service, delete folder, re-start service. and re-start the web asp.net app, so those index can re-populate...

it is just not that neat, all i want to do is delete documents, indexes and web app shouldn't be touched at all. 

bulk delete by index AllDocumentId should work, just need to figure out exact syntax.

Thanks.

[Justin A]

DELETE /admin/datanases/db_name?hard-delete=true 

Oh awesome! this will come in handy for things like RavenHQ (free) where we have a limited number of HD space.

is there an API for this? sesson.Advanced.DeleteAllTheThings("myTenant"); ?

[Oren Eini (Ayende Rahien)]

There isn't an API for that, but you can use:

But you can do:

var relativeUrl = "/admin/databases/" + databasesModel.SelectedDatabase.Name;

if (deleteDatabase.hardDelete.IsChecked == true)

relativeUrl += "?hard-delete=true";

var httpJsonRequest = asyncDatabaseCommands.CreateRequest(relativeUrl, "DELETE");

httpJsonRequest.ExecuteRequestAsync()

Note that this requires you to be admin.

[Chris Marisic]

You want Delete By Index, not delete index. There should be info on the http api docs.

My biggest fucked up with RavenDB was I once accidentally did delete by index, instead of delete index. That was a long long night recovering from that mistake.

[Matt Warren]

> My biggest fucked up with RavenDB was I once accidentally did delete by index, instead of delete index. That was a long long 

> night recovering from that mistake. 

Ouch!!!!

[Jeff]

I read the doc online in this page http://ravendb.net/docs/http-api/http-api-multi

looks I need to use something like this: DELETE http://localhost:8080/bulk_docs/UsersByActivityStatus?query=IsActive:False

I guess this is target to the default database. how do I do on a particular database? also in my case, there is no query. what's the syntax will be?

Thanks.

[Oren Eini (Ayende Rahien)]

DELETE http://localhost:8080/databases/your_db/bulk_docs/UsersByActivityStatus?query=IsActive:False

[Oren Eini (Ayende Rahien)]

With no query, you do something like:

DELETE http://localhost:8080/databases/your_db/bulk_docs/Raven/DocumentsByEntityName