`
gegewu0825
  • 浏览: 46579 次
社区版块
存档分类
最新评论

mongo 操作类封装

 
阅读更多

 

<?php

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */


class mongo_db {

    private $config;
    private $connection;
    private $db;
    private $connection_string;
    private $host;
    private $port;
    private $user;
    private $pass;
    private $dbname;
    private $persist;
    private $persist_key;
    private $selects = array();
    private $wheres = array();
    private $sorts = array();
    private $limit = 999999;
    private $offset = 0;
	private $timeout = 200;
	private $key = 0;
	/**     * 	--------------------------------------------------------------------------------	 *	CONSTRUCTOR	 *	--------------------------------------------------------------------------------	 *	 *	Automatically check if the Mongo PECL extension has been installed/enabled.	 *	Generate the connection string and establish a connection to the MongoDB.	 */

    public function __construct() {
        if((IS_NOSQL != 1)){
            return;
        }
        if (!class_exists('Mongo')) {
            //$this->error("The MongoDB PECL extension has not been installed or enabled", 500);
        }
		$configs =wxcity_base::load_config("cache","mongo_db");
		$num = count($configs['connect']);
		$this->timeout = trim($configs['timeout']);
		$keys = wxcity_base::load_config('double');
		$this->key = $keys['mongo_db'];
		$this->config = $configs['connect'][$this->key];
		$status = $this->connect();
		if($status == false)
		{
			for($i = 1; $i < $num; $i++)
			{
				$n = $this->key + $i;
				$key = $n >= $num ? $n - $num : $n;
				$this->config = $configs['connect'][$key]; 
				$status = $this->connect();
				if($status!=false)
				{
					$keys['mongo_db'] = $key ;
					$this->key = $key;
					$data = "<?php\nreturn ".var_export($keys, true).";\n?>";
					file_put_contents(WHTY_PATH.'configs/double.php', $data, LOCK_EX);
					break;
				}
			}
		}
		if($status==false)
		{
			die('mongoDB not connect');
		}
    }
	
	function __destruct() {
		if((IS_NOSQL != 1)){
            return;
		}
		if($this->connection)
		{
			$this->connection->close();
		}
	}
	
	    /**     * 	--------------------------------------------------------------------------------	 *	CONNECT TO MONGODB	 *	--------------------------------------------------------------------------------	 *	 *	Establish a connection to MongoDB using the connection string generated in	 *	the connection_string() method.  If 'mongo_persist_key' was set to true in the	 *	config file, establish a persistent connection.  We allow for only the 'persist'	 *	option to be set because we want to establish a connection immediately.	 */
    private function connect() {
		$this->connection_string();
        $options = array('connect'=>true,'timeout'=>$this->timeout);
		try {
			$this->connection = new Mongo($this->connection_string, $options);
			$this->db = $this->connection->{$this->dbname};
			return($this);
		} catch (MongoConnectionException $e) {
			return false;
		}
		
    }
    /**     * 	--------------------------------------------------------------------------------	 *	BUILD CONNECTION STRING	 *	--------------------------------------------------------------------------------	 *	 *	Build the connection string from the config file.	 */
    private function connection_string() {
        $this->host = trim($this->config['hostname']);
        $this->port = trim($this->config['port']);
        $this->user = trim($this->config['username']);
        $this->pass = trim($this->config['password']);
        $this->dbname = trim($this->config['database']);
        $this->persist = trim($this->config['autoconnect']);
        $this->persist_key = trim($this->config['mongo_persist_key']);
		
        $connection_string = "mongodb://";
        if (empty($this->host)) {
            $this->error("The Host must be set to connect to MongoDB", 500);
        } if (empty($this->dbname)) {
            $this->error("The Database must be set to connect to MongoDB", 500);
        } if (!empty($this->user) && !empty($this->pass)) {
            $connection_string .= "{$this->user}:{$this->pass}@";
        } if (isset($this->port) && !empty($this->port)) {
            $connection_string .= "{$this->host}:{$this->port}";
        } else {
            $connection_string .= "{$this->host}";
        } $this->connection_string = trim($connection_string);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	Switch_db	 *	--------------------------------------------------------------------------------	 *	 *	Switch from default database to a different db	 */
    public function switch_db($database = '') {
        if (empty($database)) {
            $this->error("To switch MongoDB databases, a new database name must be specified", 500);
        } $this->dbname = $database;
        try {
            $this->db = $this->connection->{$this->dbname};
            return(TRUE);
        } catch (Exception $e) {
            $this->error("Unable to switch Mongo Databases: {$e->getMessage()}", 500);
        }
    }

    /**     * 	--------------------------------------------------------------------------------	 *	SELECT FIELDS	 *	--------------------------------------------------------------------------------	 *	 *	Determine which fields to include OR which to exclude during the query process.	 *	Currently, including and excluding at the same time is not available, so the 	 *	$includes array will take precedence over the $excludes array.  If you want to 	 *	only choose fields to exclude, leave $includes an empty array().	 *	 *	@usage: $this->mongo_db->select(array('foo', 'bar'))->get('foobar');	 */
    public function select($includes = array(), $excludes = array()) {
        if (!is_array($includes)) {
            $includes = array();
        } 
        if (!is_array($excludes)) {
            $excludes = array();
        } 
        if (!empty($includes)) {
            foreach ($includes as $col) {
                $this->selects[$col] = 1;
            }
        } else {
            foreach ($excludes as $col) {
                $this->selects[$col] = 0;
            }
        } return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	WHERE PARAMETERS	 *	--------------------------------------------------------------------------------	 *	 *	Get the documents based on these search parameters.  The $wheres array should 	 *	be an associative array with the field as the key and the value as the search	 *	criteria.	 *	 *	@usage = $this->mongo_db->where(array('foo' => 'bar'))->get('foobar');	 */
    public function where($wheres = array()) {
        foreach ((array)$wheres as $wh => $val) {
            $this->wheres[$wh] = $val;
        } return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	WHERE_IN PARAMETERS	 *	--------------------------------------------------------------------------------	 *	 *	Get the documents where the value of a $field is in a given $in array().	 *	 *	@usage = $this->mongo_db->where_in('foo', array('bar', 'zoo', 'blah'))->get('foobar');	 */
    public function where_in($field = "", $in = array()) {
        $this->where_init($field);
        $this->wheres[$field]['$in'] = $in;
        return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	WHERE_NOT_IN PARAMETERS	 *	--------------------------------------------------------------------------------	 *	 *	Get the documents where the value of a $field is not in a given $in array().	 *	 *	@usage = $this->mongo_db->where_not_in('foo', array('bar', 'zoo', 'blah'))->get('foobar');	 */
    public function where_not_in($field = "", $in = array()) {
        $this->where_init($field);
        $this->wheres[$field]['$nin'] = $in;
        return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	WHERE GREATER THAN PARAMETERS	 *	--------------------------------------------------------------------------------	 *	 *	Get the documents where the value of a $field is greater than $x	 *	 *	@usage = $this->mongo_db->where_gt('foo', 20);	 */
    public function where_gt($field = "", $x) {
        $this->where_init($field);
        $this->wheres[$field]['$gt'] = $x;
        return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	WHERE GREATER THAN OR EQUAL TO PARAMETERS	 *	--------------------------------------------------------------------------------	 *	 *	Get the documents where the value of a $field is greater than or equal to $x	 *	 *	@usage = $this->mongo_db->where_gte('foo', 20);	 */
    public function where_gte($field = "", $x) {
        $this->where_init($field);
        $this->wheres[$field]['$gte'] = $x;
        return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	WHERE LESS THAN PARAMETERS	 *	--------------------------------------------------------------------------------	 *	 *	Get the documents where the value of a $field is less than $x	 *	 *	@usage = $this->mongo_db->where_lt('foo', 20);	 */
    public function where_lt($field = "", $x) {
        $this->where_init($field);
        $this->wheres[$field]['$lt'] = $x;
        return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	WHERE LESS THAN OR EQUAL TO PARAMETERS	 *	--------------------------------------------------------------------------------	 *	 *	Get the documents where the value of a $field is less than or equal to $x	 *	 *	@usage = $this->mongo_db->where_lte('foo', 20);	 */
    public function where_lte($field = "", $x) {
        $this->where_init($field);
        $this->wheres[$field]['$lte'] = $x;
        return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	WHERE BETWEEN PARAMETERS	 *	--------------------------------------------------------------------------------	 *	 *	Get the documents where the value of a $field is between $x and $y	 *	 *	@usage = $this->mongo_db->where_between('foo', 20, 30);	 */
    public function where_between($field = "", $x, $y) {
        $this->where_init($field);
        $this->wheres[$field]['$gte'] = $x;
        $this->wheres[$field]['$lte'] = $y;
        return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	WHERE BETWEEN AND NOT EQUAL TO PARAMETERS	 *	--------------------------------------------------------------------------------	 *	 *	Get the documents where the value of a $field is between but not equal to $x and $y	 *	 *	@usage = $this->mongo_db->where_between_ne('foo', 20, 30);	 */
    public function where_between_ne($field = "", $x, $y) {
        $this->where_init($field);
        $this->wheres[$field]['$gt'] = $x;
        $this->wheres[$field]['$lt'] = $y;
        return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	WHERE NOT EQUAL TO PARAMETERS	 *	--------------------------------------------------------------------------------	 *	 *	Get the documents where the value of a $field is not equal to $x	 *	 *	@usage = $this->mongo_db->where_between('foo', 20, 30);	 */
    public function where_ne($field = "", $x) {
        $this->where_init($field);
        $this->wheres[$field]['$ne'] = $x;
        return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	WHERE OR	 *	--------------------------------------------------------------------------------	 *	 *	Get the documents where the value of a $field is in one or more values	 *	 *	@usage = $this->mongo_db->where_or('foo', array( 'foo', 'bar', 'blegh' );	 */
    public function where_or($field = "", $values) {
        $this->where_init($field);
        $this->wheres[$field]['$or'] = $values;
        return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	WHERE AND	 *	--------------------------------------------------------------------------------	 *	 *	Get the documents where the elements match the specified values	 *	 *	@usage = $this->mongo_db->where_and( array ( 'foo' => 1, 'b' => 'someexample' );	 */
    public function where_and($elements_values = array()) {
        foreach ((array)$elements_values as $element => $val) {
            $this->wheres[$element] = $val;
        } return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	WHERE MOD	 *	--------------------------------------------------------------------------------	 *	 *	Get the documents where $field % $mod = $result	 *	 *	@usage = $this->mongo_db->where_mod( 'foo', 10, 1 );	 */
    public function where_mod($field, $num, $result) {
        $this->where_init($field);
        $this->wheres[$field]['$mod'] = array($num, $result);
        return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	*	Where size	*	--------------------------------------------------------------------------------	*	*	Get the documents where the size of a field is in a given $size int	*	*	@usage : $this->mongo_db->where_size('foo', 1)->get('foobar');	 */
    public function where_size($field = "", $size = "") {
        $this->_where_init($field);
        $this->wheres[$field]['$size'] = $size;
        return ($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	LIKE PARAMETERS	 *	--------------------------------------------------------------------------------	 *		 *	Get the documents where the (string) value of a $field is like a value. The defaults	 *	allow for a case-insensitive search.	 *	 *	@param $flags	 *	Allows for the typical regular expression flags:	 *		i = case insensitive	 *		m = multiline	 *		x = can contain comments	 *		l = locale	 *		s = dotall, "." matches everything, including newlines	 *		u = match unicode	 *	 *	@param $enable_start_wildcard	 *	If set to anything other than TRUE, a starting line character "^" will be prepended	 *	to the search value, representing only searching for a value at the start of 	 *	a new line.	 *	 *	@param $enable_end_wildcard	 *	If set to anything other than TRUE, an ending line character "$" will be appended	 *	to the search value, representing only searching for a value at the end of 	 *	a line.	 *	 *	@usage = $this->mongo_db->like('foo', 'bar', 'im', FALSE, TRUE);	 */
    public function like($field = "", $value = "", $flags = "i", $enable_start_wildcard = TRUE, $enable_end_wildcard = TRUE) {
        $field = (string) trim($field);
        $this->where_init($field);
        $value = (string) trim($value);
        $value = quotemeta($value);
        if ($enable_start_wildcard !== TRUE) {
            $value = "^" . $value;
        } if ($enable_end_wildcard !== TRUE) {
            $value .= "$";
        } $regex = "/$value/$flags";
        $this->wheres[$field] = new MongoRegex($regex);
        return($this);
    }

    public function wheres($where){
        $this->wheres = $where;
    }

    /**     * 	--------------------------------------------------------------------------------	 *	ORDER BY PARAMETERS	 *	--------------------------------------------------------------------------------	 *	 *	Sort the documents based on the parameters passed. To set values to descending order,	 *	you must pass values of either -1, FALSE, 'desc', or 'DESC', else they will be	 *	set to 1 (ASC).	 *	 *	@usage = $this->mongo_db->where_between('foo', 20, 30);	 */
    public function order_by($fields = array()) {
		if (!is_array($fields) || !count($fields)) return ;
        foreach ($fields as $col => $val) {
            if ($val == -1 || $val === FALSE || strtolower($val) == 'desc') {
                $this->sorts[$col] = -1;
            } else {
                $this->sorts[$col] = 1;
            }
        } return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	LIMIT DOCUMENTS	 *	--------------------------------------------------------------------------------	 *	 *	Limit the result set to $x number of documents	 *	 *	@usage = $this->mongo_db->limit($x);	 */
    public function limit($x = 99999) {
        if ($x !== NULL && is_numeric($x) && $x >= 1) {
            $this->limit = (int) $x;
        } return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	OFFSET DOCUMENTS	 *	--------------------------------------------------------------------------------	 *	 *	Offset the result set to skip $x number of documents	 *	 *	@usage = $this->mongo_db->offset($x);	 */
    public function offset($x = 0) {
        if ($x !== NULL && is_numeric($x) && $x >= 1) {
            $this->offset = (int) $x;
        } return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	GET_WHERE	 *	--------------------------------------------------------------------------------	 *	 *	Get the documents based upon the passed parameters	 *	 *	@usage = $this->mongo_db->get_where('foo', array('bar' => 'something'));	 */
    public function get_where($collection = "", $where = array(), $limit = 99999, $orderby=array()) {
        if (is_array($orderby) || !empty($orderby)) {
            $order_by = $this->order_by($order_by);
        }
        return($this->where($where)->limit($limit)->get($collection));
    }
    public function selectA($collection = "", $limit = 99999, $orderby=array()) {
        if(intval($limit)<1){
            $limit = 999999;
        }
        $order_by = $this->order_by($orderby);
        $re = $this->limit($limit)->get($collection);
        $this->clear();
        return (array)$re;
    }

    public function listinfo($collection = "", $orderby=array(), $page=1, $pagesize=12) {
        $page = max(intval($page), 1);
        $offset = $pagesize * ($page - 1);
        $pagesizes = $offset + $pagesize;
        $this->offset($offset);
        $order_by = $this->order_by($orderby);
        $re = $this->limit($pagesize)->get($collection);
        $this->limit(999999);
        $count = $this->count($collection);
        $this->pages = pages($count, $page, $pagesize);
        return (array)$re;
    }

    /**     * 	--------------------------------------------------------------------------------	 *	GET	 *	--------------------------------------------------------------------------------	 *	 *	Get the documents based upon the passed parameters	 *	 *	@usage = $this->mongo_db->get('foo', array('bar' => 'something'));	 */
    public function get($collection = "") {
        if (empty($collection)) {
            $this->error("In order to retreive documents from MongoDB, a collection name must be passed", 500);
        } $results = array();
        $documents = $this->db->{$collection}->find($this->wheres, $this->selects)->limit((int) $this->limit)->skip((int) $this->offset)->sort($this->sorts);
        $returns = array();
        foreach ($documents as $doc): $returns[] = $doc;
        endforeach;
        return($returns);
    }

	public function getMy($collection = "") {
        if (empty($collection)) {
            $this->error("In order to retreive documents from MongoDB, a collection name must be passed", 500);
        } $results = array();
        $documents = $this->db->{$collection}->find($this->wheres, $this->selects)->limit((int) $this->limit)->skip((int) $this->offset)->sort($this->sorts);
        $returns = array();
        foreach ($documents as $doc): $returns[] = $doc;
        endforeach;
		$this -> clear();
        return($returns);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	COUNT	 *	--------------------------------------------------------------------------------	 *	 *	Count the documents based upon the passed parameters	 *	 *	@usage = $this->mongo_db->get('foo');	 */
    public function count($collection = "") {
        if (empty($collection)) {
            $this->error("In order to retreive a count of documents from MongoDB, a collection name must be passed", 500);
        } $count = $this->db->{$collection}->find($this->wheres)->limit((int) $this->limit)->skip((int) $this->offset)->count();
        $this->clear();
        return($count);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	INSERT	 *	--------------------------------------------------------------------------------	 *	 *	Insert a new document into the passed collection	 *	 *	@usage = $this->mongo_db->insert('foo', $data = array());	 */
    public function insert($collection = "", $data = array(), $name='ID') {
        if (empty($collection)) {
            $this->error("No Mongo collection selected to insert into", 500);
        } if (count($data) == 0 || !is_array($data)) {
            $this->error("Nothing to insert into Mongo collection or insert is not an array", 500);
        } try {
		/**
			wxcity_base::load_sys_class('whtysqs','',0); 
			$mongoseq_class = new whtysqs('creaseidsqs');
            $re = $mongoseq_class->query("?name=" . $collection . "&opt=put&data=1");
		**/
			$re = put_sqs('list_mongo_creaseidsqs','1');
			if(is_numeric($re)){
				$re++;
				$data[$name] = intval($re);
            }else{
				$data[$name] = intval(time());
                //die('mongosqs error');
            }
            $this->db->{$collection}->insert($data, array('fsync' => TRUE)); 
            $this->clear();
            return $data[$name];
        } catch (MongoCursorException $e) {
            $this->error("Insert of data into MongoDB failed: {$e->getMessage()}", 500);
        }
    }

	public function insertWithId($collection = "", $data = array()) {
        if (empty($collection)) {
            $this->error("No Mongo collection selected to insert into", 500);
        } if (count($data) == 0 || !is_array($data)) {
            $this->error("Nothing to insert into Mongo collection or insert is not an array", 500);
        } try {
            $this->db->{$collection}->insert($data, array('fsync' => TRUE)); 
            $this->clear();
            return 1;
        } catch (MongoCursorException $e) {
            $this->error("Insert of data into MongoDB failed: {$e->getMessage()}", 500);
        }
    }
    /**     * 	--------------------------------------------------------------------------------	 *	UPDATE	 *	--------------------------------------------------------------------------------	 *	 *	Update a document into the passed collection	 *	 *	@usage = $this->mongo_db->update('foo', $data = array());	 */
    public function update($collection = "", $data = array()) {
        if (empty($collection)) {
            $this->error("No Mongo collection selected to update", 500);
        } if (count($data) == 0 || !is_array($data)) {
            $this->error("Nothing to update in Mongo collection or update is not an array", 500);
        } try {
            $this->db->{$collection}->update($this->wheres, array('$set' => $data), array('fsync' => TRUE, 'multiple' => FALSE));
			$this->clear();
            return(TRUE);
        } catch (MongoCursorException $e) {
            $this->error("Update of data into MongoDB failed: {$e->getMessage()}", 500);
        }
    }

    /**     * 	--------------------------------------------------------------------------------	 *	UPDATE_ALL	 *	--------------------------------------------------------------------------------	 *	 *	Insert a new document into the passed collection	 *	 *	@usage = $this->mongo_db->update_all('foo', $data = array());	 */
    public function update_all($collection = "", $data = array()) {
        if (empty($collection)) {
            $this->error("No Mongo collection selected to update", 500);
        } if (count($data) == 0 || !is_array($data)) {
            $this->error("Nothing to update in Mongo collection or update is not an array", 500);
        } try {
            $this->db->{$collection}->update($this->wheres, array('$set' => $data), array('fsync' => TRUE, 'multiple' => TRUE));
            return(TRUE);
        } catch (MongoCursorException $e) {
            $this->error("Update of data into MongoDB failed: {$e->getMessage()}", 500);
        }
    }

    /**     * 	--------------------------------------------------------------------------------	 *	DELETE	 *	--------------------------------------------------------------------------------	 *	 *	delete document from the passed collection based upon certain criteria	 *	 *	@usage = $this->mongo_db->delete('foo', $data = array());	 */
    public function delete($collection = "") {
        if (empty($collection)) {
            $this->error("No Mongo collection selected to delete from", 500);
        } try {
            $this->db->{$collection}->remove($this->wheres, array('fsync' => TRUE, 'justOne' => TRUE));
            $this->clear();
            return(TRUE);
        } catch (MongoCursorException $e) {
            $this->error("Delete of data into MongoDB failed: {$e->getMessage()}", 500);
        }
    }

    /**     * 	--------------------------------------------------------------------------------	 *	DELETE_ALL	 *	--------------------------------------------------------------------------------	 *	 *	Delete all documents from the passed collection based upon certain criteria	 *	 *	@usage = $this->mongo_db->delete_all('foo', $data = array());	 */
    public function delete_all($collection = "") {
        if (empty($collection)) {
            $this->error("No Mongo collection selected to delete from", 500);
        } try {
            $this->db->{$collection}->remove($this->wheres, array('fsync' => TRUE, 'justOne' => FALSE));
            return(TRUE);
        } catch (MongoCursorException $e) {
            $this->error("Delete of data into MongoDB failed: {$e->getMessage()}", 500);
        }
    }

    /**     * 	--------------------------------------------------------------------------------	 *	ADD_INDEX	 *	--------------------------------------------------------------------------------	 *	 *	Ensure an index of the keys in a collection with optional parameters. To set values to descending order,	 *	you must pass values of either -1, FALSE, 'desc', or 'DESC', else they will be	 *	set to 1 (ASC).	 *	 *	@usage = $this->mongo_db->add_index($collection, array('first_name' => 'ASC', 'last_name' => -1), array('unique' => TRUE));	 */
    public function add_index($collection = "", $keys = array(), $options = array()) {
        if (empty($collection)) {
            $this->error("No Mongo collection specified to add index to", 500);
        } if (empty($keys) || !is_array($keys)) {
            $this->error("Index could not be created to MongoDB Collection because no keys were specified", 500);
        } foreach ($keys as $col => $val) {
            if ($val == -1 || $val === FALSE || strtolower($val) == 'desc') {
                $keys[$col] = -1;
            } else {
                $keys[$col] = 1;
            }
        } if ($this->db->{$collection}->ensureIndex($keys, $options) == TRUE) {
            $this->clear();
            return($this);
        } else {
            $this->error("An error occured when trying to add an index to MongoDB Collection", 500);
        }
    }

    /**     * 	--------------------------------------------------------------------------------	 *	REMOVE_INDEX	 *	--------------------------------------------------------------------------------	 *	 *	Remove an index of the keys in a collection. To set values to descending order,	 *	you must pass values of either -1, FALSE, 'desc', or 'DESC', else they will be	 *	set to 1 (ASC).	 *	 *	@usage = $this->mongo_db->remove_index($collection, array('first_name' => 'ASC', 'last_name' => -1));	 */
    public function remove_index($collection = "", $keys = array()) {
        if (empty($collection)) {
            $this->error("No Mongo collection specified to remove index from", 500);
        } if (empty($keys) || !is_array($keys)) {
            $this->error("Index could not be removed from MongoDB Collection because no keys were specified", 500);
        } if ($this->db->{$collection}->deleteIndex($keys, $options) == TRUE) {
            $this->clear();
            return($this);
        } else {
            $this->error("An error occured when trying to remove an index from MongoDB Collection", 500);
        }
    }

    /**     * 	--------------------------------------------------------------------------------	 *	REMOVE_ALL_INDEXES	 *	--------------------------------------------------------------------------------	 *	 *	Remove all indexes from a collection.	 *	 *	@usage = $this->mongo_db->remove_all_index($collection);	 */
    public function remove_all_indexes($collection = "") {
        if (empty($collection)) {
            $this->error("No Mongo collection specified to remove all indexes from", 500);
        } $this->db->{$collection}->deleteIndexes();
        $this->clear();
        return($this);
    }

    /**     * 	--------------------------------------------------------------------------------	 *	LIST_INDEXES	 *	--------------------------------------------------------------------------------	 *	 *	Lists all indexes in a collection.	 *	 *	@usage = $this->mongo_db->list_indexes($collection);	 */
    public function list_indexes($collection = "") {
        if (empty($collection)) {
            $this->error("No Mongo collection specified to remove all indexes from", 500);
        } return($this->db->{$collection}->getIndexInfo());
    }

    /**     * 	--------------------------------------------------------------------------------	 *	DROP COLLECTION	 *	--------------------------------------------------------------------------------	 *	 *	Removes the specified collection from the database.  Be careful because this	 *  can have some very large issues in production!	 */
    public function drop_collection($collection = "") {
        if (empty($collection)) {
            $this->error("No Mongo collection specified to drop from database", 500);
        } $this->db->{$collection}->drop();
        return TRUE;
    }

    /**     * 	--------------------------------------------------------------------------------	 *	CLEAR	 *	--------------------------------------------------------------------------------	 *	 *	Resets the class variables to default settings	 */
    private function clear() {
        $this->selects = array();
        $this->wheres = array();
        $this->limit = NULL;
        $this->offset = NULL;
        $this->sorts = array();
    }

    /**     * 	--------------------------------------------------------------------------------	 *	WHERE INITIALIZER	 *	--------------------------------------------------------------------------------	 *	 *	Prepares parameters for insertion in $wheres array().	 */
    private function where_init($param) {
        if (!isset($this->wheres[$param])) {
            $this->wheres[$param] = array();
        }
    }

    public function error($str, $t) {
        echo $str;
        exit;
    }

}
   
?> 
使用时候 先where得到条件 在进行操作
			$table_name=trim(strtolower($this->table_name));
			$this->mongo_db->where($where);
			$order=!empty($order)?array('AID'=>'DESC'):array('AID'=>'ASC');//升序降序
			$infos=$this->mongo_db->listinfo($table_name,$order,$page,$pagesize);
分享到:
评论

相关推荐

    java针对mongo操作的封装,完全面向对象,无需修改,可直接使用

    完全面向对象的mongo封装,maven工程源码,可直接install导出jar包引用,支持基本的增删改查和分页等,使用反射对javaBean实体进行映射,所有方法参数只需要传javaBean就行了,支持带密码连接,即拿即用,无需修改。

    mongoTemplate工具类Dao层方法封装.zip

    该资源内容主要包含:两个版本常用mongoTemplate操作数据库集合语句的整理

    mongodb 操作基础类 封装

    Morphia一个nosql的ORM框架 对此二次封装

    PHP操作Mongodb封装类完整实例

    * 2:其它更高级的操作可通过 $this-&gt;getMongo() 得到原生的对象,更多API请自行查阅 Mongo PHP手册,后续版本将会对增加更多的原生API封装 * 3:该类所有API接口中的 $query 查询参数的使用请以下有关 [查询条件...

    详解nodejs操作mongodb数据库封装DB类

    这个DB类也算是我经历了3个实际项目应用的,现分享出来,有需要的请借鉴批评。... * mongoose操作类(封装mongodb) */ var fs = require('fs'); var path = require('path'); var mongoose = require('mongoos

    php操作mongodb封装类与用法实例

    本文实例讲述了php操作mongodb封装类与用法。分享给大家供大家参考,具体如下: 近来学习了mongodb,刚好是做php开发的,随便写了php操作mongodb的封装类. &lt;?php /** * Created by PhpStorm. * User: lee * ...

    java代码操作MongoDB

    运用mongo.jar开发JAVA代码操作数据库,内含一个基础的Test类,以及经过封装的工具类

    php实现的mongoDB单例模式操作类

    本文实例讲述了php实现的mongoDB单例模式操作类。分享给大家供大家参考,具体如下: 看了好多mongo类都不尽人意。最后发现根本不需要自己封装类。php mongo 的扩展自带的方法就已经很方便了 但是习惯性的把数据库...

    php封装的mongodb操作类代码

    核心代码 ...class mongo_db { private $config; private $connection; private $db; private $connection_string; private $host; private $port; private $user; private $pass; private $dbnam

    mongodb工具类

    Mongo DB 是目前在IT行业非常流行的一种非关系型数据库(NoSql),其灵活的数据存储方式备受当前IT...Mongo DB最大的优势在于所有的数据持久操作都无需开发人员手动编写SQL语句,直接调用方法就可以轻松的实现CRUD操作。

    PHP实现的mongoDB数据库操作类完整实例

    最近的项目开发中使用的数据库是mongodb数据库,因为小编的公司也是刚刚使用mongodb数据库,所以之前没有封装好的mongodb数据库操作类拿来使用,所以小编在项目中自己封装了一个mongodb数据库操作类,特拿出来分享,...

    PHP应用开发框架yaf-lib.zip

    MysqlpdoSystem_Mysqlpdo类封装了pdo_mysql的操作接口::bind::bindmore::query::lastInsertId::column::row::singleSystem_LogSystem_Log类封装了日志处理类System_SortSystem_Sort类封装了一些经典得排序算法::...

    Spring-4.1.7、jedis-2.8.0、spring-data-redis-1.6.2

    而且发现Jedis和ShardedJedis的方法非常多,覆盖了Redis几乎所有操作,但是没有注释,也没有异常处理,也没有资源回收,所以我就对这两个类进行了再次封装,对照着Redis官网的中文API加上了中文注释,并对接口方法...

    EJblog:基于Nodejs + Mongo + jQuery + Bootstrap建立个人博客系统

    电子博客 Nodejs(Express)+ MongoDB + jQuery + Bootstrap个人博客。 顾名思义Express(E)jQuery(J) 这是一个开源的个人博客系统。...---- db.js 封装了对数据库的操作(增删改查) ---- md5.

    知乎大神萧井陌web前端课程

    第6章 jinja模板套路、类和其他、作业讲解 第7章 摘要算法、加盐保护密码-数据库索引原理、微博程序 第8章 传统数据库、sql注入和mongo安装使用、mongo日常使用 第9章 前端基础、dom和事件、js todo 第10章 ajax 第...

Global site tag (gtag.js) - Google Analytics