codesvault / howdy_qb Goto Github PK

It'll look like this:

where( "posts", "=", "Hello" )

Hello
I'm facing a error of undefined $db when I'm trying to use the select query. Am I doing something wrong? I have installed the composer using composer require codesvault/howdy_qb statement. Do I have to include any namespace or any other thing?
I'm trying to get values upon the the below code.
$result =
$db::select('posts.ID', 'posts.post_title')
->distinct()
->from('posts posts')
->where('posts.post_status', '=', 'publish')
->orderBy('post_title', 'DESC')
->limit(10)->offset(2)
->get();

Need to implement PHP unit test

According to documention provided in https://wp-querybuilder.pages.dev/documentation/getting-started, installation can be done using below command

composer require codesvault/howdy_qb

But it shows error as name property in composer.json file is defined howdy-qb like this below image.

So as per composer json file documention should be renamed as

composer require codesvault/howdy-qb

I was trying to create a table with below code.

DB::create('cache')
	->column('ID')->bigInt()->unsigned()->autoIncrement()->primary()->required()
	->column('key')->string(255)->required()
	->column('data')->string(255)->default('NULL')
	->index(['ID'])
	->execute();

It is throwing an error. See below:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax;

Reason: Some words are reserved for SQL so those are not possible to use as a table column name without proper quotation.

Editor config functionality need to be added

Join APIs need to be compatible with different types of joins

Running dump-autoload -o on composer provides errors, that say not compatible with psr4.

Hi, I am using this wonderful library for our client's project. However, I am unable to retrieve data from this innerJoin query.

I seem to be having some trouble here 😕. Perhaps I overlooked something. If anyone could offer a solution, I would greatly appreciate it. 🙏

$result = $db::select( 'bv_sku_key_map.sku_child' )
	->from( 'bv_sku_key_map' )
	->innerJoin( 'bv_sku_child','bv_sku_key_map.sku_key','bv_sku_child.main_sku')
	->Where('bv_sku_child.child_sku', '=','G 10078')
	->get();

Here is the original SQL query, and it is working.

SELECT DISTINCT
	wp_bv_sku_key_map.sku_child
	
FROM
	wp_bv_sku_key_map
	INNER JOIN wp_bv_sku_child ON wp_bv_sku_key_map.sku_key = wp_bv_sku_child.main_sku
WHERE
	wp_bv_sku_child.child_sku = 'G 10078';

Thank you

Need to add functionality to add foreign key, also add it in the documentation.

Each API of the Query Builder needs documentation so that developers can understand how to use it.