Deki
Posts: 0
Joined: Tue Apr 15, 2014 4:53 pm

How to update database service on change of database columns

It seems like the database services do not refresh with the latest modifications that I make to the database; for example adding a new column. It seems that I need to re-create the service in order to see the updates (i.e. addition of new column) to the database. But, if I need to re-create the service that means deleting all of my work and starting over again. Is there an easier and more efficient way to update database services after changes are made to the database?

Thanks

RobertJay
Posts: 0
Joined: Fri Jun 15, 2012 1:32 pm

How to update database service on change of database columns

Deki's issue is an issue for me too. If a better approach does not now exist, please consider this a feature request from me. Thanks.

Kateryna Grynko
Posts: 0
Joined: Thu Nov 15, 2012 9:13 am

How to update database service on change of database columns

Hi,

1) Do database changes (delete/add column).
2) Run database service test.
3) Automatically create response parameters:
http://docs.appery.io/documentation/r...

Deki
Posts: 0
Joined: Tue Apr 15, 2014 4:53 pm

How to update database service on change of database columns

Katya,
I have tried that but it doesn't work....actually it makes things worse because it deletes all the current columns from the service...see screenshot Image

Igor
Posts: 0
Joined: Tue Apr 02, 2013 12:05 pm

How to update database service on change of database columns

Hello,

There are two ways how can you add/delete response parameter.

  1. Automatically define response
    http://docs.appery.io/documentation/r...
    2.Or you can add/delete response parameter manually
    http://docs.appery.io/documentation/r...
RobertJay
Posts: 0
Joined: Fri Jun 15, 2012 1:32 pm

How to update database service on change of database columns

The first approach works very nicely - thanks Igor for saving me a lot of time.

Andrew6784445
Posts: 1
Joined: Fri Apr 04, 2014 2:08 pm

How to update database service on change of database columns

I just imported the test service response (approach #1 above) but it looks like all mappings and javascript related to my service have been deleted. Is there way to refresh service responses automatically without losing my work? Is there a way to get my mappings and js back easily?

Illya Stepanov
Posts: 0
Joined: Mon Mar 18, 2013 8:48 am

How to update database service on change of database columns

Hi Andrew,

This is not very clear, could you please describe how exactly you have imported service?

Mapping and JS is a service data details page and there is no easy way to import it or copy, except if the page is created as a template. (http://devcenter.appery.io/documentat...).

Andrew6784445
Posts: 1
Joined: Fri Apr 04, 2014 2:08 pm

How to update database service on change of database columns

I loaded the service from Project | Services. Next, I ran a test and clicked the button "Import as Response". It automatically brought in my new structure for the response parameters in the service. However, when I went to the data tab on my page, my mappings and js tied to the service were gone.

Illya Stepanov
Posts: 0
Joined: Mon Mar 18, 2013 8:48 am

How to update database service on change of database columns

Import as Response -- only defines response parameters, mapping and JS should be defined manually.

Return to “Issues”