def write(utf8_content, preferred_uid=None):
if preferred_uid is None:
uid = utils.make_uid(utf8_content)
else:
uid = preferred_uid
while SqliteDB._retrieve_json(uid):
uid = utils.refine_uid()
SqliteDB._insert_json(uid, utf8_content)
return uid
def write(utf8_content, preferred_uid=None):
with MemoryDB._PLOCK and MemoryDB._TLOCK:
if preferred_uid is None:
uid = utils.make_uid(utf8_content)
else:
uid = preferred_uid
while uid in MemoryDB._DB:
uid = utils.refine_uid()
MemoryDB._DB[uid] = utf8_content
return uid
def write(utf8_content, preferred_uid=None):
if preferred_uid is None:
uid = utils.make_uid(utf8_content)
else:
uid = preferred_uid
while MongoDB._DB.find(uid):
uid = utils.refine_uid()
MongoDB._DB.create_collection(uid)
print(dir(MongoDB._DB))
MongoDB._DB.uid.insert(utf8_content)
return uid
def set_company(con, comp, loca):
cur = make_dic_cursor(con)
if not comp:
comp = no_write()
if not loca:
loca = no_write()
comp_uid = make_uid()
sql = """insert into company(comp_id, name, location) values(%s, %s, %s);"""
cur.execute(sql,(comp_uid,comp,loca))
con.commit()
cur.close()
return comp_uid
def set_recruit(con, w_id, t_id, c_id, title, content, cdate):
cur = make_dic_cursor(con)
r_id = make_uid()
sql = """insert into
`recruiting` (`recr_id`,`writer_id`,`type_id`,`comp_id`,`title`,`content`,`hit`,`cdate`,`is_delete`)
values(%s, %s, %s, %s, %s, %s, 0, %s, 0);"""
cur.execute(sql, (r_id,w_id, t_id, c_id, title, content, cdate))
con.commit()
cur.close()
return r_id
def set_writer(con, k_id, k_name, email, phone):
cur = make_dic_cursor(con)
if not k_id:
k_id = no_write()
if not email:
email = no_write()
if not phone:
phone = no_write()
writer_id = make_uid()
sql = """insert into `writer` (`writer_id`, `kakao_id`, `kakao_name`, `email`, `phone`) values(%s, %s, %s, %s, %s);"""
cur.execute(sql,(writer_id,k_id, k_name, email, phone))
con.commit()
return writer_id
def get_type(con, flag):
if flag :
type = 'side'
else :
type = 'job'
try:
cur = make_dic_cursor(con)
sql = """select type_id from type where type=%s;"""
cur.execute(sql, (type))
res = cur.fetchone()
cur.close()
return res['type_id']
except:
cur = make_dic_cursor(con)
type_id = make_uid()
sql = """insert into `type` (`type_id`, `type`) values(%s, %s);"""
cur.execute(sql,(type_id,type))
con.commit()
cur.close()
return type_id
