Thursday, August 16, 2012

Maula mere le le meri jaan - keep the faith in the religion and the country!

I am writing this because I cried today, no really there is no pain however. This is just a sense of Patriotism !

The religion of humanitarianism...food for thought.

No no no, I am not writing this because its an Independence day today. To be honest, having holidays on Independence day for me does not make any difference. It has been just a one more NULL day in life. I hope majority of you agree. I believe work should be done with double integrity on such days. And I know a very very few will agree.

Anyways, I was just having a last bite of my dinner now and I switched a channel and moved to Sony Max and my remote had to be put aside and I forgot I was eating something. Guys, I was listening 'Maula mere le le meri jaan……..' from Chak De India, truly a superb movie, one of my favourites. Fantastic, emotional, number one,- whatsoever best objectives to be applied - song this is.

This song is one of the very very very rare things which have made me cry...O boss, what a meaning is displays. And the voice of Krishna, truly saddening.

It talks about the relationship between a patriot and his country and how he chooses to fight back to prove his love. The feel of this song is truly something else when watched in the movie.

Each time I hear the song, it touches a chord. Initially I didn't get the word, till I realized its significance.




The Lyrics go as:
  
[Teeja tera rang thaa mai toh
Teeja teraa rang thaa mai toh
jiya tere dhang se mai toh
tu hi thaa maula tu hi aan
Maula mere le le meri jaan ] 2

I am adorned by your colors
I have lived by your traditions
You are my Lord, my pride
Take my life its yours, My Lord


Tere sang kheli holi

Tere sang ki diwali
Tere angno ki chhaya
Tere sang saawan aaya
Fer le too chaahe nazre
Chaahe yeh chura le
Laut ke too aaega re shart laga le

With you I have played Holi
And with you celebrated Diwali
In your courtyard I found shade
In your company the rains arrived
Now you can turn away from me if you want
But you will return, I am certain

Teeja tera rang thaa mai toh
Teeja tera rang thaa mai toh
jiya tere dhang se mai toh
Tu hi thaa maula tu hi aan
Maula mere le le meri jaan ...!

Mitti meri thi bhoori

Wohi mere ghee aur choori
Wohi raanjhe mere wo heer
Wohi sevaiyaan wahi kheer
Tujhse hi roothnaa mujhe hi manaana
Teraa mera naata koi dooja naa jaana

You are my earth
You are my Ghee and Churi(sweet)
You are my Ranjha and you are my Heer(star crossed lovers)
You are my sevaiyaan and my kheer (sweet)
You are the one I get angry with and the one I makeup with
No one else can understand our relationship


Teeja tera rang thaa mai toh

Teeja tera rang thaa mai toh
Jiya tere dhang se mai toh
Tu hi thaa maula tu hi aan
Maula mere le le meri jaan ! 


I was just looking for the meanings of each line. I remember It was Kapil Devani, who made me aware about the lyrics when he shared them on orkut.

Teeja rang, the third colour of the flag, the green in our flag that connotes the Indian farmer or as many say the Indian muslim. Our founding fathers chose our flag with care. Our politics is based on subtle messages, we as a nation hate being direct so if peace was the white then the saffron and the green symbolized the two communities that make the largest part of the nation, and the white probably was a hope for relations between both communities to be peaceful. Or so I feel.

Basically, the world hasn't collapsed yet and never will because rational thinkers, humanitarians, exist. One's religion should be one's personal affair, but people hardly ever think over things - they mostly go with the flow.

I am not Muslim so I just see those things. Others who are, I know, must feel very bad actually experiencing these circumstances. I am seeing the festival of Ramadan closely since very long. I am just growing up and I have begun to see differences in society - that never existed till I was in school/ college... strange! But I think if we are better thinkers, we can win over the lesser thinkers and shouters and short-term-self-gainers. I won't name those friends of mine, but they are experiencing many difficulties in getting their own homes just because they are Muslims, what a crap is this!

Please, Love and respect everyone. I can write pages and pages in such a topic, but I don't want to raise questions and thus heading to long discussions.

My religion is: 1. My Duty 2. Law 3. My Passion 4. Making someone smile and motivate !

Jay Hind.


GOD bless you!

Wednesday, August 15, 2012

ADO.NET SQL database connection strings for SQL Server

Please go through this for a reference.

SQL ODBC connection strings

Standard Security: 
 "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Uid=Your_Username;Pwd=Your_Password;"

Trusted connection: 
 "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=yes;" 

SQL OLE DB connection strings

Standard Security:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;"

Trusted connection:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;" 

SQL OleDbConnection .NET strings

Standard Security:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;"

Trusted connection:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;" 

SQL SqlConnection .NET strings

Standard Security:
1. "Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;" < br>2. "Server=Your_Server_Name;Database=Your_Database_Name;UserID=Your_Username;Password=Your_Password;Trusted_Connection=False"

Trusted connection:
1. "Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;"
2."Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=True;"


Connection Strings for Oracle with connection of C#!

Do you have a hard time remembering database connection strings?  You are not alone!  Here is an easy-to-use reference of connection strings for Oracle!


