MongoDB中string类型日期怎么改为MongoDB的ISODate类型 ？_course

我是在做csv文件里的数据导入到mongodb数据库中，程序要求是数据库中datetime列的类型为ISODate类型。 我要怎么在插入数据库前或者插入后将格式改为ISODate类型？？？ 或者可以用python的pandas模块怎么指定列的类型？？？ 又或者MongoDB 怎么把已经插入的String类型的日期（例："2017-02-06 21:00:10.500"）,改为MongoDB的ISODate类型（例：ISODate("2017-02-06T21:00:10Z")）？？？跪求解决方法

获取的地理位置（经纬度）如何存储到数据库？_course

百度地图获取的位置，需要注意哪些问题？比方是否考虑纬度编译的问题？

mongodb写入byte[]类型 4M左右数据很慢_course

int rows = 1000; int cols = 1000; float[,] data = new float[rows, cols]; var floatArray = DimensionManagerV2d0.Dimension2To1(rows, cols, 1, data); var byteArray = DataTypeManagerV2d0.ConvertFloat2ByteArray(floatArray); DateTime t1 = DateTime.Now; var entity = new Entity { ObserveTime = 201601010005, Data = byteArray }; MongoDbHelper.Save(MongoDbHelper.DefaultCollectionName, entity); string message = string.Format("写入耗时:{0}毫秒.", (DateTime.Now - t1).TotalMilliseconds); DateTime t2 = DateTime.Now; IMongoQuery query = Query<Entity>.EQ(t => t.Id, entity.Id); var queryData = MongoDbHelper.FindOne<Entity>(MongoDbHelper.DefaultCollectionName, query); message += string.Format("查询共耗时:{0}毫秒.", (DateTime.Now - t2).TotalMilliseconds); MessageBox.Show(message); 以上代码就是写入一个1000*1000的二维数组。写入和读取大概要1.5秒左右。那位可以处理一下应该一般情况下35毫秒能解决的。

php mongodb 可以批量更新同一字段为不同值？_course

如：根据id更新用户的年龄，不同的id对应不同的年龄，批量完成多条id的更新 就像mysql的如下操作： UPDATE mytable SET myfield = CASE id WHEN 1 THEN 'value1' WHEN 2 THEN 'value2' WHEN 3 THEN 'value3' END WHERE id IN (1,2,3) php中 mongodb 可以实现如上操作么？

php_mongo drive没有安装成功，class mongo not found_course

我成功安装了Mongodb，也成功启动了，但是在zend中编写程序时，使用Mongo对象都出现错误，显示class Mongo not found。 找了很多资料，在xampp中的php\ext添加了php_mongo.dll，也在php.ini中加入了extension=php_mongo.dll，重启了xampp的apache服务，还是不行，求各位大神帮我出出主意吧，多谢

MongoDB 线程长连接问题_course

我在使用MongoDB的过程当中，遇到如下问题：  我的MongoDB一直存在4个ESTABLISHED 连接，一直未释放，即使任务已经执行完了。 **代码如下，其中Client只会在系统启动的时候初始化一次，当然在系统停止contextDestroyed的时候Client也调用了close**： public class ExportServer extends BasicMongoServer { public final static Logger LOG = Logger.getLogger(ExportServer.class); public static MongoClient mongoClient; private static DB exportDB; private static DBCollection exportCollection; /** 初始化MongoDB Client */ public static void init(String add,String username,String password) throws UnknownHostException { ArrayList<ServerAddress> addr = new ArrayList<ServerAddress>(); for (String s : add.split(",")) { addr.add(new ServerAddress(s.trim())); } if (addr.size() > 1) { mongoClient = new MongoClient(addr, getOptions()); } else { mongoClient = new MongoClient(add, getOptions()); } mongoClient.setReadPreference(ReadPreference.secondaryPreferred()); exportDB = mongoClient.getDB("export"); exportDB.authenticate(username, password.toCharArray()); exportCollection = exportDB.getCollection("export"); if (exportCollection.getIndexInfo().size() == 0) { LOG.info("adding necessary indexes on export history collection"); BasicDBObject compoundIndex = new BasicDBObject(); compoundIndex.put("status", 1); exportCollection.ensureIndex(compoundIndex); compoundIndex.clear(); compoundIndex.put("key", 1); exportCollection.ensureIndex(compoundIndex); compoundIndex.clear(); compoundIndex.put("uid", 1); exportCollection.ensureIndex(compoundIndex); } } /** 更新document */ public static void update(DBObject query, DBObject update) { exportCollection.update(query, update); } /** 保存docuemnt */ public static void save(DBObject obj) { exportCollection.save(obj); } } } ``` 这些代码当中也没有什么特别操作，包括在应用停止的时候我也会将Client关闭 ``` 请问各位是否有任何建议或者解决思路。 谢谢。

