Results 1 to 4 of 4

Thread: Continuous integration of Local deployment changes in Lianja 6.3

  1. #1
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,515
    Blog Entries
    15

    Continuous integration of Local deployment changes in Lianja 6.3

    When developing in the App Builder you can now deploy schema changes in the development branch for the databases.

    See below:

    Code:
    drop database southwind_live
    copy database "cloudserver:/tenants\public\data\southwind" to southwind_live
    compare database southwind with southwind_live
    compare database southwind with southwind_live to "cloudserver:/tenants\public\data\southwind\dbc_upgrade.prg"
    Here we make a copy of out "live" database with all its tables, indexes, business rules, triggers and other resources.

    Code:
    copy database "cloudserver:/tenants\public\data\southwind" to southwind_live
    We then compare the two databases i.e our current development database and the deployed "live" database on our local development machine.

    Code:
    compare database southwind with southwind_live
    If the changes look as intended you then deploy the upgrade script "dbc_upgrade.prg".

    Code:
    compare database southwind with southwind_live to "cloudserver:/tenants\public\data\southwind\dbc_upgrade.prg"


    When you access any app with "Preview in browser" on your development machine the dbc_upgrade script will be autodetected and executed (then removed) to upgrade your "live"
    database without any other deployment being needed.

    To provide Continous Integration I have added a new App delegate "Before Preview". You can add the above code to this delegate and it will be run each time you "preview live in the browser". This delegate is called with the name of the database for the app as a parameter.



    Last edited by barrymavin; 2021-09-10 at 11:57.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  2. #2
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    2,119
    FANTASTIC!

    Make Fast, Break Fast, Fix Fast: that's how to get rockets into space fast and how to deliver working apps fast.

  3. #3
    Member
    Join Date
    Feb 2012
    Location
    Earth.Europe.Germany.Bavaria.Obing
    Posts
    44
    Thus Lianja is the SpaceX of DevTools? Cool Analogy
    wOOdy

  4. #4
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,515
    Blog Entries
    15
    Glad you like it wOOdy. Theres lots of great features and functionality and its getting better each release.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us