sqlite database /retrofit (json object)

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

im a newbie here. my problem goes with this; i like to send all my data created from my sqlite database and send it all to my custom api via json object. is this possible? if is it, can you give me reference on how to do it? because i can't find any solution for this. thanks you :)

This is my database from my mobile ive like to fetch on retrofit

enter image description here

asked Nov 29 '18 at 6:28

Julius Andaya

8511

add a comment |

This is my database from my mobile ive like to fetch on retrofit

enter image description here

asked Nov 29 '18 at 6:28

Julius Andaya

8511

add a comment |

This is my database from my mobile ive like to fetch on retrofit

enter image description here

asked Nov 29 '18 at 6:28

Julius Andaya

8511

This is my database from my mobile ive like to fetch on retrofit

enter image description here

android-sqlite retrofit2 sqliteopenhelper

asked Nov 29 '18 at 6:28

Julius Andaya

8511

asked Nov 29 '18 at 6:28

Julius Andaya

8511

asked Nov 29 '18 at 6:28

Julius Andaya

8511

asked Nov 29 '18 at 6:28

Julius Andaya

8511

asked Nov 29 '18 at 6:28

Julius Andaya

8511

add a comment |

1 Answer
1

active

oldest

votes

The easiest way is to create an Object for your data then convert that Object to json via GSON.

public class Data {



private int id;

private double latitude;

private double longitude;

private long dateTime;

private int syncStatus;



//Create a constructor for all fields



//Don't forget to generate setters/getters



}

Then set the data for the Object

Data data = new Data(id, latitude, longitude, datetime, synctime);

To convert the Object to Json

Gson gson = new Gson();

String json = gson.toJson(data);

You can also use the Object directly without using GSON via Retrofit.

public interface GetDataService {



    @POST("/api/data")

    Call<Data> createData(@Body Data data);

}

Also use ORM when using sqlite.

answered Dec 6 '18 at 1:27

mariozawa

1,268711

almost my code was the same(no gson conversion only), but i dont get the logic... this is my last previous code it only sends data what ive been getting in my onvclick listener. to the api.. but i want the all data saved to be send like json object.

– Julius Andaya
Dec 6 '18 at 3:47

Can you post some of your code?

– mariozawa
Dec 6 '18 at 4:37

here sir, stackoverflow.com/questions/53644148/…

– Julius Andaya
Dec 6 '18 at 5:05

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53533043%2fsqlite-database-retrofit-json-object%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

The easiest way is to create an Object for your data then convert that Object to json via GSON.

public class Data {



private int id;

private double latitude;

private double longitude;

private long dateTime;

private int syncStatus;



//Create a constructor for all fields



//Don't forget to generate setters/getters



}

Then set the data for the Object

Data data = new Data(id, latitude, longitude, datetime, synctime);

To convert the Object to Json

Gson gson = new Gson();

String json = gson.toJson(data);

You can also use the Object directly without using GSON via Retrofit.

public interface GetDataService {



    @POST("/api/data")

    Call<Data> createData(@Body Data data);

}

Also use ORM when using sqlite.

answered Dec 6 '18 at 1:27

mariozawa

1,268711

almost my code was the same(no gson conversion only), but i dont get the logic... this is my last previous code it only sends data what ive been getting in my onvclick listener. to the api.. but i want the all data saved to be send like json object.

– Julius Andaya
Dec 6 '18 at 3:47

Can you post some of your code?

– mariozawa
Dec 6 '18 at 4:37

here sir, stackoverflow.com/questions/53644148/…

– Julius Andaya
Dec 6 '18 at 5:05

add a comment |

The easiest way is to create an Object for your data then convert that Object to json via GSON.

public class Data {



private int id;

private double latitude;

private double longitude;

private long dateTime;

private int syncStatus;



//Create a constructor for all fields



//Don't forget to generate setters/getters



}

Then set the data for the Object

Data data = new Data(id, latitude, longitude, datetime, synctime);

To convert the Object to Json

Gson gson = new Gson();

String json = gson.toJson(data);

You can also use the Object directly without using GSON via Retrofit.

public interface GetDataService {



    @POST("/api/data")

    Call<Data> createData(@Body Data data);

}

Also use ORM when using sqlite.

answered Dec 6 '18 at 1:27

mariozawa

1,268711

almost my code was the same(no gson conversion only), but i dont get the logic... this is my last previous code it only sends data what ive been getting in my onvclick listener. to the api.. but i want the all data saved to be send like json object.

– Julius Andaya
Dec 6 '18 at 3:47

Can you post some of your code?

– mariozawa
Dec 6 '18 at 4:37

here sir, stackoverflow.com/questions/53644148/…

– Julius Andaya
Dec 6 '18 at 5:05

add a comment |

The easiest way is to create an Object for your data then convert that Object to json via GSON.

public class Data {



private int id;

private double latitude;

private double longitude;

private long dateTime;

private int syncStatus;



//Create a constructor for all fields



//Don't forget to generate setters/getters



}

Then set the data for the Object

Data data = new Data(id, latitude, longitude, datetime, synctime);

To convert the Object to Json

Gson gson = new Gson();

String json = gson.toJson(data);

You can also use the Object directly without using GSON via Retrofit.

public interface GetDataService {



    @POST("/api/data")

    Call<Data> createData(@Body Data data);

}

Also use ORM when using sqlite.

answered Dec 6 '18 at 1:27

mariozawa

1,268711

The easiest way is to create an Object for your data then convert that Object to json via GSON.

public class Data {



private int id;

private double latitude;

private double longitude;

private long dateTime;

private int syncStatus;



//Create a constructor for all fields



//Don't forget to generate setters/getters



}

Then set the data for the Object

Data data = new Data(id, latitude, longitude, datetime, synctime);

To convert the Object to Json

Gson gson = new Gson();

String json = gson.toJson(data);

You can also use the Object directly without using GSON via Retrofit.

public interface GetDataService {



    @POST("/api/data")

    Call<Data> createData(@Body Data data);

}

Also use ORM when using sqlite.

answered Dec 6 '18 at 1:27

mariozawa

1,268711

answered Dec 6 '18 at 1:27

mariozawa

1,268711

answered Dec 6 '18 at 1:27

mariozawa

1,268711

answered Dec 6 '18 at 1:27

mariozawa

1,268711

almost my code was the same(no gson conversion only), but i dont get the logic... this is my last previous code it only sends data what ive been getting in my onvclick listener. to the api.. but i want the all data saved to be send like json object.

– Julius Andaya
Dec 6 '18 at 3:47

Can you post some of your code?

– mariozawa
Dec 6 '18 at 4:37

here sir, stackoverflow.com/questions/53644148/…

– Julius Andaya
Dec 6 '18 at 5:05

add a comment |

almost my code was the same(no gson conversion only), but i dont get the logic... this is my last previous code it only sends data what ive been getting in my onvclick listener. to the api.. but i want the all data saved to be send like json object.

– Julius Andaya
Dec 6 '18 at 3:47

Can you post some of your code?

– mariozawa
Dec 6 '18 at 4:37

here sir, stackoverflow.com/questions/53644148/…

– Julius Andaya
Dec 6 '18 at 5:05

almost my code was the same(no gson conversion only), but i dont get the logic... this is my last previous code it only sends data what ive been getting in my onvclick listener. to the api.. but i want the all data saved to be send like json object.

– Julius Andaya
Dec 6 '18 at 3:47

Can you post some of your code?

– mariozawa
Dec 6 '18 at 4:37

here sir, stackoverflow.com/questions/53644148/…

– Julius Andaya
Dec 6 '18 at 5:05

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Btukfyl