SELECT INTO
Selects rows defined by any query and inserts them into a new table. You can specify whether to create a temporary or a persistent table.
Syntax
[ WITH with_subquery [, ...] ] SELECT [ TOP number ] [ ALL | DISTINCT ] * | expression [ AS output_name ] [, ...] INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table [ FROM table_reference [, ...] ] [ WHERE condition ] [ GROUP BY expression [, ...] ] [ HAVING condition [, ...] ] [ { UNION | INTERSECT | { EXCEPT | MINUS } } [ ALL ] query ] [ ORDER BY expression [ ASC | DESC ] [ LIMIT { number | ALL } ] [ OFFSET start ]
For details about the parameters of this command, see SELECT.
Examples
Select all of the rows from the EVENT table and create a NEWEVENT table:
select * into newevent from event;
Select the result of an aggregate query into a temporary table called PROFITS:
select username, lastname, sum(pricepaid-commission) as profit into temp table profits from sales, users where sales.sellerid=users.userid group by 1, 2 order by 3 desc;


com.garmin.fit
Class Manufacturer
java.lang.Object
com.garmin.fit.Manufacturer
public class Manufacturer
- extends java.lang.Object
|
Method Summary |
static java.lang.String |
getStringFromValue(java.lang.Integer value)
Retrieves the String Representation of the Value |
static java.lang.Integer |
getValueFromString(java.lang.String value)
Retrieves a value given a string representation |
| Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
GARMIN
public static final int GARMIN
- See Also:
- Constant Field Values
GARMIN_FR405_ANTFS
public static final int GARMIN_FR405_ANTFS
- See Also:
- Constant Field Values
ZEPHYR
public static final int ZEPHYR
- See Also:
- Constant Field Values
DAYTON
public static final int DAYTON
- See Also:
- Constant Field Values
IDT
public static final int IDT
- See Also:
- Constant Field Values
SRM
public static final int SRM
- See Also:
- Constant Field Values
QUARQ
public static final int QUARQ
- See Also:
- Constant Field Values
IBIKE
public static final int IBIKE
- See Also:
- Constant Field Values
SARIS
public static final int SARIS
- See Also:
- Constant Field Values
SPARK_HK
public static final int SPARK_HK
- See Also:
- Constant Field Values
TANITA
public static final int TANITA
- See Also:
- Constant Field Values
ECHOWELL
public static final int ECHOWELL
- See Also:
- Constant Field Values
DYNASTREAM_OEM
public static final int DYNASTREAM_OEM
- See Also:
- Constant Field Values
NAUTILUS
public static final int NAUTILUS
- See Also:
- Constant Field Values
DYNASTREAM
public static final int DYNASTREAM
- See Also:
- Constant Field Values
TIMEX
public static final int TIMEX
- See Also:
- Constant Field Values
METRIGEAR
public static final int METRIGEAR
- See Also:
- Constant Field Values
XELIC
public static final int XELIC
- See Also:
- Constant Field Values
BEURER
public static final int BEURER
- See Also:
- Constant Field Values
CARDIOSPORT
public static final int CARDIOSPORT
- See Also:
- Constant Field Values
A_AND_D
public static final int A_AND_D
- See Also:
- Constant Field Values
HMM
public static final int HMM
- See Also:
- Constant Field Values
SUUNTO
public static final int SUUNTO
- See Also:
- Constant Field Values
THITA_ELEKTRONIK
public static final int THITA_ELEKTRONIK
- See Also:
- Constant Field Values
GPULSE
public static final int GPULSE
- See Also:
- Constant Field Values
CLEAN_MOBILE
public static final int CLEAN_MOBILE
- See Also:
- Constant Field Values
PEDAL_BRAIN
public static final int PEDAL_BRAIN
- See Also:
- Constant Field Values
PEAKSWARE
public static final int PEAKSWARE
- See Also:
- Constant Field Values
SAXONAR
public static final int SAXONAR
- See Also:
- Constant Field Values
LEMOND_FITNESS
public static final int LEMOND_FITNESS
- See Also:
- Constant Field Values
DEXCOM
public static final int DEXCOM
- See Also:
- Constant Field Values
WAHOO_FITNESS
public static final int WAHOO_FITNESS
- See Also:
- Constant Field Values
OCTANE_FITNESS
public static final int OCTANE_FITNESS
- See Also:
- Constant Field Values
ARCHINOETICS
public static final int ARCHINOETICS
- See Also:
- Constant Field Values
THE_HURT_BOX
public static final int THE_HURT_BOX
- See Also:
- Constant Field Values
CITIZEN_SYSTEMS
public static final int CITIZEN_SYSTEMS
- See Also:
- Constant Field Values
MAGELLAN
public static final int MAGELLAN
- See Also:
- Constant Field Values
OSYNCE
public static final int OSYNCE
- See Also:
- Constant Field Values
HOLUX
public static final int HOLUX
- See Also:
- Constant Field Values
CONCEPT2
public static final int CONCEPT2
- See Also:
- Constant Field Values
ONE_GIANT_LEAP
public static final int ONE_GIANT_LEAP
- See Also:
- Constant Field Values
ACE_SENSOR
public static final int ACE_SENSOR
- See Also:
- Constant Field Values
BRIM_BROTHERS
public static final int BRIM_BROTHERS
- See Also:
- Constant Field Values
XPLOVA
public static final int XPLOVA
- See Also:
- Constant Field Values
PERCEPTION_DIGITAL
public static final int PERCEPTION_DIGITAL
- See Also:
- Constant Field Values
BF1SYSTEMS
public static final int BF1SYSTEMS
- See Also:
- Constant Field Values
PIONEER
public static final int PIONEER
- See Also:
- Constant Field Values
SPANTEC
public static final int SPANTEC
- See Also:
- Constant Field Values
METALOGICS
public static final int METALOGICS
- See Also:
- Constant Field Values
_4IIIIS
public static final int _4IIIIS
- See Also:
- Constant Field Values
SEIKO_EPSON
public static final int SEIKO_EPSON
- See Also:
- Constant Field Values
SEIKO_EPSON_OEM
public static final int SEIKO_EPSON_OEM
- See Also:
- Constant Field Values
IFOR_POWELL
public static final int IFOR_POWELL
- See Also:
- Constant Field Values
MAXWELL_GUIDER
public static final int MAXWELL_GUIDER
- See Also:
- Constant Field Values
STAR_TRAC
public static final int STAR_TRAC
- See Also:
- Constant Field Values
BREAKAWAY
public static final int BREAKAWAY
- See Also:
- Constant Field Values
ALATECH_TECHNOLOGY_LTD
public static final int ALATECH_TECHNOLOGY_LTD
- See Also:
- Constant Field Values
MIO_TECHNOLOGY_EUROPE
public static final int MIO_TECHNOLOGY_EUROPE
- See Also:
- Constant Field Values
ROTOR
public static final int ROTOR
- See Also:
- Constant Field Values
GEONAUTE
public static final int GEONAUTE
- See Also:
- Constant Field Values
ID_BIKE
public static final int ID_BIKE
- See Also:
- Constant Field Values
SPECIALIZED
public static final int SPECIALIZED
- See Also:
- Constant Field Values
WTEK
public static final int WTEK
- See Also:
- Constant Field Values
PHYSICAL_ENTERPRISES
public static final int PHYSICAL_ENTERPRISES
- See Also:
- Constant Field Values
NORTH_POLE_ENGINEERING
public static final int NORTH_POLE_ENGINEERING
- See Also:
- Constant Field Values
BKOOL
public static final int BKOOL
- See Also:
- Constant Field Values
CATEYE
public static final int CATEYE
- See Also:
- Constant Field Values
STAGES_CYCLING
public static final int STAGES_CYCLING
- See Also:
- Constant Field Values
SIGMASPORT
public static final int SIGMASPORT
- See Also:
- Constant Field Values
TOMTOM
public static final int TOMTOM
- See Also:
- Constant Field Values
PERIPEDAL
public static final int PERIPEDAL
- See Also:
- Constant Field Values
WATTBIKE
public static final int WATTBIKE
- See Also:
- Constant Field Values
MOXY
public static final int MOXY
- See Also:
- Constant Field Values
CICLOSPORT
public static final int CICLOSPORT
- See Also:
- Constant Field Values
POWERBAHN
public static final int POWERBAHN
- See Also:
- Constant Field Values
ACORN_PROJECTS_APS
public static final int ACORN_PROJECTS_APS
- See Also:
- Constant Field Values
LIFEBEAM
public static final int LIFEBEAM
- See Also:
- Constant Field Values
BONTRAGER
public static final int BONTRAGER
- See Also:
- Constant Field Values
WELLGO
public static final int WELLGO
- See Also:
- Constant Field Values
SCOSCHE
public static final int SCOSCHE
- See Also:
- Constant Field Values
MAGURA
public static final int MAGURA
- See Also:
- Constant Field Values
WOODWAY
public static final int WOODWAY
- See Also:
- Constant Field Values
ELITE
public static final int ELITE
- See Also:
- Constant Field Values
NIELSEN_KELLERMAN
public static final int NIELSEN_KELLERMAN
- See Also:
- Constant Field Values
DK_CITY
public static final int DK_CITY
- See Also:
- Constant Field Values
TACX
public static final int TACX
- See Also:
- Constant Field Values
DIRECTION_TECHNOLOGY
public static final int DIRECTION_TECHNOLOGY
- See Also:
- Constant Field Values
MAGTONIC
public static final int MAGTONIC
- See Also:
- Constant Field Values
_1PARTCARBON
public static final int _1PARTCARBON
- See Also:
- Constant Field Values
INSIDE_RIDE_TECHNOLOGIES
public static final int INSIDE_RIDE_TECHNOLOGIES
- See Also:
- Constant Field Values
SOUND_OF_MOTION
public static final int SOUND_OF_MOTION
- See Also:
- Constant Field Values
STRYD
public static final int STRYD
- See Also:
- Constant Field Values
ICG
public static final int ICG
- See Also:
- Constant Field Values
MIPULSE
public static final int MIPULSE
- See Also:
- Constant Field Values
BSX_ATHLETICS
public static final int BSX_ATHLETICS
- See Also:
- Constant Field Values
LOOK
public static final int LOOK
- See Also:
- Constant Field Values
CAMPAGNOLO_SRL
public static final int CAMPAGNOLO_SRL
- See Also:
- Constant Field Values
BODY_BIKE_SMART
public static final int BODY_BIKE_SMART
- See Also:
- Constant Field Values
PRAXISWORKS
public static final int PRAXISWORKS
- See Also:
- Constant Field Values
LIMITS_TECHNOLOGY
public static final int LIMITS_TECHNOLOGY
- See Also:
- Constant Field Values
TOPACTION_TECHNOLOGY
public static final int TOPACTION_TECHNOLOGY
- See Also:
- Constant Field Values
COSINUSS
public static final int COSINUSS
- See Also:
- Constant Field Values
FITCARE
public static final int FITCARE
- See Also:
- Constant Field Values
MAGENE
public static final int MAGENE
- See Also:
- Constant Field Values
GIANT_MANUFACTURING_CO
public static final int GIANT_MANUFACTURING_CO
- See Also:
- Constant Field Values
TIGRASPORT
public static final int TIGRASPORT
- See Also:
- Constant Field Values
SALUTRON
public static final int SALUTRON
- See Also:
- Constant Field Values
TECHNOGYM
public static final int TECHNOGYM
- See Also:
- Constant Field Values
BRYTON_SENSORS
public static final int BRYTON_SENSORS
- See Also:
- Constant Field Values
LATITUDE_LIMITED
public static final int LATITUDE_LIMITED
- See Also:
- Constant Field Values
SOARING_TECHNOLOGY
public static final int SOARING_TECHNOLOGY
- See Also:
- Constant Field Values
IGPSPORT
public static final int IGPSPORT
- See Also:
- Constant Field Values
THINKRIDER
public static final int THINKRIDER
- See Also:
- Constant Field Values
GOPHER_SPORT
public static final int GOPHER_SPORT
- See Also:
- Constant Field Values
WATERROWER
public static final int WATERROWER
- See Also:
- Constant Field Values
ORANGETHEORY
public static final int ORANGETHEORY
- See Also:
- Constant Field Values
INPEAK
public static final int INPEAK
- See Also:
- Constant Field Values
KINETIC
public static final int KINETIC
- See Also:
- Constant Field Values
JOHNSON_HEALTH_TECH
public static final int JOHNSON_HEALTH_TECH
- See Also:
- Constant Field Values
POLAR_ELECTRO
public static final int POLAR_ELECTRO
- See Also:
- Constant Field Values
SEESENSE
public static final int SEESENSE
- See Also:
- Constant Field Values
DEVELOPMENT
public static final int DEVELOPMENT
- See Also:
- Constant Field Values
HEALTHANDLIFE
public static final int HEALTHANDLIFE
- See Also:
- Constant Field Values
LEZYNE
public static final int LEZYNE
- See Also:
- Constant Field Values
SCRIBE_LABS
public static final int SCRIBE_LABS
- See Also:
- Constant Field Values
ZWIFT
public static final int ZWIFT
- See Also:
- Constant Field Values
WATTEAM
public static final int WATTEAM
- See Also:
- Constant Field Values
RECON
public static final int RECON
- See Also:
- Constant Field Values
FAVERO_ELECTRONICS
public static final int FAVERO_ELECTRONICS
- See Also:
- Constant Field Values
DYNOVELO
public static final int DYNOVELO
- See Also:
- Constant Field Values
STRAVA
public static final int STRAVA
- See Also:
- Constant Field Values
PRECOR
public static final int PRECOR
- See Also:
- Constant Field Values
BRYTON
public static final int BRYTON
- See Also:
- Constant Field Values
SRAM
public static final int SRAM
- See Also:
- Constant Field Values
NAVMAN
public static final int NAVMAN
- See Also:
- Constant Field Values
COBI
public static final int COBI
- See Also:
- Constant Field Values
SPIVI
public static final int SPIVI
- See Also:
- Constant Field Values
MIO_MAGELLAN
public static final int MIO_MAGELLAN
- See Also:
- Constant Field Values
EVESPORTS
public static final int EVESPORTS
- See Also:
- Constant Field Values
SENSITIVUS_GAUGE
public static final int SENSITIVUS_GAUGE
- See Also:
- Constant Field Values
PODOON
public static final int PODOON
- See Also:
- Constant Field Values
LIFE_TIME_FITNESS
public static final int LIFE_TIME_FITNESS
- See Also:
- Constant Field Values
FALCO_E_MOTORS
public static final int FALCO_E_MOTORS
- See Also:
- Constant Field Values
MINOURA
public static final int MINOURA
- See Also:
- Constant Field Values
CYCLIQ
public static final int CYCLIQ
- See Also:
- Constant Field Values
LUXOTTICA
public static final int LUXOTTICA
- See Also:
- Constant Field Values
TRAINER_ROAD
public static final int TRAINER_ROAD
- See Also:
- Constant Field Values
THE_SUFFERFEST
public static final int THE_SUFFERFEST
- See Also:
- Constant Field Values
FULLSPEEDAHEAD
public static final int FULLSPEEDAHEAD
- See Also:
- Constant Field Values
VIRTUALTRAINING
public static final int VIRTUALTRAINING
- See Also:
- Constant Field Values
FEEDBACKSPORTS
public static final int FEEDBACKSPORTS
- See Also:
- Constant Field Values
OMATA
public static final int OMATA
- See Also:
- Constant Field Values
VDO
public static final int VDO
- See Also:
- Constant Field Values
MAGNETICDAYS
public static final int MAGNETICDAYS
- See Also:
- Constant Field Values
HAMMERHEAD
public static final int HAMMERHEAD
- See Also:
- Constant Field Values
KINETIC_BY_KURT
public static final int KINETIC_BY_KURT
- See Also:
- Constant Field Values
SHAPELOG
public static final int SHAPELOG
- See Also:
- Constant Field Values
DABUZIDUO
public static final int DABUZIDUO
- See Also:
- Constant Field Values
JETBLACK
public static final int JETBLACK
- See Also:
- Constant Field Values
ACTIGRAPHCORP
public static final int ACTIGRAPHCORP
- See Also:
- Constant Field Values
INVALID
public static final int INVALID
Manufacturer
public Manufacturer()
getStringFromValue
public static java.lang.String getStringFromValue(java.lang.Integer value)
- Retrieves the String Representation of the Value
- Returns:
- The string representation of the value, or empty if unknown
getValueFromString
public static java.lang.Integer getValueFromString(java.lang.String value)
- Retrieves a value given a string representation
- Returns:
- The value or INVALID if unkwown


{% extends "emails/base.html" %} {% block content %}
Hi,
{% set org = workshop.get_org() %}The {{workshop.title}} at {{org.name}}, {{org.city}} is confirmed.
The trainer is {{trainer.name}}.
Wish you all the best for the workshop!
Regards,
Python Express Team
http://www.pythonexpress.in/


2 Samuel 3:20
So Abner came to David to Hebron, and twenty men with him. And David made Abner and the men that were with him a feast.


Current Courses
1. Department of Electronics and Computer Engineering, Technical Univ. of Crete, Chania, GR     TEL 411/611: Natural Language Processing (in greek)     2. Department of Electronics and Computer Engineering, Technical Univ. of Crete, Chania, GR     TEL 303: Statistical Modeling and Pattern Recognition (in greek)     3. Department of Electronics and Computer Engineering, Technical Univ. of Crete, Chania, GR     TEL 211: Probability and Random Processes (in greek)    Recent Courses
1. Department of Electrical Engineering, Columbia University, New York, NY     EE 3910: "Elements of Digital Systems", Fall 2000   2. Department of Electrical Engineering, Columbia University, New York, NY     EE 3701: "Introduction to Communication Systems and Networks", Fall 1999   3. School of Engineering, University of Cordoba, Argentina     Graduate short course: "Signal Processing with Applications", Sept. 1998


Try out our Premium Member services: Virtual Legal Assistant, Query Alert Service and an ad-free experience. Free for one month and pay only if you like it.
18 & 19. * IN THE HIGH COURT OF DELHI AT NEW DELHI + Date of Decision: 13.02.2012 % W.P.(C) 153/2011 & C.M. No. 289/2011 (for stay) YASHBEER SINGH ..... Petitioner Through: Mr. Ashish Mohan & Mr. Rohit Gandhi, Advocates. versus GNCT OF DELHI AND ANR ..... Respondents Through: Mr. N. Waziri & Ms. Neha Kapoor, Advocates. AND W.P.(C) 305/2011 & C.M. No. 558/2011 (for stay) SUBHASH CHANDER JAIN ..... Petitioner Through: Mr. N.N. Aggarwal & Mr. Rohit Gandhi, Advocates. versus GNCT OF DELHI AND ORS ..... Respondents Through: Mr. N. Waziri & Ms. Neha Kapoor, Advocates. CORAM: HON'BLE MR. JUSTICE VIPIN SANGHI VIPIN SANGHI, J. (Oral)
1. By these petitions preferred under Articles 226 & 227 of the Constitution of India, the petitioners assail the advertisement dated 21.12.2010 issued by respondent No. 2/GNCTD for the purpose of inviting applications from candidates for appointment as whole-time W.P.(C) 153/2011 & 305/2011 Page 1 of 28 members of the State Consumer Disputes Redressal Commission in Delhi (State Commission), established under the Consumer Protection Act, 1986 (The Act). The advertisement relates to two posts, out of which one post has been reserved for "Member (Female - non- judicial)" and the second post has been reserved for "Member (judicial)", for the purpose of creation of a second bench of the State Commission.
2. To appreciate the submissions of the parties and to examine the issues raised by the petitioners, it is necessary to set out Section 16 of the Consumer Protection Act, 1986, which reads as follows:
"16. Composition of the State Commission. (1) Each State Commission shall consist of--
(a) a person who is or has been a Judge of a High Court, appointed by the State Government, who shall be its President:
[Provided that no appointment under this clause shall be made except after consultation with the Chief Justice of the High Court;] [(b) not less than two, and not more than such number of members, as may be prescribed, and one of whom shall be a woman, who shall have the following qualifications, namely:-
(i) be not less than thirty-five years of age;
(ii) possess a bachelor's degree from a recognized university; and
(iii) be persons of ability, integrity and standing, and have adequate knowledge and experience of at least ten years in dealing with problems relating to W.P.(C) 153/2011 & 305/2011 Page 2 of 28 economics, law, commerce, accountancy, industry, public affairs or administration:
Provided that not more than fifty per cent of the members shall be from amongst persons having a judicial background.
Explanation.- For the purposes of this clause, the expression "persons having a judicial background" shall mean persons having knowledge and experience for at least a period of ten years as presiding officer at the district level court or any tribunal at equivalent level:
Provided further that a person shall be disqualified for appointment as a member, if he-
(a) has been convicted and sentenced to imprisonment for an offence which, in the opinion of the State Government, involves moral turpitude; or (b) is an undischarged insolvent; or (c) is of unsound mind and stands so declared by a competent court; or (d) has been removed or dismissed from the service of the Government or a body corporate owned or controlled by the Government; or (e) has, in the opinion of the State Government,
such financial or other interest, as is likely to affect prejudicially the discharge by him of his functions as a member; or
(f) has such other disqualifications as may be prescribed by the State Government.] [(1A) Every appointment under sub-section (1) shall be made by the State Government on the recommendation of a Selection Committee consisting of the following members, namely:-
(i) President of the State Commission--Chairman;
(ii) Secretary of the Law Department of the State--
Member;W.P.(C) 153/2011 & 305/2011 Page 3 of 28
(iii) Secretary, incharge of the Department dealing with consumer affairs in the State-- Member.
Provided that where the President of the State Commission is, by reason of absence or otherwise, unable to act as Chairman of the Selection Committee, the State Government may refer the matter to the Chief Justice of the High Court for nominating a sitting Judge of that High Court to act as Chairman.
(1B) (i) The jurisdiction, powers and authority of the State Commission may be exercised by Benches thereof.
(ii) A Bench may be constituted by the President with one or more members as the President may deem fit.
(iii) If the members of a Bench differ in opinion on any point, the points shall be decided according to the opinion of the majority, if there is a majority, but if the members are equally divided, they shall state the point or points on which they differ, and make a reference to the President who shall either hear the point or points himself or refer the case for hearing on such point or points by one or more of the other members and such point or points shall be decided according to the opinion of the majority of the members who have heard the case, including those who first heard it.] (2) The salary or honorarium and other allowances payable to, and the other terms and conditions of service of, the members of the State Commission shall be such as may be prescribed by the State Government.
Provided that appointment of a member on whole- time basis shall be made by the State Government on the recommendation of the President of the State Commission taking into consideration such factors as may be prescribed including the work load of the State Commission.W.P.(C) 153/2011 & 305/2011 Page 4 of 28
(3) [Every member of the State Commission shall hold office for a term of five years or up to the age of sixty- seven years, whichever is earlier;
Provided that a members shall be eligible for re- appointment for another term of five years or up to the age of sixty-seven years, whichever is earlier, subject to the condition that he fulfils the qualifications and other conditions for appointment mentioned in clause (b) of sub- section (1) and such re-appointment is made on the basis of the recommendation of the Selection Committee:
Provided further that a person appointed as a President of the State Commission shall also be eligible for re-appointment in the manner provided in clause (a) of sub-section (1) of this Section:
Provided also that a member may resign his office in writing under his hand addressed to the State Government and on such resignation being accepted, his office shall become vacant and may be filled by appointment of a person possessing any of the qualifications mentioned in sub-section (1) in relation to the category of the member who is required to be appointed under the provisions of sub-section (1A) in place of the person who has resigned.
(4) Notwithstanding anything contained in sub- section (3), a person appointed as the President or as a member before the commencement of the Consumer Protection (Amendment) Act, 2002, shall continue to hold such office as President or member, as the case may be, till the completion of his term]." (emphasis supplied)
3. The submission of learned counsel for the petitioners is that the present constitution of the State Commission is as follows:
"
S.No. Name Post
1. Mr. B.R. Zaidi President
2. Mrs. Salma Noor Non-Judicial Member
3. Mrs. Kanwal Inder Judicial Member
"
W.P.(C) 153/2011 & 305/2011 Page 5 of 28
4. Learned counsel submits that at present, apart from the President, who is a retired High Court Judge, the existing two members are females. He, therefore, submits that the respondent could not have reserved any post for a Member (Female - non-judicial), since the requirement of Section 16(1)(b), which provides that one of the members of the State Commission should be a woman, already stands satisfied. I may note that the respondent No. 1/UOI supports this stand of the petitioner in relation to the reservation of one post for Member (Female - non-judicial).
5. The submission of respondent No. 2 is that the two female members in the existing strength of the State Commission have been appointed, not on account of their being females, but as Non-judicial member (Mrs. Salma Noor) and Judicial member (Mrs. Kanwal Inder).
6. Mrs. Kanwal Inder, the judicial member already stands retired. Presently, the State Commission is left with only two incumbents, i.e. the President Mr. B.R. Zaidi and a non-judicial member Mrs. Salma Noor. It is argued that the advertisement in question is to fill up one reserved vacancy for Member (Female - non-judicial), as the earlier appointee viz. Mrs. Salma Noor was not appointed on account of her being a female.
7. Insofar as the advertisement for the second vacancy is concerned, namely that of Member (judicial), the submission of learned W.P.(C) 153/2011 & 305/2011 Page 6 of 28 counsel for the petitioners is that Section 16 does not purport to reserve any vacancy for a judicial member. On the contrary, it seeks to limit the appointment of "persons having judicial background" to not more than 50% while making appointment of members who meet the eligibility criteria set out in Section 16(1)(b) (i), (ii) & (iii). It is argued that the reservation made for Member (judicial) is contrary to Section 16 of the Act.
8. Learned counsel for the petitioners places reliance on various decisions on the interpretation of statutes to submit that normal function of a proviso is to except something out of the enactment, or to qualify something enacted therein which, but for the proviso, would be within the purview of the enactment. The proper function of a proviso is to except and to deal with a case which would otherwise fall within the general language of the main enactment and its effect is confined to that case. It is a qualification of the preceding enactment which is expressed in terms too general, to be quite accurate. As a general rule, proviso is added to an enactment to qualify or create an exception to what is in the enactment and ordinarily, a proviso is not interpreted as stating a general rule. (See Nagar Palika Nigam Vs. Krishi Upaj Mandi Samiti & Others, AIR 2009 SC 187)
9. Reliance is also placed on Nasiruddin and Others Vs. Sita Ram Agarwal, (2003) 2 SCC 577, to submit that the jurisdiction to W.P.(C) 153/2011 & 305/2011 Page 7 of 28 interpret a statute can be invoked when the same is ambiguous. The Court cannot interpret a legislation so as to enlarge the scope of the legislation, when the language of the provision is plain and unambiguous. It cannot add or subtract words to a statute or read something into it which is not there. It cannot re-write or re-cast legislation. It is submitted that the proviso to Section 16(1)(b) is worded in a negative way to prescribe that not more than 50% of the members shall be persons having a judicial background. Negative words are prohibitive and are ordinarily used as a legislative device to make a statute imperative (see M. Pentiah and Others Vs. Muddala Veeramallappa and Others, AIR 1961 SC 1107). It is submitted that when the statute provides that not more than 50% of the members shall be persons having a judicial background, it cannot mean that, necessarily, 50% of the members should be persons having a judicial background.
10. Learned counsel for the petitioners submits that the President of the State Commission is also a "member". Thus considered, the appointment of another judicial member would breach the restriction contained in proviso to Section 16(1)(b), as the number of judicial members, including the President, would exceed 50% of the total strength of the State Commission, as, apart from the President and Mrs. Kanwal Inder, one more member would be a person having a W.P.(C) 153/2011 & 305/2011 Page 8 of 28 judicial background - thus raising their number to three, whereas, the number of members not having a judicial background shall be only two, even if another member (Non-judicial) is appointed.
11. In support of this submission, learned counsel for the petitioners place reliance on the definition of the expression „member‟ contained in Section 2(jj) of the Act, and also on the decision of the Kerala High Court in K. Kanakachandran Vs. State of Kerala and Others, AIR 2007 Kerala 155. He also places reliance on the decision of the Supreme Court in Central Bank of India Vs. Ravindra and Others, AIR 2001 SC 3095. In this case, the Supreme Court has observed that "ordinarily, a word of expression used at several places in one enactment should be assigned the same meaning so as to avoid "a head-on clash" between two meanings assigned to the same word or expression occurring at two places in the same enactment. It should not be lightly assumed that "Parliament had given with one hand what it took away with the other" [See- Principles of statutory Interpretation, Justice G.P. Singh, 7th Edition 1999, p.113]. That construction is to be rejected which will introduce uncertainty, friction or confusion into the working of the system (ibid, p. 119). While embarking upon interpretation of words and expressions used in a Statute it is possible to find a situation when the same word or expression may have somewhat different meaning at different places depending on the W.P.(C) 153/2011 & 305/2011 Page 9 of 28 subject or context. This is however an exception which can be resorted to only in the event of repugnancy in the subject or context being spelled out. It has been the consistent view of Supreme Court that when the Legislature used same word or expression in different parts of the same section or statute, there is a presumption that the word is used in the same sense throughout, (ibid, p.263). More correct statement of the rule is, as held by House of Lords in Farrell V. Alexander, (1976) 2 All ER 721, 736, "where the draftsman uses the same word or phrase in similar contexts, he must be presumed to intend it in each place to bear the same meaning"."
12. Having heard learned counsel for the parties, considered the rival submission in the light of the judgments cited before me and after giving my due consideration to the provisions of the Act, I am of the considered view that so far as the advertisement of one post for Member (Female - non-judicial) is concerned, the same appears to be contrary to the provisions of Section 16(1)(b) of the Act. However, the advertisement of one post for Member (judicial) appears to be in order, and in consonance with the provisions of the Act.
13. A perusal of Section 16 of the Act clearly shows that there is no reservation of posts, either in favour of a woman or a person having judicial background, for being appointed as a Member of the State Commission. All that Section 16(1)(b) provides is that, of the members W.P.(C) 153/2011 & 305/2011 Page 10 of 28 appointed to a State Commission, at least one shall be a woman. It does not mean that a slot or a post of a member of the State Commission can be labled or classified as that reserved for a Member (Female). What Section 16(1)(b) provides is that while making appointment of members to the State Commission, if none of the existing members is a woman, the appointing authority shall give priority to a candidate who is a female, who otherwise fulfills the criteria set out in Section 16(1)(b) (i), (ii) & (iii) of the Act.
14. For example, if only one post of a member of the State Commission is required to be filled, and none of the existing members is a woman, then the respondent No. 2 would be justified in advertising the post for a member, while restricting the applicants to female candidates. It would serve no purpose to call for applications even from male candidates, as the necessity is to appoint a woman member, and the appointment of a male member would, in that eventuality, be in breach of Section 16(1)(b) of the Act.
15. The Act also does not restrict the number of women appointees as members of the State Commission. There could be more than one women members of the State Commission, who may be appointed on their own merit, but the statutory requirement is that at least one of the members of the State Commission should be a woman. That woman member may, or may not, be a person having a judicial W.P.(C) 153/2011 & 305/2011 Page 11 of 28 background, and may belong to any of the fields, i.e. economics, law, commerce, accountancy, industry, public affairs or administration with adequate knowledge and experience of at least 10 years.
16. The requirement of having at least one woman member having been fulfilled with the appointment of Mrs. Salma Noor, who still continues to be Member (Mrs. Kanwal Inder having already retired), the advertisement of one of the posts of member, with reservation for Female - non-judicial candidate, appears to be in the teeth of Section 16(1)(b) of the Act. As aforesaid, the respondent No. 2 cannot shut out applications by other aspirants, who may otherwise satisfy the requirement of Section 16(1)(b) of the Act, and who may, or may not, be women. The respondent No. 2 is not precluded from appointing a woman from amongst the applicants, but the said appointment should be based entirely on the applicants‟ merit and should not be swayed by the consideration that she is a woman. The understanding of respondent No. 2 that the earlier appointee, namely Mrs. Salma Noor was not appointed on account of her being a woman and, therefore, a post of Member is still reserved for a woman, is clearly not in consonance with the language and spirit of the Act.
17. So far as the advertisement of one post for a Member (judicial) is concerned, the same stands on a very different footing. The Consumer Courts constituted under the Act provide an additional and alternate W.P.(C) 153/2011 & 305/2011 Page 12 of 28 forum to consumers to seek redressal of their grievance in relation to the goods & services that they may procure for consideration and for their personal use or consumption. The Consumer Courts which have a 3-tier hierarchy, are required to function in compliance of the principles of natural justice. They are vested with the same powers as a Civil Court while trying a suit in respect of various matters, such as summoning and enforcing the attendance of any defendant or witness, examination of the witnesses on oath; the discovery and production of any document or other material object producible as evidence; the reception of evidence on affidavits; the requisitioning of the report of the concerned analysis or test from the appropriate laboratory or from any other relevant source; issuing of any commission for the examination of any witness, and; such other matter as may be prescribed.
18. Proceedings before the Consumer Courts are deemed to be judicial proceedings within the meaning of Sections 193 and 228 of the I.P.C. and they are deemed to be Civil Courts for the purpose of Section 195, and Chapter XXVI of the Cr.P.C. The provision of Order I, Rule 8 of the First Schedule to the C.P.C., with modifications, apply to proceedings before the Consumer Courts.
19. The legal issues which arise before the Consumer Courts for determination, experience has shown, can attain high degree of W.P.(C) 153/2011 & 305/2011 Page 13 of 28 complexity. The orders passed by the District Forum are appealable before the State Commission. Similarly, the orders passed by the State Commission are appealable before the National Commission, and the orders of the National Commission are appealable before the Supreme Court directly.
20. The orders of the District Forum, State Commission and the National Commission are statutorily enforceable on the pain of attachment of the property of the person, who fails to comply with such orders and penalties in the form of imprisonment are also prescribed for failure to comply with the orders of the District Forum, the State Commission or the National Commission. Whereas the District Forum is statutorily mandated to be headed by a person who is, or has been or is qualified to be, a District Judge as its President, the State Commission necessarily has to be headed by a person, who is or has been a Judge of a High Court as its President, and the National Commission is headed by a person, who is or has been a Judge of the Supreme Court as its President. The Consumer Courts have jurisdiction to rule on the civil rights of the parties in respect of the subject matters which fall within their jurisdiction, and their orders have civil consequences. It is, therefore, abundantly clear that the Consumer Courts discharge a part of the judicial function of the State.
21. It is precisely for this reason that the Presidents of the State W.P.(C) 153/2011 & 305/2011 Page 14 of 28 Commission and the National Commission necessarily have to be sitting or retired High Court Judge, or sitting or retired Supreme Court Judge respectively. Even in respect of the President of the District Forum, he has to be a person who is, or has been, or is qualified to be a District Judge. Being judicial organizations, ordinarily the choice would be to induct persons having judicial background as members, meaning - persons having knowledge and experience as Presiding Officer at the district level Court or a Tribunal at equivalent level. However, to make the Consumer Courts more consumer friendly, so that they are more sensitive to the needs, the plight and the difficulties of the consumers, and considering the vast scope of their jurisdiction, the Act provides that not more than 50% of the members shall be from amongst the persons having a judicial background, and atleast one of them shall be a woman. This is to ensure that at least 50% of the members are those who are appointed, not on account of their having a judicial background, but on account of their having adequate knowledge and experience in dealing with problems relating to economics, law, commerce, accountancy, industry, public affairs & administration
22. In S.P. Sampath Kumar v. Union of India & Others, (1987) 1 SCC 124, the Supreme Court was examining the validity of the Administrative Tribunals Act, 1985, whereby the jurisdiction of the High W.P.(C) 153/2011 & 305/2011 Page 15 of 28 Court under Articles 226 and 227 of the Constitution of India, of judicial review in service matters was excluded. The Administrative Tribunals Act was enacted under Article 323A(1) of the Constitution of India, introduced by the Constitution (42nd Amendment) Act, 1976. Though the examination of the provisions of the Administrative Tribunals Act was in the context of the exclusion of the jurisdiction of the High Court under Articles 226 and 227 of the Constitution of India, so as to examine whether the Administrative Tribunals were an effective alternative institutional mechanism for judicial review, the Supreme Court dwelt upon the necessity of the Administrative Tribunal necessarily consisting of a judicial member.
23. Chief Justice Bhagwati, in his concurrent judgment, observed as follows:
"5. It is necessary to bear in mind that service matters which are removed from the jurisdiction of the High Court under Articles 226 and 227 of the Constitution and entrusted to the Administrative Tribunal set up under the impugned Act for adjudication involve questions of interpretation and applicability of Articles 14, 15, 16 and 311 in quite a large number of cases. These questions require for their determination not only judicial approach but also knowledge and expertise in this particular branch of constitutional law. It is necessary that those who adjudicate upon these questions should have same modicum of legal training and judicial experience because we find that some of these questions are so difficult and complex that they baffle the minds of even trained Judges in the High Courts and the Supreme Court. That is the reason why at the time of the preliminary hearing of these writ petitions we insisted that every bench of the Administrative Tribunal should consist of one judicial W.P.(C) 153/2011 & 305/2011 Page 16 of 28 member and one administrative member and there should be no preponderance of administrative members on any bench. Of course, the presence of the administrative member would provide input of practical experience in the functioning of the services and add to the efficiency of the Administrative Tribunal but the legal input would undeniably be more important and sacrificing the legal input or not giving it sufficient weightage would definitely impair the efficacy and effectiveness of the Administrative Tribunal as compared to the High Court. .... ... ..."
24. In R.K. Jain v. Union of India, (1993) 4 SCC 119, the Supreme Court relied upon its earlier decision in Krishna Sahai v. Sate of U.P., (1990) 2 SCC 673, wherein, in relation to the constitution of the U.P. Services Tribunal, the Supreme Court had observed that it would be appropriate for the State of U.P. to change its manning and a sufficient number of people qualified in law should be on the tribunal to ensure adequate dispensation of justice and to maintain judicial temper in the functioning of the tribunal. It also referred to Rajendra Singh Yadav v. State of U.P., (1992) 2 SCC 763, wherein it was observed that the Services Tribunal mostly consist of administrative officers and the judicial element in the manning part of the tribunal is very small. The disputes require judicial handling and the adjudication being essentially judicial in character, it is necessary that adequate number of judges of the appropriate level should man the Services Tribunals. This would create appropriate temper and generate the atmosphere suitable in an adjudicatory tribunal and the institution would command the requisite confidence of the disputants. W.P.(C) 153/2011 & 305/2011 Page 17 of 28
25. The Supreme Court in A.P. Pollution Control Board Vs. Prof. M.V. Nayudu (Retd.) and Others, etc., AIR 1999 SC 812, dealt with the issue of the constitution of environmental appellate authorities/tribunals. The Supreme Court noticed that in different Statutes, different provisions existed with regard to the constitution of the Appellate Authorities/Tribunals. The Supreme Court held that most of these bodies fall short of a combination of judicial and scientific needs The Supreme Court in paragraphs 39, 40, 41, 45, 46 & 50 held as follows:
"39. Different statutes in our country relating to environment provide appeals to appellate authorities. But most of them still fall short of a combination of judicial and scientific needs. ..... ..... ..... ..... .....
40. Good Governance is an accepted principle of international and domestic law. It comprises of the rule of law, effective State institutions, transparency and accountability in public affairs, respect for human rights and the meaningful participation of citizens - (including scientists) - in the political processes of their countries and in decisions affecting their lives. (Report of the Secretary General on the work of the Organization, Official records of the UN General Assembly, 52 session, Suppl.  Of paramount importance, in the establishment of environmental Courts, Authorities and Tribunals is the need for providing adequate Judicial and scientific inputs rather than leave complicated disputes regarding environmental pollution to officers drawn only from the Executive.
41. It appears to us from what has been stated earlier that things are not quite satisfactory and there is an urgent need to make appropriate amendments so as to ensure that at all times, the W.P.(C) 153/2011 & 305/2011 Page 18 of 28 appellate authorities or tribunals consist of Judicial and also Technical personnel well versed in environmental laws. Such defects in the constitution of these bodies can certainly undermine the very purpose of those legislations. We have already referred to the extreme complexity of the scientific or technology issues that arise in environmental matters. Nor, as pointed out by Lord Woolf and Robert Cranworth should the appellate bodies be restricted to Wednesbury limitations.
42. x x x x x x x x x 43. x x x x x x x x x 44. x x x x x x x x x
45. As stated earlier, the Government of India should, in our opinion, bring about appropriate amendments in the environmental statutes, Rules and notification to ensure that in all environmental Courts, Tribunals and appellate authorities there is always a Judge of the rank of a High Court Judge or a Supreme Court Judge, - sitting or retired - and Scientist or group of Scientists of high ranking and experience so as to help a proper and fair adjudication of disputes relating to environment and pollution.
46. There is also an immediate need that in all the States and Union Territories, the appellate authorities under section 28 of the Water (Prevention of Pollution) Act, 1974 and section 31 of the Air (Prevention of Pollution) Act, 1981 or other rules there is always a Judge of the High Court, sitting or retired and a Scientist or group of Scientists of high ranking and experience, to help in the adjudication of disputes relating to environment and pollution. An amendment to existing notifications under these Acts can be made for the present.
47. x x x x x x x x x
48. x x x x x x x x x
W.P.(C) 153/2011 & 305/2011 Page 19 of 28
49. x x x x x x x x x
50. As stated above and we reiterate that there is need to see that in the appellate authority under the Water (Prevention of Pollution) Act, 1974, the Air (Prevention of Pollution) Act, and the appellate authority under Rule 12 of the Hazardous Wastes (Management & Handling) Rules, 1989, under the notification issued under section 3(3) of the Environment (Protection) Act, 1986 for National Capital Territory and under section 10 of the National Environment Tribunal Act, 1995 and other appellate bodies, there are invariably Judicial and Technical Members included. This Court has also observed in M.C.Mehta vs. Union of India and Shriram Foods & Fertilizers Case [ 1986 (2) SCC 176] (at 262) that there should be a right of regular appeal to the Supreme Court, i.e. an appeal incorporated in the relevant statutes. This is a matter for the Governments concerned to consider urgently, by appropriate legislation whether plenary or subordinate or by amending the notifications." (emphasis supplied)
26. I may also refer to the Division Bench judgment of this Court in Rajeshwar Kumar Gupta v. Lt. Governor & Others in W.P(C) 7718/2007 . In this case, the issue raised in the petition was whether the constitution of the Delhi Cooperative Tribunal is constitutional, legal and as per the Rules or not. Rule 144(2) of the Delhi Cooperative Societies Rules 1973 prescribes that the presiding officer or the president of the tribunal shall be the person who has been a judge of any High Court, or a retired District Judge or a person who has for not less than ten years been an advocate or a pleader, or who has held the office of the Registrar, Joint Registrar or Deputy Registrar for not less than continuous period of three years at a time, or has not less than W.P.(C) 153/2011 & 305/2011 Page 20 of 28 five years judicial experience at his credit. The Lt. Governor was empowered to relax the qualification in case of any person otherwise qualified in his opinion. The Division Bench placed reliance on the aforesaid decision in the case of S.P. Sampath Kumar (supra), and set aside the notification dated 26.05.2006, whereby the Delhi Cooperative Tribunal was constituted, and directed the constitution of a proper tribunal of which the Chairman should be a judicial member, preferably a retired District Judge.
27. The reasoning adopted by the Supreme Court in Sampath Kumar (supra), R.K. Jain (supra), A.P. Pollution Control Board (supra) and Rajeshwar Kumar Gupta (supra), in my view, applies with the same force to Consumer Courts. The Consumer Courts adjudicate civil rights arising out of contractual matters relating to sale of goods and provision of services to a consumer. Complex laws relating to banking, financing, insurance etc. fall within the jurisdiction of the Consumer Courts. Apart from these, the Contract Act, the sale of Goods Act etc which too require legal background and understanding for proper appreciation also routinely fall for consideration by the Consumer Courts. In the case of Consumer Courts as well, the legal input would undeniably be equally important as the inputs that the other members may provide and sacrificing the legal input and not giving its sufficient weightage would definitely W.P.(C) 153/2011 & 305/2011 Page 21 of 28 impair the efficacy and effectiveness of the Consumer Courts. Since the Consumer Courts discharge judicial function, and the proceedings are judicial proceedings, wherein advocates also appear and argue case and make legal submissions, the presence of a person having judicial background would certainly further the cause of efficacy, consistency and quality in the decision making process of the Consumer Courts and would help in maintaining judicial temper. The Consumer Courts and its benches, if there are more than one, should consist of at least one person having judicial background, unless it is presided by the President himself.
28. The aforesaid being the position, if the Government decides to specifically appoint a person having judicial background so as to facilitate the creation of a bench of the State Commission and, therefore, advertises the post by inviting applications from persons having a judicial background, the petitioners can have no grievance, particularly when the percentage of the persons having judicial background would not exceed 50%, even after the filling up of the advertised post.
29. The State Government is entitled to fill the vacancy of a Member from amongst the persons having judicial background if that is the need of the hour. There is no purpose of inviting applications from the general public under Section 16(1)(b) and then making an appointment W.P.(C) 153/2011 & 305/2011 Page 22 of 28 of a person having judicial background from amongst the applicants. Unless a specific advertisement is issued to make appointment of a person having judicial background, it is quite likely that persons with such credentials may not even apply. At the same time, it would be a wasted exercise for those who do not have such background, to require them to submit their applications, if the need is to appoint a person having judicial background.
30. As aforesaid, Mrs. Kanwal Inder has already retired and even if the President of the State Commission is considered as a "member" for the purpose of Section 16(1)(b) of the Act, the appointment of another person having a judicial background would not breach the upper limit of 50% of posts of members of the State Commission. Since the tenure of the persons of the State Commission is provided for in Section 16(3), the State Government would in advance, be aware of the date of expiry of the term of each of the members, and would do well to advertise the posts in advance to fill up the impending vacancies, so that the work of the Consumer Courts do not suffer due to non-filling up of vacancies.
31. Even if Mrs. Kanwal Inder had not retired, and the respondents were to appoint another person having judicial background, to my mind, there would be no breach of Section 16(1)(b) of the Act. Section 16(1) clearly draws a distinction between a "President" who is, or has W.P.(C) 153/2011 & 305/2011 Page 23 of 28 been a Judge of a High Court, and a "member" appointed under Section 16(1)(b). In my view, the expression "member" as used in Section 16(1)(b) as well as the proviso to Section 16(1)(b) does not include the President, even though the term "member" has been defined in Section 2(jj) to include the President of the National Commission, or a State Commission, or a District Forum, as the case may be. The definitions in Section 2 begin with the words "In this Act unless the context otherwise requires, ..... ..... .....". (emphasis supplied) Therefore, the definitions contained in Section 2 may not be relevant, if the context in which the defined expression is used, is different. The "President" of the State Commission is dealt with in clause (a) of Section 16(1), whereas the "member(s)" are dealt with in clause(b). The President stands on a different-rather a higher footing, than the members of the State Commission. His position, his terms of engagement, as well as the salary paid to him are different from the position, the terms of engagement and the salary paid to the members. The president of the State Commission is not merely the first amongst equals. His position is clearly on a higher pedestal, though he may sit in a bench with the other members to discharge his judicial functions. The context in which the expression "member" has been used in Section 16 of the Act requires that the expression "President" be not read or understood to mean a "member". W.P.(C) 153/2011 & 305/2011 Page 24 of 28
32. In my view, the decision in Central Bank of India (supra) supports the view that I am taking. The Supreme Court recognized that while embarking upon interpretation of the words used in a Statute, it is possible to find a situation when the same word or expression may have somewhat different meaning at different places, depending on the subject or context. This is an exception to the general rule that when the legislature has used the same word or expression in different parts of the same Section or Statutes, there is a presumption that the word is used in the same sense throughout. In my view, the present case clearly falls in the exception, rather than under the aforesaid rule.
33. It is clear to me on a plain reading of Section 16 that the State Commission consists of at least three persons, i.e. the President appointed under Section 16(1)(a), and not less than two members appointed under Section 16(1)(b). If the submission of learned counsel for the petitioners that the President is also a "member" for the purpose of Section 16(1)(b) were to be accepted, it would mean that the State Commission could consist of two members, i.e. one President and a second member appointed under Section 16(1)(b). This scheme of things would not explain Section 16(1B)(iii) which, inter alia, provides that if the members of a Bench differ in opinion on any point, the points shall be decided according to the opinion of the majority, if W.P.(C) 153/2011 & 305/2011 Page 25 of 28 there is a majority, but if the members are equally divided, they shall state the point or points on which they differ, and make a reference to the President who shall either hear the point or points himself, or refer the case for hearing on such point or points by one or more of the other members, and such point or points shall be decided according to the opinion of the majority of the members, who have heard the case, including those who first heard it.
34. Without, at least, three incumbents in the State Commission (including the President), there is no question of a "majority" view or opinion. In that case, the deadlock created on account of difference of opinion between the President and the other member would never get resolved. It is, therefore, clear that the State Commission has to necessarily consist of at least three persons, i.e. the President and two other members. It is obvious that the expression "member/members" used in Section 16(1)(b) does not include the President.
35. Viewed thus, even if Mrs. Kanwal Inder had not retired and the appointments in terms of the advertisement in question had been made (which have not been made on account of pendency of these proceedings), the number of members having judicial background would have remained at two, and the number of members not having judicial background, but appointed under Section 16(1)(b), would also have remained at two. In that eventuality as well, the proviso to W.P.(C) 153/2011 & 305/2011 Page 26 of 28 Section 16(1)(b) would not have been breached.
36. Reliance placed by the learned counsel for the petitioners on various decisions, as aforesaid, on the aspect of interpretation of statutes have no relevance in the facts of the case and also in view of the aforesaid discussion.
37. The decision in Nasiruddin and Others (supra) does not advance the case of the petitioners in the light of the aforesaid discussion. Similarly, the decision in M. Pentiah and Others (supra) also does not advance the petitioners‟ case, since the upper limit of 50% for appointment of members of the State Commission having a judicial background has not been breached. The decision in Nagar Palika Nigam (supra) also has no relevance since the restrictions contained in the proviso to Section 16(1)(b) have not been breached by the respondents.
38. The decision of the Kerala High Court in K. Kanakachandran (supra) also does not advance the petitioners‟ case. It is clear from reading of paras 5 & 6 of the said judgment that the Court apart from recording the submission of the petitioner had not expressed a definite view on the issue whether the President was a "member" in the context of Section 16(1)(b) of the Act, as the said issue did not arise for determination in the facts of that case. This is clear from a reading of para 6, the relevant part of which reads as follows: W.P.(C) 153/2011 & 305/2011 Page 27 of 28
"6. Even if the contention of the petitioner that the members mentioned therein does not include the President is accepted, I feel that the same will also make no difference on the outcome of the case. Among the 4 members, if one is a member with a judicial background, the representation will be 25%. Twenty five percent is definitely a percentage which is not more than 50% as contemplated by the proviso to Section 16(1)(b) of the Act. But, the learned counsel for the petitioner submits that the said proviso should be read to mean that the persons with judicial background should be at leat 50%."
39. For all the aforesaid reasons, I partially allow these petitions and hold that the advertisement in question issued by respondent No. 2 for filling the post of Member (Female - non-judicial) is contrary to the provisions of the Act. However, the said advertisement to fill the post of a Member (judicial), i.e., to appoint a person having judicial background is in accord with Section 16 of the Act and is, therefore, upheld.
40. The petitions stand disposed of in the aforesaid terms leaving the parties to bear their own costs.
VIPIN SANGHI, J FEBRUARY 13, 2012 „BSR‟/sr W.P.(C) 153/2011 & 305/2011 Page 28 of 28


Hi.
When I use the "set settings" function of the API, I get the following output :
Notice: Trying to get property of non-object in /var/www/emoncms/Modules/raspberrypi/raspberrypi_model.php on line 45
Notice: Trying to get property of non-object in /var/www/emoncms/Modules/raspberrypi/raspberrypi_model.php on line 57
Notice: Trying to get property of non-object in /var/www/emoncms/Modules/raspberrypi/raspberrypi_model.php on line 58
Notice: Trying to get property of non-object in /var/www/emoncms/Modules/raspberrypi/raspberrypi_model.php on line 59
Notice: Trying to get property of non-object in /var/www/emoncms/Modules/raspberrypi/raspberrypi_model.php on line 60
Notice: Trying to get property of non-object in /var/www/emoncms/Modules/raspberrypi/raspberrypi_model.php on line 62
Notice: Trying to get property of non-object in /var/www/emoncms/Modules/raspberrypi/raspberrypi_model.php on line 63
Notice: Trying to get property of non-object in /var/www/emoncms/Modules/raspberrypi/raspberrypi_model.php on line 63
Warning: Creating default object from empty value in /var/www/emoncms/Modules/raspberrypi/raspberrypi_model.php on line 63
Notice: Undefined property: stdClass::$remoteapikey in /var/www/emoncms/Modules/raspberrypi/raspberrypi_model.php on line 65
{"success":true,"message":"Field updated","remotesend":false}
Apparently, $fields it not what it should be in
public function set($userid,$apikey,$fields)
{
$fields = json_decode($fields);
Has anyone seen this already or should I investigate ?
BTW, I've got a cosmetic error I'm mentioning here although I doubt it would be related: In the Raspberry Pi page,
Raspberry Pi connected to emoncms user account:
the account name is not displayed. I do have a Username set in the account page.
Re: [emonCMS Raspberry Pi dev branch] Error using set settings
Hello Jerome, I didn't see that, but I can see why it would happen if you where not sending the set json string with all the properties present. I've fixed it by adding the isset() check to all the properties, the updated version is pushed to the master branch.
Re: [emonCMS Raspberry Pi dev branch] Error using set settings
Thanks, I'll try that and keep you informed.
Which branch should I be using and sending pull requests to ? Is this the end of the dev branch ?
I was probably missing a parameter. I should check that all parameters (even newly created) are in the link in the API help page.
Anyway, even though I thought I was sending all parameters, I assumed it would work for a single parameter as well and I even tried that purposely while debugging. It's better with your fix, it provides much more flexibility.
Re: [emonCMS Raspberry Pi dev branch] Error using set settings
I did a quick test with one parameter only. I didn't get any error message but it didn't work either :
gives me
but the group is unchanged, and besides remotesend should not be false.
The settings are all unchanged, such that if I then click save in RapsberryPi tab, remotesend becomes true again and I'm back where I started.
Re: [emonCMS Raspberry Pi dev branch] Error using set settings
I am not sure if this is connected, but I have just upgraded both emoncms and the Raspberry Pi software using GIT and now when I go into the Raspberry PI config option I get
Notice: Trying to get property of non-object in /var/www/emoncms/Modules/raspberrypi/raspberrypi_controller.php on line 27
Notice: Trying to get property of non-object in /var/www/emoncms/Modules/raspberrypi/raspberrypi_controller.php on line 34
Re: [emonCMS Raspberry Pi dev branch] Error using set settings
If you have updated be sure to click admin in emoncms and then click update database.
Re: [emonCMS Raspberry Pi dev branch] Error using set settings
Yes, I did that, it finished ok and created some tables, if I do a check now if lists everything as ok, so I don't think that is the problem
Re: [emonCMS Raspberry Pi dev branch] Error using set settings
I'm not sure it is related. In your case, it seems to be $route that is not what it should be.
The error message looks alike, but the symptom is not the same. Yet, it may well be the same cause.
Re: [emonCMS Raspberry Pi dev branch] Error using set settings
Yes, I was thinking that $route is not correct, I see lots of references to "localhost" in the scripts but I log onto the server using an IP address to look at the data.
http://<IP_ADDRESS>/emoncms/raspberrypi/config
Do you think thats the problem ?
Re: [emonCMS Raspberry Pi dev branch] Error using set settings
I wrote :
Could this be due to the fact that I did not use
when moving to dev branch ?
Is it too late ?
Not sure what this does...
Re: [emonCMS Raspberry Pi dev branch] Error using set settings
Jerome, the missing username is a bug rather than any error on your part, something I missed adding back in when rebuilding the code.
Neil: It looks to me like you may have the latest version of the raspberrypi module but old version of emoncms core?


Problem 2. Correct brackets
- Write a JavaScript function to check if in a given expression the brackets are put correctly.
- Example of correct expression: ((a+b)/5-d). Example of incorrect expression: )(a+b)).
You could use Chrome console (F12) or Firebug to see the results.


Oops! Something went wrong. Further extensions to the request are required for the server to fulfil it.


Crown Lands Applications in British Columbia
Use the list below to navigate to individual applications. Click on any application to go directly to its details page or click arrow_drop_down to expand the list item to see basic information (e.g., Location, Description, etc.) about that application.
| Applicant(s) 0) }" aria-hidden="true"> | CL File 0) }" aria-hidden="true"> | Purpose / Subpurpose 0) }" aria-hidden="true"> | Region 0) }" aria-hidden="true"> | Status 0) }" aria-hidden="true"> | PRC Status 0) }" aria-hidden="true"> |
|---|---|---|---|---|---|
|
arrow_drop_down
arrow_drop_up
{{app.applicants || '-'}}
{{app.clFile || '-'}}
{{app.purpose || '-'}} / {{app.subpurpose || '-'}}
{{app.region || '-'}}
{{app.appStatus || '-'}}
{{app.cpStatus}}
|


