PHP Classes

File: test/python/out2.txt

Recommend this page to a friend!
  Classes of Nikos M.  >  Dialect PHP SQL Query Builder  >  test/python/out2.txt  >  Download  
File: test/python/out2.txt
Role: Documentation
Content type: text/plain
Description: Documentation
Class: Dialect PHP SQL Query Builder
Build SQL queries from templates
Author: By
Last change: v.1.4.0 contd

* support default values in sql_function, sql_type
* more standard and versatile sql types supported
* add JSON sql type
Date: 2 months ago
Size: 553 bytes
 

Contents

Class file image Download
Dialect.VERSION = 1.4.0 CREATE TABLE IF NOT EXISTS "new_table" ( id BIGSERIAL NOT NULL, name VARCHAR(100) NOT NULL DEFAULT '', categoryid BIGSERIAL NOT NULL DEFAULT 0, companyid BIGSERIAL NOT NULL DEFAULT 0, fields TEXT NOT NULL DEFAULT '', start TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT '0000-00-00 00:00:00', end TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT '0000-00-00 00:00:00', status SMALLSERIAL NOT NULL DEFAULT 0, extra TEXT NOT NULL DEFAULT '' ) CREATE VIEW "new_view" ( id, name ) AS SELECT id, name FROM another_table