Database Develop

MyEpisodes Viewer Available

Hi Guys
Don’t miss your favourite TV programs, let MyEpisodes viewer show you when it’s on.
MyEpisodes Viewer is an easy to use viewer that extends www.myepisodes.com website to your mobile phone.
All the viewer requires is your MyEpisodes username and password to fetch the listings you have already configured on the MyEpisodes site,
The viewer also allows you to update listed episodes to watched status with one click.
Caveats
1.) Due to MyEpisodes not having a standard API, the Viewer uses a API Helper site (api.madmouse.co.uk) to handle the data.
2.) MyEpisodes has the right to change permissions and there site without notice, which could cause the application to stop working.
3.) To allow api.madmouse.co.uk to enable advanced caching some information that identifies the device will be transmitted to the site
a. These details are hashed and erased 20 minutes after last call to the site.
b. No data is record to disk.
c. No data will be passed onto 3rd Party vendors.
Have Fun

I will put this into the Market place, when teh development team sort out a few issues that prevent me from uploading the application.
Such as?? If I may inquire.

Hi flcl
I have to admit when I am wrong, please ignore or learn from the unjustified comment, as it turned out to be a flaw in the build process.
If developers have the following problem in the future , here's how to solve it.
After building/signing an application, when you publish it get this message
"The new apk's versionCode (x) in AndroidManifest.xml must be higher
than the old apk's versionCode (x)."
If you have set the android:versionCode to a higher number than x, it means your application manifest file has not been updated correctly.
These are the steps I took to correct the problem.
Make sure you have increased the android:versionCode.
close all applications that don't need to be built in the Eclipse editor.
Delete the APK if it already exists (Optional)
Run Project -> clean , select your application hit ok
Rebuild - Export unsigned Package/sign then publish
I have now published the applicaton in the marketplace.

[RHBROMS][WIP][Guide] Mobile Application Testing [Manual Testing/Automation Testing]

