Rubygems | Latest Versions for gadgethttps://rubygems.org/gems2023-09-30T00:50:11Zgadget (0.7.0)https://rubygems.org/gems/gadget/versions/0.7.02016-11-01T21:03:59ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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
gadget (0.6.2)https://rubygems.org/gems/gadget/versions/0.6.22015-02-05T18:03:20ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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
gadget (0.6.1)https://rubygems.org/gems/gadget/versions/0.6.12014-09-10T22:19:58ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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
gadget (0.6.0)https://rubygems.org/gems/gadget/versions/0.6.02014-03-26T02:15:50ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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
gadget (0.5.4)https://rubygems.org/gems/gadget/versions/0.5.42014-03-25T15:49:27ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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
gadget (0.5.3)https://rubygems.org/gems/gadget/versions/0.5.32014-03-25T15:12:24ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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
gadget (0.5.2)https://rubygems.org/gems/gadget/versions/0.5.22014-02-26T18:09:49ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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
gadget (0.5.1)https://rubygems.org/gems/gadget/versions/0.5.12014-02-26T16:39:11ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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
gadget (0.5.0)https://rubygems.org/gems/gadget/versions/0.5.02014-02-26T15:51:00ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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.
`#functions(conn)`
Returns a list of all functions in the schema reachable through `conn`.
`#triggers(conn)`
Returns a list of all triggers in the schema reachable through `conn`.
`#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.
## 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
gadget (0.4.1)https://rubygems.org/gems/gadget/versions/0.4.12014-02-21T01:12:21ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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.
`#functions(conn)`
Returns a list of all functions in the schema reachable through `conn`.
`#triggers(conn)`
Returns a list of all triggers in the schema reachable through `conn`.
`#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.
## 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
gadget (0.4.0)https://rubygems.org/gems/gadget/versions/0.4.02014-02-20T21:07:36ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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.
`#functions(conn)`
Returns a list of all functions in the schema reachable through `conn`.
`#triggers(conn)`
Returns a list of all triggers in the schema reachable through `conn`.
`#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.
## 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
gadget (0.3.2)https://rubygems.org/gems/gadget/versions/0.3.22014-02-20T17:04:28ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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.
`#functions(conn)`
Returns a list of all functions in the schema reachable through `conn`.
`#triggers(conn)`
Returns a list of all triggers in the schema reachable through `conn`.
`#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.
## 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
gadget (0.3.1)https://rubygems.org/gems/gadget/versions/0.3.12014-02-20T16:59:34ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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.
`#functions(conn)`
Returns a list of all functions in the schema reachable through `conn`.
`#triggers(conn)`
Returns a list of all triggers in the schema reachable through `conn`.
`#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.
## 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
gadget (0.3.0)https://rubygems.org/gems/gadget/versions/0.3.02014-02-20T16:55:51ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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.
`#functions(conn)`
Returns a list of all functions in the schema reachable through `conn`.
`#triggers(conn)`
Returns a list of all triggers in the schema reachable through `conn`.
`#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.
## 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
gadget (0.2.1)https://rubygems.org/gems/gadget/versions/0.2.12014-02-19T23:31:06ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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.
`#functions(conn)`
Returns a list of all functions in the schema reachable through `conn`.
`#triggers(conn)`
Returns a list of all triggers in the schema reachable through `conn`.
`#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.
## 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
gadget (0.2.0)https://rubygems.org/gems/gadget/versions/0.2.02014-02-19T20:53:09ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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.
`#functions(conn)`
Returns a list of all functions in the schema reachable through `conn`.
`#triggers(conn)`
Returns a list of all triggers in the schema reachable through `conn`.
`#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.
## 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
gadget (0.1.0)https://rubygems.org/gems/gadget/versions/0.1.02014-01-28T16:00:36ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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.
`#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.
## 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
gadget (0.0.2)https://rubygems.org/gems/gadget/versions/0.0.22014-01-27T22:19:09ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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.
`#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.
## 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
gadget (0.0.1)https://rubygems.org/gems/gadget/versions/0.0.12014-01-27T21:14:12ZCraig S. CottinghamSome methods for getting metadata and other deep details from a PostgreSQL database.
# 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.
`#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.
## 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