developer.jelix.org is not used any more and exists only for history. Post new tickets on the Github account.
developer.jelix.org n'est plus utilisée, et existe uniquement pour son historique. Postez les nouveaux tickets sur le compte github.

Custom Query (1324 matches)

Filters
 
Or
 
  
 
Columns

Show under each result:


Results (25 - 27 of 1324)

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Ticket Resolution Summary Owner Reporter
#572 fixed Instructions in/not in dans jDaoConditions Julien yferp
Description

Il y a un bug lors de la génération de requêtes utilisant des "in" et "not in" SQL : la requête générée est syntaxiquement incorrecte

#590 fixed Feature: make PDO/sqlite database path specification relative Julien maurice
Description

php5.x+ allows using sqlite3 as PDO database with absotute path to the database file.

In order to make a web application with sqlite database relocatable, one should be able to build the path from the path of the web application itself.

But Jelix use ini file which only allows key-value driver spécification.

    ;dsn=sqlite:var/data/actu.org.sqlite3              ; NOT ALLOWED
    dsn=sqlite:/home/.../.../var/data/actu.org.sqlite3 ; NOT RELOCATABLE

So the require feature consists of add (or change) the specification of a sqlite database in dbprofiles.ini.php file to accept some relative path (suggestion has been proposed to adapt the jDbPDOConnection class)

Solution 1 : allow some variable interpretation

    dsn=sqlite:{$APP_DIR}/var/data/actu.org.sqlite3
    ; OR
    dsn=sqlite:{$JELIX_DIR}/var/data/actu.org.sqlite3

Solution 2: post-parse dsn path

    ; the dns is parsed, and modified to replace a possible relative path by an absolute one
    ; The path is relative to the APP_DIR.
    driver=pdo
    dsn=sqlite:var/data/actu.org.sqlite3 

Solution 3 (cut dsn in several parts)

    driver=pdo

    ;dsn=sqlite:/home/.../.../var/data/actu.org.sqlite3
    dsntype = sqlite

    ; just the file name itself
    dsnfile = actu.org.sqlite3

    ; a way to tell the base file if relative specif is used
    dsnbasedir = ABSOLUTE | APP_DIR | JELIX_DIR

    ; the dir can be absolute. il ut is relative the défault is relative to APP_DIR
    ; usless other dir is spécified by the previous key
    dsndir = var/data

Not sure which is better for minimize coding but the first solution allow simple one without some magic hidden process as for solution 2. Solution 3 has to be refine (many new keywords should be add which is not a good thing)

-- Maurice

#592 fixed form plugin create always a form with method post Julien laurentj
Description

When we indicates 'get' as a parameter of the plugin, the generated "method" attribute has the "post" value.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Note: See TracQuery for help on using queries.