Data Analyst with a background in Digital Asset Management and skills in SQL, Excel, Tableau, PowerBI, and Access. Extensive experience creating databases, data mapping, cataloging, and Project Management. An excellent problem solver with meticulous attention to detail.
Logistics Data Analyst for the global distribution of Nissan and INFINITI vehicles. Reporting and database management using Access, SQL, Tableau, PowerBI, and Excel. Project manager integrating Tableau office-wide as a visualization tool. Dashboard creation demonstrating global logistics routing with over 7,000 discrete paths.
Data and file manager for Highline Automotive web project. Cleaning, mapping, and consolidating all master data for web development. A large scale project stemming from Highline Automotive acquiring Camco Manufacturing and merging with Warren Distribution requiring new retail website deployment and presence.
Manage all aspects of database creation, data mapping, cataloging, and coordination of file deliveries. Project Manager for ingestion of acquisition assets into digital repository, DAM hardware, and cloud based content management. Perform metadata collection, quality control, and file verification.
Created databases by cataloging metadata from projects delivered by freelance contractors and engineers. Project manager overseeing digital repository creation of synchronized RAID array and cloud based archive solutions. Managed sales and reporting, accounts receivable, and social media. Responsible for all technical aspects of a facility specializing in broadcast, post-production, and music recording.
Began as an engineer, promoted to VP of Operations, supervised a staff of 10 engineers and facilities technicians. Trained staff engineers for session work, focusing on signal flow, command of non-linear recording/editing, session etiquette, studio documentation, and master delivery standards.
A Tableau visualization of Citi Bike data. Click image to see my public profile with complete story.
Screen Shot from an analysis of United States Geological Survey Earthquake Data. This is one week of reports, pulled from the API feed of real time GeoJSON data, built with D3.js and Leaflet.
Screen shot from a project comparing poverty to obesity on a state by state basis. SVG will conform to mobile devices, and the tooltip will display exact data points.
Screen shot of a Choropleth map displaying Profit and Loss covering five years of sales data, from the Plotly graphing library. Data was pulled from a PostgreSQL database using SQLAlchemy. A Flask app was coded in Python to provide RESTful APIs who's routes are accessed in JavaScript, and are also used in our HTML to navigate between our home page, graphs, and raw data.


 This post documents what's going on so far, mainly for myself, so that I can almost certainly look back with regret and mortification later on, but also so that I can stop hurting my throat by giving the CI spiel to my friends.
