Subversion Repositories SmartDukaan

'''
Created on 02-Jun-2010

@author: gaurav
'''

from elixir import *
from datastore.DataCodeDefinition import *

def initialize_table():
    init()
    
def get_code_word_byId(id):
    try:
        cw = code_words.query.filter_by(id=id).one()
    except:
        cw = "EMPTY"
    return cw
   
def get_code_word(key):
    try:
        cw = code_words.query.filter_by(key=key).one()
        cw = cw.value
        print key
        print cw
    except:
        cw = "EMPTY"
    return cw

def get_allcode_words(key):
    try:
        cw = code_words.query.all()
    except:
        cw = "EMPTY"
    return cw

def get_code_word_byKey(key):
    try:
        cw = code_words.query.filter_by(key=key).one()
    except:
        cw = "EMPTY"
    return cw


def set_code_word(key,value,description):
    try:
        cw = code_words.query.filter_by(key=key).one()
        #print value
        #print description
        cw.value = value
        cw.description = description
    except:
        cw = code_words()
        cw.key = key
        cw.value = value
        cw.description = description
    session.commit()