Description
nullalign is a tool to detect missing non-null constraints in Rails projects.
Nullalign alternatives and similar gems
Based on the "Database Tools" category
-
Seedbank
Seedbank allows you to structure your Rails seed data instead of having it all dumped into one large file. -
Upsert
Upsert on MySQL, PostgreSQL, and SQLite3. Transparently creates functions (UDF) for MySQL and PostgreSQL; on SQLite3, uses INSERT OR IGNORE. -
SecondBase
Seamless second database integration for Rails. SecondBase provides support for Rails to manage dual databases by extending ActiveRecord tasks that create, migrate, and test your application. -
QueryTrack
Tool for finding time-consuming database queries for ActiveRecord-based Rails Apps. Provides Slack notifications for with backtrace, raw SQL, time duration, etc. -
Ruby PG Extras
Ruby PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more. -
PgDriveBackup
Simple solution to make encrypted with ccrypt PostgreSQL backups and storing on Google Drive API -
PgDice
Postgres table partitioning with a Ruby API built on top of https://github.com/ankane/pgslice -
ActiveRecord::DataIntegrity
Data Integrity Checker for Rails -
bundler-download
Bundler plugin for auto-downloading extra gem files (e.g. large file downloads) post bundle install
Scout APM: Application Performance Monitoring
* Code Quality Rankings and insights are calculated and provided by Lumnify.
They vary from L1 to L5 with "L5" being the highest. Visit our partner's website for more details.
Do you think we are missing an alternative of Nullalign or a related project?
Popular Comparisons
-
NullalignvsLarge Hadron Migrator
-
NullalignvsSquasher
-
NullalignvsSeed Fu
-
NullalignvsBatchLoader
-
NullalignvsPgHero
|
SaaSHub - Software Alternatives and Reviews
More from our partner
|
README
Nullalign
Description
nullalign is a tool to detect missing non-null constraints in Rails projects.
Suppose you have a validation like this:
validates :email, presence: true
Do you have a non-null constraint in your database to back that up? If not, nullalign will find it for you.
Nullalign is based on Colin Jones' consistency_fail. I mean really really based on it, as in I copied and pasted over a bunch of the code and changed the module and file names. And a lot of this README, too.
Installation
Put this in the development group in your Gemfile
gem 'nullalign'
Usage
Run it like this:
bundle exec nullalign
Example output
There are presence validators that aren't backed by non-null constraints.
--------------------------------------------------------------------------------
Model Table Columns
--------------------------------------------------------------------------------
Album albums: name, owner_id
AttendanceRecord attendance_records: group_id, attended_at
CheckinLabel checkin_labels: name, xml
CheckinTime checkin_times: campus
Generating a migration
You can also run a Rake task which will generate a migration which will add indexes as needed:
bundle exec rake nullalign:fix
Limitations
nullalign depends on being able to find all your ActiveRecord::Base
subclasses with some $LOAD_PATH trickery. If any models are in a path either
not on your project's load path or in a path that doesn't include the word
"models", nullalign won't be able to find or analyze them. I'm open to
making the text "models" configurable if people want that. Please open an issue
or pull request if so!
To disable nullalign, I could add a thing that checks column comments for a string like 'nonullalign' if people think that would be useful. Just let me know.
Contributors
- Tom Copeland - author
- Denny Mueller - fix for ActiveStorage compatibility issue
- Woongcheol Yang - support for conditional validations
- Paweł Dąbrowski - Rake task suggestion
Tests
You can run the tests with:
bundle exec rspec
License
Released under the MIT License. See the LICENSE file for further details.
*Note that all licence references and agreements mentioned in the Nullalign README section above
are relevant to that project's source code only.