Esempio n. 1
0
def submitTake():
    response.view = "takes/submitTake.html"
    response.title = "Submit Take"

    topicsList = databaseQueries.getGlobalTopicsList(db)
    numOfTopics = len(topicsList)

    fields = []
    options = []

    for i in range(1, numOfTopics):
        topicMapping = topicsList[i]
        options += [topicMapping["topicName"]]

    fields += [Field('topics','string')]
    fields += [Field('takeTags','string')]
    fields += [field for field in db.takes]
    form = SQLFORM.factory(*fields, _id = "tagform-full")
    
    if form.process().accepted:
        selectedTopics = form.vars.topics
        selectedTags = form.vars.takeTags
        takeId = databaseQueries.addTake(db, form.vars.takeTitle, form.vars.takeContent)
        for i in range(1, numOfTopics):
            topicMapping = topicsList[i]
            if(topicMapping["topicName"] in selectedTopics):
                databaseQueries.addTakeTopicMapping(db, takeId, i)

        for tag in selectedTags.split(","):
            tagId = databaseQueries.getTagId(db, tag)
            if(tagId == 0):
                tagId = databaseQueries.insertTag(db, tag)
            databaseQueries.addTakeTagMapping(db, takeId, tagId)
            
            
        redirect(URL('takes','viewTake',vars=dict(takeId = takeId)))
    elif form.errors:
        response.flash = 'Errors found in the form.'
    else:
        response.flash = 'Please fill the form.'

    return dict(form=form, options = options, preSelectedTopics = [], existingTags = "")
Esempio n. 2
0
def editTake():
    response.view = "takes/submitTake.html"
    response.title = "Edit Take"

    userId = auth.user.id
    takeId = request.vars.takeId

    if not(utilityFunctions.isTakeIdValid(takeId,db)):
        redirect(URL('default','index'))

    if(not(databaseQueries.checkIfUserTakePairExists(db, userId, takeId))):
        redirect(URL('default','index'))

    takeTopicMappings = databaseQueries.getTopicMappings(db, takeId)
    preSelectedTopics = []
    topicsList = databaseQueries.getGlobalTopicsList(db)
    numOfTopics = len(topicsList)
    
    preSelectedTags = databaseQueries.getTakeTags(db, takeId)
    existingTags = ""
    for row in preSelectedTags:
        existingTags = existingTags + row.tags.tagName + ", "
    existingTags = existingTags + "end[]"
    existingTags = existingTags.replace(", end[]","")

    fields = []
    options = []

    for i in range(1, numOfTopics):
        topicMapping = topicsList[i]
        options += [topicMapping["topicName"]]
        if(i in takeTopicMappings):
            preSelectedTopics += [topicMapping["topicName"]]

    fields += [Field('topics','string')]
    fields += [Field('takeTags','string')]
    fields += [field for field in db.takes]
    form = SQLFORM.factory(*fields)

    takeInfo = databaseQueries.getTakeInfo(db, takeId)
    form.vars.takeTitle = takeInfo.takeTitle
    form.vars.takeContent = takeInfo.takeContent
    form.vars.topics = ['Entertainment', 'Technology', 'Friendship']

    if form.process().accepted:
        databaseQueries.updateTake(db, form.vars.takeTitle, form.vars.takeContent, takeId)
        selectedTopics = form.vars.topics
        selectedTags = form.vars.takeTags
        for i in range(1, numOfTopics):
            topicMapping = topicsList[i]
            if(topicMapping["topicName"] in selectedTopics):
                databaseQueries.addTakeTopicMapping(db, takeId, i)
            else:
                databaseQueries.removeTakeTopicMapping(db, takeId, i)

        databaseQueries.removeTakeTags(db, takeId)
        for tag in selectedTags.split(","):
            tagId = databaseQueries.getTagId(db, tag)
            if(tagId == 0):
                tagId = databaseQueries.insertTag(db, tag)
            databaseQueries.addTakeTagMapping(db, takeId, tagId)

        redirect(URL('takes','viewTake',vars=dict(takeId = request.vars.takeId)))
    elif form.errors:
        response.flash = 'Errors found in the form.'
    else:
        response.flash = 'Please fill the form.'

    return dict(form=form, options = options, preSelectedTopics = preSelectedTopics, existingTags = existingTags)