{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
Presents
Mobile Application Testing
This will be a Full Tutorial on Mobile Application Testing.
I will be updating this thread as I get time. SO NO ETA's.
Click to expand...
Click to collapse
If anybody wants to use / copy this tutorial to their Website or Blog please feel free to contact me at my personal email id: [email protected]
or at our official Website: www.rhbroms.com
Click to expand...
Click to collapse
Please Click on Thanks button if this tutorial by me had helped you for some extent !!!
Click to expand...
Click to collapse
Manual Testing
Contents:
1. What is Mobile Application Testing?
2. Difference Between Mobile Testing and Mobile Application Testing.
3. Mobile Application Extensions and Small intro about Android Platform.
4. How to Test a Mobile Application?
Automation Testing
Click on the below Topics to Lean Automation Testing..
It will take only 2-3 days to learn If you are good at Java
Contents:
1. Robotium for Android Application Testing.
2. Monkeyrunner for Android Application Testing.​
Credits,
My Parents - For the best support.
@Swaroop Bandagadde - For the best support.
Renas Reda(Founder of Robotium Test Automation Tool) - For liking my tutorial and for the best support. :good:
jutikorn (My friend) - For the best support.

Mobile Application Testing
1. What is Mobile Application Testing?​
It is somewhat similar to software testing but the testing will be performed on a mobile device instead of performing on a system.
Types of Mobile application Testing are:
1. Installation testing.
2. Functional Testing.
3. Memory Leakage Testing.
4. Interrupt Testing.
5. Usability testing.
6. Certification Testing.
7. Performance Testing.
8. Integration Testing.
9. System Testing.
10. Accessibility Testing.
11. Adhoc(Monkey) Testing.
The all above points will be discussed on "How to Test Mobile application?" Chapter.
2. Difference Between Mobile Testing and Mobile Application Testing.​
Mobile Testing
- Mobile Testing is testing of Mobile Handsets or Devices.
- Here we mainly concentrate on Native applications(Blot wares).
- Testing all the core like SMS, Voice calls, Connectivity(Bluetooth), Battery(Charging), Signal receiving, Network are working correctly.
- Testing is conducted on both hardware and software.
Mobile Application Testing
- Mobile Application Testing is the testing of mobile applications which we are making as third party for the targeted mobile handset.
- Some core feature of the mobile are tested just to see that your application has not created any side effects on the device functionality.

Mobile Application Extensions and Small intro about Android Platform
3. Mobile Application Extensions and Small intro about Android Platform.​
Below are some Mobile Platforms given with respective File Extensions
1. Android - .apk (Android application package file)
2. Iphone - .ipa (iOS application archive file)
3. Symbian - .sis (Software Installation Script)
4. J2ME - .jad and .jar (Java Application Descriptor and Java ARchive)
5. RIM - .alx and .cod
6. Windows Mobile - .cab
7. Bada - .jad and .jar (Java Application Descriptor and Java ARchive)
Android Platform
Testing Purpose we should have to know about the android architecture as well as about Android Versions. Details On this discussed below:
Architecture of Android:
Android operating system is a stack of software components which is roughly divided into five sections and four main layers as shown below in the architecture diagram:
Linux kernel
At the bottom of the layers is Linux - Linux 2.6 with approximately 115 patches. This provides basic system functionality like process management, memory management, device management like camera, keypad, display etc. Also, the kernel handles all the things that Linux is really good at such as networking and a vast array of device drivers, which take the pain out of interfacing to peripheral hardware.
Libraries
On top of Linux kernel there is a set of libraries including open-source Web browser engine WebKit, well known library libc, SQLite database which is a useful repository for storage and sharing of application data, libraries to play and record audio and video, SSL libraries responsible for Internet security etc.
Android Runtime
This is the third section of the architecture and available on the second layer from the bottom. This section provides a key component called Dalvik Virtual Machine which is a kind of Java Virtual Machine specially designed and optimized for Android.
The Dalvik VM makes use of Linux core features like memory management and multi-threading, which is intrinsic in the Java language. The Dalvik VM enables every Android application to run in its own process, with its own instance of the Dalvik virtual machine.
The Android runtime also provides a set of core libraries which enable Android application developers to write Android applications using standard Java programming language.
Application Framework
The Application Framework layer provides many higher-level services to applications in the form of Java classes. Application developers are allowed to make use of these services in their applications.
Applications
You will find all the Android application at the top layer. You will write your application to be installed on this layer only. Examples of such applications are Contacts Books, Browser, Games etc.
Android Application Activity Lifecycle
The life cycle of an activity with main methods as shown below:
onCreate() This is the first callback and called when the activity is first created.
onStart() This callback is called when the activity becomes visible to the user.
onResume() This is called when the user starts interacting with the application.
onPause() The paused activity does not receive user input and cannot execute any code and called when the current activity is being paused and the previous activity is being resumed.
onStop() This callback is called when the activity is no longer visible.
onDestroy() This callback is called before the activity is destroyed by the system.
onRestart() This callback is called when the activity restarts after stopping it.
If you know this much it is enough to Go ahead with Mobile application testing in Android platform.

How to Test a Mobile Application?
4. How to Test a Mobile Application?​
1. Installation testing:
To Verify application can be installed successfully.
Different ways of Installing an application to Android Device:
1(a). OTA(Over The Air) : We can install our application by using android play store app on the mobile or else by browsing into Google playstore website. This can be done using WiFi as well as by using GPRS connection.
1(b). Sideloading From Your PC : To do this we need ADB(Android Debug Bridge). This is a very simplest way to install any 3rd party app to your device, most of the time we test engineers prefer this way only.
Just download and Install Android SDK to your system and follow the below steps:
1. Download the application (APK) file to a folder of your choice on your computer.
2. Connect the phone to the computer through the USB port.
3. Enable installation of non-market applications on your phone:
a. On your phone, open the Applications menu (i.e., the tab in the bottom center of the
phone’s home screen) and click on the Settings application, then select Applications
from the Settings menu.
b. Make sure that the first selection, Unknown Sources, is checked so that you can install
an APK file from a location other than the Android Market. A warning message about
the phone being vulnerable to attack will be displayed. Select OK to continue if you
trust the APK file you are about to download. You can change this setting back after the
current installation is complete.
4. Turn on “USB debugging” on your phone: open the Applications menu and select Development,
then enable USB debugging.
5. Open a command/terminal window:
• On Windows, select Start > Run> then type ‘cmd’.
• On Mac OS X, open the Applications folder, select Utilities, then Terminal.
• On Linux, select Applications > Accessories > Terminal.
6. In the command/terminal window, enter the following command:
Code:
adb install <APK_FILE_PATH><APK_FILE>
2. Functional Testing:
Testing the functionality of the application with respect to given requirements of the application.
2(a). Application LOGO Test: Testing the logo of the application to check whether the app which is under test have used the proper logo as per the requirement specification or not.
2(b). Application Splash Screen Test: To verify that when user selects application logo in application manager splash is displayed.
Note that Splash do not remain for more than 3 seconds.
2(c). Application Background Image Test: To test whether the application under test is using the proper Background image as per given requirement specification or not.
2(d). Font style / size / color: Testing the Font size/style/color as per requirement specification.
2(e). Layout: Testing the layouts with respect to given requirement specification.
2(f). Back Key: Verify that back key should navigate the user to previous screen or should close the application with proper exit popup dialog(Again it depends on Requirement specification).
2(g). Application Start/Restart:
i. Find the application icon and select it
ii. Observe the application launch In the timeline defined.
iii. Application must not take more than 25s to start
2(h). Exit Application: Verify that user is able to exit from application with every form of exit modes like Flip, Slider, End Key or Exit option in application and from any point.
3. Memory Leakage Testing
Memory leakage happens when a computer program or application is unable to manage the memory it is allocated resulting in poor performance of the application and the overall slowdown of the system. As mobile devices have significant constraints of available memory, memory leakage testing is crucial for the proper functioning of an application.
4. Interrupt Testing
An application while functioning may face several interruptions like incoming calls or network coverage outage and recovery. The different types of interruptions are:
Incoming and Outgoing SMS and MMS.
Incoming and Outgoing calls.
Incoming Notifications.
Battery Removal.
Cable Insertion and Removal for data transfer.
Network outage and recovery.
Media Player on/off.
Device Power cycle.
An application should be able to handle these interruptions by going into a suspended state and resuming afterwards.
5. Usability testing
Checking the user-friendliness of the application is known as Usability testing.
We have to verify if the application is achieving its goals and getting a favorable response from users. The application should have to give the results in very few steps or in few clicks.
The best example for this is: If you are booking a movie ticket by using some application, user should get the ticket booked in a very short amount of time / only by using 3-4 activities maximum!!
6. Certification Testing
Use this command : (Jarsigner is in your Java bin folder goto java->jdk->bin path in cmd prompt)
Code:
$ jarsigner -verify -verbose -certs my_application.apk
If you see "CN=Android Debug", this means the .apk was signed with the debug key generated by the Android SDK (means it is unsigned), else u will find something for CN. for more details http://developer.android.com/guide/publishing/app-signing.html
How do developer signs their apps:
He/She creates a keystore file by using the below cmd:
Code:
$ keytool -genkey -v -keystore my-release-key.keystore
-alias alias_name -keyalg RSA -keysize 2048 -validity 10000
To show you how it works I have given a screen shot of creating one below:
After generating key we have to follow the following steps:
Right click on project > Android Tools > Export Signed Application Package
The Export Android Application wizard appears.
Select the project I want to export, click Next.
The Keystore Selection screen appears.
Select the keystore and enter the password.
After this just give the path of the .apk file that has to be released.
7. Performance Testing
This testing process is undertaken to check the performance and behavior of the application under certain conditions such as low battery, bad network coverage, low available memory, simultaneous access to application’s server by several users and other conditions. Performance of an application can be affected from two sides: application’s server side and client’s side. Performance testing is carried out to check both.
This is done by performance test engineers. They use specific tools for this, for example: LoadRunner, Apache JMeter etc...
8. Integration Testing
Testing the data flow between two modules(activities) is called to be as Integration Testing.
This is done after finishing of Functional Testing.
The reason why we do Integration Testing is to make sure that all the activities are connected together properly or not.
9. System Testing
It is a end to end testing of the application where in Testing Environment is similar to production.
Here we test the data flow from the beginning to the end, If something is broken we have to report it as a bug.
We perform system testing after finishing of Integration Testing.
We perform system testing to make sure that end to end scenarios of the application is working properly or not.
10. Accessibility Testing
Accessibility testing is a subset of usability testing where the users under consideration have disabilities that affect how they use the application. The end goal, in both usability and accessibility, is to discover how easily people can use application and feed that information back into improving future designs and implementations.
This testing is done after completion of system testing.
11. Adhoc Testing(Monkey Testing)
Testing the application in a random way is called to be as Adhoc or Monkey Testing.
Monkey Testing is done after completion of full software testing and reporting of all the bugs is done. And also when the product is almost stable.
The reason why we perform this testing is,
To some how brake the product.
To find more number of bugs.
To make the software more stable.
to be continued...

It's very massive info, which you have shared with us.
I just want to know what's the meaning of Defect Detailed Report ?

Is CC apps java based? Can apps been extracted from rooted CCs?

Well, I know CC doesn't execute APKs, but does CC apps still based on Java? or some nasty binaries?
Mine bought in UK with serial 4103, sadly it's not rootable, but I'm curious if the apps based on java, in other words, can we crack the source code of CC apps?

The "apps" (called cast receiver) are created in HTML5/JavaScript and hosted on the internet. The API ia well (?) documented on Google pages. If you register yourself as developer (5$) you can create your own apps or use the remote debugger (http://ip-of-your-cast:9222) on existing apps.

morph1us said:
The "apps" (called cast receiver) are created in HTML5/JavaScript and hosted on the internet. The API ia well (?) documented on Google pages. If you register yourself as developer (5$) you can create your own apps or use the remote debugger (url removed as new use) on existing apps.
Click to expand...
Click to collapse
Thanks. So is there any way to find the source code of an app running on CC? Well, not necessarily all or original source code, i.e., APKs and JARs are fine as they can be decompiled into readable source code, although may obfuscated but still readable...

[Q] What database should i use for my app ?

hi to all.
im new in java and android studio.
i want to make a application that users can register on it.
i guess maximum 30.000 user capacity is suitable for my database.
so what database should i use ?
i can't understand database differents.
like : SQLite - MySQL - SQL Server - Oracle - the database maker in ide and etc ...
please some body help me ... what database should i learn to connect with my app ?
thanx.

You should use SQLite

Yep. .u should use SQLite

Go with Parse or any other mBaaS services.
If you want to learn then do this
1. Create a db in SQL or mySQL ( you need to host it locally or through some service)
2. Write an API/Service that talks to your database
3. Use volley or other networking library in android to talk to the database
4. Use the data you got in (3)

Use SQLite

SQL
U should use MySql, i used on all of my projects and it is the best in my opinion. If u want u can use MariaDB to run the database, it is a improved and fastest version of MySql :laugh: .

You have to use SQLITE database in your app.

SQLite is the easiest choice, considering you are going to use the database just for user registration you can use SQLite..... In the future if you start using the database for other purposes and depend on performance you should choose Oracle.

remote databases like parse.com can help u for massive data
Sent from my SM-N900 using XDA Free mobile app

Use SQLite as a primary database for Android.
But before you start reading documentation, you probably want to know something about ORM realizations, which are commonly used in Android development. The most popular is GreenDao, ORMLite, Realm.io and many others. They incapsulate work with sql queries and db initializations, and much save your time.

Can I use Android Studio with libgdx?

Can I open the android version of a libgdx project inside android studio and make my game from there or do I have to use another java IDE like eclipse??

har88 said:
Can I open the android version of a libgdx project inside android studio and make my game from there or do I have to use another java IDE like eclipse??
Click to expand...
Click to collapse
You can use Android Studio to open Libgdx projects, yes. In the future, you could just try it.

Thanks.
Also, how do I use the normal android APIs inside the Game.java file?
(Specifically, I want to use the Log API)
EDIT:
I think I wasn't clear enough so I'll reword my question.
All the Game logic is done in the core, platform independent java class.
But I want to get messages on logcat about various events and methods etc.
How do I import those classes into the core class?

deleted