This is a plugin to manage your database records using browser.

• Totally non intrusive. No change is required anywhere in your app. All the features are provided without using any named_scope. Nothing is stored in sesssion or in cookies.

• Browse table records.

• For each individual record a snapshot of all association records is shown. Associations that are supported are has_many, belongs_to and has_one. If an associated record is not present then there will be no link.

• Next to association a count of number of associated records is shown.

• Al the associated records are links so one can navigate from record to record.

• Quick search across all records in a table.

• Advance search for each field of each of the tables.

• Along with search sort the result on any column in ascending or descending order.

• Browse migration records from the table even though there is no corresponding model for it.

• Add a new record (persmission check enforced)

• Edit an existing record (persmission check enforced)

• Delete an existing record (persmission check enforced and no callbacks)

• Destroy an existing record (persmission check enforced and callbacks will be invoked)

http://www.neeraj.name/admin_data

Note that in the demo you will be accessing only features available for read only. You will not be able to update/delete/create any record.

Your Rails project must be using Rails 2.2 or higher.

ruby script/plugin install git://github.com/neerajdotname/admin_data.git

that's it. Now visit http://localhost:3000/admin_data

If you are using Rails 2.2 then you need to checkout older version of this plugin like this

	
	git clone git://github.com/neerajdotname/admin_data.git
   	cd admin_data
   	git co -b for_rails_2.2 origin/for_rails_2.2
   	cd ..
   	cp -rv admin_data my_app/vendor/plugins 
   

After the plugin has been copied to your vendor/plugins directory then you need to make certain changes to the config/routes.rb .

After installing the plugin you need to put following lines of code in config/routes.rb at the very top

AdminData::Routing.connect_with map. 

After the lines have been added it might look like this

ActionController::Routing::Routes.draw do |map|
  AdminData::Routing.connect_with map
  # ... more routing information
end

http://localhost:3000/admin_data

This plugin will allow access to browse the models without any authorization check in development and test environment.

However in other environments a security check is enforced. Given below is one way to ensure authentication. Put the following lines of code in an initializer at ~/config/initializers/admin_data.rb

ADMIN_DATA_VIEW_AUTHORIZATION = Proc.new { |controller| controller.send("admin_logged_in?") }

ADMIN_DATA_UPDATE_AUTHORIZATION    = Proc.new { |controller| return false }

I have tested this plugin with MySQL and PostgreSQL.

Email me: neerajdotname [at] gmail (dot) com

www.neeraj.name

http://github.com/neerajdotname/admin_data

MIT

Copyright (c) 2009 neerajdotname