JsonDB의 사용 예-PHP开发-php.cn

JsonDB의 사용 예

巴扎黑

풀어 주다： 2016-11-07 10:30:41

원래의

1760명이 탐색했습니다.

JsonDB는 Python으로 구현된 JSON 형식을 기반으로 하는 경량 데이터베이스 오픈 소스 프로젝트입니다. 프로젝트 주소는 https://github.com/hujiang001/jsonDB/입니다.

저자는 완전한 참조 문서를 제공하며 중국어로 되어 있어 시작하기가 매우 쉽습니다. 중국어 문서의 주소는 https://github.com/hujiang001/jsonDB/입니다. 위키/참조 문서 . 현재 이 문서는 프로젝트 프로젝트인 reference.md에도 포함되어 있습니다.

이 프로젝트는 예제도 제공합니다. 아래에 이 예제를 붙여넣으면 사용이 매우 간단하다는 것을 알 수 있습니다. 🎜 >

#!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

로그인 후 복사