usmanhalalit/pixie issues and pull requests

#211 - Nulls first construction in SQL query

Issue - State: open - Opened by atainex 6 months ago

#210 - Group where

Issue - State: open - Opened by atainex 10 months ago - 2 comments

#209 - fixed QueryBuilderHandler dynamic properties for PHP 8.2

Pull Request - State: open - Opened by vukbgit over 1 year ago

#208 - Error QueryBuilderHandler

Issue - State: open - Opened by WesleyMarinho over 1 year ago

#207 - When updating data, does not write values containing double quotes to the database

Issue - State: open - Opened by BloodyEagle over 1 year ago

#206 - return random data

Issue - State: closed - Opened by m1ss3 almost 2 years ago - 1 comment

#205 - How can i use external variable in transactions?

Issue - State: closed - Opened by JKwang00 about 5 years ago - 2 comments

#204 - SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'data' at row 1 in

Issue - State: open - Opened by aboly about 5 years ago

#203 - On duplicate key update

Pull Request - State: closed - Opened by peti562 about 5 years ago

#202 - issue in count()

Issue - State: open - Opened by mromid over 5 years ago - 3 comments

#201 - Select with special characters

Issue - State: open - Opened by Deepak-nb over 5 years ago - 2 comments

#200 - pass array to where

Issue - State: open - Opened by jonasfrey over 5 years ago - 6 comments

#199 - 2.x i would like to pass an array to the where function

Pull Request - State: open - Opened by jonasfrey over 5 years ago

#198 - How to close connection?

Issue - State: open - Opened by catchem99 over 5 years ago - 2 comments

#197 - Add prefix for an alias of the main table

Pull Request - State: closed - Opened by n30fly about 6 years ago - 1 comment

#196 - update and order by

Issue - State: open - Opened by lotarbo about 6 years ago

#195 - support parameterized raw expressions in inserts/updates/criteria values

Pull Request - State: open - Opened by drdaxxy about 6 years ago - 1 comment
Labels: enhancement, pending-review

#194 - Usage in a namespaced application and running CREATE statements

Issue - State: closed - Opened by randohinn over 6 years ago - 2 comments

#193 - Update accumulating column

Issue - State: open - Opened by ManuelMolina97 over 6 years ago

#192 - insert() doesn't work with table alias

Issue - State: open - Opened by ArthurHoaro over 6 years ago
Labels: enhancement

#191 - Query event

Pull Request - State: closed - Opened by rohap over 6 years ago

#190 - increment

Issue - State: open - Opened by Blaster-777 over 6 years ago

#189 - Postgres: Update has syntax error

Issue - State: open - Opened by James-A1 over 6 years ago - 1 comment

#188 - PDOException: 'SQLSTATE[55000]' on insert (lastInsertId)

Issue - State: open - Opened by James-A1 over 6 years ago - 2 comments
Labels: bug, duplicate

#187 - SELECT ... FOR UPDATE

Issue - State: open - Opened by dragonattack over 6 years ago

#186 - try to add TIME function in WHERE

Issue - State: closed - Opened by amoulin974 over 6 years ago - 4 comments

#185 - Specifying FetchMode with options

Issue - State: closed - Opened by vikkio88 over 6 years ago - 2 comments
Labels: enhancement

#184 - onDuplicateKeyUpdate is not valid syntax for Postgresql

Issue - State: open - Opened by vikkio88 over 6 years ago - 1 comment
Labels: bug

#183 - Fix on FetchMode getting lost between instances

Pull Request - State: closed - Opened by vikkio88 over 6 years ago - 14 comments

#182 - orderBy Rand

Issue - State: closed - Opened by ngdanghau over 6 years ago - 1 comment

#181 - optimize query with use index

Issue - State: closed - Opened by StephanKrauss over 6 years ago - 2 comments

#180 - count() problem when groupBy is used

Issue - State: open - Opened by mtarlac over 6 years ago - 7 comments

#179 - Query cachin / MYSQLND_QC_ENABLE_SWITCH

Issue - State: closed - Opened by mewcrazy over 6 years ago - 3 comments

#178 - Add ability to pass array of conditions into where statement

Pull Request - State: closed - Opened by kticka over 6 years ago - 4 comments

#177 - Add new ConnectionAdapters

Issue - State: closed - Opened by todiadiyatmo almost 7 years ago - 1 comment

