Search In
A common problem encountered during SQL server development is to check if a particular table exists or not. There are different approaches to solve this problem and in this blog we will list out these approaches. For illustration purpose we will be u
Hello Guys
Here, I am writing blog for deleting user by userId in liferay from custom portlet.
User : The extended model interface for the User service. Represents a row in the "User_" database
table, with each column mapped to a property of th
if we want to access and manipulate objects without considering much about its data resources, we use ORM. ORM allows programmers to maintain a consistent view of objects over time.Mapping details between a set of objects is managed by ORM.
ORM con
osv.osv object in OpenERP:-
in openerp osv.osv object is actually an orm.Model class and define a new object, you must define a new Python class then instantiate it. This class must inherit from the osv class in the osv module.
Example:-
class name
Sometimes we need to check how many duplicate values a column has in MySQL table. We can do this by using "group by" and "having".
Example: Suppose you have a table "user" with "fist_name" column from which you want to find all the records which ha
Below are the steps to Export an ORS:
Step 1: Launch the jnlp file.
Step 2: Enter you credential, select the ORS.
Step 3: Under Workbench, select Repository Manager.
Step 4: Connect to Master Database.
Step 5: Under Validate tab, validate the ORS tha
Python have following integration which is given below:-
1. Python scripts can easily communicate with other application using variety of integration mechanisms.
2. simple object persistence system is provided by Python's standard pickle module
3. P
In MySQL, the MAX() function used to return the largest value of the specified column in a table.
MAX() Syntax
SELECT MAX(column_name) FROM table_name;
We have a table "employee" as below:
employee
id first_name last_name
In MySQL, MIN() function is used to return the smallest value of the specified column in a table.
MIN() Syntax
SELECT MIN(column_name) FROM table_name;
We have a table "employee" as below:
employee
id first_name last_name
What is the use of AVG() function in MySQL?
The AVG() function is used to return the average of the numeric column in a table.
AVG() Syntax
SELECT AVG(column_name) FROM table_name;
We have a table "employee" as below:
employee
id first
