Project

liquigen

0.0
No release in over 3 years
Low commit activity in last 3 years
liquigenjerecui/liquigenHomepageDocumentationSource CodeBug TrackerWiki
Simple tool for generating the liquibase script.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
 Popularity
Downloads
22,153
Stars
3
Forks
1
Watchers
2
 Releases
Current version
0.1.8
Total releases
13
First release
2018-11-03
Latest release
2019-09-09
 Issues
Open Issues
0
Closed Issues
1
Total Issues
1
Issue Closure Rate
100%
 Pull Requests
Open Pull Requests
2
Closed Pull Requests
2
Merged Pull Requests
2
Pull Request Acceptance Rate
33%
 Development
Primary Language
Ruby
Licenses
MIT
Average date of last 50 commits
2019-04-10
Reverse Dependencies
0

 Dependencies

Development

aruba
~> 0
rake
~> 10.0
rspec
~> 3.0

Runtime

activesupport
>= 4.1.11
gli
= 2.18.0
 Project Readme

liquigen

Comparing with ruby, java sucks.

It is a simple tool for java liquibase script generation.

Only support mysql db. And it is not a perfect tool, can help to create basic content with simple name. Please change the generated content manually if the generation was wrong.

Liquibase documentation.

how to use

  1. gem install liquigen

  2. Use the liquigen script. For help, type

liquigen help

create_table

liquigen add_table -t table_name prop1:type prop2:type

# Example
liquigen add_table -t user id:integer name:string email:string created_time:datetime updated_time:datetime

The result file:

databaseChangeLog:
- changeSet:
    id: '20181103214403'
    name: jeremy
    changes:
    - createTable:
        tableName: users
        columns:
        - column:
            name: id
            type: bigint
            constraints:
                primaryKey: true
            autoIncrement: true
        - column:
            name: name
            type: varchar(255)
            constraints:
                nullable: false

rename_table

liquigen rename_table users:s_users customers:s_customers

Result file:

databaseChangeLog:
- changeSet:
    id: 20181121150900_RenameTableUsersAndCustomer
    author: Jeremy
    changes:
    - renameTable:
        oldTableName: users
        newTableName: s_users
    - renameTable:
        oldTableName: customers
        newTableName: s_customers

drop_table

liquigen drop_table user customer

add_column

liquigen add_column -t users name:string email:string

Result:

databaseChangeLog:
- changeSet:
    id: 20181121155512_AddColumn_User_NameAndEmail
    author: Jeremy Cui
    changes:
    - addColumn:
        tableName: users
        columns:
        - column:
            name: name
            type: varchar(255)
            constraints:
                nullable: false
        - column:
            name: email
            type: varchar(255)
            constraints:
                nullable: false

rename_column

liquigen rename_column user:status:status_ok:string customer:status:status_ok:string

Result:

databaseChangeLog:
- changeSet:
    id: 20181121162306_RenameColumn_UserStatusToStatusOkAndCustomerStatusToStatusOk
    author: Jeremy Cui
    changes:
    - renameColumn:
        tableName: users
        oldColumnName: status
        newColumnName: status_ok
        columnDataType: varchar(255)
    - renameColumn:
        tableName: customers
        oldColumnName: status
        newColumnName: status_ok
        columnDataType: varchar(255)

change_type

liquigen change_type user:id:integer customer:name:string

Result:

databaseChangeLog:
- changeSet:
    id: '20181121145051'
    author: Jeremy
    changes:
    - modifyDataType:
        tableName: users
        columnName: id
        newDateType: bigint
    - modifyDataType:
        tableName: customers
        columnName: name
        newDateType: varchar(255)

create_index

liquigen add_index -t user name:string email:string

sql

liquigen sql update permission data

This will generate one file called 'datexxxx_Sql_UpdatePermissionData.ymal'

config

Which is used for scaffolding java codes. In your application directory, one file called '.liquigen' will be added.

liquigen config

Please specify your custom name and path:

  • package_name=com.yourpackage
  • java_codes_root=src/main/java
  • migration_path=src/main/resources/db/migrations
  • controller_package_name=
  • entity_package_name=
  • repository_package_name=
  • repository_suffix= # If you want UserRepository, set Repository here.

scaffold

liquigen scaffold -n table id:integer name:string email:string
# Get help by typing liquigen scaffold --help

How to let the liquibase use migration directory

  • In your java project, open application.yml, add the following lines:
spring:
  liquibase:
    change-log: classpath:/db/changelog-master.yaml
    relativeToChangelogFile: true
  • Edit your changelog-master.yaml file.
databaseChangeLog:
- includeAll:
    path: "db/migrations/"

That's it.

  • Liquigen will create the directory automatically.

How to use the latest source in your java project

  1. Add .ruby-version file to your project root path.
ruby-2.5.1

You can also use the other version.

  1. Add Gemfile file as well.
source 'https://rubygems.org'

gem 'liquigen', :git => 'https://github.com/jerecui/liquigen'
  1. Bundle install
bundle install
  1. cd your project in command line, type liquigen xxxxx
# say
liquigen add_table -t user id:integer name:string

Contributing

Bug reports and pull requests are welcome on GitHub at https://github.com/jerecui/liquigen.

License The gem is available as open source under the terms of the MIT License.