RubyGems Navigation menu

gadget 0.6.1

# Gadget Some methods for getting metadata and other deep details from a PostgreSQL database. ## Installation Add this line to your application's Gemfile: gem 'gadget' And then execute: $ bundle Or install it yourself as: $ gem install gadget ## Usage `#tables(conn)` Returns a list of all tables in the schema reachable through `conn`. `#columns(conn, tablename=nil)` Returns a list of all columns in the schema reachable through `conn`. If `tablename` is given, returns the columns in only that table. `#foreign_keys(conn, tablename=nil)` Returns a list of all foreign keys in the schema reachable through `conn`. If `tablename` is given, returns the foreign keys in only that table. `#constraints(conn, tablename=nil)` Returns a list of all constraints in the schema reachable through `conn`. If `tablename` is given, returns the constraints in only that table. `#dependencies(conn)` Returns a structure representing the dependencies between tables in the schema reachable through `conn`. Table A is defined as dependent on table B if A contains a foreign key reference to B. `#tables_in_dependency_order(conn)` Returns a list of all tables in the schema reachable through `conn`, ordered such that any given table appears later in the list than all of its dependencies. `#dependency_graph(conn)` Returns `.dot` script (suitable for feeding into Graphviz) describing the table dependency graph. `#functions(conn)` Returns a list of all functions in the schema reachable through `conn`. `#sequences(conn)` Returns a list of all sequences in the schema reachable through `conn`. `#triggers(conn)` Returns a list of all triggers in the schema reachable through `conn`. `#types(conn)` Returns a list of all types in the schema reachable through `conn`. ## Contributing 1. Fork it 2. Create your feature branch (`git checkout -b my-new-feature`) 3. Commit your changes (`git commit -am 'Add some feature'`) 4. Push to the branch (`git push origin my-new-feature`) 5. Create new Pull Request

Gemfile:
= Copy to clipboard Copied!

install:
=

Versions:

  1. 0.7.0 - November 01, 2016 (9.5 KB)
  2. 0.6.2 - February 05, 2015 (9.5 KB)
  3. 0.6.1 - September 10, 2014 (9.5 KB)
  4. 0.6.0 - March 26, 2014 (9.5 KB)
  5. 0.5.4 - March 25, 2014 (8.5 KB)
Show all versions (19 total)

Runtime Dependencies (1):

pg ~> 0.17.0

Development Dependencies (2):

bundler ~> 1.3
rake >= 0

Owners:

Authors:

  • Craig S. Cottingham

SHA 256 checksum:

93151177047ae016ec022dc95c951b7862a868c2b0473a7e0897dcb9ce63d1f2

Total downloads 47,500

For this version 2,528

License:

MIT

Required Ruby Version: >= 0

Links: