Esempio n. 1
0
	def updatetableinfo_byparams(self,table,select_params=[],set_params=[],request_params=[],equal_params=[],extra=''):
		if len(request_params)!=len(equal_params):
			print 'request_params,equals_params长度不相等'
			return False
		elif  self.__isconnect==1:

			try:
				sql='update     '

				length=len(table)

				for j in range(0,length-1):
					sql=sql+table[j]+','
				sql=sql+table[length-1]


				select_params_length=len(select_params)
				if select_params_length>0:

					sql=sql+' set  '
					for k in range(0,select_params_length-1):
						sql=sql+select_params[k]+' = '+set_params[k]+'  , '
					sql=sql+select_params[select_params_length-1]+' = '+set_params[select_params_length-1]+'  '
			
				
				
				request_params_length=len(request_params)
				if request_params_length>0:

					sql=sql+' where '
					for k in range(0,request_params_length-1):
						sql=sql+request_params[k]+' = '+equal_params[k]+' and '
					sql=sql+request_params[request_params_length-1]+' = '+equal_params[request_params_length-1]+'  '
				
				sql+=extra

# 				print sql
				count=None
				try:
					count=self.__cur.execute(sql)
				
					self.__conn.commit()
				except MySQLdb.Error,e:
					try:
						if self.isdisconnect(e):
							self.connectdb()
							count=self.__cur.execute(sql)
				
							self.__conn.commit()
						else:
							debug=Debug.getObject()
							debug.error(str(e))
							return False
					except Exception,e:
						return False
				if count>0:
					return True
				else:
					return False
Esempio n. 2
0
    def inserttableinfo_byparams(self,
                                 table,
                                 select_params,
                                 insert_values,
                                 extra=' ',
                                 updatevalue=[]):
        if len(insert_values) < 1:
            print '没有插入参数'
            return False
        elif self.__isconnect == 1:

            try:
                sql = 'insert into     ' + table
                length = len(select_params)
                if length > 0:
                    sql += '('
                    for j in range(0, length - 1):
                        sql = sql + select_params[j] + ','
                    sql = sql + select_params[length - 1] + ')'
                    sql = sql + '    '
                    sql = sql + ' values('
                    for j in range(0, length - 1):
                        sql = sql + '%s' + ','
                    sql = sql + '%s' + ')'
                else:
                    return False
                ulen = len(updatevalue)
                if ulen > 0:
                    sql += '  on duplicate key update  '
                    for o in range(0, ulen - 1):
                        sql = sql + updatevalue[o] + ' =  %s ' + '  ,'
                    sql = sql + updatevalue[ulen - 1] + '  =%s '
                sql += extra
                print sql

                print insert_values
                returnmeg = None
                try:
                    returnmeg = self.__cur.executemany(sql, insert_values)
                except MySQLdb.Error, e:
                    try:
                        if self.isdisconnect(e):
                            self.connectdb()
                            returnmeg = self.__cur.executemany(
                                sql, insert_values)
                        else:
                            debug = Debug.getObject()
                            debug.error(str(e))
                            return False
                    except Exception, e:
                        return False
                print '返回的消息: ' + str(returnmeg)
                if returnmeg > 0:
                    if self.__conn is not None:
                        self.__conn.commit()
                    return True
                else:
                    return False
Esempio n. 3
0
    def replaceinserttableinfo_byparams(self, table, select_params,
                                        insert_values):
        if len(insert_values) < 1:
            print '没有插入参数'
            return False
        elif self.__isconnect == 1:

            try:
                sql = 'replace into     ' + table
                length = len(select_params)
                if length > 0:
                    sql += '('
                    for j in range(0, length - 1):
                        sql = sql + select_params[j] + ','
                    sql = sql + select_params[length - 1] + ')'
                    sql = sql + '    '
                    sql = sql + ' values('
                    for j in range(0, length - 1):
                        sql = sql + '%s' + ','
                    sql = sql + '%s' + ')'
                else:
                    return False

# 				print sql
                returnmeg = None
                try:
                    returnmeg = self.__cur.executemany(sql, insert_values)
                    print '返回的消息: ' + str(returnmeg)

                    self.__conn.commit()
                    if str(returnmeg) == '0':
                        print '没有数据变化'
                    return True


# 						self.connectdb()
# 						returnmeg=self.__cur.executemany(sql,insert_values)
# 						print '返回的消息: '+str(returnmeg)
# 						self.__conn.commit()
                except MySQLdb.Error, e:
                    try:
                        if self.isdisconnect(e):

                            print '进行重连'
                            self.connectdb()
                            returnmeg = self.__cur.executemany(
                                sql, insert_values)
                            print '返回的消息: ' + str(returnmeg)

                            self.__conn.commit()
                            return True
                        else:
                            debug = Debug.getObject()
                            debug.error(str(e))
                            return False
                    except Exception, e:
                        return False
