persistance.wSql
Class FieldsJoin

Object
  persistance.wSql.FieldsJoin

public class FieldsJoin
extends Object

A_doc
Licence.

Field Summary

(package private) String	aliasTable
(package private) String	baseJoin
(package private) Gp	gp
(package private) String	joinTable
(package private) String[]	link
(package private) boolean	notspeedable
(package private) String[]	origine
(package private) String[]	select

Constructor Summary

FieldsJoin(String[] origine, Gp gp, String joinTable, String aliasTable, String[] link, String[] select)

Method Summary

String	getJoin()
String	getOnjoin(String table, String SqlPipe, boolean sqlconcat)
String	getSelect()
boolean	isNotSpeedable()

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

notspeedable

boolean notspeedable

origine

String[] origine

gp

Gp gp

baseJoin

String baseJoin

select

String[] select

joinTable

String joinTable

aliasTable

String aliasTable

link

String[] link

Constructor Detail

FieldsJoin

public FieldsJoin(String[] origine,
                  Gp gp,
                  String joinTable,
                  String aliasTable,
                  String[] link,
                  String[] select)

Parameters:

origine - // champs d'origine

gp - // Base de la Table fille

joinTable - // Table fille

aliasTable - // Alias de la Table fille

link - // index de la Table fille en égalite avec le champs d'origine

select - // champs de la Table fille à lister

Ex :
select planning.rowid AS RECNO, planning.c_code,planning.c_heur
from PLANNING
LEFT JOIN Repas AS repasLundi ON (planning.c_lund = repas AS repasLundi.c_code)
ORDER BY planning.c_code||planning.c_heur
desc limit 1

Method Detail

getSelect

public String getSelect()

getJoin

public String getJoin()

getOnjoin

public String getOnjoin(String table,
                        String SqlPipe,
                        boolean sqlconcat)

isNotSpeedable

public boolean isNotSpeedable()