예제 #1
0
def import_categories():
    c = conn.cursor()
    sql = """
SELECT
    ID_CAT
    ,name
    ,catOrder
FROM
    smf_categories;"""

    c.execute(sql)
    for row in c.fetchall():
        cat = Category()
        cat.name = row[1]
        cat.order = row[2]
        cat.save()

        categories[row[0]] = cat

    c.close()