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