Python insert_and_get_id Examples

Example #1

File: emailTagTable.py Project: jedirv/tagServices

def add_email_tag(entryID, tag):
    emailID = emailTable.get_email_id_for_email(entryID)
    print('emailID is {0}'.format(emailID))
    tagID = tagTable.get_tag_id_for_tag(tag)
    if (tagID=='?'):
        return util.insert_rejected('tag {0} does not exist'.format(tag))
    if (emailID=='?'):
        return util.insert_rejected('email {0} does not exist'.format(entryID))
    print('tagID is {0}'.format(tagID))
    query = "INSERT INTO EmailTags (EmailID, TagID) VALUES ('{0}','{1}');".format(emailID, tagID)
    return db.insert_and_get_id(query, 'EmailTags')

Example #2

def add_person_tag(person, tag):
    personID = personTable.get_person_id_for_person(person)
    print('personID is {0}'.format(personID))
    tagID = tagTable.get_tag_id_for_tag(tag)
    if (tagID == '?'):
        return util.insert_rejected('tag {0} does not exist'.format(tag))
    if (personID == '?'):
        return util.insert_rejected('person {0} does not exist'.format(person))
    print('tagID is {0}'.format(tagID))
    query = "INSERT INTO PersonTags (PersonID, TagID) VALUES ('{0}','{1}');".format(
        personID, tagID)
    return db.insert_and_get_id(query, 'PersonTags')

Example #3

def add_resource_tag(type, name, tag):
    resourceID = resourceTable.get_resource_id(type, name)
    print('resourceID is {0}'.format(resourceID))
    tagID = tagTable.get_tag_id_for_tag(tag)
    if (tagID == '?'):
        return util.insert_rejected('tag {0} does not exist'.format(tag))
    if (resourceID == '?'):
        return util.insert_rejected('resource {0} {1} does not exist'.format(
            type, name))
    print('tagID is {0}'.format(tagID))
    query = "INSERT INTO ResourceTags (ResourceID, TagID) VALUES ('{0}','{1}');".format(
        resourceID, tagID)
    return db.insert_and_get_id(query, 'ResourceTags')

Example #4

def add_person(person):
    query = "INSERT INTO Persons (Name) VALUES ('{0}');".format(person)
    return db.insert_and_get_id(query, 'Persons')

Example #5

File: emailTable.py Project: jedirv/tagServices

def add_email(conversationID, entryID):
    query = "INSERT INTO Emails (EntryID, ConversationID) VALUES ('{0}','{1}');".format(
        entryID, conversationID)
    return db.insert_and_get_id(query, 'Emails')

Example #6

def add_tag(tag):
    query = "INSERT INTO Tags (Name) VALUES ('{0}');".format(tag)
    print(query)
    return db.insert_and_get_id(query, 'Tags')

Example #7

File: resourceTable.py Project: jedirv/tagServices

def add_resource(type, name):
    query = "INSERT INTO Resources (Type, Name) VALUES ('{0}','{1}');".format(
        type, name)
    return db.insert_and_get_id(query, 'Resources')