db_operations.py

# -*- coding: utf-8 -*-
import shelve

from utils.models import Qestion
from utils.SQlite3 import *

#Чтение данных из базы
'''
for key in db:
    #Если ответ на ворос не установлен, то задаем этот вопрос
    if db[key].correctAnswer is None:
        print(key, '=>\n ', db[key].testName)
        newObj = db[key]
        newObj.findAnswer()
        db[key] = newObj

db.close()

#Ответ на вопросы, eсли ответ на ворос не установлен, то задаем этот вопрос
cur, con = connect_or_create('upwork_test.db')
show_table("Qestion", cur)
for key in filter_table("Qestion", cur, "TEST", "CORRECT", ["Python test", "No answer"]):
    print "N: ", key[0]
    tempObj = Qestion(*(list(key))[1:])
    print tempObj.moreOneAnswer
    if tempObj.moreOneAnswer:
        print "Bot: Attantion More one answer"
    tempObj.findAnswer()
    update_record("Qestion", cur, con, "CORRECT", '#~'.join(tempObj.correctAnswer), key[0])





####### Работа с SQL ########
#cur, con = connect_or_create('upwork.db')

#Создать таблицу
#create_table("Qestion", cur, "ID", "TEST", "QESTION", "ANSWERS", "CORRECT", "MOREONE")

#print parserModel(db['question_1'])

#Перешел из Shelve в SQL
recordsList = []
idCount = 0
for key in db:
	tempList = parserModel(db[key])
	tempList.append(False)
	tempList.insert(0,idCount)
	recordsList.append(tempList)
	idCount+=1
	#Записать в базу запись
print idCount, "TOTAL"
save_records("Qestion", cur, con, recordsList)



#Показать результат
result = show_table("Qestion", cur, 'CORRECT')
print len(result)
for i in result:
	print i



#Изменить значения в базе
idCount = 0
for key in db:
#print "#~".join(db[key].correctAnswer)
	temp_res = "#~".join(db[key].correctAnswer)
	update_record("Qestion", cur, con, "CORRECT", temp_res, idCount)
	idCount+=1



#Показать результат
#result = show_table("Qestion", cur, "CORRECT")
#print len(result)
#for i in result:
#	print i

#Запись результатов в файл
cur, con = connect_or_create('upwork.db')
'''

cur, con = connect_or_create('data/database.db')


delete_record("Qestion", cur, con, "ID", [194])
for i in filter_table("Qestion", cur, "TEST", None, ["Python Test"]):
    if i[0]==1720 or i[0]==194:
        print i

    
    #update_record("Qestion", cur, con, "TEST", "Python Test", i[0])
#filterResult = filter_table("Qestion", cur, "TEST", None, ["Python test"])
#print create_table("User", cur, con, USERNAME = "TEXT", EMAIL = "TEXT", PASSWORD = "TEXT")
#print saveInFile(filter_table("Qestion", cur, "TEST", None, ["Python test"]))



"""
for (type, name) in showInfo('Qestion', cur):
    if type == u"BOOLEAN":
        print 'bool'
    else:
        print 'not bool'
"""
#Изменить значения в базе
#idCount = 0
#for key in filter_table("Qestion", cur, "TEST", None, ["Python test"]):
#print "#~".join(db[key].correctAnswer)
#	if key[4].find('#~')!=-1:
#		update_record("Qestion", cur, con, "MOREONE", True, idCount)
#	idCount+=1