def run(cls, database=DEFAULT_DB_ALIAS, **kwargs):
import frepple
if cls.filter:
filter_and = "and %s " % cls.filter
filter_where = "where %s " % cls.filter
else:
filter_and = ""
filter_where = ""
with connections[database].chunked_cursor() as cursor:
cnt = 0
starttime = time()
cursor.execute('''
SELECT
resource_id, skill_id, effective_start, effective_end, priority, source
FROM resourceskill %s
ORDER BY skill_id, priority, resource_id
''' % filter_where)
for i in cursor:
cnt += 1
try:
cur = frepple.resourceskill(
resource=frepple.resource(name=i[0]), skill=frepple.skill(name=i[1]),
priority=i[4] or 1, source=i[5]
)
if i[2]:
cur.effective_start = i[2]
if i[3]:
cur.effective_end = i[3]
except Exception as e:
logger.error("**** %s ****" % e)
logger.info('Loaded %d resource skills in %.2f seconds' % (cnt, time() - starttime))
def loadResourceSkills(self):
print('Importing resource skills...')
cnt = 0
starttime = time()
self.cursor.execute('''
SELECT
resource_id, skill_id, effective_start, effective_end, priority, source
FROM resourceskill %s
ORDER BY skill_id, priority, resource_id
''' % self.filter_where)
for i in self.cursor.fetchall():
cnt += 1
try:
cur = frepple.resourceskill(
resource=frepple.resource(name=i[0]),
skill=frepple.skill(name=i[1]),
priority=i[4] or 1,
source=i[5])
if i[2]:
cur.effective_start = i[2]
if i[3]:
cur.effective_end = i[3]
except Exception as e:
print("Error:", e)
print('Loaded %d resource skills in %.2f seconds' %
(cnt, time() - starttime))
def loadResourceSkills(cursor):
print('Importing resource skills...')
cnt = 0
starttime = time()
cursor.execute('''SELECT
resource_id, skill_id, effective_start, effective_end, priority
FROM resourceskill
ORDER BY skill_id, priority, resource_id''')
for i,j,k,l,m in cursor.fetchall():
cnt += 1
try:
cur = frepple.resourceskill(resource=frepple.resource(name=i), skill=frepple.skill(name=j), priority=m or 1)
if k: cur.effective_start = k
if l: cur.effective_end = l
except Exception as e: print("Error:", e)
print('Loaded %d resource skills in %.2f seconds' % (cnt, time() - starttime))
def loadResourceSkills(cursor):
print('Importing resource skills...')
cnt = 0
starttime = time()
cursor.execute('''SELECT
resource_id, skill_id, effective_start, effective_end, priority
FROM resourceskill
ORDER BY skill_id, priority, resource_id''')
for i, j, k, l, m in cursor.fetchall():
cnt += 1
try:
cur = frepple.resourceskill(resource=frepple.resource(name=i),
skill=frepple.skill(name=j),
priority=m or 1)
if k: cur.effective_start = k
if l: cur.effective_end = l
except Exception as e:
print("Error:", e)
print('Loaded %d resource skills in %.2f seconds' %
(cnt, time() - starttime))
def loadResourceSkills(self):
print('Importing resource skills...')
cnt = 0
starttime = time()
self.cursor.execute('''
SELECT
resource_id, skill_id, effective_start, effective_end, priority, source
FROM resourceskill %s
ORDER BY skill_id, priority, resource_id
''' % self.filter_where)
for i in self.cursor.fetchall():
cnt += 1
try:
cur = frepple.resourceskill(
resource=frepple.resource(name=i[0]), skill=frepple.skill(name=i[1]),
priority=i[4] or 1, source=i[5]
)
if i[2]:
cur.effective_start = i[2]
if i[3]:
cur.effective_end = i[3]
except Exception as e:
print("Error:", e)
print('Loaded %d resource skills in %.2f seconds' % (cnt, time() - starttime))