My language background: I'm a native English speaker who grew up in a Cantonese household. I've taken 5 years of elementary school Cantonese, 3 years of middle school Mandarin, 3 years of high school Mandarin, and 2 quarters of university Mandarin. All that to say: I function in Cantonese well enough such that my family has to be disappointed in my career instead, and I'm practically worthless when it comes to Mandarin.
A brief timeline of my Spanish learning so far:
The spiel: for now, I'm pretty much all-in on the comprehensible input method.  Grammar, output (speaking), pronunciation, translation - those are all either unnecessary or even harmful in the early stages, and input is the best method to natively absorb a language. For better or worse, I've learned some level of grammar Spanish due to the two semesters of classes and Language Transfer, but I don't think it's actively hurt me yet.
My current input goal is 70 minutes/day; I'm hoping to have at least 600 hours of input by the end of the year, which is not mathematically sound (I'd have to get 118 minutes/day to reach that goal). However, my experience so far is that CI is absolutely a snowball: the better my comprehension, the easier it is to consume more content, since I will increasingly be able to understand longer, more interesting media (podcasts, TV shows, YouTube channels that interest me, video games, etc).
> What level of Spanish can you currently understand?
This video is highly comprehensible for me (maybe 90-95%).
> Why not Duolingo/other app?
 When will I ever fill in the blank or pick from a word bank? When will there ever be exactly one right answer for what to say in a situation? When will I have the time to translate back and forth from English in a real conversation? And how is it valuable whatsoever to formulate sentences when I have no means of understanding what someone is saying back to me?


