import { Injectable } from '@angular/core';
import { HttpClient, HttpHeaders } from '@angular/common/http';
import { Observable } from 'rxjs';
import { environment } from '../../../../../../environments/environment';

@Injectable({
  providedIn: 'root'
})
export class SqlService {

  constructor(private _http : HttpClient) { }

  getSQLTabData(reportId : string) : Observable<any>
  {
    return this._http.get(environment.baseUrl + "report/wizard/retrieve_sql_tab_wise_data/" + reportId, { headers: new HttpHeaders({'Content-Type': 'application/json'})})

  }  

  postSQLValidateAndSave(sqlText : string ) : Observable<any>
  {
    return this._http.post(environment.baseUrl + "report/wizard/retrieve_data/true", 
    {
      "query": sqlText,
      "tabId": "Sql",
      "tabName": "Sql"
    } 
    , { headers: new HttpHeaders({'Content-Type': 'application/json'})});
  }
}