db-models-and-eloquent

Sat Jan 20 2024 02:11:01 GMT+0000 (Coordinated Universal Time)

Saved by @hasan #laravel #database #eloquent #model

https://github.com/LaravelDaily/laravel-tips/blob/master/db-models-and-eloquent.md

Save snippets that work from anywhere online with our extensions

Comments

Eloquent - observer - Model

@hasan

collection tips - laravel daily db-models-and-eloquent

#pyproj #python #database #path

Fix pyproj database path

 """ 
'UserWarning: pyproj unable to set database path.' <- This happens with multiple pyproj installations on the same machine, which is quite common, as almost every geo software depends on it.

How to fix:
First, find all copies of 'proj.db' on the machine. Get the path for the correct one, which is probably something like 'C:/Users/Clemens Berteld/.conda/pkgs/proj-8.2.0-h1cfcee9_0/Library/share/proj'. Definitively not a QGIS or PostGIS path.

Then, use it as a parameter for this function and run it at the top of your code:
"""

def set_pyproj_path(proj_path):
    from pyproj import datadir
    datadir.set_data_dir(proj_path)
    # print(datadir.get_data_dir.__doc__)

#laravel

file_put_contents(...): failed to open stream: Permission denied

php artisan cache:clear
chmod -R 777 storage/
composer dump-autoload

#php #laravel

Method Illuminate\Support\Collection::appends does not exist

// replace get()
$products = Product::where('active', 1)->get();

// by paginate()
$products = Product::where('active', 1)->paginate(10);

#php #laravel

Call to a member function getClientOriginalName() on null

<!-- use enctype -->
<form  action="/route" method="POST" enctype="multipart/form-data">

#php #laravel

array dot method

$original = [
    'user' => [
        'name' => 'foo',
        'occupation' => 'bar',
    ]
];
 
$dotted = Arr::dot($original);
 
// Results in...
$dotted = [
    'user.name' => 'foo',
    'user.occupation' => 'bar',
];

#sql #database #querying-data

SQL Select all columns with GROUP BY one column

https://stackoverflow.com/a/39816161/6942743

#prestashop #delete #mysql #db #database #ids

Delete from DB if not in array

Db::getInstance()->executeS("DELETE FROM product_images WHERE id_product NOT IN (" . join($allProductIds,',') . ")")

#wordpress #database #credentials #automate

Store database credentials from wp-config in shell variable

WPDBNAME=`cat wp-config.php | grep DB_NAME | cut -d \' -f 4`
WPDBUSER=`cat wp-config.php | grep DB_USER | cut -d \' -f 4`
WPDBPASS=`cat wp-config.php | grep DB_PASSWORD | cut -d \' -f 4`

#database #mysql

Create user and database and grant access

# If your logged in to mysql (mysql -u root -p) you can create the database
#CREATE DATABASE database_name;
CREATE DATABASE <database> CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci';

# The user can be created with
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'user_password';

# This user also needs access to the database
GRANT ALL PRIVILEGES ON database_name.* TO 'database_user'@'localhost';

# To make the new access rights available you have to reload them
FLUSH PRIVILEGES;

#php #codeigniter #database #model

Query Builder for database CI

https://codeigniter.com/userguide3/database/query_builder.html

#php #codeigniter #database #model

Shortcuts in Model CI

$sql = "SELECT * FROM some_table WHERE id = ? AND status = ? AND author = ?";
$this->db->query($sql, array(3, 'live', 'Rick')); // insert in ci

#php #codeigniter #database #model

Validate in Codeigniter

$this->load->library("form_validation");
$this->form_validation->set_rules("username", "User name", "trim|required");
if($this->form_validation->run() === FALSE)
{
     //$this->view_data["errors"] = validation_errors();
}
else
{
     //codes to run on success validation here
}

#database

Count group by date

SELECT count(*) as application, YEARWEEK(created_date) as weekNum
FROM nepaldevjobsapplication
GROUP BY YEARWEEK(created_date)

#database

Chat DB Design

Inbox
id, userId(holder of this account), senderId, lastMessage

Chat
id, senderId, recieverId, message, seen, deleted

//
DB query when inbox is opened
findall where userId = senderId or userid = receiverId

#python #mysql #database #thirdparty

My SQL Connection

#!/usr/bin/python



-- coding: UTF-8 --


pip install MySQL-python



import MySQLdb, os




try:
    conn = MySQLdb.connect(host='172.17.42.1', user='my_email', passwd='normal', db='database', port=3306)




cur = conn.cursor()
cur.execute('SELECT `id`, `name`, `path`, FROM `doc_file`')

# results
resulsts=cur.fetchall()    id, name, path = r[0], r[1], r[2]

    if path and not os.path.exists(path):
        print 'file not exist: ', id, name, path, flashpath

cur.close()
conn.close()

 



except MySQLdb.Error,e:
     print "Mysql Error %d: %s" % (e.args[0], e.args[1])




</pre>

db-models-and-eloquent

Save snippets that work from anywhere online with our extensions

Comments

More like this

Eloquent - observer - Model

Browse more snippets >>

db-models-and-eloquent

Save snippets that work from anywhere online with our extensions

Comments

More like this

Eloquent - observer - Model

Browse more snippets >>

Embed code snippet