---
title: "ruby on rails 连接多个数据库"
author: "PBFox"
date: "2007-09-25T08:51:00Z"
tags: []
slug: "ruby-on-rails"
draft: false
lastmod: "2007-09-25T08:51:00Z"
id: 479284
url: "https://developerwork.iteye.com/blog/479284"
---

首先在database.yml中加入以下代码，其中cg\_clone是外部等待使用的数据库。  
cg\_clone:  
adapter: mysql  
database: cg\_clone  
username: root  
password:  
host: localhost

假如在cg\_clone中有一张表叫contracts，那么生成Contract类。并用establish\_connection来声明建立到哪个数据库的连接：

class Contract &lt; ActiveRecord::Base  
establish\_connection :cg\_clone  
end

这样我们在控制器中就可以使用Contract类了，如：

def contract\_list  
@contracts=Contract.find\_all  
end