Esempio n. 4
0
	def replaceinserttableinfo_byparams(self,table,select_params,insert_values):
		if len(insert_values)<1 :
			print '没有插入参数'
			return False
		elif  self.__isconnect==1:
			
			try:
				sql='replace into     '+table
				length=len(select_params)
				if length > 0:
					sql+='('
					for j in range(0,length-1):
						sql=sql+select_params[j]+','
					sql=sql+select_params[length-1]+')'
					sql=sql+'    '
					sql=sql+' values('	
					for j in range(0,length-1):
						sql=sql+'%s'+','	
					sql=sql+'%s'+')'			
				else:
					return False

# 				print sql
				returnmeg=None
				try:
					returnmeg=self.__cur.executemany(sql,insert_values)
					print '返回的消息: '+str(returnmeg)
				
					self.__conn.commit()
					if str(returnmeg)=='0':
						print '没有数据变化'
					return True
# 						self.connectdb()
# 						returnmeg=self.__cur.executemany(sql,insert_values)
# 						print '返回的消息: '+str(returnmeg)		
# 						self.__conn.commit()				
				except MySQLdb.Error,e:
					try:
						if self.isdisconnect(e):
						
							print '进行重连'
							self.connectdb()
							returnmeg=self.__cur.executemany(sql,insert_values)
							print '返回的消息: '+str(returnmeg)
				
							self.__conn.commit()
							return True
						else:
							debug=Debug.getObject()
							debug.error(str(e))
							return False
					except Exception,e:
						return False
Esempio n. 5
0
	def inserttableinfo_byparams(self,table,select_params,insert_values,extra=' ',updatevalue=[]):
		if len(insert_values)<1 :
			print '没有插入参数'
			return False
		elif  self.__isconnect==1:
			
			try:
				sql='insert into     '+table
				length=len(select_params)
				if length > 0:
					sql+='('
					for j in range(0,length-1):
						sql=sql+select_params[j]+','
					sql=sql+select_params[length-1]+')'
					sql=sql+'    '
					sql=sql+' values('	
					for j in range(0,length-1):
						sql=sql+'%s'+','	
					sql=sql+'%s'+')'			
				else:
					return False
				ulen=len(updatevalue)
				if ulen>0:
					sql+='  on duplicate key update  '
					for o in range(0, ulen-1):
						sql=sql+updatevalue[o]+' =  %s '+'  ,'	
					sql=sql+updatevalue[ulen-1]+'  =%s ' 
				sql+=extra
# 				print sql
				
				
				returnmeg=None
				try:
					returnmeg=self.__cur.executemany(sql,insert_values)
				except MySQLdb.Error,e:
					try:
						if self.isdisconnect(e):
							self.connectdb()
							returnmeg=self.__cur.executemany(sql,insert_values)
						else:
							debug=Debug.getObject()
							debug.error(str(e))	
							return False
					except Exception,e:
						return False
				print '返回的消息: '+str(returnmeg)
				if returnmeg>0:
					if self.__conn is not None:
						self.__conn.commit()
					return True
				else:
					return False
Esempio n. 6
0
	def  searchtableinfo_byparams(self,table,select_params=[],request_params=[],equal_params=[],limit='',order='',extra='',command='and'):
		if len(request_params)!=len(equal_params):
			print 'request_params,equals_params长度不相等'
			return (0,0,0,0)
		elif  self.__isconnect==1:

			try:
				sql='select     '
				length=len(select_params)
				if length > 0:

					for j in range(0,length-1):
						sql=sql+select_params[j]+','
					sql=sql+select_params[length-1]
				else:
					sql=sql+'*'
				sql=sql+' from '
				length=len(table)

				for j in range(0,length-1):
					sql=sql+table[j]+','
				sql=sql+table[length-1]
				request_params_length=len(request_params)
				if request_params_length>0:

					sql=sql+' where '
					for k in range(0,request_params_length-1):
						sql=sql+request_params[k]+' = '+equal_params[k]+' '+command+' '
					sql=sql+request_params[request_params_length-1]+' = '+equal_params[request_params_length-1]+'  '
				
				sql+=extra
				if order!='':
					sql+=' order by '+order
				sql+=limit
				sql+=''
# 				print sql
				count=None
				try:
					if self.__cur is not None:
						count=self.__cur.execute(sql)
					else:
						self.connectdb()
						count=self.__cur.execute(sql)
				except MySQLdb.Error,e:
					try:
						if self.isdisconnect(e):
							self.connectdb()
							count=self.__cur.execute(sql)
						else:
							debug=Debug.getObject()
							debug.error(str(e))
							return (0,0,0,0)
					except Exception,e:
						return (0,0,0,0)
				if count>0:
					result=self.__cur.fetchall()
					content=self.__cur.description
					"""
					print '相关信息如下:'
					print result
					print content
					for temp in content:
						print temp[0],
					print ''

					for temp in result:
						for i in range(0,len(temp)):
							print temp[i],
						print ''
					"""
					col=None
					if content is not None:
						col= len(content)
					return result,content,count,col


				else:
					print '没有相关信息'
					return (0,0,0,0)