// ODBC DSN

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString =
              "Dsn=DsnName;" +
              "Uid=UserName;" +
              "Pwd=Secret;";
conn.Open();



// ODBC -- New Microsoft Driver

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString =
           "Driver={Microsoft ODBC for Oracle};" +
           "Server=OracleServer.world;" +
           "Uid=UserName;" +
           "Pwd=Secret;";
conn.Open();



// ODBC -- Old Microsoft Driver

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString =
    "Driver={Microsoft ODBC Driver for Oracle};" +
    "ConnectString=OracleServer.world;" +
    "Uid=UserName;" +
    "Pwd=Secret;";
conn.Open();



// ODBC -- Oracle Driver

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString =
    "Driver={Oracle ODBC Driver};" +
    "Dbq=myDataBase;" + // define in tsnames.ora
    "Uid=UserName;" +
    "Pwd=Secret;";
conn.Open();




// OleDb -- Microsoft Driver

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString =
              "Driver=MSDAORA;" +
              "Data Source=ServerName;" +
              "User id=UserName;" +
              "Password=Secret;";
conn.Open();




// OleDb -- Oracle Driver -- Standard Connection

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString =
              "Driver=OraOLEDB.Oracle;" +
              "Data Source=ServerName;" +
              "User id=UserName;" +
              "Password=Secret;";
conn.Open();




// OleDb -- Oracle Driver -- Trusted Connection

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString =
              "Driver=OraOLEDB.Oracle;" +
              "Data Source=ServerName;" +
              "OSAuthent=1;";
conn.Open();

// or

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString =
              "Driver=OraOLEDB.Oracle;" +
              "Data Source=ServerName;" +
              "User id=/" +
              "Password=;";
conn.Open();



// .NET DataProvider from Microsoft
// -- Standard Connection

using System.Data.OracleClient;

OracleConnection conn = new OracleConnection();
conn.ConnectionString =
              "Data Source=ServerName;" +
              "User id=UserName;";
              "Password=Secret;";
conn.Open();



// .NET DataProvider from Microsoft
// -- Trusted Connection

using System.Data.OracleClient;

OracleConnection conn = new OracleConnection();
conn.ConnectionString =
              "Data Source=Servername;" +
              "Integrated Security=Yes;";
conn.Open();




// .NET DataProvider from Oracle
// -- Standard Connection

using Oracle.DataAccess.Client;

OracleConnection conn = new OracleConnection();
conn.ConnectionString =
              "Data Source=ServerName;" +
              "User id=UserName;";
              "Password=Secret;";
conn.Open();




// .NET DataProvider from Oracle
// -- Trusted Connection

using Oracle.DataAccess.Client;

OracleConnection conn = new OracleConnection();
conn.ConnectionString =
              "Data Source=Servername;" +
              "Integrated Security=Yes;";
conn.Open();

Saturday, August 11, 2012

મરણ તો આવે ત્યારે વાત !

મરણ તો આવે ત્યારે વાત
અત્યારે તો જીવન સાથે ગમતી મુલાકાત.

ખીલવાનો આનંદ હોય છે,
ખરવાની કોઈ યાદ નથી.
સુગંધ જેવો ભીનો ભીનો
વરદાન સમો વરસાદ નથી.

સોના જેવો દિવસ, રૂપા જેવી રાત
મરણ તો આવે ત્યારે વાત

હરતા રહેવું, ફરતા રહેવું
ઝરણાની જેમ વહેતા રહેવું
મહેફિલને મનભરીને માણી
જલસા જલસા કહેતા રહેવું

જીવન અને મરણની વચ્ચે નહીં પ્રશ્નો, પંચાત.
મરણ તો આવે ત્યારે વાત.

મૃત્યુ જેટલું મોટું પૂર્ણવિરામ કોઈ નથી!

આંખ તો મારી આથમી રહી, કાનના કૂવા ખાલી.
એક પછી એક ઇન્દ્રિય કહે : હમણાં હું તો ચાલી.

શ્વાસના થાક્યા વણઝારાનો નાકથી છૂટે નાતો,
ચીમળાયેલી ચામડીને સ્પર્શ નથી વરતાતો.

સૂકા હોઠની પાસે રાખો ગંગાજળને ઝાલી,
એક પછી એક ઇન્દ્રિય કહે : અબઘડી હું ચાલી.

નસના ધોરી રસ્તા તૂટ્યા, લોહીનો ડૂબે લય.
સ્મરણમાં તો કંઈ કશું નહિ, વહી ગયેલી વય.

પંખી ઉડ્યું જાય ને ...પછી કંપે જરી ડાળી

- સુરેશ દલાલ

મરણનો માર્ગ શૂરો !

દિવસ તો હમણાં શરુ થયો ને સાંજ પડે કે પુરો.
ક્યારેક ક્યારેક અહીં ઉગે છે ચંદ્ર પૂર્ણ, મધુરો.

આમ ને આમ આ શૈશવ વીત્યું
ને વહી ગયું આ યૌવન,
વનપ્રવેશની પાછળ પાછળ
ધસી આવતું ઘડપણ.

