Python DBmysql.execSQLの例

コード例 #1

ファイル: auth.py プロジェクト: harveyzh/tunnelking

def logLastLogin(id):
	# insert session key
	try:
		db = DBmysql(config.databaseUserName, config.databasePassword, config.databaseName)
		sql = "UPDATE users SET lastlogin = NOW() WHERE id = %s" % id
		db.execSQL(sql)
	except Exception, e:
		log.log(2, "%s: %s" % (type(e), e))
		sys.exit(1)

コード例 #2

def logLastLogin(id):
    # insert session key
    try:
        db = DBmysql(config.databaseUserName, config.databasePassword,
                     config.databaseName)
        sql = "UPDATE users SET lastlogin = NOW() WHERE id = %s" % id
        db.execSQL(sql)
    except Exception, e:
        log.log(2, "%s: %s" % (type(e), e))
        sys.exit(1)

コード例 #3

ファイル: learnaddress.py プロジェクト: harveyzh/tunnelking

	def learn(self, rip, lip, id):
		try:
			db = DBmysql(config.databaseUserName, config.databasePassword, config.databaseName)
			
			sql = "INSERT INTO connections (lip, rip, userid) VALUES('%s', '%s', %s) ON DUPLICATE KEY UPDATE rip = '%s', userid = %s" % (lip, rip, id, rip, id)
			log.log(3, "sql: %s" % (sql))
			
			db.execSQL(sql)
		except Exception, e:
			log.log(2, "learn %s: %s" % (type(e), e))
			sys.exit(1)

コード例 #4

    def learn(self, rip, lip, id):
        try:
            db = DBmysql(config.databaseUserName, config.databasePassword,
                         config.databaseName)

            sql = "INSERT INTO connections (lip, rip, userid) VALUES('%s', '%s', %s) ON DUPLICATE KEY UPDATE rip = '%s', userid = %s" % (
                lip, rip, id, rip, id)
            log.log(3, "sql: %s" % (sql))

            db.execSQL(sql)
        except Exception, e:
            log.log(2, "learn %s: %s" % (type(e), e))
            sys.exit(1)