Home > Article > php教程 > A usage example of JsonDB

A usage example of JsonDB

巴扎黑Original: 2016-11-07 10:30:411708browse

JsonDB is a lightweight database open source project based on JSON format implemented in python. You can download and install it through github. The project address is: https://github.com/hujiang001/jsonDB/.

The author provides a complete reference document, and it is in Chinese, so it is very easy to get started. This is the address of his Chinese document: https://github.com/hujiang001/jsonDB/wiki/reference-document. Currently, this document is also included in the project project: reference.md.

The project also provides an example of use. In example.py, let’s paste this example below. There are detailed comments on it. It can be seen that it is quite simple to use:

#!usr/bin/env python# -*- coding: utf-8 -*-from database import JSONDBif __name__=="__main__":
    shopDb = JSONDB(&#39;shop_db&#39;,hashSize=1)  #create shop db
    userDb = JSONDB(&#39;sellerDb&#39;,hashSize=1) #create user db
    #specify key
    shopDb.ensureKey(&#39;shop&#39;,[&#39;id&#39;])
    shopDb.ensureKey(&#39;goods&#39;,[&#39;id&#39;])
    userDb.ensureKey(&#39;seller&#39;,[&#39;id&#39;,&#39;name&#39;])
    userDb.ensureKey(&#39;customer&#39;,[&#39;id&#39;,&#39;name&#39;])    #for debugging, you can start perfDot and open debug switch
    shopDb.perfDotStart()
    userDb.perfDotStart()
    shopDb.debugSwitch(1)
    userDb.debugSwitch(1)    #insert data
    #here we insert some data
    for i in range(0,100):        #insert data one by one
        shopDb.insert(&#39;shop&#39;,[{&#39;id&#39;:i, &#39;name&#39;:&#39;my shop&#39;, &#39;description&#39;:&#39;this is a telephone shop&#39;}])    #inset a data list
    goodsList = [{&#39;id&#39;:10001, &#39;class&#39;:&#39;telephone&#39;, &#39;brand&#39;:&#39;apple&#39;, &#39;color&#39;:&#39;white&#39;},
                 {&#39;id&#39;:10002, &#39;class&#39;:&#39;telephone&#39;, &#39;brand&#39;:&#39;huawei&#39;, &#39;color&#39;:&#39;black&#39;},
                 {&#39;id&#39;:10003, &#39;class&#39;:&#39;telephone&#39;, &#39;brand&#39;:&#39;zte&#39;, &#39;color&#39;:&#39;white&#39;},
                 {&#39;id&#39;:10004, &#39;class&#39;:&#39;telephone&#39;, &#39;brand&#39;:&#39;xiaomi&#39;, &#39;color&#39;:&#39;black&#39;},
                 {&#39;id&#39;:10005, &#39;class&#39;:&#39;telephone&#39;, &#39;brand&#39;:&#39;moto&#39;, &#39;color&#39;:&#39;white&#39;},
                 {&#39;id&#39;:10006, &#39;class&#39;:&#39;telephone&#39;, &#39;brand&#39;:&#39;oppo&#39;, &#39;color&#39;:&#39;black&#39;},]
    shopDb.insert(&#39;goods&#39;,goodsList)
    sellersList = [{&#39;id&#39;:0x34200,&#39;name&#39;:&#39;li&#39;,&#39;sex&#39;:&#39;female&#39;,&#39;birth&#39;:&#39;1985-09-03&#39;,&#39;tel&#39;:&#39;0816-19876545432&#39;},
                   {&#39;id&#39;:0x34201,&#39;name&#39;:&#39;wang&#39;,&#39;sex&#39;:&#39;male&#39;,&#39;birth&#39;:&#39;1988-11-03&#39;,&#39;tel&#39;:&#39;0816-2345453453&#39;},
                   {&#39;id&#39;:0x34202,&#39;name&#39;:&#39;hong&#39;,&#39;sex&#39;:&#39;female&#39;,&#39;birth&#39;:&#39;1995-10-19&#39;,&#39;tel&#39;:&#39;0816-144567589&#39;}]
    userDb.insert(&#39;seller&#39;,sellersList)
    customersList = [{&#39;id&#39;:0x7800,&#39;name&#39;:&#39;zhu&#39;,&#39;sex&#39;:&#39;female&#39;,&#39;profile&#39;:[&#39;dress&#39;,&#39;mother&#39;,&#39;sport&#39;]},
                   {&#39;id&#39;:0x7801,&#39;name&#39;:&#39;rong&#39;,&#39;sex&#39;:&#39;male&#39;,&#39;profile&#39;:[&#39;baby&#39;,&#39;read&#39;,&#39;tech&#39;]},
                   {&#39;id&#39;:0x7802,&#39;name&#39;:&#39;guo&#39;,&#39;sex&#39;:&#39;female&#39;,&#39;profile&#39;:[&#39;phone&#39;,&#39;dress&#39;,&#39;food&#39;]}]
    userDb.insert(&#39;customer&#39;,customersList)    #export to default file
    shopDb.exportToFile()
    userDb.exportToFile(fileName=&#39;user&#39;)    #find
    # find with key
    findList = shopDb.find(&#39;goods&#39;,filter={&#39;id&#39;:{&#39;$lt&#39;:10004}})
    JSONDB.rprint(findList)
    findList = shopDb.find(&#39;goods&#39;,filter={&#39;id&#39;:10004})
    JSONDB.rprint(findList)
    findList = userDb.find(&#39;customer&#39;,filter={&#39;name&#39;:&#39;guo&#39;})
    JSONDB.rprint(findList)    #delete
    shopDb.delete(&#39;goods&#39;,{&#39;id&#39;:10005})    #update
    shopDb.update(&#39;goods&#39;,set={&#39;class&#39;:&#39;phone&#39;})    #merge
    shopDb.merge(userDb)
    shopDb.exportToFile(&#39;mergeDb&#39;)    #show pref time
    shopDb.perfDotEnd()
    userDb.perfDotEnd()    #import
    importDb = JSONDB(&#39;importDb&#39;)
    importDb.debugSwitch(1)
    importDb.importFromFile(fileName=&#39;mergeDb&#39;)    #importDb.printAll()
    importDb.exportToFile()    print importDb

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：Repair corrupted PDF files under LinuxNext article：Repair corrupted PDF files under Linux

See more

A usage example of JsonDB

Related articles