mongo 聚合查询 分组，求最大值_course

数据 聚合查询实在是要了老命了，下面是模拟数据： ``` { "_id" : ObjectId("590c15751f70bd329f8a972d"), "_class" : "com.birdnest.model.AppPublish", "user" : "admin", "deviceType" : "nurse", "version" : "1.1。2。2", "message" : "范德萨312313213213范德萨", "creation" : ISODate("2017-05-05T06:02:29.300Z") } { "_id" : ObjectId("590c15751f70bd329f8a972e"), "_class" : "com.birdnest.model.AppPublish", "user" : "admin", "deviceType" : "nurse", "version" : "1.1。2。2", "message" : "范德萨312313213213范德萨", "creation" : ISODate("2017-05-05T06:02:29.447Z") } { "_id" : ObjectId("590c157b1f70bd329f8a972f"), "_class" : "com.birdnest.model.AppPublish", "user" : "admin", "deviceType" : "bed", "version" : "1.1。2。2", "message" : "范1123德萨312313213213范德萨", "creation" : ISODate("2017-05-05T06:02:35.731Z") } { "_id" : ObjectId("590c157c1f70bd329f8a9730"), "_class" : "com.birdnest.model.AppPublish", "user" : "admin", "deviceType" : "bed", "version" : "1.1。2。2", "message" : "范1123德萨312313213213范德萨", "creation" : ISODate("2017-05-05T06:02:36.164Z") } { "_id" : ObjectId("590c158a1f70bd329f8a9733"), "_class" : "com.birdnest.model.AppPublish", "user" : "admin", "deviceType" : "room", "version" : "1.1.112", "message" : "范1123德萨312313213213范德萨", "creation" : ISODate("2017-05-05T06:02:50.082Z") } { "_id" : ObjectId("590c158a1f70bd329f8a9734"), "_class" : "com.birdnest.model.AppPublish", "user" : "admin", "deviceType" : "room", "version" : "1.1.112", "message" : "范1123德萨312313213213范德萨", "creation" : ISODate("2017-05-05T06:02:50.238Z") } ``` 需求 按照deviceType分类，获得其中每个分类最新的一个版本号 结果举例 ``` /* 1 */ { "deviceType" : "bed", "version" :"1.1.112") } /* 2 */ { "deviceType" : "room", "version" :"1.1.112") } /* 3 */ { "deviceType" : "nurse", "version" : "1.1.112") } ```

PHP安装mongoDB驱动失败_course

我的xampp版本是5.6.8-0。PHP版本是5.6.8。MongoDB是2.6.8 我按照网上的教程将驱动文件安装在ext文件夹下面，并在php.ini文件中加入了路径：extension=php_mongo.dll。 但是启动之后还是看不到mongoDB，请问是什么问题？​​

php连接远程mongodb查询很慢_course

php连接远程mongodb查询很慢，查询数据量大概6000条，大概用了4秒。 求大神请教下，怎么连接远程monogdb，是代码问题还是需要配置什么？ $mongo = new MongoClient('mongodb://xx.xx.xx.xx:27017/test'); $filter['every_day'] = array('$gte' => "2017-01-01", '$lte' => "2017-09-30"); $cursor = $mongo->selectCollection('test', 'test')->find($filter); $data = []; $starttime = explode(' ', microtime()); foreach ($cursor as $id => $value) { $data[] = $value; } $endtime = explode(' ', microtime()); $thistime = $endtime[0] + $endtime[1] - ($starttime[0] + $starttime[1]); $thistime = round($thistime, 3); echo "执行耗时：" . $thistime . " 秒。";