#176 - [bugfix] Float values are inserted to a built SQL query incorrectly when some locales are set in PHP

Pull Request - State: closed - Opened by Finesse almost 7 years ago - 4 comments

#175 - [Enhancement #150] Fix PHP Doc Blocks

Pull Request - State: closed - Opened by DarkMukke almost 7 years ago

#174 - Custom search operators

Issue - State: open - Opened by hastom almost 7 years ago - 2 comments

#173 - README typo

Pull Request - State: closed - Opened by ptejada about 7 years ago - 1 comment

#172 - Multiple conditional joins

Issue - State: open - Opened by scott-wmm about 7 years ago - 2 comments

#171 - None.

Issue - State: closed - Opened by lordmemed about 7 years ago - 6 comments

#170 - Add query tags similar to drupal

Issue - State: closed - Opened by richwandell about 7 years ago - 1 comment
Labels: enhancement

#169 - Update BaseAdapter.php

Pull Request - State: closed - Opened by techjewel about 7 years ago - 1 comment

#168 - Update README.md

Pull Request - State: closed - Opened by antoiba86 about 7 years ago - 1 comment

#167 - Update docblock to include data types and better support IDEs

Issue - State: closed - Opened by TCB13 over 7 years ago - 3 comments

#166 - SELECT where FLOATs

Issue - State: closed - Opened by dragonattack over 7 years ago - 6 comments

#165 - getQuery() on update/insert doesn't work.

Issue - State: closed - Opened by RyanHipkiss over 7 years ago - 1 comment

#164 - How you check if your last query (i.e. update) was successful?

Issue - State: closed - Opened by dragonattack over 7 years ago - 4 comments

#163 - Prefix added to join aliases

Issue - State: open - Opened by m-mohr over 7 years ago - 1 comment

#162 - Agrigate functions

Issue - State: closed - Opened by ZaidSaid over 7 years ago - 1 comment

#161 - Incorrect field names quatation in query

Issue - State: open - Opened by Napas over 7 years ago - 7 comments
Labels: bug

#160 - insertedid is not working

Issue - State: open - Opened by billionri over 7 years ago - 5 comments

#159 - Added $row[0] check in QBHandler::aggregate

Pull Request - State: open - Opened by zlodes over 7 years ago

#158 - Query Results as Standard Class Object

Issue - State: closed - Opened by himanshuahuja96 over 7 years ago - 4 comments

#157 - Nested where clauses result in weird behavior

Issue - State: closed - Opened by acburdine over 7 years ago - 1 comment

#156 - 'Viocon\Container' not found

Issue - State: closed - Opened by angujo almost 8 years ago - 2 comments

#155 - Transaction exception handling should rollback and throw exception

Issue - State: open - Opened by dlmorais-13 almost 8 years ago - 2 comments

#154 - fix alias overwriting when 2 or more connectios are created

Pull Request - State: closed - Opened by luccas641 almost 8 years ago - 1 comment

#153 - how to add sub condition in where like `(x=1 or y=1) and (z>0 and z<>1)`

Issue - State: open - Opened by kingofnull almost 8 years ago - 1 comment

#152 - Return options for INSERT operations, UPDATE and DELETE

Issue - State: open - Opened by robertaodj about 8 years ago - 2 comments

#151 - Row Count

Issue - State: open - Opened by robertaodj about 8 years ago - 1 comment

#150 - Fix PHP Doc Blocks

Issue - State: open - Opened by DarkMukke about 8 years ago - 14 comments
Labels: enhancement

#149 - Don't work leftJoin(['table'=>'alias'],...)

Issue - State: closed - Opened by DaaGER about 8 years ago - 2 comments

#148 - Support `select <column> AS <alias>` by using an associative array in select method call

Issue - State: closed - Opened by acburdine about 8 years ago - 3 comments

#147 - added support for Postgresql PDO::lastInsertId()

Pull Request - State: open - Opened by leosilvano about 8 years ago - 1 comment
Labels: bug

#146 - insert() method returning false on Postgresql

Issue - State: open - Opened by leosilvano about 8 years ago
Labels: bug

#145 - Event wont be triggered when using join

Issue - State: open - Opened by eL-Prova over 8 years ago

#144 - Multiple database connection, last connection is overwriting

Issue - State: open - Opened by roystijsiger over 8 years ago - 2 comments

