Example #1
0
    public static function getLoadSql()
    {
        $tableName = Author::getTableName();
        return '
			SELECT
				`' . $tableName . '`.*
			FROM
				`' . Author::getDbName() . '`.`' . $tableName . '`
		';
    }
Example #2
0
    public static function getLoadSql()
    {
        $tableName = Book::getTableName();
        return '
			SELECT
				`' . $tableName . '`.*
				, ' . implode("\n\t\t\t\t, ", CoughObject::getFieldAliases('Author', 'Author_Object', 'author')) . '
			FROM
				`' . Book::getDbName() . '`.`' . $tableName . '`
				INNER JOIN `' . Author::getDbName() . '`.`' . Author::getTableName() . '` AS `author`
					ON `' . $tableName . '`.`author_id` = `author`.`author_id`
		';
    }