如何在MongoDB中使用$ in查询中的ObjectId？_course

<div class="post-text" itemprop="text"> <p>I have the following query in MongoDB</p> <pre><code>$this-&gt;createQueryBuilder() -&gt;field('actor')-&gt;in($actorIdArray) -&gt;getQuery() -&gt;execute(); </code></pre> <p>where the field actor is an object reference with annotation</p> <pre><code>@MongoDB\ReferenceOne(targetDocument="User", simple=true) </code></pre> <p>which means it will store the object Id instead of the full reference.</p> <p>When $actorIdArray is an array of id with the form</p> <pre><code>["5706cb39821b166d3931f34f", "56015f7d4f8bd90b769e6e75"] </code></pre> <p>the query does not return nothing, which is the expected since the filed actor contains object id.</p> <p>However, if I build the array this way</p> <pre><code>[new MongoId("5706cb39821b166d3931f34f"), new MongoId("56015f7d4f8bd90b769e6e75")] </code></pre> <p>it doesn't work either, which is quite surprising for me.</p> <p>The log shows the query is made</p> <pre><code>{ "actor": {"$in":[{"$id":"5706cb39821b166d3931f34f"},{"$id":"56015f7d4f8bd90b769e6e75"}]}} </code></pre> <p>and I think it should be something like this</p> <pre><code>{ "actor": {"$in":[ObjectId("5706cb39821b166d3931f34f"),ObjectId("56015f7d4f8bd90b769e6e75"]}} </code></pre> <p>Not sure if I am doing something wrong, any ideas?</p> </div>

想问一个关于mongodb的问题，_course

在wamp中为php添加mongodb拓展，在php的phpinfo中已经出现了mongo的拓展支持，但是在我连接数据库的时候却不能完成连接，并且提示的错误为class mongo not found，在网上找了相关的资料，资料说是添加mongo拓展没有成功，但是在我的php里面确实出现了mongo了。贴图为证，，谁能帮忙解决一下问题，在此谢过了！

公告信息阅读记录，判断用户是否阅读进行记录_course

网站公告或是站内信那种，判断用户此条消息是否查阅怎么实现？ A方法： 消息ID：5662 记录表：xxx_log UID：335 用户查看了就添加一条信息 5662 +335 +时间 进入XXX——log表 但是这种方法的话感觉xxx_log 的压力比较大， 假如有十万个用户，一个月群发个几十条消息，那么占用资源就会很多， 如果删除记录表，那么用户进信箱看到就是所有的消息都是未阅读了

找不到错误'MongoDB \ Driver \ Manager'_course