Esempio n. 7
0
    def updatetableinfo_byparams(self,
                                 table,
                                 select_params=[],
                                 set_params=[],
                                 request_params=[],
                                 equal_params=[],
                                 extra=''):
        if len(request_params) != len(equal_params):
            print 'request_params,equals_params长度不相等'
            return False
        elif self.__isconnect == 1:

            try:
                sql = 'update     '

                length = len(table)

                for j in range(0, length - 1):
                    sql = sql + table[j] + ','
                sql = sql + table[length - 1]

                select_params_length = len(select_params)
                if select_params_length > 0:

                    sql = sql + ' set  '
                    for k in range(0, select_params_length - 1):
                        sql = sql + select_params[k] + ' = ' + set_params[
                            k] + '  , '
                    sql = sql + select_params[select_params_length -
                                              1] + ' = ' + set_params[
                                                  select_params_length -
                                                  1] + '  '

                request_params_length = len(request_params)
                if request_params_length > 0:

                    sql = sql + ' where '
                    for k in range(0, request_params_length - 1):
                        sql = sql + request_params[k] + ' = ' + equal_params[
                            k] + ' and '
                    sql = sql + request_params[request_params_length -
                                               1] + ' = ' + equal_params[
                                                   request_params_length -
                                                   1] + '  '

                sql += extra

                # 				print sql
                count = None
                try:
                    count = self.__cur.execute(sql)

                    self.__conn.commit()
                except MySQLdb.Error, e:
                    try:
                        if self.isdisconnect(e):
                            self.connectdb()
                            count = self.__cur.execute(sql)

                            self.__conn.commit()
                        else:
                            debug = Debug.getObject()
                            debug.error(str(e))
                            return False
                    except Exception, e:
                        return False
                if count > 0:
                    return True
                else:
                    return False
Esempio n. 8
0
    def searchtableinfo_byparams(self,
                                 table,
                                 select_params=[],
                                 request_params=[],
                                 equal_params=[],
                                 limit='',
                                 order='',
                                 extra='',
                                 command='and'):
        if len(request_params) != len(equal_params):
            print 'request_params,equals_params长度不相等'
            return (0, 0, 0, 0)
        elif self.__isconnect == 1:

            try:
                sql = 'select     '
                length = len(select_params)
                if length > 0:

                    for j in range(0, length - 1):
                        sql = sql + select_params[j] + ','
                    sql = sql + select_params[length - 1]
                else:
                    sql = sql + '*'
                sql = sql + ' from '
                length = len(table)

                for j in range(0, length - 1):
                    sql = sql + table[j] + ','
                sql = sql + table[length - 1]
                request_params_length = len(request_params)
                if request_params_length > 0:

                    sql = sql + ' where '
                    for k in range(0, request_params_length - 1):
                        sql = sql + request_params[k] + ' = ' + equal_params[
                            k] + ' ' + command + ' '
                    sql = sql + request_params[request_params_length -
                                               1] + ' = ' + equal_params[
                                                   request_params_length -
                                                   1] + '  '

                sql += extra
                if order != '':
                    sql += ' order by ' + order
                sql += limit
                sql += ''
                print sql
                count = None
                try:
                    if self.__cur is not None:
                        count = self.__cur.execute(sql)
                    else:
                        self.connectdb()
                        count = self.__cur.execute(sql)
                except MySQLdb.Error, e:
                    try:
                        if self.isdisconnect(e):
                            self.connectdb()
                            count = self.__cur.execute(sql)
                        else:
                            debug = Debug.getObject()
                            debug.error(str(e))
                            return (0, 0, 0, 0)
                    except Exception, e:
                        return (0, 0, 0, 0)
                if count > 0:
                    result = self.__cur.fetchall()
                    content = self.__cur.description
                    """
					print '相关信息如下:'
					print result
					print content
					for temp in content:
						print temp[0],
					print ''

					for temp in result:
						for i in range(0,len(temp)):
							print temp[i],
						print ''
					"""
                    col = None
                    if content is not None:
                        col = len(content)
                    return result, content, count, col

                else:
                    print '没有相关信息'
                    return (0, 0, 0, 0)
Esempio n. 9
0
    def __init__(self):
        self.oo = 1

    def temp(self, name):
        print name

    def fuc(self):
        print '123'

    def ad(self):
        return 1


v = alotod()
print v.temp.__name__

# k=getattr(v, 'ad','1')()
try:
    try:
        pp = 1
        pp[2] = ''
    except Exception, e:
        print 2222
except Exception, e:
    print 12222
e = 'askjdajksnd Masdnk'
if 'M' in str(e):
    print 123123
debug = Debug.getObject()
debug.error("asd")
Esempio n. 10
0
    print arg4
  
kwargs = {"arg3": 3, "arg2": "two","arg1":p} # dictionary  
fun_var_args_call(**kwargs)
class alotod:
	def __init__(self):
		self.oo=1
	def temp(self,name):
		print name
	def fuc(self):
		print '123'
	def ad(self):
		return 1
v=alotod()		
print v.temp.__name__		
		
# k=getattr(v, 'ad','1')()
try:
	try:
		pp=1
		pp[2]=''
	except Exception,e:
		print 2222
except Exception,e:
	print 12222
e='askjdajksnd Masdnk'
if 'M' in str(e):
	print 123123
debug=Debug.getObject()
debug.error("asd")