Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #IMportacion
- #IMPORT MSSQL TABLE TO MONGODB COLLECTION
- import pymssql
- from pymongo import Connection
- conn = Connection()
- db = conn.test
- coll = db.listado
- i=1
- conn2 = pymssql.connect(host='XXXX', user='XXXX', password='XXX', database='XXX', as_dict=True)
- cur = conn2.cursor()
- cur.execute('select top 2000000 * from dbo.sistema ')
- for row in cur:
- print "%d" % (i)
- i += 1
- testdatos = {"eventlog": row[0],
- "recordn": row[1],
- "comp": row[11],
- "eventid": row[4],
- "fecha": row[2],
- }
- coll.insert(testdatos)
- conn2.close()
- ######
- #Contar ocurrencias
- #db.listado.count({"comp": "STEIN"})
- #Select por campo desde mongoDB
- #db.listado.find({"comp": "STEIN"})
- #Select entre fechas desde mongoDB
- #db.listado.find({
- # fecha: {
- # $gte:ISODate("2010-01-25T00:11:17Z"),
- # $lt: ISODate("2010-01-25T00:12:17Z")
- # }
- # ,comp : "XXXXX"
- #})
Add Comment
Please, Sign In to add comment