<div class="post-text" itemprop="text"> <p>I'm trying to use MongoDB with PHP 7, but I'm getting the error 'MongoDB\Driver\Manager' not found</p> <p>I used $ composer require mongodb/mongodb to install, and my code is:</p> <pre><code>use MongoDB\Client; use MongoDB\Driver\Manager; class MongoDBSingleton extends AbstractSingleton { private $client; protected function __construct() { // $manager = new Manager("mongodb://localhost:27017"); // $manager = new \MongoDB\Driver\Manager("mongodb://localhost:27017"); // die(var_dump($manager)); $this-&gt;client = new Client("mongodb://localhost:27017"); } } </code></pre> <p>I triple checked php.ini where I used extension=mongodb.so and restarted apache</p> </div>

将mongoDB $ lookup与$ project结合使用_course

<div class="post-text" itemprop="text"> <p>Right now I'm using the $project aggregation for filtering out unnecessary fields. Also I'm using the $lookup aggregation to link two collections togethe and I know how to use both of them in the main collection. Now my question is; how can I put this $project aggregation inside of a lookup? What I have now is looks like this:</p> <pre><code>[ '$lookup' =&gt; [ 'from' =&gt; Media::collectionName(), 'localField' =&gt; '_id', 'foreignField' =&gt; 'project_id', 'as' =&gt; 'mediaList' ] ], [ '$project' =&gt; [ 'title' =&gt; 1, 'owner_id' =&gt; 1, 'owner_name' =&gt; 1, 'created_at' =&gt; 1, 'updated_at' =&gt; 1, 'status' =&gt; 1, 'discount' =&gt; 1, 'company' =&gt; 1, 'media' =&gt; [ '$filter' =&gt; [ 'input' =&gt; '$mediaList', 'as' =&gt; 'media', 'cond' =&gt; $mediaFilter ] ] ] ], </code></pre> <p>So I can filtering out the unnecessary fields in the main collection. How can I do this in the sub-collection?</p> </div>

无法在我的项目中安装“jenssegers / mongodb”_course

<div class="post-text" itemprop="text"> <p>I'm cloned my project from git repository and tried to install packages (composer install), but I get an error:</p> <pre><code>Problem 1 - jenssegers/mongodb v3.5.0 requires mongodb/mongodb ^1.0.0 -&gt; satisfiable by mongodb/mongodb[1.0.0, 1.0.0-alpha1, 1.0.0-beta1, 1.0.0-beta2, 1.0.1, 1.0.2, 1.0.3, 1.0.4, 1.0.5, 1.1.0, 1.1.0-alpha1, 1.1.1, 1.1.2, 1.2.0, 1.2.0-alpha1, 1.3.0, 1.3.1, 1.3.2, 1.4.0, 1.4.1, 1.4.2, 1.4.3, 1.5.x-dev, v1.0.x-dev, v1.1.x-dev, v1.2.x-dev, v1.3.x-dev, v1.4.x-dev]. - mongodb/mongodb v1.4.x-dev requires ext-mongodb ^1.5.0 -&gt; the requested PHP extension mongodb is missing from your system. </code></pre> <p>...</p> <pre><code>To enable extensions, verify that they are enabled in your .ini files: - /usr/local/etc/php/7.3/php.ini - /usr/local/etc/php/7.3/conf.d/ext-opcache.ini - /usr/local/etc/php/7.3/conf.d/php-memory-limits.ini You can also run `php --ini` inside terminal to see which files are used by PHP in CLI mode. Installation failed, reverting ./composer.json to its original content. </code></pre> <blockquote> <p>I added "extension=mongo.so" to "php.ini", but it didn't help. What I need to do for fix this?</p> </blockquote> <p><em>MacOS Mojave, Homebrew, Valet, php@7.3, lumen@5.6</em></p> </div>

Mongodb中映射的动态实体定义_course

<div class="post-text" itemprop="text"> <p><strong>Edit:</strong> Still working on my problem. I finally used @MongoDB\EmbedDocument to save the complex Document and it seems to be working as expected. Sadly, the retrieving part is not working very well. If i retrieve a very basic element, it goes very well. But as far as i use a EmbedDocument, i am retrieving extra data and methods that seems to be created by recursion and do not stop.</p> <p>Any idea ?</p> <hr> <p>I am currently facing a design issue in using MongoDB with Symfony2. My aim is to create a polymorph class that could allow me to register a Document with properties that can change from a Document to another.</p> <p>The idea is to use the MongoDB's schema-free approach to save object definitions that can be defined on-the fly.</p> <p>So, I created an abstract class to define my properties Type. I'll extend all my properties from that AbstractEntity, and get some formated basic property (String, Int, ...).</p> <pre><code>/** * @MongoDB\MappedSuperclass */ abstract class AbstractEntity { /** * @MongoDB\Id */ protected $id; /** * @MongoDB\String */ protected $name; /** * @MongoDB\String */ protected $type; /** * Every basic element has an ID * @return @MongoDB\Id */ public function getId() { return $this-&gt;id; } // Here are methods, getters and setters // ... } </code></pre> <p>Then, I created a class Document that is able to be extended with some basic properties I described earlier. My Document class contains an array of properties.</p> <pre><code>/** * @MongoDB\Document */ class Document extends AbstractEntity{ /** * @MongoDB\??? */ private $attributes = array(); public function __construct($name) { $this-&gt;setType(TYPE::DOCUMENT); $this-&gt;setName($name); } public function addAttribute($type, $name, $options = array()) { $attribute = $this-&gt;attributeFactory($type, $name, $options); array_push($this-&gt;attributes, $attribute); return $this; } private function attributeFactory($type, $name, $options = array()) { $entity = NULL; if( $type == TYPE::STRING) { $entity = new String($name); } return $entity; } } </code></pre> <p>From this work, i was hoping to be able to save in my database a single entry (a Document) that could describe a new document with its properties, something like:</p> <pre><code>{ "name" : "Character", "type" : "Document", "properties" : [ { "name": "alias", "type": "String" }, // ... ] } </code></pre> <p>Sadly, i am new on mongodb + symfony and i feel stuck because of the mapping, which is great but limited in an schema-free approach.</p> <p>Does anyone know how i could make that working or if i am going in the wrong direction ?</p> <p>In my idea, i would like to limit to split my document definition into a relational approach (not mongodb's spirit) from a document to multiple rows.</p> <p>I am open to any suggestion or discussion :) Thanks :)</p> </div>

Composer安装mongodb版本问题_course

<div class="post-text" itemprop="text"> <p>I want to install a package using composer for my PHP project.</p> <p>I tried this first:</p> <p><code>composer require jenssegers/mongodb --ignore-platform-reqs</code></p> <p>But it doesn't work with this method. Therefore, I removed the mongodb and after install again.</p> <p>But it doesn't work this method.</p> <pre><code>composer install Problem 1 - Installation request for mongodb/mongodb 1.4.2 -&gt; satisfiable by mongodb/mongodb[1.4.2]. - mongodb/mongodb 1.4.2 requires ext-mongodb ^1.5.0 -&gt; the requested PHP extension mongodb is missing from your system. Problem 2 - mongodb/mongodb 1.4.2 requires ext-mongodb ^1.5.0 -&gt; the requested PHP extension mongodb is missing from your system. - jenssegers/mongodb v3.5.0 requires mongodb/mongodb ^1.0.0 -&gt; satisfiable by mongodb/mongodb[1.4.2]. - Installation request for jenssegers/mongodb v3.5.0 -&gt; satisfiable by jenssegers/mongodb[v3.5.0]. </code></pre> </div>

mongodb写入每隔7分钟超时一波_course

求教大神，mongodb版本v3.6.13，分片集群，线上每隔7分钟左右就会有一波超时，有的写入超时高达10多秒，开发语言使用的php，感觉是mongodb内部的啥机制导致的

php7.1.19 安装 mongodb 扩展后无法加载_course

我的电脑mac oxs 10.13.6，PHP使用的XAMPP集成环境，PHP版本为7.1.19，php的bin目录已经添加至PATH，可直接执行php、pecl、phpize等命令，使用pecl命令已经成功安装redis扩展，并可以正常使用。后来用同样的方法，安装mongodb扩展，结果无效，然后到php官方网站下载mongodb-1.6.0alpha1.tgz文件，然后通过 pecl install 命令进行安装，已经提示成功，且PHP的extensions目录中已经成功生成了mongodb.so文件。安装成功后的截图如下图：  重启Apache后，通过phpinfo()无法看到mongodb被加载，然后去phperror_log里查看错误信息，发现有一条如下错误：  后来网上查了一下相关资料，说可能是openssl没有安装，然后查看了本地，已经确认openssl被安装，版本如下：  然后通过 pecl unstall mongodb 命令卸载已经安装的mongodb命令并重装其他版本的mongodb扩展，均提示安装成功，但是最终的结果都是无法通过phpinfo()查看到，并在phperror_log里打印了相同的日志信息。 请问各位大神，你们谁遇到过这种情况？应该如何解决？ 非常感谢。

MongoDB将ObjectId转换为结果中的字符串_course

<div class="post-text" itemprop="text"> <p>If document has fields with value as <code>MongoId</code> object, it will be returned to php something like <a href="http://dl.dropbox.com/u/7017985/Screenshots/26.jpg" rel="nofollow noreferrer">http://dl.dropbox.com/u/7017985/Screenshots/26.jpg</a>, is there any way how to return it like simple strings and not as <code>MongoId</code> object.</p> <p>Why I need it ? Because I need to send result to javascript browser side. I have document which has 2-3 fields which is refs to another document, and they keep as <code>ObjectId</code>. </p> </div>