vishwasbabu

@RunWith(SpringJUnit4ClassRunner.class)
@SpringApplicationConfiguration(classes = ServerApplication.Configuration.class)
@WebAppConfiguration
@IntegrationTest({ "server.port=0", "management.port=0", "mariaDB4j.port=0", "mariaDB4j.dataDir=null" })
public abstract class AbstractSpringBootWithDatabaseIntegrationTest {

    // do NOT put any helper methods here!
    // it's much better to use composition instead of inheritance
    // so write a test util ("fixture") and use it as a field in your test

vishwasbabu

import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.io.OutputStreamWriter;
import java.io.PrintWriter;
import java.net.URL;
import java.net.URLConnection;

vishwasbabu

use mifosplatform-tenants;
/**Check if multiple entries exist for a tenant**/
select * from tenants where identifier = "ssi";
/***If this returns more than one entry, delete the  duplicate entries (id is the id of the duplicate row you want to delete)**/
delete from tenants where identifier="ssi" and id="237";
/**Check again if multiple entries exist for a tenant (the query should return a single result)**/
select * from tenants where identifier = "ssi";

vishwasbabu

Get email  Id of the new user : [email protected]

If the user has sent thier public key, skip directly to step 2


1) Generate the new keypair in your mac
=======In you mac=====================

ssh-keygen -t rsa -C "youremailaddress"

vishwasbabu

delete from m_note;
delete from `m_loan_installment_charge`;
delete from m_loan_overdue_installment_charge;
delete from m_loan_interest_recalculation_additional_details;
delete from m_loan_transaction_repayment_schedule_mapping;
delete from m_loan_repayment_schedule;
delete from `acc_gl_journal_entry`;
delete from m_loan_charge_paid_by;
delete from m_account_transfer_transaction;
delete from m_guarantor_transaction;

vishwasbabu

use `mifosplatform-tenants`;

INSERT INTO `tenant_server_connections` (`schema_name`) VALUES ('mifostenant-reference');

INSERT INTO `tenants` (`identifier`, `name`, `oltp_id`, `report_id`, `timezone_id`) VALUES ('reference', 'reference', ( select id from tenant_server_connections where schema_name="mifostenant-reference"), (select id from tenant_server_connections where schema_name="mifostenant-reference"), 'Asia/Kolkata');

create database `mifostenant-reference`;

use `mifostenant-reference`;

vishwasbabu

SELECT loandata.*
,ifnull(group_concat(c.name,':',convert(lc.amount,decimal(10,2))  separator ', '),'') fees
, SUM(ifnull(lc.amount_outstanding_derived,0)) AS chargesDue
#,ld.principal_amount_proposed
FROM
 (
SELECT cn.display_name centerName

vishwasbabu

select a.cid centerId
,a.branch
,a.center
,a.loanOfficer
,a.dueDate
,sum(a.disbursementAmount) disbursementAmount
,sum(a.principalDue) principalDue

vishwasbabu

Introduce local variable : Command + option + V
Search All : Shift + Shift
Toggle line comment : Command + /
Run : Command + Shift + R
Refactor : Shift + Rename (touchpad)
Reformat selection : Option + Command + L