def myupdate(self,survey_id, title, content, interview_cnt, deadline, in_date, in_user_id, up_date, up_user_id): sql = mybatis_mapper2sql.get_child_statement(self.mapper, "update") MyLog().getLogger().debug(sql) self.cs.execute(sql, (title, content, interview_cnt, deadline, up_user_id, survey_id)) self.conn.commit() cnt = self.cs.rowcount return cnt
def mydelete(self,survey_id): sql = mybatis_mapper2sql.get_child_statement(self.mapper, "delete") MyLog().getLogger().debug(sql) self.cs.execute(sql, (survey_id,)) self.conn.commit() cnt = self.cs.rowcount return cnt
def myupdate(self, survey_id,s_seq, st_mobile, answer, in_date, in_user_id, up_date, up_user_id): sql = mybatis_mapper2sql.get_child_statement(self.mapper, "update") MyLog().getLogger().debug(sql) self.cs.execute(sql, (answer, up_user_id, survey_id, s_seq, st_mobile,)) self.conn.commit() cnt = self.cs.rowcount return cnt
def mydelete(self, user_id): sql = mybatis_mapper2sql.get_child_statement(self.mapper, "delete") self.mylog.logger.debug(sql) self.cs.execute(sql, (user_id, )) self.conn.commit() cnt = self.cs.rowcount return cnt
def myupdate(self,user_id, pwd, user_name, mobile, email, birth, in_date, in_user_id, up_date, up_user_id): sql = mybatis_mapper2sql.get_child_statement(self.mapper, "update") MyLog().getLogger().debug(sql) self.cs.execute(sql, (pwd, user_name, mobile, email, birth, up_user_id,user_id)) self.conn.commit() cnt = self.cs.rowcount return cnt
def myinsert(self, survey_id, title, content, interview_cnt, deadline, in_date, in_user_id, up_date, up_user_id): sql = mybatis_mapper2sql.get_child_statement(self.mapper, "insert") self.cs.execute(sql, (survey_id, title, content, interview_cnt, deadline, in_user_id, up_user_id)) self.conn.commit() cnt = self.cs.rowcount return cnt
def myselect(self,in_user_id): sql = mybatis_mapper2sql.get_child_statement(self.mapper, "select") MyLog().getLogger().debug(sql) rs = self.cs.execute(sql,(in_user_id,)) list = [] for record in rs: list.append({'survey_id':record[0],'title':record[1],'content':record[2],'interview_cnt':record[3],'deadline':record[4], 'in_date':record[5],'in_user_id':record[6],'up_date':record[7],'up_user_id':record[8]}) return list
def myselect_graph(self,survey_id): sql = mybatis_mapper2sql.get_child_statement(self.mapper, "select_graph") MyLog().getLogger().debug(sql) rs = self.cs.execute(sql, (survey_id,)) list = [] for r in rs: list.append({'survey_id':r[0],'s_seq':r[1],'question':r[2],'a1':r[3],'a2':r[4],'a3':r[5],'a4':r[6],'c1':r[7],'c2':r[8],'c3':r[9],'c4':r[10]}) return list
def myselect(self): sql = mybatis_mapper2sql.get_child_statement(self.mapper, "select") MyLog().getLogger().debug(sql) rs = self.cs.execute(sql) list = [] for record in rs: list.append({'user_id':record[0],'pwd':record[1],'user_name':record[2],'mobile':record[3],'email':record[4],'birth':record[5],'in_date':record[6],'in_user_id':record[7],'up_date':record[8],'up_user_id':record[9]}) return list
def myselect(self): sql = mybatis_mapper2sql.get_child_statement(self.mapper, "select") MyLog().getLogger().debug(sql) rs = self.cs.execute(sql) list = [] for record in rs: list.append({'survey_id':record[0],'s_seq':record[1],'st_mobile':record[2], 'answer':record[3],'in_date':record[4],'in_user_id':record[5],'up_date':record[6],'up_user_id':record[7]}) return list
def myinsert(self, survey_id, st_mobile, complete_yn, in_date, in_user_id, up_date, up_user_id): sql = mybatis_mapper2sql.get_child_statement(self.mapper, "insert") MyLog().getLogger().debug(sql) self.cs.execute( sql, (survey_id, st_mobile, complete_yn, in_user_id, up_user_id)) self.conn.commit() cnt = self.cs.rowcount return cnt
def myinsert(self, user_id, pwd, user_name, mobile, email, birth, in_date, in_user_id, up_date, up_user_id): sql = mybatis_mapper2sql.get_child_statement(self.mapper, "insert") self.mylog.logger.debug(sql) self.cs.execute(sql, (user_id, pwd, user_name, mobile, email, birth, in_user_id, up_user_id)) self.conn.commit() cnt = self.cs.rowcount return cnt
def myupdate(self, survey_id, s_seq, question, a1, a2, a3, a4, in_date, in_user_id, up_date, up_user_id): sql = mybatis_mapper2sql.get_child_statement(self.mapper, "update") MyLog().getLogger().debug(sql) self.cs.execute( sql, (question, a1, a2, a3, a4, up_user_id, survey_id, s_seq)) self.conn.commit() cnt = self.cs.rowcount return cnt
def myinsert_ans(self, survey_id, st_mobile, ans): anses = ans.split(",") sql = mybatis_mapper2sql.get_child_statement(self.mapper, "merge") MyLog().getLogger().debug(sql) for idx, a in enumerate(anses): self.cs.execute(sql, (survey_id, idx + 1, st_mobile, a)) self.conn.commit() cnt = self.cs.rowcount return cnt
def myselect(self): sql = mybatis_mapper2sql.get_child_statement(self.mapper, "select") rs = self.cs.execute(sql) list = [] for record in rs: list.append({ 'col01': record[0], 'col02': record[1], 'col03': record[2] }) return list
def executeMany(self, mapId, paramsList): try: connection = self.__connection_pool.getconn() cursor = connection.cursor() statement = mybatis_mapper2sql.get_child_statement(self._mapper, mapId) cursor.executemany(statement, paramsList) cursor.close() connection.commit() self.__connection_pool.putconn(connection) except: traceback.print_exc()
def queryPandas(self, mapId, params=None, dtype=None): try: connection = self.__connection_pool.getconn() statement = mybatis_mapper2sql.get_child_statement(self._mapper, mapId) df = pd.read_sql(statement, connection, params=[params]) self.__connection_pool.putconn(connection) if dtype is not None: df = df.astype(dtype) return df except: traceback.print_exc()
def query(self, mapId, params=None): try: connection = self.__connection_pool.getconn() cursor = connection.cursor() statement = mybatis_mapper2sql.get_child_statement(self._mapper, mapId) cursor.execute(statement, [params]) records = cursor.fetchall() cursor.close() self.__connection_pool.putconn(connection) return records except: traceback.print_exc()
def myselect(self, survey_id): sql = mybatis_mapper2sql.get_child_statement(self.mapper, "select") MyLog().getLogger().debug(sql) rs = self.cs.execute(sql, (survey_id, )) list = [] for record in rs: list.append({ 'survey_id': record[0], 's_seq': record[1], 'question': record[2], 'a1': record[3], 'a2': record[4], 'a3': record[5], 'a4': record[6], 'in_date': record[7], 'in_user_id': record[8], 'up_date': record[9], 'up_user_id': record[10], 'in_user_id': record[11] }) return list
import mybatis_mapper2sql mapper, xml_raw_text = mybatis_mapper2sql.create_mapper( xml='mybatis_sample.xml') # statement = mybatis_mapper2sql.get_statement(mapper) # print(statement) statement = mybatis_mapper2sql.get_child_statement(mapper, "select") print(statement) statement = mybatis_mapper2sql.get_child_statement(mapper, "insert") print(statement) statement = mybatis_mapper2sql.get_child_statement(mapper, "update") print(statement) statement = mybatis_mapper2sql.get_child_statement(mapper, "delete") print(statement)
def test_parameters(self): self.child_id = 'testParameters' print("============{}============".format(self.child_id)) self.statement = mybatis_mapper2sql.get_child_statement( self.mapper, child_id=self.child_id, reindent=True) print(self.statement)
def mydelete(self, col01): sql = mybatis_mapper2sql.get_child_statement(self.mapper, "delete") self.cs.execute(sql, (col01, )) self.conn.commit() cnt = self.cs.rowcount return cnt
def myinsert(self, col01, col02, col03): sql = mybatis_mapper2sql.get_child_statement(self.mapper, "insert") self.cs.execute(sql, (col01, col02, col03)) self.conn.commit() cnt = self.cs.rowcount return cnt
def test_foreach(self): self.child_id = 'testForeach' print("============{}============".format(self.child_id)) self.statement = mybatis_mapper2sql.get_child_statement( self.mapper, child_id=self.child_id, reindent=True) print(self.statement)
def get_sql(self, query_id=None): self.logger.debug(f"\n<< get_sql : query_id='{query_id}' >>") return mybatis_mapper2sql.get_child_statement(self.mapper, child_id=query_id, reindent=True)
def test_choose_native(self): self.child_id = 'testChooseNative' print("============{}============".format(self.child_id)) self.statement = mybatis_mapper2sql.get_child_statement( self.mapper, child_id=self.child_id, reindent=True, native=True) print(self.statement)