સ્વાદ બધોયે ચાખી લીધો : ખાટો, મીઠો, તૂરો.
દિવસ તો હમણાં શરુ થયો ને સાંજ પડે કે પુરો.

હવે બારણાં પાછળ ક્યાંક તો
લપાઈ બેઠું મરણ,
એણે માટે એકસરખા છે
વાઘ હોય કે હરણ.

ઝંખો, ઝૂરો, કરો કંઈ પણ : પણ મરણનો માર્ગ શૂરો,
દિવસ તો હમણાં શરુ થયો ને સાંજ પડે કે પુરો.

- સુરેશ દલાલ

Wednesday, August 8, 2012

OpenERP : Parent_left and parent_right explained!

Guys,

By the time we are typing this down(1 AM crossing soon), Husen and Jay have been delivering Remote Training of the month and this has given us an idea to share a very nice topic which has been a ‘What’ for many.

It has been a busy set of months as have been busy managing Trainings. It is to share that we just finished July 2012 and preparing for the overwhelming response for Aug 2012 OpenERP Training in India.

I understand you might have a hard time understanding what is all about parent_left and parent_right!

Had you seen the code for account.account and product.category, you would better know what it looks like and what’s the importance! Basically, they have been added for faster execution of search call when you have lots of records on these models. In short, you can count them the agents of binary search!

The parent_left and parent_right are 2 special fields that are related to the parent_id field. The purpose of those fields is to make queries within the hierarchy execute efficiently: with parent_left and parent_right, you can retrieve all the descendants of a node without making recursive queries.

Consider two nodes A and B in the hierarchy. A and B can be partner categories, for instance. Their integer fields parent_left and parent_right are such that:
B is a descendant of A in the hierarchy (defined by parent_id)
if and only if

 A.parent_left < B.parent_left, B.parent_right and B.parent_left, B.parent_right < A.parent_right

So, imagine that you have six partner categories like below. You can assign parent_left and parent_right by traversing the tree. The result is show in parentheses next to each node. Note that the values there are optimal; in practice, you can leave gaps in the numbers.
- Customers (1, 10)
  – Consumers (2, 3)
  – Partners (4, 9)
  – Basic Partners (5, 6)
  – Gold Partners (7, 8)
- Suppliers (11, 12)

You can retrieve all the subcategories of Customers with a single SQL query. Note that the values 1 and 10 are the parent_left and parent_right of Customers; they can be retrieved as part of the query itself.

SELECT id FROM partner_category
WHERE parent_left > 1 AND parent_left < 10

The last remark is that parent_left and parent_right can be updated without traversing the whole hierarchy. Removing a node does not require any change.

For adding a node, you can adapt the parent_left and parent_right with two UPDATE queries: one to “make some space” between the parent_left and parent_right of the node’s ascendants, and one to shift the parent_left and parent_right of all the nodes “at the right” of the new position. So parent_left and parent_right can be maintained efficiently.


I hope this helps understanding how they work.
Thanks,

Serpent Consulting Services.

Idea : From the questions of many programmers!
Reference : Own study, understanding.
Contents : Thanks to Launchpad for some good contents.

If you face issues on them, having your records imported by CSV:
To fix on your db:
alter table account_account drop parent_left;
alter table account_account drop parent_right;
and restart the server with –update=account.

Saturday, August 4, 2012

એના શમણા!

sorry , થોડો બીઝી હતો, કામમાં હતો હમણાં,
સાચું કહું તો જોતો હતો હું તો એના શમણા...!

એક તો મળતી છે નહિ ને એ હેરાન કરે છે,
નાહક માં મુજ જીવતા જીવ ને એ બેજાન કરે છે.

મળવું હોય તો પણ એ તો એવા ભાવ ખાશે!
એક દિ એ તો સાચે મુજને હાર્ટ-અટેક દઈ જાશે!

કાલે કાલે કરીને મળવાના પ્રોમિસ એ કરશે,
તોયે મળવા નહિ આવે ને સો બહાના ધરશે!

આમ જોઈએ તો હું પણ એનાથી છું કંટાળ્યો,
વિચાર પણ આવે કે આવો તે શું પ્રેમ પાળ્યો!

કંટાળીને બેસું લઈ ને હાથ ની વચ્ચે લમણા,
ત્યાં ફરીથી પ્રેમમાં ખેંચી જાય છે એના શમણા!

-વિરાજ રાઓલ

શાંતિ નો સનેપાત !

વાતાવરણ
અકળામણું, ભારે
શાંતિ ક્યાંથી?

ઘડી બે ઘડી
હાશકારા ની શોધ,
વૈભવ માંથી?

રાત દિવસ,
એક કરવા મથું,
દિવસ રાત!

જડ ચેતન,
પેટાળ, કણ-કણ;
અંતરિક્ષ માં!

દીવો લઈને,
કે સૂર્ય તળે શોધું,
તિમિર માંથી!

સાંધું એક તો,
તુટે તેર છેડલા,
સંબંધો માંથી.

જન્મ લઈને,
આ તો જાણે મેં બાંધ્યો,
સફેદ હાથી!

- જય વોરા