#143 - Connection with "PDO::FETCH_ASSOC" option.

Issue - State: closed - Opened by DaaGER over 8 years ago - 5 comments
Labels: enhancement

#142 - cannot get two columns with same nam in multiple tables where joining

Issue - State: closed - Opened by danielskowronski over 8 years ago - 3 comments

#141 - Bugfix where false bool

Pull Request - State: closed - Opened by skipperbent over 8 years ago - 11 comments

#140 - Feature: no table support

Pull Request - State: closed - Opened by skipperbent over 8 years ago - 4 comments

#139 - Update README.md, fix a small syntax error

Pull Request - State: closed - Opened by NineRec over 8 years ago - 2 comments

#138 - Adding options for mutate tables and columns

Pull Request - State: closed - Opened by eL-Prova over 8 years ago - 5 comments

#137 - Fixed notices in QueryBuilderHandler

Pull Request - State: open - Opened by skipperbent over 8 years ago - 2 comments

#136 - Speedups

Pull Request - State: closed - Opened by neoascetic over 8 years ago - 7 comments

#135 - Send data to eventhandler to mutate

Pull Request - State: open - Opened by eL-Prova over 8 years ago

#134 - Order by Raw bindings

Pull Request - State: open - Opened by hashstudio over 8 years ago - 2 comments

#133 - Can't figure out how to add alias to tables

Issue - State: closed - Opened by skipperbent over 8 years ago - 5 comments

#132 - WhereIn for subqueries

Issue - State: closed - Opened by eL-Prova over 8 years ago - 1 comment

#131 - SubQueries in where() not working properly

Issue - State: open - Opened by drozdza over 8 years ago - 1 comment

#130 - Multi-tendancy, make possible to manipulate data in before events

Issue - State: open - Opened by eL-Prova over 8 years ago - 6 comments

#129 - Support on CASE WHEN clause and IF THEN clause

Issue - State: closed - Opened by 199911 over 8 years ago - 1 comment

#128 - When you're calling onDuplicateKeyUpdate, passing in id = LAST_INSERT…

Pull Request - State: open - Opened by LewisTheobald over 8 years ago - 1 comment

#127 - Where method being strict about types

Pull Request - State: closed - Opened by skipperbent over 8 years ago

#126 - Backport changes to the 1.x branch

Issue - State: closed - Opened by acburdine over 8 years ago - 2 comments

#125 - Added support for * event matching

Pull Request - State: closed - Opened by skipperbent over 8 years ago

#124 - [TASK] Added support for nested query-builder

Pull Request - State: open - Opened by skipperbent over 8 years ago - 3 comments

#123 - IDE Autocomplete

Issue - State: closed - Opened by aiphee over 8 years ago - 6 comments

#121 - Problems using Time Intervall

Issue - State: closed - Opened by mewcrazy over 8 years ago - 2 comments

#119 - inject data in before-insert event

Issue - State: closed - Opened by Kaimite over 8 years ago - 5 comments

#117 - Use an existing connection

Issue - State: closed - Opened by sirhubber over 8 years ago - 3 comments

#115 - Uncaught exception 'ReflectionException'

Issue - State: closed - Opened by cmjunior over 8 years ago - 2 comments

#106 - Support manual transaction and make sure only one transaction active

Pull Request - State: open - Opened by swznd almost 9 years ago - 4 comments

#98 - onDuplicateKeyUpdate & Batch Insert (array of arrays)

Issue - State: open - Opened by zlodes almost 9 years ago - 4 comments
Labels: bug

#84 - JOIN on literal is quoted with backticks

Issue - State: closed - Opened by bmanth60 about 9 years ago - 4 comments
Labels: bug

#63 - ->setFetchMode(\PDO::FETCH_ASSOC) on all queries

Issue - State: closed - Opened by TCB13 over 9 years ago - 12 comments

#59 - PDO::ATTR_ERRMODE

Issue - State: closed - Opened by TCB13 over 9 years ago - 4 comments
Labels: enhancement

#40 - [sqlite] date functions not working?

Issue - State: closed - Opened by dragonattack almost 10 years ago - 14 comments

#24 - Handle DateTime objects

Issue - State: open - Opened by matthieusieben about 10 years ago - 4 comments
Labels: enhancement

GitHub / usmanhalalit/pixie issues and pull requests