#?-*-?coding:?utf-8?-*-
import?pickle
from?PCV.imagesearch?import?imagesearch
from?PCV.localdescriptors?import?sift
from?sqlite3?import?dbapi2?as?sqlite
from?PCV.tools.imtools?import?get_imlist

#獲取圖像列表
imlist?=?get_imlist（‘first1000/‘）
nbr_images?=?len（imlist）
#獲取特征列表
featlist?=?[imlist[i][:-3]+‘sift‘?for?i?in?range（nbr_images）]

#?load?vocabulary
#載入詞匯
with?open（‘first1000/vocabulary.pkl‘?‘rb‘）?as?f:
????voc?=?pickle.load（f）
#創建索引
indx?=?imagesearch.Indexer（‘testImaAdd.db‘voc）
indx.create_tables（）
#?go?through?all?images?project?features?on?vocabulary?and?insert
#遍歷所有的圖像，并將它們的特征投影到詞匯上
for?i?in?range（nbr_images）[:1000]:
????locsdescr?=?sift.read_features_from_file（featlist[i]）
????indx.add_to_index（imlist[i]descr）
#?commit?to?database
#提交到數據庫
indx.db_commit（）

con?=?sqlite.connect（‘testImaAdd.db‘）
print?（con.execute（‘select?count?（filename）?from?imlist‘）.fetchone（））
print?（con.execute（‘select?*?from?imlist‘）.fetchone（））

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-05-27?20:44??BOW\
?????目錄???????????0??2019-05-27?20:42??BOW\.ipynb_checkpoints\
?????文件???????50144??2019-04-30?11:57??BOW\.ipynb_checkpoints\ch07_addImage-checkpoint.ipynb
?????文件???????73670??2019-04-30?08:54??BOW\.ipynb_checkpoints\ch07_cocabulary-checkpoint.ipynb
?????文件???????72741??2019-04-30?01:44??BOW\.ipynb_checkpoints\ch07_reranking-checkpoint.ipynb
?????文件????????5572??2019-04-30?01:50??BOW\.ipynb_checkpoints\ch07_searchdemo-checkpoint.ipynb
?????文件???????25876??2019-04-30?00:47??BOW\.ipynb_checkpoints\ch07_test_candidates-checkpoint.ipynb
?????目錄???????????0??2019-05-27?20:42??BOW\PCV\
?????文件?????????174??2017-03-30?22:53??BOW\PCV\__init__.py
?????文件?????????303??2019-04-16?10:10??BOW\PCV\__init__.pyc
?????目錄???????????0??2019-05-27?20:42??BOW\PCV\__pycache__\
?????文件?????????308??2019-05-01?20:02??BOW\PCV\__pycache__\__init__.cpython-36.pyc
?????目錄???????????0??2019-05-27?20:42??BOW\PCV\classifiers\
?????文件???????????0??2017-03-30?22:53??BOW\PCV\classifiers\__init__.py
?????文件?????????114??2019-04-16?10:10??BOW\PCV\classifiers\__init__.pyc
?????目錄???????????0??2019-05-27?20:42??BOW\PCV\classifiers\__pycache__\
?????文件?????????158??2019-05-01?20:02??BOW\PCV\classifiers\__pycache__\__init__.cpython-36.pyc
?????文件????????1886??2019-05-01?21:09??BOW\PCV\classifiers\bayes.py
?????文件?????????921??2017-03-30?22:53??BOW\PCV\classifiers\knn.py
?????目錄???????????0??2019-05-27?20:42??BOW\PCV\clustering\
?????文件???????????0??2017-03-30?22:53??BOW\PCV\clustering\__init__.py
?????文件?????????113??2019-04-16?10:10??BOW\PCV\clustering\__init__.pyc
?????目錄???????????0??2019-05-27?20:42??BOW\PCV\clustering\__pycache__\
?????文件?????????157??2019-05-01?20:02??BOW\PCV\clustering\__pycache__\__init__.cpython-36.pyc
?????文件????????4324??2017-03-30?22:53??BOW\PCV\clustering\hcluster.py
?????目錄???????????0??2019-05-27?20:42??BOW\PCV\geometry\
?????文件???????????0??2017-03-30?22:53??BOW\PCV\geometry\__init__.py
?????文件?????????111??2019-04-16?10:10??BOW\PCV\geometry\__init__.pyc
?????目錄???????????0??2019-05-27?20:42??BOW\PCV\geometry\__pycache__\
?????文件?????????155??2019-05-01?20:02??BOW\PCV\geometry\__pycache__\__init__.cpython-36.pyc
?????文件????????4274??2019-05-01?21:18??BOW\PCV\geometry\__pycache__\homography.cpython-36.pyc
............此處省略283個文件信息