Delete_mongo_collection.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Collections before removing:\n",
      "135 collections in 'data': \n",
      "LV1371_800V_light_external\n",
      "LV1371_830V_light_external\n",
      "LV1371_850V_light_external\n",
      "LV1371_870V_light_external\n",
      "LV1371_900V_light_external\n",
      "LV1388_830V_light_external\n",
      "LV1388_850V_light_external\n",
      "LV1388_870V_light_external\n",
      "LV1388_900V_background_external\n",
      "LV1388_900V_light_external\n",
      "LV1405_800V_light_external\n",
      "LV1405_830V_light_external\n",
      "LV1405_850V_light_external\n",
      "LV1405_870V_light_external\n",
      "LV1405_900V_background_external\n",
      "LV1405_900V_light_external\n",
      "LV1413_900V_background_external\n",
      "LV1418_800V_light_external\n",
      "LV1418_830V_light_external\n",
      "LV1418_850V_light_external\n",
      "LV1418_870V_light_external\n",
      "LV1418_900V_background_external\n",
      "LV1418_900V_light_external\n",
      "LV1418_900V_light_external_1\n",
      "LV1418_900V_light_external_2\n",
      "LV1418_900V_light_external_3\n",
      "LV1421_800V_light_external\n",
      "LV1421_830V_light_external\n",
      "LV1421_850V_light_external\n",
      "LV1421_870V_light_external\n",
      "LV1421_900V_light_external\n",
      "LV1439_800V_light_external\n",
      "LV1439_800V_light_external_1\n",
      "LV1439_800V_light_external_2\n",
      "LV1439_800V_light_external_3\n",
      "LV1439_830V_light_external\n",
      "LV1439_830V_light_external_1\n",
      "LV1439_830V_light_external_2\n",
      "LV1439_830V_light_external_3\n",
      "LV1439_850V_light_external\n",
      "LV1439_850V_light_external_1\n",
      "LV1439_850V_light_external_2\n",
      "LV1439_850V_light_external_3\n",
      "LV1439_870V_light_external\n",
      "LV1439_870V_light_external_1\n",
      "LV1439_870V_light_external_2\n",
      "LV1439_870V_light_external_3\n",
      "LV1439_900V_light_external\n",
      "LV1439_900V_light_external_1\n",
      "LV1439_900V_light_external_2\n",
      "LV1439_900V_light_external_3\n",
      "LV1439_900V_new_base\n",
      "LV1452_800V_light_external\n",
      "LV1452_830V_light_external\n",
      "LV1452_850V_light_external\n",
      "LV1452_870V_light_external\n",
      "LV1452_900V_light_external\n",
      "LV1702_750V_new_base\n",
      "LV1702_770V_new_base\n",
      "LV1702_800V_new_base\n",
      "LV1702_800V_new_base_bern\n",
      "LV1702_830V_light_external\n",
      "LV1702_850V_light_external\n",
      "LV1702_850V_new_base\n",
      "LV1702_870V_light_external\n",
      "LV1702_870V_new_base\n",
      "LV1702_900V_light_external\n",
      "LV1702_900V_new_base\n",
      "LV1707_800V_light_external\n",
      "LV1707_830V_light_external\n",
      "LV1707_850V_light_external\n",
      "LV1707_870V_light_external\n",
      "LV1707_900V_background\n",
      "LV1707_900V_light_external\n",
      "LV1707_900V_light_external_1\n",
      "LV1707_900V_light_external_2\n",
      "LV1707_900V_new_base\n",
      "LV1712_850V_light_external\n",
      "LV1712_870V_light_external\n",
      "LV1712_900V_light_external\n",
      "LV1712_900V_light_external_1\n",
      "LV1712_900V_light_external_2\n",
      "Warm_800V_no_vacuum_2min\n",
      "Warm_800V_no_vacuum_2min_3.45Vpp\n",
      "Warm_800V_no_vacuum_2min_3.55Vpp\n",
      "Warm_800V_no_vacuum_5min\n",
      "Xebra_PMT_cold_bot1400V_4.15_5min\n",
      "Xebra_PMT_cold_bot1450V_4.15_5min\n",
      "Xebra_PMT_cold_bot1500V_4.15_5min\n",
      "Xebra_PMT_cold_bot1550V_4.15_5min\n",
      "Xebra_PMT_cold_top770V_5min\n",
      "Xebra_PMT_cold_top800V_5min\n",
      "Xebra_PMT_cold_top800V_5min_1\n",
      "Xebra_PMT_cold_top830V_5min\n",
      "Xebra_PMT_cold_top830V_5min_1\n",
      "Xebra_PMT_cold_top850V_5min\n",
      "Xebra_PMT_cold_top850V_5min_1\n",
      "Xebra_PMT_cold_top850V_5min_2\n",
      "Xebra_PMT_cold_top870V_5min\n",
      "Xebra_PMT_cold_top870V_5min_1\n",
      "Xebra_PMT_cold_top900V_5min\n",
      "Xebra_PMT_cold_top900V_5min_1\n",
      "Xebra_PMT_warm_bot1400V_3.68_5min\n",
      "Xebra_PMT_warm_bot1450V_3.68_5min\n",
      "Xebra_PMT_warm_bot1500V_3.68_5min\n",
      "Xebra_PMT_warm_bot1550V_3.68_5min\n",
      "Xebra_PMT_warm_top800V_5min\n",
      "Xebra_PMT_warm_top830V_5min\n",
      "Xebra_PMT_warm_top850V_5min\n",
      "Xebra_PMT_warm_top870V_5min\n",
      "Xebra_PMT_warm_top900V_5min\n",
      "xebra_anode_2500\n",
      "xebra_anode_3000\n",
      "xebra_anode_3500\n",
      "xebra_anode_4000\n",
      "xebra_anode_4500\n",
      "xebra_anode_5000\n",
      "xebra_cathode_1000\n",
      "xebra_cathode_1200\n",
      "xebra_cathode_1400\n",
      "xebra_cathode_1600\n",
      "xebra_cathode_1800\n",
      "xebra_cathode_200\n",
      "xebra_cathode_2000\n",
      "xebra_cathode_2500\n",
      "xebra_cathode_3000\n",
      "xebra_cathode_3500\n",
      "xebra_cathode_400\n",
      "xebra_cathode_4000\n",
      "xebra_cathode_4500\n",
      "xebra_cathode_5000\n",
      "xebra_cathode_600\n",
      "xebra_cathode_800\n",
      "xebra_drift_test_2\n",
      "xebra_drift_test_6\n",
      "-------------- \n",
      "Collections after removing:\n",
      "135\n",
      "\n",
      "\n"
     ]
    }
   ],
   "source": [
    "import pymongo\n",
    "\n",
    "mongo_string = \"mongodb://daq:WIMPfinder@10.4.73.148:27017/admin\"\n",
    "db = \"data\"\n",
    "coll = \"a1\"  #type here the collection you want to remove\n",
    "\n",
    "client = pymongo.MongoClient(mongo_string)\n",
    "database = client[db]\n",
    "collection = database[coll]\n",
    "\n",
    "print(\"\\nCollections before removing:\")\n",
    "collections = sorted(database.collection_names())\n",
    "print(str(len(collections))+ \" collections in 'data': \")\n",
    "for coll in collections:\n",
    "    print(coll)\n",
    "collection.drop()\n",
    "print(\"-------------- \\nCollections after removing:\")\n",
    "print(str(len(database.collection_names())))\n",
    "print(\"\\n\")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}