Overview Control flow tasks
Database and logging specific tasks
ControlFlow Tasks are an easy way to run database independent sql code or to avoid the boilerplate code when you just want to execute a simple statement. Control Flow task can be split in general tasks and logging tasks. General tasks allow you to create or drop objects or to run some particular predefined statements that will execute on any database. Logging tasks are useful helper when you need to create some tables for logging or to retrieve the whole log as Json.
Control Flow Tasks reside in the ALE.ETLBox.ControlFlow
namespace - tasks for logging in the ALE.ETLBox.Logging
namespace.
This article will go into the details about the general ControlFlow Tasks - see the article about logging to learn more about logging specific tasks.
General Idea behind Control Flow Task
Control Flow Tasks are a set of tasks to manage, alter or query a database. With one single line of code you will be able to create a table or fire some sql on your database - you write your code in C#, and in the background database code for your specific database is generated.
ControlFlow Tasks do not strive to be an replacement for an ORM (Object relation mapper), nor is it a complete set of tasks for all the operations you actually can do on the database. They were created as useful helper to create Tests for ETL pipelines - they can help you to (re)create databases, drop tables (if they exists) or to create a test environment on your database without writing to much database specific sql code.
Avoiding boilerplate code
If you have ever wrote some ADO.NET code to simply execute some Sql, you probably found that there is some boilerplate code you have to write over and over again. The idea behind some of the Control Flow Tasks is that you don't have to write the same code again and again, e.g. just for doing something trivial like opening up a connection and counting the rows in table. This should be doable with only one line of .NET/C# code, and it should work independently on every database.
RowCount with ADO.NET
For instance, the code for establishing a connection and doing a simple row count on a table with a classic ADO.NET connection would look like this:
string connectionString = "Data Source=.; Database=Sample; Integrated Security=SSPI";
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("select count(*) from demotable", con);
con.Open();
int numrows = (int)cmd.ExecuteScalar();
}
RowCount with Control Flow Tasks
Now let's have a look how to do a row count with the Control Flow Tasks library. First, we need to setup a connection manager in order to connect with database. This is the same connection manager as used within the data flow part.
SqlConnectionManager connectionManager = new SqlConnectionManager("Data Source=.; Database=Sample; Integrated Security=SSPI"");
Now you can use a RowCountTask
to query the number of rows within a table with only one line.
int count = RowCountTask.Count(connectionManager, "demotable");
Optionally, you can set up a default connection that is used every time you don't provide a connection manager.
Simple set the property DefaultDbConnection
on the static ControlFlow
class.
ControlFlow.DefaultDbConnection = new SqlConnectionManager(new SqlonnectionString("Data Source=.; Database=Sample; Integrated Security=SSPI""));
Now a RowCount is as simple as this:
int count = RowCountTask.Count("demotable");
Internally, an ADO.NET connection is opened up (the default ADO.NET connection pooling is used)
and a select count(*) from demotable
is executed on the database. The result is returned from the RowCountTask.
Create, Drop and IfExists tasks
There are a lot of tasks that can help you to create, drop or check the existence of database objects. In the following there will be example how to create tables, views, procedures, indexes or databases, how to drop them and how to check for their existence.
ConnectionManager
All example have connectionManager
object passed - this is the actual connection manager for your database.
E.g. for Sql Server you would create it with
SqlConnectionManager connectionManager = new SqlConnectionManager("Data Source=.; Database=Sample; Integrated Security=SSPI");
or for MySql with
MySqlConnectionManager connectionManager = new MySqlConnectionManager("Server=<IP_ADDRESS>;Database=ETLBox_DataFlow;User Id=postgres;Password=etlboxpassword;");
Tables
CreateTables Task
CreateTableTask will help you to create a table on the database. You can pass either a TableDefinition
object
or a table name and a list of table colums.
Here is an example with passing the table name and a list of table columns
List<TableColumn> columns = new List<TableColumn>() {
new TableColumn("Id", "INT",allowNulls:false,isPrimaryKey:true, isIdentity: true),
new TableColumn("value2", "DATE", allowNulls:true),
new TableColumn("value3", "DECIMAL(10,2)",allowNulls:false) { DefaultValue = "3.12" },
new TableColumn("compValue", "BIGINT",allowNulls:true) { ComputedColumn = "(value1 * value2)" }
};
CreateTableTask.Create(connectionManager, "tablename", columns);
A table column describe the column in the database with the most used attributes: Name, Data type (use the data type which you are most familiar with, there will be an attempt to convert the database type into the right database specific format), if the column is nullable, if the column is a primary key and if the column is used as identity column. (Serial for Postgres or auto increment for MySql). Additionaly, you could specify if the column is a computed column or if it has a default value.
Here is an example for creating a TableDefinition
and pass it to the CreateTableTask:
TableDefinition CustomerTableDef = new TableDefinition("customer",
new List<TableColumn>() {
new TableColumn("CustomerKey", "int",allowNulls: false, isPrimaryKey:true, isIdentity:true),
new TableColumn("Name","nvarchar(200)", allowNulls: false),
});
CreateTableTask.Create(connectionManager, CustomerTableDef);
DropTableTask
This task simple drops a table (and optionally checks if the table exists):
DropTableTask.Drop(connectionManager, "DropTableTest");
DropTableTask.DropIfExists(connectionManager, "DropTableTest");
IfExistsTableOrViewTask
This task checks if a table or view exists and returns true or false.
bool exists = IfTableOrViewExistsTask.IsExisting(connectionManager, "tablename");
Table Definition
If you are interesting in retrieving a TableDefinition object from an existing database table, use can use
the static method GetDefinitionFromTableName
on the TableDefinition
class:
TableDefinition.GetDefinitionFromTableName("demoTable", connectionManager);
Views
CreateViewTask
Creates a view on the database. If the view already exists, it will alter (or replace) the existing view.
CreateViewTask.CreateOrAlter(connectionManager, "View1", "SELECT 1 AS Test");
DropViewTask
Drops a view (and optionally checks if the view exists).
DropViewTask.Drop(connectionManager, "viewname");
DropViewTask.DropIfExists(connectionManager, "viewname");
Indexes
Similar to views and tables, you can (re)create, drop or check the existence as well on indexes.
//Create an index
CreateIndexTask.CreateOrRecreate(connection, "indexname", "tablename",
new List<string>() { "index_column_1", "index_column_1" });
//Drop an index
DropIndexTask.DropIfExists(connectionManager, "indexname", "tablename");
//Check if an index exists
bool exists = IfIndexExistsTask.IsExisting(connectionManager, "indexname", "tablename");
Procedures
//Create a procedure
List<ProcedureParameter> pars = new List<ProcedureParameter>() {
new ProcedureParameter("Par1", "VARCHAR(10)"),
new ProcedureParameter("Par2", "INT", "7"),
};
CreateProcedureTask.CreateOrAlter(connectionManager, "ProcedureName", "SELECT 1;", pars);
//Drop a procedure
DropProcedureTask.DropIfExists(connectionManager, "ProcedureName");
//Check if a procedure exists
bool exists = IfProcedureExistsTask.IsExisting(connectionManager, "ProcedureName");
Schema
Schema are only available for Sql Server and Postgres databases. For MySql, use Create/Drop/Exists Database instead.
//Create a schema
CreateSchemaTask.CreateOrAlter(connectionManager, "SchemaName");
//Drop a schema
DropSchemaTask.DropIfExists(connectionManager, "SchemaName");
//Check if a schema exists
bool exists = IfSchemaExistsTask.IsExisting(connectionManager, "SchemaName");
Databases
This is not supported with SQLite.
//Create a database
CreateDatabaseTask.CreateOrAlter(connectionManager, "DBName");
//Drop a database
DropDatabaseTask.DropIfExists(connectionManager, "DBName");
//Check if a database exists
bool exists = IfDatabaseExistsTask.IsExisting(connectionManager, "DBName");
Retrieving the connection without catalog or database
In some cases, you might want to get a connection string without a catalog, e.g. because you need to create the database first. This is where you could use the ConnectionString-Wrapper for you database. E.g., for Postgres you could run the following code:
PostgresConnectionString conStringWrapper = new PostgresConnectionString("Server=<IP_ADDRESS>;Database=ETLBox_DataFlow;User Id=postgres;Password=etlboxpassword;");
PostgresConnectionString connectionWithoutCatalog = conStringWrapper.GetMasterConnection();
PostgresConnectionManager connectionManager = new PostgresConnectionManager(connectionWithoutCatalog);
Your connection manager would now connect to the "postgres" database (which would be the "master" database in Sql Server and "mysql" database in MySql).
RowCount
Truncate a table
Truncating a table is as simple as
TruncateTableTask.Truncate(connectionManager, "demo.table1");
SqlTask
This is the swiss-army knife for running sql on your database. It will use the underlying ADO.NET connection manager, which allows you to do almost everything on the database, without the "overhead" and boilerplate code that ADO.NET brings with it.
SqlTask always expects a descriptive name when you use it - this name is used for logging purposes.
SqlTask.ExecuteNonQuery(connectionManager, "Insert data",
$@"insert into demo.table1 (value) select * from (values ('Ein Text'), ('Noch mehr Text')) as data(v)");
ExecuteNonQuery will just execute the sql code without reading any results from the database.
Using parameters
You can pass parameterized sql code to have the database reuse existing plans in the cache.
var parameter = new List<QueryParameter>
{
new QueryParameter("value1", "INT", 1),
new QueryParameter("value2", "NVARCHAR(100)", "Test1")
};
SqlTask.ExecuteNonQuery(connectionManager, "Test insert with parameter",
$"INSERT INTO ParameterTest VALUES (@value1, @value2)", parameter);
Reading result sets
Scalar values
If you result set contains only one row with one column, you can use the ExecuteScalar
methods to retrieve that value.
//without type conversion
object result = SqlTask.ExecuteScalar(connectionManager, "Execute scalar",
$@"SELECT 'Hallo Welt' AS ScalarResult");
//with type conversion
double? result = SqlTask.ExecuteScalar<double>(connectionManager,"Execute scalar with datatype",
$@"SELECT CAST(1.343 AS NUMERIC(4,3)) AS ScalarResult"));
Result sets
Use the following code to read a result set from your database and store it in a List object.
The table to read from would have two columns (ColumnA and ColumnB), and the object MyRow
would have two properties (Col1 and Col2).
List<MyRow> result = new List<MyRow>();
MyRow CurRow = new MyRow();
SqlTask.ExecuteReader(connectionManager,
"Test execute reader",
$"SELECT ColumnA, ColumnB FROM ResultTable"
, () => CurRow = new MyRow() //this is executed before each row
, () => result.Add(CurRow) //this is execute after each row
, colA => CurRow.Col1 = int.Parse(colA.ToString())
, colB => CurRow.Col2 = (string)colB
);
Bulk Inserts
Bulk inserts in ADO.NET normally need an object which implement IDataReader
. Normally, you use a DataTable
for this purpose.
But as the implementation of the ADO.NET DataTable has a large overhead and comes with some performance downside, ETLBox
provides it's own object that implements IDataReader: TableData
can be used to be passed to a bulk insert operation.
Here is an example for a bulk insert:
TableData<string[]> data = new TableData<string[]>(destTable.TableDefinition);
string[] values = { "1", "Test1" };
data.Rows.Add(values);
string[] values2 = { "2", "Test2" };
data.Rows.Add(values2);
string[] values3 = { "3", "Test3" };
data.Rows.Add(values3);
//Act
SqlTask.BulkInsert(connection, "Bulk insert demo data", data, "TableName");
Using the instances
For every Control Flow Tasks, there are static accessors to simplify the use of the tasks. In order to have access to all functionalities of a task, sometime you have to create a new instance of the task object.
If you want to do a row count with an instance instead of the static accessors, it would look like this:
RowCountTask task = new RowCountTask("demotable");
int count = task.Count().Rows;
So whenever you don't find a static accessor satisfying your needs, try to create an instance and check the properties and methods of the object.
Configure a task
But there is more. Let's assume you want to count the rows on a pretty big table, a "normal" row count perhaps would take some time.
So RowCount has a property called QuickQueryMode
. If set to true, a sql statement that queries the partition tables is then executed.
RowCountTask task = new RowCountTask("demotable")
{ QuickQueryMode = true };
int count = task.Count().Rows;
This would give you the same result, but instead of doing a select count(*) from dbo.tbl
the following sql is fired on the database
select cast(sum([rows]) as int) from sys.partitions where [object_id] = object_id(N'dbo.tbl') and index_id in (0,1)
Note: The QuickQueryMode will create sql code that only works on SqlServer. For other databases, this won't work.
Why not Entitiy Framework
ETLBox was designed to be used as an ETL object library. Therefore, the user normally deals with big data, some kind of datawarehouse structures and is used to have full control over the database. With the underlying power of ADO.NET - which is used by ETLBox - you have full access to the database and basically can do anything you are used to do with sql on the server. As EF (Entity Framework) is a high sophisticated ORM tool, it comes with the downside that you can only do things on a database that EF allows you to do. But as EF does not incorporate all the possibilities that you can do with SQL and ADO.NET on a Sql Server, Entitity Framework normally isn't a good choice for creating ETL jobs. This is also true for other ORM tools.


Conducted functional tests with the following tools:
Provides the stack for testing : http://theintern.io/
Automates web browsers : http://www.seleniumhq.org/
"JavaScript client library that brings cross-platform consistency to the Selenium WebDriver API.": http://theintern.github.io/leadfoot/
Javascript assertion library: http://chaijs.com/api/assert/
Remote mobile and automated testing: https://saucelabs.com/home